Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1531:

  Which element in the Query Profile interface shows the relationship between the nodes in the execution of a query?

  A. Node List
  B. Steps
  C. Overview
  D. Operator Tree
  D. Operator Tree

  ---

  Explanation

• Question 1532:

  Which of the following terms best describes Snowflake's database architecture?

  A. Columnar shared nothing
  B. Shared disk
  C. Multi-cluster, shared data
  D. Cloud-native shared memory
  C. Multi-cluster, shared data

  ---

  Explanation

  https://www.snowflake.com/product/architecture/

  Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.

• Question 1533:

  What feature can be used to reorganize a very large table on one or more columns?

  A. Micro-partitions
  B. Clustering keys
  C. Key partitions
  D. Clustered partitions
  B. Clustering keys

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 1534:

  Using variables in Snowflake is denoted by using which SQL character?

  A. @
  B. and
  C. $
  D. #
  C. $

  ---

  Explanation

• Question 1535:

  When unloading to a stage, which of the following is a recommended practice or approach?

  A. Set SINGLE: = true for larger files
  B. Use OBJECT_CONSTRUCT ( * ) when using Parquet
  C. Avoid the use of the CAST function
  D. Define an individual file format
  D. Define an individual file format

  ---

  Explanation

• Question 1536:

  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
  B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

  ---

  Explanation

• Question 1537:

  Where does Snowflake store the data output from a query that was executed in the past 24 hours?

  A. In a micro-partition
  B. In a remote disk
  C. In the result cache layer
  D. In the local disk cache layer
  C. In the result cache layer

  ---

  Explanation

  Snowflake stores query results in the result cache layer for up to 24 hours if the query and underlying data have not changed. This allows Snowflake to return results quickly without re-executing the query. The result cache is distinct from local

  disk or remote storage and is optimized for query performance.

  References:

  Snowflake Documentation: Query Result Caching

• Question 1538:

  What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

  A. Enterprise
  B. Business Critical
  C. Standard
  D. Virtual Private Snowflake
  A. Enterprise

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition

• Question 1539:

  When creating a custom role that will be allowed to create warehouses and databases, which system-defined role does Snowflake recommend also be assigned to the custom role?

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

  ---

  Explanation

• Question 1540:

  A user wants to create objects within a schema but wants to restrict other users' ability to grant privileges on these objects.

  What configuration should be used to create the schema?

  A. Use a regular (non-managed) schema.
  B. Use a managed access schema.
  C. Use a transient schema.
  D. Set the Default_DDL_Collation parameter.
  B. Use a managed access schema.

  ---

  Explanation