Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 271:

  Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

  A. Bytes sent over network
  B. Percentage scanned from cache
  C. Partitions total
  D. Bytes spilled to local storage
  E. Partitions scanned
  B. Percentage scanned from cache
  E. Partitions scanned

• Question 272:

  Using variables in Snowflake is denoted by using which SQL character?

  A. @
  B. and
  C. $
  D. #
  C. $

• Question 273:

  Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

  A. UPDATE TABLE FROM STREAM
  B. SELECT FROM STREAM
  C. INSERT INTO TABLE SELECT FROM STREAM
  D. ALTER TABLE AS SELECT FROM STREAM
  E. BEGIN COMMIT
  C. INSERT INTO TABLE SELECT FROM STREAM
  D. ALTER TABLE AS SELECT FROM STREAM

• Question 274:

  What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

  A. The Pipe load history is reset to empty.
  B. The REFRESH command is executed.
  C. The stage will be purged.
  D. The destination table is truncated.
  B. The REFRESH command is executed.

• Question 275:

  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/Reference:

  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 276:

  Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

  A. Is available to all Snowflake Editions
  B. Is only available to customers with Business Critical Edition
  C. Restricts or enables access to specific IP addresses
  D. Is activated using an "ALTER DATABASE" command
  A. Is available to all Snowflake Editions
  C. Restricts or enables access to specific IP addresses

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

• Question 277:

  Which of the following statements are true about Schemas in Snowflake? (Choose two.)

  A. A Schema may contain one or more Databases
  B. A Database may contain one or more Schemas
  C. A Schema is a logical grouping of Database Objects
  D. Each Schema is contained within a Warehouse
  B. A Database may contain one or more Schemas
  C. A Schema is a logical grouping of Database Objects

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

• Question 278:

  How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

  A. Configure the warehouse to a size larger than generally required
  B. Set the minimum and maximum clusters to autoscale
  C. Use the standard warehouse scaling policy
  D. Use the economy warehouse scaling policy
  B. Set the minimum and maximum clusters to autoscale

• Question 279:

  Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

  A. Pre-signed URL
  B. Scoped URL
  C. Signed URL
  D. File URL
  C. Signed URL

• Question 280:

  In the Snowflake access control model, which entity owns an object by default?

  A. The user who created the object
  B. The SYSADMIN role
  C. Ownership depends on the type of object
  D. The role used to create the object
  D. The role used to create the object