Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 711:

  Which ACCOUNT_USAGE view can be used to identify the masking policy assigned to an object?

  A. ACCESS_HISTORY
  B. OBJECT_DEPENDENCIES
  C. POLICY_REFERENCES
  D. TAG_REFERENCES
  C. POLICY_REFERENCES

  ---

  Explanation

• Question 712:

  What are the benefits of using the Snowflake Access_History view? (Select TWO).

  A. identifies data that is not being used so that it can be archived or deleted.
  B. It allows the user to compare query performance data over time.
  C. It audits whether query policies are being enforced correctly.
  D. It tracks how sensitive data has been moved.
  E. It allows users to track the relationships among objects.
  D. It tracks how sensitive data has been moved.
  E. It allows users to track the relationships among objects.

  ---

  Explanation

  The Access_History view provides detailed metadata about how objects in Snowflake are accessed and used.

  Key benefits include:

  References:

  Snowflake Documentation: ACCESS_HISTORY View

  Data Governance in Snowflake

• Question 713:

  Which command is used to unload files from an internal or external stage to a local file system?

  A. COPY INTO
  B. GET
  C. PUT
  D. TRANSFER
  B. GET

  ---

  Explanation

• Question 714:

  A column named "Data" contains VARIANT data and stores values as follows:

  

  How will Snowflake extract the employee's name from the column data?

  A. Data:employee.name
  B. DATA:employee.name
  C. data:Employee.name
  D. data:employee.name
  C. data:Employee.name

  ---

  Explanation

• Question 715:

  AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

• Question 716:

  Which command should be used to unload all the rows from a table into one or more files in a named stage?

  A. COPY INTO
  B. GET
  C. INSERT INTO
  D. PUT
  A. COPY INTO

  ---

  Explanation

• Question 717:

  Which data types does Snowflake support when querying semi-structured data? (Select TWO)

  A. VARIANT
  B. ARRAY
  C. VARCHAR
  D. XML
  E. BLOB
  A. VARIANT
  B. ARRAY

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.

  The maximum length of a VARIANT is 16 MB.

  A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.

• Question 718:

  When setting up a resource monitor for a virtual warehouse, at what interval are used credits reset?

  A. Every 12 hours
  B. Daily
  C. Every 48 hours
  D. Quarterly
  B. Daily

  ---

  Explanation

• Question 719:

  What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

  A. Data is hashed by the cluster key to facilitate fast searches for common data values
  B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
  C. Smaller micro-partitions are created for common data values to allow for more parallelism
  D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
  D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

  ---

  Explanation

• Question 720:

  Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

  A. SELECT SUM (ORDER_AMT) FROM SALES;
  B. SELECT AVG(ORDER_QTY) FROM SALES;
  C. SELECT MIN(ORDER_AMT) FROM SALES;
  D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;
  C. SELECT MIN(ORDER_AMT) FROM SALES;

  ---

  Explanation