A company stores Personal Identifiable Information (PII) in Snowflake across multiple countries, including the United States, Canada, and the United Kingdom.
How can Snowflake be used to automatically identify data, in order to support data governance requirements for each country?

• A.Use semantic category classification.
• B.Tag all columns directly that contain PII.
• C.Implement a third-party service to protect the data.
• D.Create a custom User-Defined Function (UDF).

Comment: *

Name: *

Email: *

Verification: *

What is the recommended file sizing for data loading using Snowpipe?

• A.A compressed file size greater than 100 MB, and up to 250 MB
• B.A compressed file size greater than 100 GB, and up to 250 GB
• C.A compressed file size greater than 10 MB, and up to 100 MB
• D.A compressed file size greater than 1 GB, and up to 2 GB

Comment: *

Name: *

Email: *

Verification: *

Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?

• A.External tables
• B.Secure views
• C.Alerts
• D.Materialized views

Comment: *

Name: *

Email: *

Verification: *

A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

• A.The user will be unable to enter a password.
• B.The user will encounter an error, and will not be able to log in.
• C.The user will be able to log into Snowflake successfully.
• D.After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

Comment: *

Name: *

Email: *

Verification: *

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

• A.UPDATE TABLE FROM STREAM
• B.SELECT FROM STREAM
• C.INSERT INTO TABLE SELECT FROM STREAM
• D.ALTER TABLE AS SELECT FROM STREAM
• E.BEGIN COMMIT

Comment: *

Name: *

Email: *

Verification: *