Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1441:

  What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

  A. Data can be filtered by an optional where clause
  B. Incoming data can be joined with other tables
  C. Columns can be reordered
  D. Columns can be omitted
  E. Row level access can be defined
  C. Columns can be reordered
  D. Columns can be omitted

  ---

  Explanation

• Question 1442:

  What kind of authentication do Snowpipe REST endpoints use?

  A. OAuth
  B. Key-based
  C. Username and password
  D. Single Sign-On (SSO)
  B. Key-based

  ---

  Explanation

• Question 1443:

  When unloading data to an external stage, what is the MAXIMUM file size supported?

  A. 1 GB
  B. 5 GB
  C. 10 GB
  D. 16 GB
  B. 5 GB

  ---

  Explanation

• Question 1444:

  When a schema is cloned, what will happen if the schema includes a table with a column that references a sequence that generates default values? (Select TWO).

  A. If the table and sequence are in the same schema, the cloned table will reference the source sequence.
  B. If the table and sequence are in the same schema, the cloned table will reference the cloned sequence.
  C. If the table and sequence are in different schemas, the cloned table will reference the source sequence.
  D. If the table and sequence are in different schemas, the cloned table will no longer have a default value for the column.
  E. If the table and sequence are in the same schema, the cloned table will use the most-recently generated value from the source sequence.
  A. If the table and sequence are in the same schema, the cloned table will reference the source sequence.
  C. If the table and sequence are in different schemas, the cloned table will reference the source sequence.

  ---

  Explanation

• Question 1445:

  Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

  A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
  B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
  C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
  D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
  E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
  F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
  D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
  E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
  F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

  ---

  Explanation

• Question 1446:

  What is to be expected when sharing worksheets in Snowsight?

  A. Worksheets can be shared with users that are internal or external to any organization.
  B. To run a shared worksheet, a user must be granted the role used for the worksheet session context.
  C. Snowsight allows users to view and refresh results but not to edit shared worksheets.
  D. Snowsight offers different sharing permissions at the worksheet, folder, and dashboard level.
  B. To run a shared worksheet, a user must be granted the role used for the worksheet session context.

  ---

  Explanation

• Question 1447:

  Use of which virtual warehouse or warehouse configuration will improve the performance of workloads that have large memory requirements, such as Machine Learning model training using a stored procedure?

  A. Snowpark-optimized warehouse
  B. Standard warehouse
  C. Multi-cluster warehouse
  D. Serverless compute
  A. Snowpark-optimized warehouse

  ---

  Explanation

  A Snowpark-optimized warehouse is specifically designed to handle workloads with large memory requirements such as machine learning and data processing using Snowpark APIs or stored procedures. Snowpark-optimized warehouses

  provide enhanced memory configurations compared to standard warehouses to support such use cases effectively.

  Why Other Options Are Incorrect:

  B. Standard warehouse: Does not have memory optimizations for advanced ML workloads.

  C. Multi-cluster warehouse: Useful for concurrency but not specifically optimized for memory-intensive tasks.

  D. Serverless compute: Designed for ad hoc query execution and not suited for memory-intensive workloads.

  References:

  Snowpark Overview

• Question 1448:

  What is a User-Defined Table Function (UDTF) used for in Snowflake?

  A. To return a tabular value for each input row.
  B. To process input rows and return the results as a pandas series.
  C. To return one output row as a single column or value for each input row.
  D. To process input rows as pandas DataFrames and return tabular results.
  A. To return a tabular value for each input row.

  ---

  Explanation

• Question 1449:

  What are valid sub-clauses to the OVER clause for a window function? (Choose two.)

  A. GROUP BY
  B. LIMIT
  C. ORDER BY
  D. PARTITION BY
  E. UNION ALL
  C. ORDER BY
  D. PARTITION BY

  ---

  Explanation

• Question 1450:

  What does the VARIANT data type impose a 16 MB size limit on?

  A. All rows
  B. All columns
  C. Individual rows
  D. Individual columns
  C. Individual rows

  ---

  Explanation

  The VARIANT data type imposes a 16 MB size limit on individual rows. https://docs.snowflake.com/en/user-guide/semistructured-considerations