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
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
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
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
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
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 Snowflake technique can be used to improve the performance of a query?
A. Clustering
B. Indexing
C. Fragmenting
D. Using INDEX__HINTS
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 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 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
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-R02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.