Question 1

Which SQL command is commonly used to load structured data from a stage into a Snowflake table?

Options :

A : INSERT INTO

B : COPY INTO

C : LOAD DATA

D : IMPORT DATA

Answer: B

Question 2

What parameter is used to define how long Time Travel can be used to access a table?

Options :

A : DATE_OUTPUT_FORMAT

B : DATA_RETENTION_TIME_IN_DAYS

C : TIMEZONE

D : USE_CACHED_RESULT

Answer: B

Question 3

What is the LIST command used for in Snowflake?

Options :

A : Lists all the users assigned to a given role.

B : Lists all the files in a given stage.

C : Lists all the tables in a specific schema.

D : Lists all the privileges granted on a specific object.

Answer: B

Question 4

Which options are used in Snowflake notebooks for querying data? (Choose any 3 options)

Options :

A : Python

B : SQL

C : Markup

D : Markdown

Answer: A,B,D

Question 5

Which function in Snowflake Cortex LLM are Task Specific Function? (Select two)

Options :

A : TRANSLATE

B : CLASSIFY_TEXT / AI_CLASSIFY

C : COUNT_TOKENS

D : PARSE_DOCUMENT

Answer: A,B,D