Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 111:

  How long is the Fail-safe period for temporary and transient tables?

  A. There is no Fail-safe period for these tables.
  B. 1 day
  C. 7 days
  D. 31 days
  E. 90 days
  A. There is no Fail-safe period for these tables.

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

• Question 112:

  When is the result set cache no longer available? (Select TWO)

  A. When another warehouse is used to execute the query
  B. When another user executes the query
  C. When the underlying data has changed
  D. When the warehouse used to execute the query is suspended
  E. When it has been 24 hours since the last query
  C. When the underlying data has changed
  E. When it has been 24 hours since the last query

• Question 113:

  How would you determine the size of the virtual warehouse used for a task?

  A. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
  B. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
  C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
  D. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
  C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

• Question 114:

  The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

  A. USERADMIN
  B. PUBLIC
  C. ORGADMIN
  D. SYSADMIN
  D. SYSADMIN

• Question 115:

  If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

  A. The columns that are queried in the select clause.
  B. The columns with very high cardinality.
  C. The columns with many different values.
  D. The columns most actively used in the select filters.
  D. The columns most actively used in the select filters.

• Question 116:

  True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

• Question 117:

  A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

  How can this be accomplished?

  A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
  B. The transient table version cannot be retrieved after 24 hours.
  C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
  D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
  B. The transient table version cannot be retrieved after 24 hours.

• Question 118:

  True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

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

• Question 119:

  Which feature is only available in the Enterprise or higher editions of Snowflake?

  A. Column-level security
  B. SOC 2 type II certification
  C. Multi-factor Authentication (MFA)
  D. Object-level access control
  A. Column-level security

  ---

  Explanation/Reference:

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

• Question 120:

  A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

  Which statements will provide this access?

  A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
  B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
  C. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
  D. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
  B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;