Free Access to Snowflake.COF-C02.v2024-02-19.q153 with Valid Practice Test (Page 23)

Question 106

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

A.Custom Edition
B.Business Critical Edition
C.Virtual Private Snowflake
D.Standard Edition
E.Enterprise Edition

Question 107

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

Question 108

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.

Question 109

Which of the following statements about data sharing are true? choose 2 answers

A.All database objects can be included In a shared database
B.New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts
C.Reader Accounts are created and funded by Data Prowlers
D.Shared databases are read-only

Question 110

Which of the following statements is true of Snowflake?

A.It's based on an Oracle Architecture
B.It was built for Hadoop architecture
C.It was built as an on-premises solution and then ported to the cloud
D.It was built specifically for the cloud
E.It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

Question 106

Question 107

Question 108

Question 109

Question 110

Download PDF File