Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1461:

  Which categories are included in the execution time summary in a Query Profile? (Choose two.)

  A. Pruning
  B. Spilling
  C. Initialization
  D. Local Disk I/O
  E. Percentage of data read from cache
  C. Initialization
  D. Local Disk I/O

  ---

  Explanation

• Question 1462:

  The following settings are configured:

  THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level. THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level.

  For how many days will the data be retained at the object level?

  A. 2
  B. 3
  C. 5
  D. 7
  C. 5

  ---

  Explanation

• Question 1463:

  What is the default Time Travel retention period?

  A. 1 day
  B. 7 days
  C. 45 days
  D. 90 days
  A. 1 day

  ---

  Explanation

• Question 1464:

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

  A. Cloud services layer
  B. Compute layer
  C. Storage layer
  D. Cloud agnostic layer
  A. Cloud services layer

  ---

  Explanation

  https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556

• Question 1465:

  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
  A. The account type
  C. The cloud region used by the account

  ---

  Explanation

• Question 1466:

  You can query the files in an External Stage directly without having to load the data into a table.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-external-intro.html

  External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

• Question 1467:

  Which steps will reduce memory spillage when running a very large query? (Select TWO)

  A. Enable auto-scale mode on the virtual warehouse.
  B. Increase the network bandwidth.
  C. Process the data in smaller batches.
  D. Add a DISTINCT clause to the query.
  E. Increase the size of the virtual warehouse.
  C. Process the data in smaller batches.
  E. Increase the size of the virtual warehouse.

  ---

  Explanation

  Processing data in smaller batches reduces resource pressure during execution.

  Increasing warehouse size provides more memory and CPU, which helps reduce memory spillage , where intermediate data is written to disk.

  Snowflake Docs: Query Performance Tuning

• Question 1468:

  When a database is cloned, which objects in the clone inherit all granted privileges from the source object? (Choose two.)

  A. Account
  B. Database
  C. Schemas
  D. Tables
  E. Internal named stages
  C. Schemas
  D. Tables

  ---

  Explanation

  Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container.

• Question 1469:

  Which are true of Snowflake roles?

  A. All grants to objects are given to roles, and never to users
  B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
  C. The public role controls at other roles
  D. Roles are a subset of users and users own objects In Snowflake
  A. All grants to objects are given to roles, and never to users
  B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation

  ---

  Explanation

• Question 1470:

  When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.

  A. True
  B. False
  B. False

  ---

  Explanation