Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 411:

  What are key characteristics of virtual warehouses in Snowflake? (Choose two.)

  A. Warehouses that are multi-cluster can have nodes of different sizes.
  B. Warehouses can be started and stopped at any time.
  C. Warehouses can be resized at any time, even while running.
  D. Warehouses are billed on a per-minute usage basis.
  E. Warehouses can only be used for querying and cannot be used for data loading.
  B. Warehouses can be started and stopped at any time.
  C. Warehouses can be resized at any time, even while running.

  ---

  Explanation

• Question 412:

  How does a Snowflake user reference a directory table created on stage mystage in a SQL query?

  A. SELECT * FROM @mystage::DIRECTORY
  B. SELECT * FROM DIRECTORY (@mystage)
  C. SELECT * FROM TO_TABLE (DIRECTORY @mystage)
  D. SELECT * FROM TABLE (@mystage DIRECTORY)
  B. SELECT * FROM DIRECTORY (@mystage)

  ---

  Explanation

• Question 413:

  When is the VARIANT data type suitable when using semi-structured data? (Select TWO).

  A. When there is a need for a predefined schema which cannot be changed after it is created.
  B. When there is a need to add or modify elements within the data structure without interrupting the session.
  C. When the data set is huge and the order of the data elements in the data set does not change.
  D. When the data contains nested data structures like JSON or XML.
  E. When the data consists of images and videos.
  B. When there is a need to add or modify elements within the data structure without interrupting the session.
  D. When the data contains nested data structures like JSON or XML.

  ---

  Explanation

• Question 414:

  While unloading data into a stage, how can the user ensure that the output will be a single file?

  A. Use the COPY option FILES=SINGLE.
  B. Use the COPY option SINGLE=TRUE.
  C. Use the GET option SINGLE=TRUE.
  D. Use the GET option FILES=SINGLE.
  B. Use the COPY option SINGLE=TRUE.

  ---

  Explanation

• Question 415:

  Who can activate a network policy for users in a Snowflake account? (Choose two.)

  A. ACCOUNTADMIN
  B. USERADMIN
  C. PUBLIC
  D. SYSADMIN
  E. Any role that has the global ATTACH POLICY privilege
  A. ACCOUNTADMIN
  E. Any role that has the global ATTACH POLICY privilege

  ---

  Explanation

• Question 416:

  Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

  A. Custom
  B. Economy
  C. Optimized
  D. Standard
  B. Economy
  D. Standard

  ---

  Explanation

  https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

• Question 417:

  While preparing to unload data in Snow ake, the le format option can be speci ed in which commands? (Choose two.)

  A. GET
  B. CREATE STAGE
  C. PUT
  D. COPY INTO
  E. CREATE PIPE
  B. CREATE STAGE
  D. COPY INTO

  ---

  Explanation

• Question 418:

  Two users share a virtual warehouse named WH_DEV_01. When one of the users loads data, the other one experiences performance issues while querying data.

  How does Snowflake recommend resolving this issue?

  A. Scale up the existing warehouse
  B. Create separate warehouses for each user
  C. Create separate warehouses for each workload
  D. Stop loading and querying data at the same time
  C. Create separate warehouses for each workload

  ---

  Explanation

• Question 419:

  What information is stored in the ACCESS_HlSTORY view?

  A. History of the files that have been loaded into Snowflake
  B. Names and owners of the roles that are currently enabled in the session
  C. Query details such as the objects included and the user who executed the query
  D. Details around the privileges that have been granted for all objects in an account
  D. Details around the privileges that have been granted for all objects in an account

  ---

  Explanation

  Details around the privileges that have been granted for all objects in an account. The ACCESS_HISTORY view in Snowflake provides a comprehensive log of access control changes, including grants and revocations of privileges on all

  securable objects within the account. This information is crucial for auditing and monitoring the security posture of your Snowflake environment.

  Here's how to understand and use the ACCESS_HISTORY view:

  Purpose of ACCESS_HISTORY View: It is designed to track changes in access controls, such as when a user or role is granted or revoked privileges on various Snowflake objects. This includes tables, schemas, databases, and more.

  Querying ACCESS_HISTORY: To access this view, you can use the following SQL query pattern:

  SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY WHERE EVENT_TYPE = 'GRANT' OR EVENT_TYPE = 'REVOKE';

  Interpreting the Results: The results from the ACCESS_HISTORY view include the object type, the specific privilege granted or revoked, the grantee (who received or lost the privilege), and the timestamp of the event. This data is invaluable

  for audits and compliance checks.

  For detailed information on the ACCESS_HISTORY view and how to interpret its data, please visit the official Snowflake documentation:

  https://docs.snowflake.com/en/sql-reference/account-usage/access_history.html

• Question 420:

  What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

  A. The warehouse size does not change until all queries currently running in the warehouse have completed.
  B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
  C. The warehouse size does not change until the warehouse is suspended and restarted.
  D. It does not return from the command until the warehouse has finished changing its size.
  D. It does not return from the command until the warehouse has finished changing its size.

  ---

  Explanation