Which service or tool is a Command Line Interface (CLI) client used for connecting to Snowflake to execute SQL queries?

• A.Snowsight
• B.SnowCD
• C.Snowpark
• D.SnowSQL

Comment: *

Name: *

Email: *

Verification: *

What type of query benefits the MOST from search optimization?

• A.A query that uses only disjunction (i.e., OR) predicates
• B.A query that includes analytical expressions
• C.A query that uses equality predicates or predicates that use IN
• D.A query that filters on semi-structured data types

Comment: *

Name: *

Email: *

Verification: *

What are the default Time Travel and Fail-safe retention periods for transient tables?

• A.Transient tables are retained in neither Fail-safe nor Time Travel
• B.Time Travel - 1 day. Fail-safe - 1 day
• C.Time Travel - 0 days. Fail-safe - 1 day
• D.Time Travel - 1 day. Fail-safe - 0 days

Comment: *

Name: *

Email: *

Verification: *

Which of the following are common use cases for zero-copy cloning? Choose 3 answers

• A.Performance optimization
• B.Quick provisioning of Dev and Test/QA environments
• C.Point in time snapshots
• D.Data backups

Comment: *

Name: *

Email: *

Verification: *

True or False: You can query the files in an External Stage directly without having to load the data into a table.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *