Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 71:

  Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

  A. Customer-managed encryption keys through Tri-Secret Secure
  B. Automatic encryption of all data
  C. Up to 90 days of data recovery through Time Travel
  D. Object-level access control
  E. Column-level security to apply data masking policies to tables and views
  B. Automatic encryption of all data
  D. Object-level access control

  ---

  Explanation/Reference:

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

• Question 72:

  How a Snowpipe charges calculated?

  A. Per-second/per Warehouse size
  B. Per-second/per-core granularity
  C. Number of Pipes in account
  D. Total storage bucket size
  B. Per-second/per-core granularity

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

• Question 73:

  Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

  A. Schema
  B. View
  C. Internal stage
  D. Table
  E. User
  F. Role
  A. Schema
  D. Table

• Question 74:

  Which of the following objects are contained within a schema? (Choose two.)

  A. Role
  B. Stream
  C. Warehouse
  D. External table
  E. User
  F. Share
  C. Warehouse
  D. External table

• Question 75:

  What is cached during a query on a virtual warehouse?

  A. All columns in a micro-partition
  B. Any columns accessed during the query
  C. The columns in the result set of the query
  D. All rows accessed during the query
  B. Any columns accessed during the query

• Question 76:

  Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

  A. The user has the appropriate privileges on the objects associated with the query
  B. Micro-partitions have been reclustered since the query was last run
  C. The new query is run using the same virtual warehouse as the previous query
  D. The query includes a User Defined Function (UDF)
  E. The query has been run within 24 hours of the previously-run query
  A. The user has the appropriate privileges on the objects associated with the query
  E. The query has been run within 24 hours of the previously-run query

• Question 77:

  True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

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

• Question 78:

  A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

  A. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;
  B. SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())
  C. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;
  D. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;
  D. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

• Question 79:

  Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

  A. Configure the user to be initially disabled.
  B. Force an immediate password change.
  C. Set a default role for the user.
  D. Set the number of minutes to unlock to 15 minutes.
  E. Set the user's access to expire within a specified timeframe.
  A. Configure the user to be initially disabled.
  E. Set the user's access to expire within a specified timeframe.

• Question 80:

  Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

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