Home / Snowflake / COF-R02

Snowflake COF-R02 Practice Test - Questions Answers, Page 23

Question list

List of questions

Question 221

(0)

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be

Question 222

(0)

Users are responsible for data storage costs until what occurs?

Question 223

(0)

What affects whether the query results cache can be used?

Question 224

(0)

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Question 225

(0)

How many days is load history for Snowpipe retained?

Question 226

(0)

How can a row access policy be applied to a table or a view? (Choose two.)

Question 227

(0)

Which command can be used to load data files into a Snowflake stage?

Question 228

(0)

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Question 229

(0)

What is the maximum Time Travel retention period for a temporary Snowflake table?

Question 230

(0)

When should a multi-cluster warehouse be used in auto-scaling mode?

Question 221

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

How can this requirement be met?

Use data encryption.

Use dynamic data masking.

Use secure materialized views.

Revoke all roles for functional managers and end users.

Show Answer Comment (0)

Question 222

Users are responsible for data storage costs until what occurs?

Data expires from Time Travel

Data expires from Fail-safe

Data is deleted from a table

Data is truncated from a table

Show Answer Comment (0)

Question 223

What affects whether the query results cache can be used?

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

Show Answer Comment (0)

Question 224

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

SELECT SUM (ORDER_AMT) FROM SALES;

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT MIN(ORDER_AMT) FROM SALES;

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Show Answer Comment (0)