COF-C02 Online Practice Questions and Answers

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

A. True

B. False

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

A. Their default role should be set to SYSTEMADMIN (the lower of the two)

B. They should not set up multi_Factor Authentication (MFA)--as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so

C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

D. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

E. They should use the SYSADMIN role to perform administrative work on database objects

Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy? Select one.

A. Account-> Schema-> Database-> Table

B. Account-> Database-> Schema-> Table

C. Database-> Schema-> Table-> Account

D. Database-> Table-> Schema-> Account

True or False: It is possible to load data into Snowflake without creating a named File Format object.

A. True

B. False

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

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

A. VARIANT

B. ARRAY

C. VARCHAR

D. XML

E. BLOB

Will data cached in a warehouse be lost when the warehouse is resized?

A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B. Yes. because the compute resource is replaced in its entirety with a new compute resource.

C. No. because the size of the cache is independent from the warehouse size

D. Yes. became the new compute resource will no longer have access to the cache encryption key

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A. Bytes sent over network

B. Percentage scanned from cache

C. Partitions total

D. Bytes spilled to local storage

E. Partitions scanned

What actions does the use of the PUT command do automatically? (Choose two.)

A. It creates a file format object.

B. It uses the last stage created.

C. It compresses all files using GZIP.

D. It encrypts the file data in transit.

E. It creates an empty target table.

What factors impact storage costs in Snowflake? (Choose two.)

A. The account type

B. The storage file format

C. The cloud region used by the account

D. The type of data being stored

E. The cloud platform being used