Snowflake COF-R02 SnowPro Core Recertification Exam Online Training
Snowflake COF-R02 Online Training
The questions for COF-R02 were last updated at Nov 22,2024.
- Exam Code: COF-R02
- Exam Name: SnowPro Core Recertification Exam
- Certification Provider: Snowflake
- Latest update: Nov 22,2024
What privileges are required to create a task?
- A . The global privilege create task is required to create a new task.
- B . Tasks are created at the Application level and can only be created by the Account Admin role.
- C . Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
- D . The role must have access to the target schema and the create task privilege on the schema itself.
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
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A . To accommodate more queries
- B . To accommodate more users
- C . To accommodate fluctuations in workload
- D . To accommodate a more complex workload
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A . The Pipe load history is reset to empty
- B . The REFRESH parameter is set to TRUE
- C . Previously loaded files will be ignored
- D . All of the above
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
True or False: During data unloading, only JSON and CSV files can be compressed.
- A . True
- B . False
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A . Standard
- B . Premier
- C . Enterprise
- D . Business Critical Edition
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
- A . Standard
- B . Premier
- C . Enterprise
- D . Business Critical Edition
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
- A . True
- B . False
Which type of table corresponds to a single Snowflake session?
- A . Temporary
- B . Translent
- C . Provisional
- D . Permanent