COF-R02 Online Practice Questions and Answers

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

A. True

B. False

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

A. 4

B. 16

C. 32

D. 128

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

A. True

B. False

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

A. Informatica

B. Power Bl

C. Adobe

D. Data Robot

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

A. The load HISTORY view

B. The Query history view

C. The show warehouses command

D. The WAREHOUSE_METERING__HISTORY View

E. The billing and usage tab in the Snowflake web Ul

Which of the following objects are contained within a schema? (Choose two.)

A. Role

B. Stream

C. Warehouse

D. External table

E. User

F. Share

Which Snowflake tool would be BEST to troubleshoot network connectivity?

A. SnowCLI

B. SnowUI

C. SnowSQL

D. SnowCD

What are common issues found by using the Query Profile? (Choose two.)

A. Identifying queries that will likely run very slowly before executing them

B. Locating queries that consume a high amount of credits

C. Identifying logical issues with the queries

D. Identifying inefficient micro-partition pruning

E. Data spilling to a local or remote disk

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

B. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

C. The ACCOUNTADMIN role must be granted to only one user.

D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

E. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

A. There is no need to have a Snowflake account in the target region, a share will be created for each user.

B. The listing is replicated into all selected regions automatically, the data is not.

C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.

D. Shares attached to listings in remote regions can be viewed from any account in an organization.

E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.