Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 291:

  Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

  A. Pipes
  B. Streams
  C. Tasks
  D. Procedures
  B. Streams

  ---

  Explanation/Reference:

  https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20change.

• Question 292:

  A materialized view should be created when which of the following occurs? (Choose two.)

  A. There is minimal cost associated with running the query.
  B. The query consumes many compute resources every time it runs.
  C. The base table gets updated frequently.
  D. The query is highly optimized and does not consume many compute resources.
  E. The results of the query do not change often and are used frequently.
  C. The base table gets updated frequently.
  E. The results of the query do not change often and are used frequently.

• Question 293:

  What are the default Time Travel and Fail-safe retention periods for transient tables?

  A. Time Travel-1 day. Fail-safe-1 day
  B. Time Travel-0 days. Fail-safe-1 day
  C. Time Travel-1 day. Fail-safe-0 days
  D. Transient tables are retained in neither Fail-safe nor Time Travel
  C. Time Travel-1 day. Fail-safe-0 days

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help%20manageandtext=Temporary%20tables%20can%20also%20have,have%20no%20Fail%2Dsafe% 20period.

• Question 294:

  The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

  A. Users
  B. Tables
  C. Databases
  D. Internal Stages
  A. Users
  B. Tables
  C. Databases

• Question 295:

  When cloning a database, what is cloned with the database? (Choose two.)

  A. Privileges on the database
  B. Existing child objects within the database
  C. Future child objects within the database
  D. Privileges on the schemas within the database
  E. Only schemas and tables within the database
  B. Existing child objects within the database
  E. Only schemas and tables within the database

• Question 296:

  A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

  Which of the following statements will accommodate this request?

  A. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
  B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
  C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
  D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
  B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

• Question 297:

  True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

• Question 298:

  A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

  1.

  Runs a query that takes 3 minutes to complete

  2.

  Leaves for 15 minutes

  3.

  Returns and runs a query that takes 10 seconds to complete

  4.

  Manually suspends the warehouse as soon as the last query was completed

  When the user returns, how much billable compute time will have been consumed?

  A. 4 minutes
  B. 10 minutes
  C. 14 minutes
  D. 24 minutes
  C. 14 minutes

• Question 299:

  How often are encryption keys automatically rotated by Snowflake?

  A. 30 Days
  B. 60 Days
  C. 90 Days
  D. 365 Days
  A. 30 Days

  ---

  Explanation/Reference:

  All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.

  https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is%20automatically%20destroyed.

• Question 300:

  What is the MOST performant file format for loading data in Snowflake?

  A. CSV (Unzipped)
  B. Parquet
  C. CSV (Gzipped)
  D. ORC
  A. CSV (Unzipped)