Snowflake COF-R02 SnowPro Core Recertification Exam Online Training
Snowflake COF-R02 Online Training
The questions for COF-R02 were last updated at Nov 23,2024.
- Exam Code: COF-R02
- Exam Name: SnowPro Core Recertification Exam
- Certification Provider: Snowflake
- Latest update: Nov 23,2024
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)
- A . JDBC
- B . SnowSQL
- C . Snowflake Web Interface (UI)
- D . ODBC
- E . Python
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
- A . Number of users
- B . Warehouse size
- C . Amount of data processed
- D . # of clusters for the Warehouse
The Query History in the Snowflake Web Interface (UI) is kept for approximately:
- A . 60 minutes
- B . 24 hours
- C . 14 days
- D . 30 days
- E . 1 year
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
- A . The tables are now orphaned
- B . The user that deleted the role
- C . SYSADMIN
- D . The assumed role that dropped the role
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A . A Schema may contain one or more Databases
- B . A Database may contain one or more Schemas
- C . A Schema is a logical grouping of Database Objects
- D . Each Schema is contained within a Warehouse
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
- A . Concurrency
- B . Performance
What are the three layers that make up Snowflake’s architecture? Choose 3 answer
- A . Compute
- B . Tri-Secret Secure
- C . Storage
- D . Cloud Services
Which of the following objects can be cloned? (Choose four.)
- A . Tables
- B . Named File Formats
- C . Schemas
- D . Shares
- E . Databases
- F . Users
True or False: An active warehouse is required to run a COPY INTO statement.
- A . True
- B . False