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
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A . Configure the Maximum Clusters setting to “Auto-Scale”
- B . Set the Warehouse type to “Auto”
- C . Set the Minimum Clusters and Maximum Clusters settings to the same value
- D . Set the Minimum Clusters and Maximum Clusters settings to the different values
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)
- A . Growth of storage and compute are tightly coupled together
- B . Storage expands without the requirement to add more compute
- C . Compute can be scaled up or down without the requirement to add more storage
- D . Multiple compute clusters can access stored data without contention
Which of the following roles is recommended to be used to create and manage users and roles?
- A . SYSADMIN
- B . SECURITYADMIN
- C . PUBLIC
- D . ACCOUNTADMIN
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A . Custom
- B . Economy
- C . Optimized
- D . Standard
Which of the following statements is true of Snowflake?
- A . It was built specifically for the cloud
- B . It was built as an on-premises solution and then ported 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
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
- A . True
- B . False
Which of the following terms best describes Snowflake’s database architecture?
- A . Columnar shared nothing
- B . Shared disk
- C . Multi-cluster, shared data
- D . Cloud-native shared memory
Which of the following objects is not covered by Time Travel?
- A . Tables
- B . Schemas
- C . Databases
- D . Stages
Which of the following statements would be used to export/unload data from Snowflake?
- A . COPY INTO @stage
- B . EXPORT TO @stage
- C . INSERT INTO @stage
- D . EXPORT_TO_STAGE(stage = > @Wage, select = > ‘select * from t1);
Which of the following are options when creating a Virtual Warehouse?
- A . Auto-suspend
- B . Auto-resume
- C . Local SSD size
- D . User count
Latest COF-R02 Dumps Valid Version with 330 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
