Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 511:

  Which Snowflake architectural layer is responsible for a query execution plan?

  A. Compute
  B. Data storage
  C. Cloud services
  D. Cloud provider
  C. Cloud services

  ---

  Explanation

• Question 512:

  When cloning a schema, which Snowflake object will not be included in the clone?

  A. An external stage
  B. A named internal stage
  C. A task
  D. A User-Defined Function (UDF)
  B. A named internal stage

  ---

  Explanation

• Question 513:

  Network policies can be set at which Snowflake levels? (Choose two.)

  A. Role
  B. Schema
  C. User
  D. Database
  E. Account
  F. Tables
  C. User
  E. Account

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies

• Question 514:

  Which sequence (order) of object privileges should be used to grant a custom role read-only access on a table?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

  ---

  Explanation

• Question 515:

  Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?

  A. Data classification
  B. Query acceleration service
  C. Search optimization service
  D. Tagging
  C. Search optimization service

  ---

  Explanation

• Question 516:

  Which file formats support unloading semi-structured data? (Choose two.)

  A. Avro
  B. JSON
  C. ORC
  D. Parquet
  E. XML
  B. JSON
  D. Parquet

  ---

  Explanation

• Question 517:

  What do these Query Profile metrics indicate about the query micro-partition pruning?

  

  A. No micro-partitions were pruned during execution.
  B. The query used the local disk cache and pruning was not required.
  C. The size of the data queried was too small to trigger micro-partition pruning.
  D. Since the bytes scanned is less than the bytes written to results, some pruning has occurred.
  A. No micro-partitions were pruned during execution.

  ---

  Explanation

  Micro-partition pruning is a Snowflake optimization feature that minimizes the amount of data scanned by restricting the query to relevant micro-partitions.

  Query Profile Analysis:

  Key Observations from the Metrics:

  Bytes Scanned vs. Partitions:

  Percentage Scanned from Cache (25.58%):

  Bytes Scanned vs. Bytes Written:

  References:

  Snowflake Documentation: Query Profile Overview

  Snowflake Documentation: Micro-Partition Pruning

• Question 518:

  At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

  A. Account
  B. Database
  C. Schema
  D. Table
  A. Account

  ---

  Explanation

• Question 519:

  Assuming the data provider has granted the required permissions to the objects in a share, which statement will grant permissions to the role consumer_role, allowing access to the database share_db?

  A. grant imported privileges on database share_db to role consumer_role;
  B. grant usage on database share_db to role consumer_role;
  C. grant ownership on database share_db to role consumer_role;
  D. grant all on database share_db to role consumer_role;
  A. grant imported privileges on database share_db to role consumer_role;

  ---

  Explanation

• Question 520:

  What type of query will benefit from the query acceleration service?

  A. Queries without filters or aggregation
  B. Queries with large scans and selective filters
  C. Queries where the GROUP BY has high cardinality
  D. Queries of tables that have search optimization service enabled
  B. Queries with large scans and selective filters

  ---

  Explanation

  Examples of the types of workloads that might benefit from the query acceleration service:

  1) Ad hoc analytics.

  2) Workloads with unpredictable data volume per query.

  3) Queries with large scans and selective filters.

  https://docs.snowflake.com/en/user-guide/query-acceleration-service#label-query-acceleration-scale-factor