Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 581:

  Which statements reflect valid commands when using secondary roles? (Choose two.)

  A. USE SECONDARY ROLES RESUME
  B. USE SECONDARY ROLES SUSPEND
  C. USE SECONDARY ROLES ALL
  D. USE SECONDARY ROLES ADD
  E. USE SECONDARY ROLES NONE
  C. USE SECONDARY ROLES ALL
  E. USE SECONDARY ROLES NONE

  ---

  Explanation

• Question 582:

  What are supported file formats for unloading data from Snowflake? (Choose three.)

  A. XML
  B. JSON
  C. Parquet
  D. ORC
  E. AVRO
  F. CSV
  B. JSON
  C. Parquet
  F. CSV

  ---

  Explanation

• Question 583:

  What is a recommended approach for optimizing query performance in Snowflake?

  A. Use subqueries whenever possible.
  B. Use a large number of joins to combine data from multiple tables.
  C. Select all columns from tables, even if they are not needed in the query.
  D. Use a smaller number of larger tables rather than a larger number of smaller tables.
  D. Use a smaller number of larger tables rather than a larger number of smaller tables.

  ---

  Explanation

• Question 584:

  What metadata does Snowflake store concerning all rows stored in a micro-partition? (Choose two.)

  A. A count of the number of total values in the micro-partition
  B. The range of values for each partition in the micro-partition
  C. The range of values for each of the rows in the micro-partition
  D. The range of values for each of the columns in the micro-partition
  E. The number of distinct values for each column in the micro-partition
  D. The range of values for each of the columns in the micro-partition
  E. The number of distinct values for each column in the micro-partition

  ---

  Explanation

  Snowflake stores metadata about all rows stored in a micro-partition, including the range of values for each of the columns in the micro-partition and the number of distinct values

• Question 585:

  What does SnowCD help Snowflake users to do?

  A. Copy data into files.
  B. Manage different databases and schemas.
  C. Troubleshoot network connections to Snowflake.
  D. Write SELECT queries to retrieve data from external tables.
  C. Troubleshoot network connections to Snowflake.

  ---

  Explanation

• Question 586:

  Which metrics in the QUERY_HISTORY Account _Usage View can be used to assess the pruning e ciency of a query? (Choose two.)

  A. EXECUTION_TIME
  B. PARTITIONS_TOTAL
  C. COMPILATION_TIME
  D. TOTAL_ELAPSED_TIME
  E. PARTITIONS_SCANNED
  B. PARTITIONS_TOTAL
  E. PARTITIONS_SCANNED

  ---

  Explanation

• Question 587:

  What will be the result of this command?

  SELECT value FROM LATERAL FLATTEN(input => parse_json('[1, 2, 3]'));

  A. It will return a single row with three columns with values 1, 2, and 3.
  B. It will return a single row with the values 1, 2, and 3 concatenated.
  C. It will return a single row with the array [1, 2, 3].
  D. It will return three rows with the values 1, 2, and 3.
  A. It will return a single row with three columns with values 1, 2, and 3.

  ---

  Explanation

• Question 588:

  What does a table with a clustering depth of 1 mean in Snowflake?

  A. The table has only 1 micro-partition.
  B. The table has 1 overlapping micro-partition.
  C. The table has no overlapping micro-partitions.
  D. The table has no micro-partitions.
  C. The table has no overlapping micro-partitions.

  ---

  Explanation

• Question 589:

  How can a user get the MOST detailed information about individual table storage details in Snowflake?

  A. SHOW TABLES command
  B. SHOW EXTERNAL TABLES command
  C. TABLES view
  D. TABLE STORAGE METRICS view
  D. TABLE STORAGE METRICS view

  ---

  Explanation

• Question 590:

  What is the minimum Snowflake edition that has column-level security enabled?

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

  ---

  Explanation