Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 841:

  What role in Snowflake separates the management of users and roles from the management of all grants?

  A. ACCOUNTADMIN
  B. SYSADMIN
  C. SECURITYADMIN
  D. USERADMIN
  C. SECURITYADMIN

  ---

  Explanation

  https://medium.com/snowflake/role-based-access-control-rbac-with-secondary-roles-8ce3c7bb57df

• Question 842:

  A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period.

  How can the table be restored using the LEAST amount of operational overhead?

  A. Clone the table schema as it existed before the table was dropped.
  B. Clone the database as it existed before the table was dropped.
  C. Recreate the table and reload the data.
  D. Run the UNDROP command against the table.
  D. Run the UNDROP command against the table.

  ---

  Explanation

  In Snowflake, if a table is accidentally dropped but still within the data retention period (also known as "Time Travel"), the simplest and most efficient recovery method is the UNDROP command. This command restores the deleted table to its previous state with minimal operational effort. Since Snowflake retains dropped table data for a specific retention period (up to 90 days for the Enterprise edition), UNDROP can quickly recover the table without the need for complex cloning or data reloading processes, making it ideal for accidental deletions.

• Question 843:

  What is the purpose of a Query Profile?

  A. To profile how many times a particular query was executed and analyze its usage statistics over time.
  B. To profile a particular query to understand the mechanics of the query, its behavior, and performance.
  C. To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
  D. To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.
  B. To profile a particular query to understand the mechanics of the query, its behavior, and performance.

  ---

  Explanation

• Question 844:

  Which validation option is the only one that supports the COPY INTO command?

  A. RETURN_ROWS
  B. RETURN__ROWS
  C. RETURN_ERRORS
  D. RETURN_ALL_ERRORS
  A. RETURN_ROWS

  ---

  Explanation

• Question 845:

  What aspect of an executed query is represented by the remote disk I/O statistic of the Query Profile in Snowflake?

  A. Time spent scanning the table partitions to filter data based on the predicate
  B. Time spent caching the data to remote storage in order to buffer the data being extracted and exported
  C. Time spent reading and writing data from and to remote storage when the data being accessed does not fit into the executing virtual warehouse node memory
  D. Time spent reading and writing data from and to remote storage when the data being accessed does not fit into either the virtual warehouse memory or the local disk
  D. Time spent reading and writing data from and to remote storage when the data being accessed does not fit into either the virtual warehouse memory or the local disk

  ---

  Explanation

• Question 846:

  Which privilege is required to use the search optimization service in Snowflake?

  A. GRANT SEARCH OPTIMIZATION ON SCHEMA TO ROLE
  B. GRANT SEARCH OPTIMIZATION ON DATABASE TO ROLE
  C. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE
  D. GRANT ADD SEARCH OPTIMIZATION ON DATABASE TO ROLE
  C. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE

  ---

  Explanation

• Question 847:

  How can storage costs be MINIMIZED while maintaining the history and integrity of a large, permanent table that is updated frequently?

  A. Decrease the Time Travel retention period
  B. Convert the table type to transient.
  C. Use zero-copy clones of the table.
  D. Enable automatic clustering
  A. Decrease the Time Travel retention period

  ---

  Explanation

• Question 848:

  How should clustering be used to optimize the performance of queries that run on a very large table?

  A. Manually re-cluster the table regularly.
  B. Choose one high cardinality column as the clustering key.
  C. Use the column that is most-frequently used in query select clauses as the clustering key.
  D. Assess the average table depth to identify how clustering is impacting the query.
  D. Assess the average table depth to identify how clustering is impacting the query.

  ---

  Explanation

• Question 849:

  How can a Snowflake user configure a virtual warehouse to support over 100 users if their company has Enterprise Edition?

  A. Add additional warehouses and configure them as a cluster.
  B. Set the auto-scale to 100.
  C. Use a multi-cluster warehouse.
  D. Use a larger warehouse.
  C. Use a multi-cluster warehouse.

  ---

  Explanation

• Question 850:

  Which command can be performed on a Snowflake secure view?

  A. SELECT
  B. INSERT
  C. UPDATE
  D. DELETE
  A. SELECT

  ---

  Explanation