Free Snowflake SOL-C01 Exam Dumps Questions & Answers

What is a key characteristic of a Snowflake virtual warehouse?

• A.It manages account roles.
• B.It encrypts data.
• C.It permanently stores data.
• D.It provides compute resources.

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

• A.DATA_RETENTION_TIME_IN_DAYS
• B.USE_CACHED_RESULT
• C.DATE_OUTPUT_FORMAT
• D.TIMEZONE

What is the purpose of the USE SCHEMA command in Snowflake?

• A.To modify the schema structure in a session
• B.To create a new schema in a database
• C.To take ownership of an existing schema
• D.To set the current schema for a session

What is a key capability of the Snowflake virtual warehouse?

• A.It can store data permanently.
• B.It supports unlimited concurrency.
• C.It can be located on-premises.
• D.It can be dynamically scaled up or down.

Which of the following are date and time data types in Snowflake? (Choose any 3 options)

• A.DATETIME
• B.DATE
• C.TIMEDATE
• D.TIMESTAMP