Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 181:

  Which of the following DML commands isn't supported by Snowflake?

  A. UPSERT
  B. MERGE
  C. UPDATE
  D. TRUNCATE TABLE
  A. UPSERT

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html

• Question 182:

  A user unloaded a Snowflake table called mytable to an internal stage called mystage.

  Which command can be used to view the list of files that has been uploaded to the staged?

  A. list @mytable;
  B. list @%raytable;
  C. list @ %m.ystage;
  D. list @mystage;
  D. list @mystage;

• Question 183:

  Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

  A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
  B. A Data Exchange allows groups of accounts to share data privately among the accounts.
  C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
  D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
  E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
  B. A Data Exchange allows groups of accounts to share data privately among the accounts.

• Question 184:

  To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

  A. Configure the Maximum Clusters setting to "Auto-Scale"
  B. Set the Warehouse type to "Auto"
  C. Set the Minimum Clusters and Maximum Clusters settings to the same value
  D. Set the Minimum Clusters and Maximum Clusters settings to the different values
  D. Set the Minimum Clusters and Maximum Clusters settings to the different values

  ---

  Explanation/Reference:

  Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

• Question 185:

  What is a key feature of Snowflake architecture?

  A. Zero-copy cloning creates a mirror copy of a database that updates with the original
  B. Software updates are automatically applied on a quarterly basis
  C. Snowflake eliminates resource contention with its virtual warehouse implementation
  D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
  E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
  D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters

• Question 186:

  If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

  A. 4
  B. 8
  C. 16
  D. 32
  B. 8

  ---

  Explanation/Reference:

  Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

  

  https://docs.snowflake.com/en/user-guide/warehouses-overview.html

• Question 187:

  Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

  A. The number of queries executed
  B. The number of active users assigned to the warehouse
  C. The size of the virtual warehouse
  D. The length of time the warehouse is running
  E. The duration of the queries that are executed
  A. The number of queries executed
  D. The length of time the warehouse is running

• Question 188:

  Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

  A. ORC
  B. XML
  C. Avro
  D. Parquet
  E. JSON
  D. Parquet
  E. JSON

  ---

  Explanation/Reference:

  Semi-structured JSON, Parquet

  https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20fileandtext=Delimited%20(CSV%2C%20TSV%2C%20etc.

• Question 189:

  The Snowflake Search Optimization Services supports improved performance of which kind of query?

  A. Queries against large tables where frequent DML occurs
  B. Queries against tables larger than 1 TB
  C. Selective point lookup queries
  D. Queries against a subset of columns in a table
  C. Selective point lookup queries

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimization%20service%20can%20improve%20the%20performance%20of%20point,OBJECT%2C%20and%20ARRAY% 20columns)

• Question 190:

  Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

  A. Number of users
  B. Warehouse size
  C. Amount of data processed
  D. # of clusters for the Warehouse
  B. Warehouse size
  D. # of clusters for the Warehouse

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage "Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."