Snowflake Updated SnowPro-Core Exam Questions and Answers by aarya

Set SINGLE: = true for larger files

Use OBJECT_CONSTRUCT ( * ) when using Parquet

Avoid the use of the CAST function

Define an individual file format

SHOW

MERGE

INSERT

DELETE

DESCRIBE

Use COPY INTO followed by a GET command to download the file.

Use COPY INTO followed by a put command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.