QUESTION: 653

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

Swift
JavaScript
Python
SQL

Answer(s): C

QUESTION: 654

A user needs to ingest 1 GB of data that is available in an external stage using a COPY INTO command.
How can this be done with MAXIMUM performance and the LEAST cost?

Ingest the data in a compressed format as a single file.
Ingest the data in an uncompressed format as a single file.
Split the file into smaller files of 100-250 MB each, compress and ingest each of the smaller files.
Split the file into smaller files of 100-250 MB each and ingest each of the smaller files in an uncompressed format.

Answer(s): C

Reveal Solution Next Question

QUESTION: 655

A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables.
Which set operator should be used?

INTERSECT
MERGE
MINUS
UNION

Answer(s): A

Reveal Solution Next Question

QUESTION: 656

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table.
What will the query from the view return?

The data from the permanent table.
The data from the temporary table.
An error stating that the view could not be compiled.
An error stating that the referenced object could not be uniquely identified.

Answer(s): B

Reveal Solution Next Question

Free SnowPro Core Exam Braindumps (page: 164)

QUESTION: 653

QUESTION: 654

QUESTION: 655

QUESTION: 656