COF-R02 Online Practice Questions and Answers

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

A. Configure the Maximum Clusters setting to "Auto-Scale"

B. Set the Warehouse type to "Auto"

C. Set the Minimum Clusters and Maximum Clusters settings to the same value

D. Set the Minimum Clusters and Maximum Clusters settings to the different values

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A. A single join node uses more than 50% of the query time

B. Partitions scanned is equal to partitions total

C. An AggregateOperacor node is present

D. The query is spilling to remote storage

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

A. Via the Snowflake Web Interface (Ul)

B. Via the data_share=true parameter

C. Via SQL commands

D. Via Virtual Warehouses

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

A. Standard

B. Premium

C. Enterprise

D. Business Critical

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

A. Pipes

B. Streams

C. Tasks

D. Procedures

Which statement describes how Snowflake supports reader accounts?

A. A reader account can consume data from the provider account that created it and combine it with its own data.

B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

A. The columns that are queried in the select clause.

B. The columns with very high cardinality.

C. The columns with many different values.

D. The columns most actively used in the select filters.

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

A. SHOW GRANTS ON ROLE DATA_SCIENCE

B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

C. SHOW GRANTS TO USER INQUISITIVE_PERSON

D. SHOW GRANTS OF ROLE DATA_SCIENCE

What is true about sharing data in Snowflake? (Choose two.)

A. The Data Consumer pays for data storage as well as for data computing.

B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

C. A Snowflake account can both provide and consume shared data.

D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.

E. The Data Consumer pays only for compute resources to query the shared data.

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.