Which minimum Snowflake edition allows for a dedicated metadata store?

• A.Standard
• B.Enterprise
• C.Business Critical
• D.Virtual Private Snowflake

Comment: *

Name: *

Email: *

Verification: *

When should a multi-cluster warehouse be used in auto-scaling mode?

• A.If the runtime of the executed query is very slow
• B.If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
• C.When a large number of concurrent queries are run on the same warehouse
• D.When it is unknown how much compute power is needed

Comment: *

Name: *

Email: *

Verification: *

What is the maximum Time Travel retention period for a temporary Snowflake table?

• A.90 days
• B.1 day
• C.7 days
• D.45 days

Comment: *

Name: *

Email: *

Verification: *

Which features make up Snowflake's column level security? (Select TWO).

• A.Key pair authentication
• B.Dynamic Data Masking
• C.External Tokenization
• D.Row access policies
• E.Continuous Data Protection (CDP)

Comment: *

Name: *

Email: *

Verification: *

How can a user change which columns are referenced in a view?

• A.Modify the columns in the underlying table
• B.Use the ALTER VIEW command to update the view
• C.Recreate the view with the required changes
• D.Materialize the view to perform the changes

Comment: *

Name: *

Email: *

Verification: *