Question 1

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 2

What is the main characteristic of Snowflake's Standard Edition?

Options :

A : Offers unlimited Time Travel history.

B : Includes Business Critical features like HIPAA compliance.

C : Supports Private Connectivity (AWS PrivateLink, Azure Private Link).

D : Provides core Snowflake features for data warehousing and analytics.

Answer: D

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 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

Question 5

What filter can be used when searching for data products on the Snowflake Marketplace?

Options :

A : Size

B : Compatibility

C : Price

D : Performance

Answer: C

Higher Test Marks with Free Online SOL-C01 Exam Practice