Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 11:

  What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

  A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
  B. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
  C. The ACCOUNTADMIN role must be granted to only one user.
  D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
  E. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
  A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
  D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

• Question 12:

  Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

  A. Files
  B. External tables
  C. Secure User-Defined Functions (UDFs)
  D. Sequences
  E. Streams
  B. External tables
  C. Secure User-Defined Functions (UDFs)

• Question 13:

  Which command is used to unload data from a Snowflake table into a file in a stage?

  A. COPY INTO
  B. GET
  C. WRITE
  D. EXTRACT INTO
  A. COPY INTO

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.

• Question 14:

  True or False: Snowflake supports federated authentication in all editions.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Reference: https://community.snowflake.com/s/news/federated-authentication-sso-now-available-in-all-snowflake-editions-MC6N3I63LJGNGMHCTKGKFDH4NH2Q

• Question 15:

  What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

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

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition

• Question 16:

  How does Snowflake Fail-safe protect data in a permanent table?

  A. Fail-safe makes data available up to 1 day, recoverable by user operations.
  B. Fail-safe makes data available for 7 days, recoverable by user operations.
  C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
  D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
  C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

• Question 17:

  What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

  A. Informatica
  B. Power Bl
  C. Adobe
  D. Data Robot
  D. Data Robot

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

• Question 18:

  True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

  A. True
  B. False
  A. True

• Question 19:

  Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

  A. Custom
  B. Economy
  C. Optimized
  D. Standard
  B. Economy
  D. Standard

  ---

  Explanation/Reference:

  Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

• Question 20:

  If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

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

  ---

  Explanation/Reference:

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