Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 301:

  Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

  A. Management of metadata
  B. Computing the data
  C. Maintaining Availability Zones
  D. Infrastructure security
  E. Parsing and optimizing queries
  A. Management of metadata
  E. Parsing and optimizing queries

• Question 302:

  Which statement describes how Snowflake supports reader accounts?

  A. A reader account can consume data from the provider account that created it and combine it with its own data.
  B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
  C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
  D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
  C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

• Question 303:

  How would a user execute a series of SQL statements using a task?

  A. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
  B. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
  C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
  D. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
  D. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

• Question 304:

  What happens when a virtual warehouse is resized?

  A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
  B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
  C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
  D. Users who are trying to use the warehouse will receive an error message until the resizing is complete
  B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

• Question 305:

  Which of the following can be used when unloading data from Snowflake? (Choose two.)

  A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
  B. Use the ENCODING file format option to change the encoding from the default UTF-8.
  C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
  D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
  E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
  A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
  D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

• Question 306:

  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

• Question 307:

  What is the default character set used when loading CSV files into Snowflake?

  A. UTF-8
  B. UTF-16
  C. ISO S859-1
  D. ANSI_X3.A
  A. UTF-8

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for%20loading. For delimited files (CSV, TSV, etc.), the default character set is UTF

  8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).

• Question 308:

  Which minimum Snowflake edition allows for a dedicated metadata store?

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

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 309:

  True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

• Question 310:

  When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

  A. There is no need to have a Snowflake account in the target region, a share will be created for each user.
  B. The listing is replicated into all selected regions automatically, the data is not.
  C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
  D. Shares attached to listings in remote regions can be viewed from any account in an organization.
  E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
  A. There is no need to have a Snowflake account in the target region, a share will be created for each user.
  C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.