Question 1

How can customer data be restricted by country for a global company using a multi-tenant environment?

Options :

A : Implement a new account structure and create sub-accounts for each country. Then replicate the required data.

B : Implement a row-level security policy in the customer table that looks at a mapping table identifying which users should have access to what data.

C : Implement a secure User-Defined Function (UDF) and use a secure data share for each country.

D : Implement a column-level security policy in the customer table that restricts access based on the user's geographic location.

Answer: B

Question 2

How does Snowflake support the use of structured and semi-structured data? (Select TWO)

Options :

A :

Structured data is supported through the use of traditional relational database tables, organized into rows and columns.

B :

Structured and semi-structured data are stored in separate physical storage locations; users must choose which type of data to use when creating a table.

C : Semi-structured data is supported through the use of automatically indexed database tables.

D :

All semi-structured data is automatically converted into structured data when it is loaded into Snowflake.

E :

Users can load and query semi-structured data using SQL using the SQL semi-structured data handling functions.

Answer: A,E

Question 3

How can unstructured data be processed in a Snowflake stage? (Select TWO).

Options :

A : Use a SQL procedure.

B : Use external functions.

C : Use a C# procedure.

D : Implement a Golang (Go) User-Defined Function (UDF).

E : Implement a Python User-Defined Function (UDF).

Answer: B

Question 4

What action will change a customized schedule for a resource monitor back to the default schedule?

Options :

A : Changing the monitoring frequency to the default value

B : Changing the monitoring start timestamp to the default value

C : Dropping and re-creating the monitor

D : Cloning the monitor and then editing the cloned monitor schedule

Answer: C

Question 5

What can a directory table be used for? (Select TWO)

Options :

A : Retrieve a list of all unstructured files on a stage.

B : Set an automatic refresh of the metadata for a directory table on internal and external stages.

C : Remove files from a directory table using the GET command.

D : Create a view for unstructured data.

E : Process unstructured data using Snowflake system-defined functions.

Answer: A,B

Confidently Practice Online with Free COF-C02 Exam Cram

Buying Options: