Snowflake COF-R02 Exam Practice Test Instant Access

Question 1

True or False: Snowflake supports federated authentication in all editions.

ATrue

BFalse

Answer : A

Question 2

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

A4 minutes

B10 minutes

C14 minutes

D24 minutes

Answer : C

Question 3

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Aparse_json()

Bjson_extract_path_text()

Cobject_construct()

Dflatten

Answer : B

Question 4

Which of the following accurately describes shares?

ATables, secure views, and secure UDFs can be shared

BShares can be shared

CData consumers can clone a new table from a share

DAccess to a share cannot be revoked once granted

Answer : A

Question 5

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

ATrue

BFalse

Answer : B

Question 6

What feature can be used to reorganize a very large table on one or more columns?

AMicro-partitions

BClustering keys

CKey partitions

DClustered partitions

Answer : B

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Question 7

What can be used to view warehouse usage over time? (Select Two).

AThe load HISTORY view

BThe Query history view

CThe show warehouses command

DThe WAREHOUSE_METERING__HISTORY View

EThe billing and usage tab in the Snowflake web Ul

Answer : D, E

Snowflake COF-R02 SnowPro Core Recertification Exam Practice Test