A clustering key was defined on a table, but It is no longer needed. How can the key be removed?

• A.ALTER TABLE <TABLE NAME> PURGE CLUSTERING KEY
• B.ALTER TABLE <TABLE NAME> DELETE CLUSTERING KEY
• C.ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY
• D.ALTER TABLE <TABLE NAME> REMOVE CLUSTERING KEY

Comment: *

Name: *

Email: *

Verification: *

True or False: A single database can exist in more than one Snowflake account.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

• A.12 hours
• B.1 Hour
• C.24 hours
• D.3 Hours

Comment: *

Name: *

Email: *

Verification: *

What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).

• A.INSERT
• B.UPDATE
• C.DELETE
• D.TRUNCATE
• E.UPSERT

Comment: *

Name: *

Email: *

Verification: *

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

• A.View
• B.External table
• C.Materialized view
• D.Secure view

Comment: *

Name: *

Email: *

Verification: *