Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1321:

  When creating a virtual warehouse, what setting should be used to avoid both over- provisioning resources and auto-scaling when there is increased concurrency?

  A. WAREH0USE_SIZE = LARGE
  B. WAREHOUSEJTYPE = SNOWPARK-OPTIMIZED
  C. MAX_CLUSTER_COUHT - 10
  D. ENABLE_QUERY _ACCELERATION = TRUE
  C. MAX_CLUSTER_COUHT - 10

  ---

  Explanation

  Setting MAX_CLUSTER_COUNT defines the maximum number of clusters for a multi-cluster virtual warehouse.

  To handle increased concurrency without over-provisioning resources or enabling auto-scaling:

  Why Other Options Are Incorrect:

  A. WAREHOUSE_SIZE = LARGE: Does not control concurrency or prevent auto- scaling.

  B. WAREHOUSE_TYPE = SNOWPARK-OPTIMIZED: Designed for ML workloads, unrelated to concurrency control.

  D. ENABLE_QUERY_ACCELERATION = TRUE: Increases compute power dynamically but does not address concurrency.

  References:

  Multi-Cluster Warehouses

• Question 1322:

  Which activities are included in the Cloud Services layer? (Choose two.)

  A. Data storage
  B. Dynamic data masking
  C. Partition scanning
  D. User authentication
  E. Infrastructure management
  D. User authentication
  E. Infrastructure management

  ---

  Explanation

  The Cloud Services layer in Snowflake is responsible for critical data-related activities1. Services managed in this layer include:

  Authentication Infrastructure management Metadata management Query parsing and optimization Access control

• Question 1323:

  A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used.

  The following COPY INTO command was executed:

  COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

  The load failed with this error:

  Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

  How can this issue be resolved?

  A. Compress the file and load the compressed file.
  B. Split the file into multiple files in the recommended size range (100 MB-250 MB).
  C. Use a larger-sized warehouse.
  D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
  D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

  ---

  Explanation

• Question 1324:

  Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? (Choose three)

  A. MIN(< < column value>>)
  B. COPY
  C. SUM(>)
  D. UPDATE
  B. COPY
  C. SUM(>)
  D. UPDATE

  ---

  Explanation

• Question 1325:

  If a query is being used to unload a 1 TB table into a stage, which DML operator will be shown in the Query Profile?

  A. INSERT
  B. UNLOAD
  C. COPY
  D. UPDATE
  C. COPY

  ---

  Explanation

• Question 1326:

  Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

  A. Each Snowflake account can be hosted in a different cloud vendor and region.
  B. Each Snowflake account must be hosted in a different cloud vendor and region
  C. All Snowflake accounts must be hosted in the same cloud vendor and region
  D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
  A. Each Snowflake account can be hosted in a different cloud vendor and region.

  ---

  Explanation

• Question 1327:

  What is the default file size when unloading data from Snowflake using the COPY command?

  A. 5 MB
  B. 8 GB
  C. 16 MB
  D. 32 MB
  C. 16 MB

  ---

  Explanation

• Question 1328:

  What action can be performed using the GET command in Snowflake?

  A. Automatically rename downloaded files.
  B. Automatically decrypt downloaded data on a client machine.
  C. Download data files from Snowflake internal stages to a local directory/folder.
  D. Download data files from Snowflake external stages to a local directory/folder.
  C. Download data files from Snowflake internal stages to a local directory/folder.

  ---

  Explanation

• Question 1329:

  If a source table is updated while cloning is in progress, what data will be included in the cloned table?

  A. All data from the timestamp when the user runs the query.
  B. All data from the timestamp when the user session was created.
  C. All data from the timestamp when the clone statement was initiated.
  D. All data from the timestamp when the clone statement was completed.
  C. All data from the timestamp when the clone statement was initiated.

  ---

  Explanation

• Question 1330:

  How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

  A. ACCESS_HYSTORY
  B. LOAD_HYSTORY
  C. QUERY_HISTORY
  D. REST_EVENT_HISTORY
  D. REST_EVENT_HISTORY

  ---

  Explanation