Which feature is designed to reduce security risks associated with an individual user ' s password authentication?

• A.Multi-Factor Authentication, or MFA
• B.Standard authentication
• C.Snowflake OAuth
• D.External OAuth

Comment: *

Name: *

Email: *

Verification: *

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

• A.Data can be filtered by an optional where clause
• B.Incoming data can be joined with other tables
• C.Columns can be reordered
• D.Columns can be omitted
• E.Row level access can be defined

Comment: *

Name: *

Email: *

Verification: *

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

• A.Create a task that runs a copy into operation from an external stage every 5 minutes
• B.Create a task that puts the files in an internal stage and automate the data loading wizard
• C.Create a task that runs a GET operation to intermittently check for new files
• D.Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Comment: *

Name: *

Email: *

Verification: *

Which type of role can be granted to a share?

• A.Account role
• B.Custom role
• C.Database role
• D.Secondary role

Comment: *

Name: *

Email: *

Verification: *

What should be considered before implementing a Snowflake Data Clean Room?

• A.Participants can run unrestricted SQL queries directly against another participant's protected data.
• B.Providers can configure and share clean rooms only with individual users in other Snowflake accounts.
• C.A consumer must be approved by a clean-room administrator before the consumer can be invited.
• D.The regional locations of the participating Snowflake accounts must be considered because collaboration availability and cross-region requirements depend on the clean-room deployment.

Comment: *

Name: *

Email: *

Verification: *