Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1361:

  Which common query issues can be identified by the Query Profile? (Choose two.)

  A. Insufficient credit quota
  B. Inefficient query pruning
  C. Excessive query pruning
  D. Exploding joins
  E. Credit usage that exceeds a set threshold
  B. Inefficient query pruning
  D. Exploding joins

  ---

  Explanation

• Question 1362:

  When does a materialized view get suspended in Snowflake?

  A. When a column is added to the base table
  B. When a column is dropped from the base table
  C. When a DML operation is run on the base table
  D. When the base table is reclustered
  B. When a column is dropped from the base table

  ---

  Explanation

• Question 1363:

  A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

  What table type should be used?

  A. Permanent
  B. Transient
  C. Temporary
  D. External
  B. Transient

  ---

  Explanation

• Question 1364:

  Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

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

  ---

  Explanation

• Question 1365:

  Which function unloads data from a relational table to JSON?

  A. TO_OBJECT
  B. TO_JSON
  C. TO_VARIANT
  D. OBJECT_CONSTRUCT
  D. OBJECT_CONSTRUCT

  ---

  Explanation

• Question 1366:

  A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/jdbc.html

  Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64-bit environment and requires Java 1.8 (or higher). The driver can be used with most client tools/applications that support JDBC for connecting to a database server.

• Question 1367:

  Which function should be used to find the query ID of the second query executed in a current session?

  A. Select LAST_QUERY_ID(-2)
  B. Select LAST_QUERY_ID(-1)
  C. Select LAST_QUERY_ID(1)
  D. Select LAST_QUERY_ID(2)
  D. Select LAST_QUERY_ID(2)

  ---

  Explanation

• Question 1368:

  Which privileges are required for a user to restore an object? (Choose two.)

  A. UPDATE
  B. OWNERSHIP
  C. MODIFY
  D. UNDROP
  E. CREATE
  B. OWNERSHIP
  E. CREATE

  ---

  Explanation

• Question 1369:

  What information is found within the Statistic output in the Query Profile Overview?

  A. Operator tree
  B. Table pruning
  C. Most expensive nodes
  D. Nodes by execution time
  B. Table pruning

  ---

  Explanation

• Question 1370:

  How can data be shared between two users who have different Snowflake accounts?

  A. Create a share with the same name as the original database.
  B. Create a share and ensure the proper role is assigned to the share.
  C. Ensure both users' accounts are using the same cloud provider and region.
  D. Use the PUT command to create a shared account.
  B. Create a share and ensure the proper role is assigned to the share.

  ---

  Explanation