Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 31:

  Which privilege must be granted by one role to another role, and cannot be revoked?

  A. MONITOR
  B. OPERATE
  C. OWNERSHIP
  D. ALL
  C. OWNERSHIP

  ---

  Explanation

• Question 32:

  For a multi-cluster virtual warehouse, which parameters are used to calculate the number of credits billed? (Choose two.)

  A. Cache size
  B. Warehouse size
  C. Number of clusters
  D. Volume of data processed
  E. Number of queries executed
  B. Warehouse size
  C. Number of clusters

  ---

  Explanation

• Question 33:

  When resizing a currently-running virtual warehouse, what happens to in-progress queries?

  A. In-progress queries will be cancelled.
  B. Queries will continue running, using the new warehouse size.
  C. Queries will continue running, using the current warehouse size.
  D. Queries will be paused and automatically be re-processed using the new warehouse size.
  C. Queries will continue running, using the current warehouse size.

  ---

  Explanation

• Question 34:

  How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?

  A. Log in to the data consumer account and check if the secure view data is appearing as expected.
  B. Create a data share for a test data consumer account and check if the secure view data is appearing as expected.
  C. Query the secure view from a consumer account by setting the share_restrictions parameter.
  D. Simulate querying the secure view by setting the simulated_data_sharing_consumer session parameter.
  B. Create a data share for a test data consumer account and check if the secure view data is appearing as expected.

  ---

  Explanation

  The most effective way for a data provider to validate secure view configurations is to create a data share for a test data consumer account. This method allows the provider to review and confirm that only the intended data is accessible in the secure view. Secure views are designed to mask or restrict data visibility, so creating a test share replicates the consumer's experience and ensures data security before sharing with actual consumers.

• Question 35:

  What does the orange bar on an operator represent when reviewing the Query Profile?

  

  A. A measure of progress of the operator's execution.
  B. The fraction of time that this operator consumed within the query step.
  C. The cost of the operator in terms of the virtual warehouse CPU utilization.
  D. The fraction of data scanned from cache versus remote disk for the operator.
  B. The fraction of time that this operator consumed within the query step.

  ---

  Explanation

• Question 36:

  In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?

  A. READ
  B. REFERENCES
  C. REFERENCE_USAGE
  D. USAGE
  D. USAGE

  ---

  Explanation

• Question 37:

  What is a characteristic of a role in Snowflake?

  A. Roles cannot be granted to other roles.
  B. System-defined roles can be dropped.
  C. Privileges granted to system roles by Snowflake can be revoked.
  D. Privileges on securable objects can be granted and revoked to a role.
  D. Privileges on securable objects can be granted and revoked to a role.

  ---

  Explanation

• Question 38:

  What are the native data types that Snowflake provides to store semi-structured data? (Choose two.)

  A. ARRAY
  B. JSON
  C. ORC
  D. Parquet
  E. VARIANT
  A. ARRAY
  E. VARIANT

  ---

  Explanation

• Question 39:

  The VALIDATE table function has which parameter as an input argument for a Snowflake user?

  A. LAST_QUERY_ID
  B. CURRENT_STATEMENT
  C. UUID_STRING
  D. JOB_ID
  D. JOB_ID

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/functions/validate

• Question 40:

  Which privilege must be granted to show data categories in a Data Exchange?

  A. MONITOR PRIVILEGE
  B. USAGE PRIVILEGE
  C. OWNERSHIP PRIVILEGE
  D. IMPORTED PRIVILEGES
  A. MONITOR PRIVILEGE

  ---

  Explanation