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
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
- A . 4
- B . 16
- C . 32
- D . 128
Select the different types of Internal Stages: (Choose three.)
- A . Named Stage
- B . User Stage
- C . Table Stage
- D . Schema Stage
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
- A . True
- B . False
Which of the following statements are true of Snowflake releases: (Choose two.)
- A . They happen approximately weekly
- B . They roll up and release approximately monthly, but customers can request early release application
- C . During a release, new customer requests/queries/connections transparently move over to the newer version
- D . A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
True or False: Snowflake supports federated authentication in all editions.
- A . True
- B . False
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
- A . Customers can change the size of the Warehouse after creation
- B . A Warehouse can be resized while running
- C . A Warehouse can be configured to suspend after a period of inactivity
- D . A Warehouse can be configured to auto-resume when new queries are submitted
True or False: Snowflake charges a premium for storing semi-structured data.
- A . True
- B . False
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
- A . True
- B . False
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A . True
- B . False
The PUT command: (Choose two.)
- A . Automatically creates a File Format object
- B . Automatically uses the last Stage created
- C . Automatically compresses files using Gzip
- D . Automatically encrypts files