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
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
- A . True
- B . False
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A . True
- B . False
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A . True
- B . False
True or False: A single database can exist in more than one Snowflake account.
- A . True
- B . False
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A . True
- B . False
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A . The Snowflake Web Interface (UI)
- B . SQL commands
- C . Data integration tools
- D . All of the above
When can a Virtual Warehouse start running queries?
- A . 12am-5am
- B . Only during administrator defined time slots
- C . When its provisioning is complete
- D . After replication
Which of the following DML commands isn’t supported by Snowflake?
- A . UPSERT
- B . MERGE
- C . UPDATE
- D . TRUNCATE TABLE
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
- A . A multi-cluster Warehouse can add clusters automatically based on query activity
- B . A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
- C . A multi-cluster Warehouse can scale down when query activity slows
- D . A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
Which of the following statement is true of Snowflake?
- A . It was built specifically for the cloud
- B . it was built as an on-premises solution and then potted to the cloud
- C . It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
- D . It was built for Hadoop architecture
- E . It’s based on an Oracle Architecture
Latest COF-R02 Dumps Valid Version with 330 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
