Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1271:

  Which object can be used with Secure Data Sharing?

  A. View
  B. Materialized view
  C. External table
  D. User-Defined Function (UDF)
  C. External table

  ---

  Explanation

• Question 1272:

  Which Snowflake data governance feature supports resource usage monitoring?

  A. Data classi cation
  B. Column lineage
  C. Access history
  D. Object tagging
  C. Access history

  ---

  Explanation

• Question 1273:

  Which account usage view in Snowflake can be used to identify the most-frequently accessed tables?

  A. Access_History
  B. Object_Dependencies
  C. Table_Storage_Metrics
  D. Tables
  A. Access_History

  ---

  Explanation

• Question 1274:

  What privilege should a user be granted to change permissions for new objects in a managed access schema?

  A. Grant the OWNERSHIP privilege on the schema.
  B. Grant the OWNERSHIP privilege on the database.
  C. Grant the MANAGE GRANTS global privilege.
  D. Grant ALL privileges on the schema.
  A. Grant the OWNERSHIP privilege on the schema.

  ---

  Explanation

• Question 1275:

  Which Snowflake objects can be secured to protect data privacy? (Choose two.)

  A. Schemas
  B. Stages
  C. Views
  D. Materialized views
  E. Tags
  C. Views
  D. Materialized views

  ---

  Explanation

• Question 1276:

  Which languages require that User-Defined Function (UDF) handlers be written inline? (Choose two.)

  A. Java
  B. Javascript
  C. Scala
  D. Python
  E. SQL
  B. Javascript
  E. SQL

  ---

  Explanation

• Question 1277:

  When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

  A. A single join node uses more than 50% of the query time
  B. Partitions scanned is equal to partitions total
  C. An AggregateOperacor node is present
  D. The query is spilling to remote storage
  D. The query is spilling to remote storage

  ---

  Explanation

• Question 1278:

  When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?

  A. The database owner
  B. The object owner
  C. The schema owner
  D. The Snowflake user's role
  C. The schema owner

  ---

  Explanation

• Question 1279:

  A user has a standard multi-cluster warehouse auto-scaling policy in place. Which condition will trigger a cluster to shut-down?

  A. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
  B. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
  C. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
  D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
  D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

  ---

  Explanation

• Question 1280:

  Which function will return the URL for an external stage by using the stage name as the input?

  A. GET_ABSOLUTE_PATH
  B. GET_PRESIGNED_URL
  C. GET_STAGE_LOCATION
  D. BUILD_STAGE_FILE_URL
  C. GET_STAGE_LOCATION

  ---

  Explanation

  The GET_STAGE_LOCATION function retrieves the full external URL associated with a named stage. It is useful for accessing the storage location of external stages configured in Snowflake.

  Snowflake Docs: GET_STAGE_LOCATION