Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 131:

  Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

  A. Each Snowflake account can be hosted in a different cloud vendor and region.
  B. Each Snowflake account must be hosted in a different cloud vendor and region
  C. All Snowflake accounts must be hosted in the same cloud vendor and region
  D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
  B. Each Snowflake account must be hosted in a different cloud vendor and region

  ---

  Explanation/Reference:

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

• Question 132:

  What COPY INTO SQL command should be used to unload data into multiple files?

  A. SINGLE=TRUE
  B. MULTIPLE=TRUE
  C. MULTIPLE=FALSE
  D. SINGLE=FALSE
  C. MULTIPLE=FALSE

• Question 133:

  Snowflake is designed for which type of workloads? (Choose two.)

  A. OLAP (Analytics) workloads
  B. OLTP (Transactional) workloads
  C. Concurrent workloads
  D. On-premise workloads
  A. OLAP (Analytics) workloads
  C. Concurrent workloads

  ---

  Explanation/Reference:

  Reference: https://blog.couchbase.com/its-the-workload-stupid/ https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

• Question 134:

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

  A. The validation_mode option is used when creating an Internal Stage
  B. validation_mode=return_all_errors is a parameter of the copy command
  C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
  D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
  B. validation_mode=return_all_errors is a parameter of the copy command
  D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

• Question 135:

  Which services does the Snowflake Cloud Services layer manage? (Choose two.)

  A. Compute resources
  B. Query execution
  C. Authentication
  D. Data storage
  E. Metadata
  C. Authentication
  E. Metadata

• Question 136:

  Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

  A. Amazon Web Services
  B. Docker
  C. IBM Cloud
  D. Microsoft Azure Cloud
  E. Google Cloud Platform
  F. Oracle Cloud
  B. Docker
  D. Microsoft Azure Cloud
  E. Google Cloud Platform

• Question 137:

  Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)

  A. Growth of storage and compute are tightly coupled together
  B. Storage expands without the requirement to add more compute
  C. Compute can be scaled up or down without the requirement to add more storage
  D. Multiple compute clusters can access stored data without contention
  B. Storage expands without the requirement to add more compute
  C. Compute can be scaled up or down without the requirement to add more storage
  D. Multiple compute clusters can access stored data without contention

  ---

  Explanation/Reference:

  Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt-separate-storage-and-compute-65d2dffd450f

• Question 138:

  What is a responsibility of Snowflake's virtual warehouses?

  A. Infrastructure management
  B. Metadata management
  C. Query execution
  D. Query parsing and optimization
  E. Permanent storage of micro-partitions
  C. Query execution

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A%20warehouse%20provides%20the%20required,rows%20from%20tables%20and%20views)

• Question 139:

  Which of the following statements describe features of Snowflake data caching? (Choose two.)

  A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
  B. When the data cache is full, the least-recently used data will be cleared to make room.
  C. A user can only access their own queries from the query result cache.
  D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
  E. The RESULT_SCAN table function can access and filter the contents of the query result cache.
  B. When the data cache is full, the least-recently used data will be cleared to make room.
  D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

• Question 140:

  What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

  A. VIEWS_HISTORY
  B. OBJECT_HISTORY
  C. ACCESS_HISTORY
  D. LOGIN_HISTORY
  C. ACCESS_HISTORY