Which virtual warehouse configuration requires the maximum number of clusters to be equal to the minimum number of clusters?

• A.Auto-scale mode
• B.Maximized mode
• C.Standard scaling policy
• D.Economy scaling policy

Comment: *

Name: *

Email: *

Verification: *

What are the main differences between the account usage views and the information schema views? (Select TWO).

• A.No active warehouse to needed to query account usage views but one is needed to query information schema views.
• B.Account usage views do not contain data about tables but information schema views do.
• C.Account issue views contain dropped objects but information schema views do not.
• D.Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
• E.Information schema views are read-only but account usage views are not.

Comment: *

Name: *

Email: *

Verification: *

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

• A.Okta Verify
• B.Duo Mobile
• C.Microsoft Authenticator
• D.Google Authenticator

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes a Snowflake stored procedure?

• A.They can be created as secure and hide the underlying metadata from the user.
• B.They can only access tables from a single database.
• C.They can contain only a single SQL statement.
• D.They can be created to run with a caller's rights or an owner's rights.

Comment: *

Name: *

Email: *

Verification: *

Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

• A.DELETE
• B.DROP
• C.REMOVE
• D.TRUNCATE

Comment: *

Name: *

Email: *

Verification: *