Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 561:

  A user is unloading data to a stage using this command:

  copy into @message from (select object_construct('id', 1, 'first_name', 'Snowflake', 'last_name', 'User', 'city', 'Bozeman')) file_format = (type = json) What will the output file in the stage be?

  A. A single compressed JSON file with a single VARIANT column
  B. Multiple compressed JSON files with a single VARIANT column
  C. A single uncompressed JSON file with multiple VARIANT columns
  D. Multiple uncompressed JSON files with multiple VARIANT columns
  A. A single compressed JSON file with a single VARIANT column

  ---

  Explanation

• Question 562:

  When unloading data: which file formal will keep floating-point number column data without truncating it?

  A. XML
  B. JSON
  C. Parquet
  D. CSV
  C. Parquet

  ---

  Explanation

• Question 563:

  A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table.

  What will the query from the view return?

  A. The data from the permanent table.
  B. The data from the temporary table.
  C. An error stating that the view could not be compiled.
  D. An error stating that the referenced object could not be uniquely identified.
  B. The data from the temporary table.

  ---

  Explanation

• Question 564:

  What is the recommended way to change the existing file format type in my_format from CSV to JSON?

  A. ALTER FILE FORMAT my_format SET TYPE=JSON;
  B. ALTER FILE FORMAT my_format SWAP TYPE WITH JSON;
  C. CREATE OR REPLACE FILE FORMAT my_format TYPE=JSON;
  D. REPLACE FILE FORMAT my_format TYPE=JSON;
  C. CREATE OR REPLACE FILE FORMAT my_format TYPE=JSON;

  ---

  Explanation

  ALTER FILE FORMAT does not support the following actions:

  -Changing the type (CSV, JSON, etc.) for the file format. To make any of these changes, you must recreate the file format.

• Question 565:

  Which command should be used to look into the validity of an XML object in Snowflake?

  A. XMLGET
  B. TO_XML
  C. PARSE_XML
  D. CHECK_XML
  D. CHECK_XML

  ---

  Explanation

• Question 566:

  Which statement about billing applies to Snowflake credits?

  A. Credits are billed per-minute with a 60-minute minimum
  B. Credits are used to pay for cloud data storage usage
  C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs
  D. Credits are consumed based on the warehouse size and the time the warehouse is running
  D. Credits are consumed based on the warehouse size and the time the warehouse is running

  ---

  Explanation

  Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used. https:// docs.snowflake.com/en/user-guide/what-are-credits.html

• Question 567:

  How does Snowflake handle the data retention period for a table if a stream has not been consumed?

  A. The data retention period is reduced to a minimum of 14 days.
  B. The data retention period is permanently extended for the table.
  C. The data retention period is temporarily extended to the stream's offset.
  D. The data retention period is not affected by the stream consumption.
  C. The data retention period is temporarily extended to the stream's offset.

  ---

  Explanation

  In Snowflake, the use of streams impacts how the data retention period for a table is handled, particularly in scenarios where the stream has not been consumed. The key point to understand is that Snowflake's streams are designed to capture data manipulation language (DML) changes such as INSERTS, UPDATES, and DELETES that occur on a source table. Streams maintain a record of these changes until they are consumed by a DML operation or a COPY command that references the stream. When a stream is created on a table and remains unconsumed, Snowflake extends the data retention period of the table to ensure that the changes captured by the stream are preserved. This extension is specifically up to the point in time represented by the stream's offset, which effectively ensures that the data necessary for consuming the stream's contents is retained. This mechanism is in place to prevent data loss and ensure the integrity of the stream's data, facilitating accurate and reliable data processing and analysis based on the captured DML changes. This behavior emphasizes the importance of managing streams and their consumption appropriately to balance between data retention needs and storage costs. It's also crucial to understand how this temporary extension of the data retention period impacts the overall management of data within Snowflake, including aspects related to data lifecycle, storage cost implications, and the planning of data consumption strategies.

  References: Snowflake Documentation on Streams: Using Streams Snowflake Documentation on Data Retention: Understanding Data Retention

• Question 568:

  What is the MINIMUM Snowflake edition required to add masking policies to selectively mask plain-text data in a table or in view columns at query time?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPS)
  C. Business Critical

  ---

  Explanation

• Question 569:

  What happens when a value in a single row of a large table is updated?

  A. The affected micro-partition will be modified.
  B. All existing micro-partitions will be modified.
  C. The affected micro-partition will be deleted and recreated.
  D. All micro-partitions will be deleted and recreated.
  C. The affected micro-partition will be deleted and recreated.

  ---

  Explanation

• Question 570:

  According to Snowflake best practice recommendations, which system-defined roles should be used to create custom roles? (Choose two.)

  A. ACCOUNTADMIN
  B. SYSADMIN
  C. SECURITYADMIN
  D. USERADMIN
  E. ORGADMIN
  C. SECURITYADMIN
  D. USERADMIN

  ---

  Explanation