This query was executed:

Assuming the weather_events table has not changed, which query would benefit from cached results?

• A.SELECT DISTINCT(severity) FROM weather_events ; if run within 24 hours after the initial query execution
• B.select distinct (severity) from weather_events; if run within 24 hours after the initial query execution
• C.select distinct(severity) from weather_events; if run within 48 hours after the initial query execution
• D.SELECT DISTINCT(severity) FROM weather_events we; if run within 24 hours after the initial query execution

Comment: *

Name: *

Email: *

Verification: *

What is the recommended way to change the existing file format type in my format from CSV to JSON?

• A.REPLACE FILE FORMAT my format TYPE-JSON;
• B.ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
• C.CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
• D.ALTER FILE FORMAT my_format SET TYPE=JSON;

Comment: *

Name: *

Email: *

Verification: *

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

• A.When users will be using compute at different times throughout a 24/7 period
• B.When managing a steady workload
• C.When the compute must be available with no delay or lag time
• D.When the user does not want to have to manually turn on the warehouse each time it is needed
• E.When the warehouse is shared across different teams

Comment: *

Name: *

Email: *

Verification: *

What happens when a cloned table is replicated to a secondary database? (Select TWO)

• A.A read-only copy of the cloned tables is stored.
• B.The replication will not be successful.
• C.The physical data is replicated
• D.Additional costs for storage are charged to a secondary account
• E.Metadata pointers to cloned tables are replicated

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake native tool can be used to diagnose and troubleshoot network connections?

• A.SnowSQL
• B.Snowflake Python connector
• C.Snowsight
• D.SnowCD

Comment: *

Name: *

Email: *

Verification: *