Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 321:

  When used with a select statement in the copy into command, what statement will unload data from a table as JSON?

  A. TO_OBJECT
  B. TO_JSON
  C. PARSE_JSON
  D. OBJECT CONSTRUCT
  B. TO_JSON

  ---

  Explanation

  The COPY INTO command in Snowflake allows you to export or unload data from a Snowflake table into an external stage (e.g., an Amazon S3 bucket) in a specific format like JSON, CSV, or Parquet. When you want to unload data as JSON using a SELECT statement, Snowflake provides built-in functions to format the data properly into JSON structures. Among the options provided: TO_JSON: Example Usage: sql CopyEdit COPY INTO @my_stage/unload_data.json FROM (SELECT TO_JSON(data_column) FROM my_table) FILE_FORMAT = (TYPE = JSON); Why the Other Options Are Incorrect: SnowPro

  References: COPY INTO Command Documentation TO_JSON Function Working with JSON Data in Snowflake

• Question 322:

  What Snowflake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

  A. Temporary table
  B. External table
  C. Secure view
  D. Materialized view
  D. Materialized view

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/views-materialized

• Question 323:

  Using which object-level parameters will help limit query processing and concurrency slowdowns? (Select TWO).

  A. MULTI_STATEMENT_COUNT
  B. ENABLE_QUERY_ACCELERATION
  C. STATEMENT_TIMEOUT_IN_SECONDS
  D. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
  E. QUERY_ACCELERATION_MAX_SCALE_fACTOR
  C. STATEMENT_TIMEOUT_IN_SECONDS
  D. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

  ---

  Explanation

• Question 324:

  What is the minimum Snowflake edition that provides data sharing?

  A. Standard
  B. Premier
  C. Enterprise
  D. Business Critical Edition
  A. Standard

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing

• Question 325:

  A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

  A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
  B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
  C. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
  D. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
  A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/grant-privilege.html#examples

• Question 326:

  What Multi-Factor Authentication (MFA) service is provided by Snowflake?

  A. Microsoft Entra ID
  B. Google Authenticator
  C. Duo Security
  D. Microsoft Authenticator
  C. Duo Security

  ---

  Explanation

• Question 327:

  What is the purpose of multi-cluster virtual warehouses?

  A. To create separate data warehouses to increase query optimization
  B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
  C. To eliminate or reduce Queuing of concurrent queries
  D. To allow the warehouse to resize automatically
  C. To eliminate or reduce Queuing of concurrent queries

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and% 20off%20hours.

• Question 328:

  What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?

  A. IO
  B. Network
  C. Pruning
  D. Spilling
  D. Spilling

  ---

  Explanation

• Question 329:

  What is used during the FIRST execution of SELECT COUNT(*) FROM ORDER?

  A. Remote disk cache
  B. Virtual warehouse cache
  C. Cache result
  D. Metadata-based result
  D. Metadata-based result

  ---

  Explanation

  https://community.snowflake.com/s/question/0D5Do00000IaCZlKAN/what-is-the-difference-between-metadata-cache-and-result-cache

• Question 330:

  Which function is used to profile warehouse credit usage?

  A. AUTOMATIC_CLUSTERING_HISTORY
  B. MATERIALIZED_VIEW_REFRESH_HISTORY
  C. WAREHOUSE_LOAD_HISTORY
  D. WAREHOUSE_METERING_HISTORY
  D. WAREHOUSE_METERING_HISTORY

  ---

  Explanation