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 feature is only available in the Enterprise or higher editions of Snowflake?
- A . Column-level security
- B . SOC 2 type II certification
- C . Multi-factor Authentication (MFA)
- D . Object-level access control
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- A . An FTP server with TLS encryption
- B . An HTTPS server with WebDAV
- C . A Google Cloud storage bucket
- D . A Windows server file share on Azure
Which statement about billing applies to Snowflake credits?
- A . Credits are billed per-minute with a 60-minute minimum
- B . Credits are used to pay for cloud data storage usage
- C . Credits are consumed based on the number of credits billed for each hour that a warehouse runs
- D . Credits are consumed based on the warehouse size and the time the warehouse is running
Which Snowflake technique can be used to improve the performance of a query?
- A . Clustering
- B . Indexing
- C . Fragmenting
- D . Using INDEX__HINTS
What are the default Time Travel and Fail-safe retention periods for transient tables?
- A . Time Travel – 1 day. Fail-safe – 1 day
- B . Time Travel – 0 days. Fail-safe – 1 day
- C . Time Travel – 1 day. Fail-safe – 0 days
- D . Transient tables are retained in neither Fail-safe nor Time Travel
Which of the following are benefits of micro-partitioning? (Select TWO)
- A . Micro-partitions cannot overlap in their range of values
- B . Micro-partitions are immutable objects that support the use of Time Travel.
- C . Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
- D . Rows are automatically stored in sorted order within micro-partitions
- E . Micro-partitions can be defined on a schema-by-schema basis
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
- A . The user has the appropriate privileges on the objects associated with the query
- B . Micro-partitions have been reclustered since the query was last run
- C . The new query is run using the same virtual warehouse as the previous query
- D . The query includes a User Defined Function (UDF)
- E . The query has been run within 24 hours of the previously-run query
What happens when a cloned table is replicated to a secondary database? (Select TWO)
- A . A read-only copy of the cloned tables is stored.
- B . The replication will not be successful.
- C . The physical data is replicated
- D . Additional costs for storage are charged to a secondary account
- E . Metadata pointers to cloned tables are replicated
What can be used to view warehouse usage over time? (Select Two).
- A . The load HISTORY view
- B . The Query history view
- C . The show warehouses command
- D . The WAREHOUSE_METERING__HISTORY View
- E . The billing and usage tab in the Snowflake web Ul
Will data cached in a warehouse be lost when the warehouse is resized?
- A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
- B . Yes. because the compute resource is replaced in its entirety with a new compute resource.
- C . No. because the size of the cache is independent from the warehouse size
- D . Yes. became the new compute resource will no longer have access to the cache encryption key
Latest COF-R02 Dumps Valid Version with 330 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
