Which command will consume credits from a virtual warehouse?

• A.SELECT MAX(UUID) FROM SNOWFLAKE;
• B.SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY UUID;
• C.SHOW TABLES LIKE ' SNOWFL% ' IN SCHEMA( ' PUBLIC ' );
• D.SELECT COUNT(*) FROM SNOWFLAKE;

Comment: *

Name: *

Email: *

Verification: *

A company configures two resource monitors:
* An account-level resource monitor with a quota of 1,000 credits and the action NOTIFY & SUSPEND.
* A warehouse-level resource monitor for the Marketing warehouse with a quota of 200 credits and the action NOTIFY & SUSPEND.
What happens when the Marketing warehouse reaches 200 credits while total account usage is only 700 credits?

• A.The Marketing warehouse is suspended immediately, and all running queries are canceled.
• B.A notification is sent, and the Marketing warehouse is suspended after currently running statements finish.
• C.A notification is sent, and the warehouse is suspended only when no ACCOUNTADMIN queries are running.
• D.The Marketing warehouse continues running until the account-level resource monitor reaches 1,000 credits.

Comment: *

Name: *

Email: *

Verification: *

How does Snowflake support Multi-Factor Authentication (MFA) with a second factor device?

• A.Using time-based, one-time passcodes
• B.Through integration with OAuth
• C.Through Role-Based Access Control (RBAC)
• D.Using federated authentication and Single Sign-On (SSO)

Comment: *

Name: *

Email: *

Verification: *

What is the minimum Snowflake edition required for row level security?

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

Comment: *

Name: *

Email: *

Verification: *

Which automatic Snowpipe feature ensures that the same data file is not loaded multiple times into a table?

• A.Snowpipe deletes files from the stage after they are loaded, so they cannot be loaded twice.
• B.Snowpipe references the metadata of previously loaded files and will not load new files with the same metadata.
• C.Snowpipe renames each file after loading, ensuring that the same file cannot be loaded more than once.
• D.Snowpipe moves each file to a temporary stage after loading, so it cannot be loaded more than once.

Comment: *

Name: *

Email: *

Verification: *