Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 81:

  What is the minimum Snowflake edition required to use Dynamic Data Masking?

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

• Question 82:

  Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

  A. PUT
  B. GET
  C. COPY
  D. SELECT
  B. GET

  ---

  Explanation/Reference:

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

• Question 83:

  Which interfaces can be used to create and/or manage Virtual Warehouses?

  A. The Snowflake Web Interface (UI)
  B. SQL commands
  C. Data integration tools
  D. All of the above
  D. All of the above

  ---

  Explanation/Reference:

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

• Question 84:

  Which of the following roles is recommended to be used to create and manage users and roles?

  A. SYSADMIN
  B. SECURITYADMIN
  C. PUBLIC
  D. ACCOUNTADMIN
  B. SECURITYADMIN

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

  "Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

• Question 85:

  Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

  A. Data is live, ready-to-query, and can be personalized.
  B. Data needs to be loaded into a cloud provider as a consumer account.
  C. Data is not available for copying or moving to an individual Snowflake account.
  D. Data is available without copying or moving.
  E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
  A. Data is live, ready-to-query, and can be personalized.
  D. Data is available without copying or moving.

• Question 86:

  True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

  A. True
  B. False
  A. True

• Question 87:

  Which statement describes pruning?

  A. The filtering or disregarding of micro-partitions that are not needed to return a query.
  B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.
  C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.
  D. The ability to allow the result of a query to be accessed as if it were a table.
  A. The filtering or disregarding of micro-partitions that are not needed to return a query.

• Question 88:

  Which services does the Snowflake Cloud Services layer manage? (Select TWO).

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

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control

• Question 89:

  When can a Virtual Warehouse start running queries?

  A. 12am-5am
  B. Only during administrator defined time slots
  C. When its provisioning is complete
  D. After replication
  C. When its provisioning is complete

  ---

  Explanation/Reference:

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

• Question 90:

  When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse

  According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

  A. Use multi-clustered warehousing to scale out warehouse capacity.
  B. Scale up the warehouse size to allow Queries to execute faster.
  C. Stop and start the warehouse to clear the queued queries
  D. Migrate some queries to a new warehouse to reduce load
  E. Limit user access to the warehouse so fewer queries are run against it.
  A. Use multi-clustered warehousing to scale out warehouse capacity.
  D. Migrate some queries to a new warehouse to reduce load