Free COF-C02 Exam Dumps

Question 101

- (Topic 2)
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
B. The transient table version cannot be retrieved after 24 hours.
C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Correct Answer:A
To go back to the first version of a transient table created three days prior,
one can use Time Travel if the DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days. This allows the user to access historical data within the specified retention period. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 102

- (Topic 5)
What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

A. The provisioning of new compute resources for the warehouse will begin immediately.
B. The warehouse will remain suspended but new resources will be added to the query acceleration service.
C. The provisioning of additional compute resources will be in effect when the warehouse is next resumed.
D. The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

Correct Answer:C
When a Snowflake user increases the size of a suspended virtual warehouse, the changes to compute resources are queued but do not take immediate effect. The provisioning of additional compute resources occurs only when the warehouse is resumed. This ensures that resources are allocated efficiently, aligning with Snowflake's commitment to cost-effective and on-demand scalability.
References:
✑ Snowflake Documentation: Virtual Warehouses

Question 103

- (Topic 2)
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Correct Answer:DEF
Snowflake??s architecture is designed to operate entirely on cloud infrastructure. It uses the core compute and storage services of each cloud provider, which allows it to leverage the scalability and reliability of cloud resources. Snowflake??s services are deployed across multiple availability zones within a cloud provider??s region to ensure high availability and fault tolerance. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 104

- (Topic 3)
How can a data provider ensure that a data consumer is going to have access to the required objects?

A. Enable the data sharing feature in the account and validate the view.
B. Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
C. Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.
D. Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

Correct Answer:A
To ensure a data consumer has access to the required objects, a data provider can enable the data sharing feature and validate that the consumer can access the views or tables shared with them. References: Based on general data sharing practices in cloud services as of 2021.

Question 105

- (Topic 4)
A column named "Data" contains VARIANT data and stores values as follows:
COF-C02 dumps exhibit
How will Snowflake extract the employee's name from the column data?

A. Data:employee.name
B. DATA:employee.name
C. data:Employee.name
D. data:employee.name

Correct Answer:D
In Snowflake, to extract a specific value from a VARIANT column, you use the column name followed by a colon and then the key. The keys are case-sensitive.
Therefore, to extract the employee??s name from the ??Data?? column, the correct syntax is data:employee.name.