COF-R02 Online Practice Questions and Answers

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

A. The tables are now orphaned

B. The user that deleted the role

C. SYSADMIN

D. The assumed role that dropped the role

Which feature is only available in the Enterprise or higher editions of Snowflake?

A. Column-level security

B. SOC 2 type II certification

C. Multi-factor Authentication (MFA)

D. Object-level access control

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

A. Compute layer

B. Storage layer

C. Cloud infrastructure layer

D. Cloud services layer

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

A. Users

B. Tables

C. Databases

D. Internal Stages

Which Snowflake partner specializes in data catalog solutions?

A. Alation

B. DataRobot

C. dbt

D. Tableau

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

B. A Data Exchange allows groups of accounts to share data privately among the accounts.

C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.

D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

A. 10-50 MB

B. 100-250 MB

C. 300-500 MB

D. 1000-1500 MB

Which statement describes pruning?

A. The filtering or disregarding of micro-partitions that are not needed to return a query.

B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.

C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.

D. The ability to allow the result of a query to be accessed as if it were a table.

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

A. In the metadata of the target table for 14 days

B. In the metadata of the pipe for 14 days

C. In the metadata of the target table for 64 days

D. In the metadata of the pipe for 64 days

How many days is load history for Snowpipe retained?

A. 1 day

B. 7 days

C. 14 days

D. 64 days