COF-C02 Snowflake Exam Questions and Free Practice Test

Question 55

- (Topic 5)
The VALIDATE table function has which parameter as an input argument for a Snowflake user?

A. Last_QUERY_ID

B. CURRENT_STATEMENT

C. UUID_STRING

D. JOB_ID

Correct Answer:C
The VALIDATE table function in Snowflake would typically use a unique identifier, such as a UUID_STRING, as an input argument. This function is designed to validate the data within a table against a set of constraints or conditions, often requiring a specific identifier to reference the particular data or job being validated.
References:
✑ There is no direct reference to a VALIDATE table function with these specific parameters in Snowflake documentation. It seems like a theoretical example for understanding function arguments. Snowflake documentation on UDFs andsystem functions can provide guidance on how to create and use custom functions for similar purposes.

Question 56

- (Topic 3)
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

A. Use Snowpipe.

B. Use the INSERT command.

C. Use an external table.

D. Use the COPY command.

Correct Answer:D
Snowflake recommends using the COPY command for bulk loading data batches from files already available in cloud storage. This command allows for efficient and large-scale data loading operations from files staged in cloud storage into Snowflake tables3.

Question 57

- (Topic 5)
How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

A. 60 minutes

B. 24 hours

C. 14 days

D. 30 days

Correct Answer:C
In the Snowflake Web Interface (UI), the Query History page displays the history of queries executed in Snowflake for up to 14 days. This allows users to review and analyze their query performance, troubleshoot issues, and understand their query patterns over a two-week period. The Query History page is a critical tool for monitoring and optimizing the use of Snowflake.
References:
✑ Snowflake Documentation: Using the Web Interface

Question 58

- (Topic 3)
What happens when a database is cloned?

A. It does not retain any privileges granted on the source object.

B. It replicates all granted privileges on the corresponding source objects.

C. It replicates all granted privileges on the corresponding child objects.

D. It replicates all granted privileges on the corresponding child schema objects.

Correct Answer:A
When a database is cloned in Snowflake, it does not retain any privileges that were granted on the source object. The clone will need to have privileges reassigned as necessary for users to access it. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 59

- (Topic 6)
Which semi-structured file format is a compressed, efficient, columnar data representation?

A. Avro

B. JSON

C. TSV

D. Parquet

Correct Answer:D
Parquet is a columnar storage file format that is optimized for efficiency in both storage and processing. It supports compression and encoding schemes that significantly reduce the storage space needed and speed up data retrieval operations, making it ideal for handling large volumes of data. Unlike JSON or TSV, which are row- oriented and typically uncompressed, Parquet is designed specifically for use with big data frameworks, offering advantages in terms of performance and cost when storing and querying semi-structured data.References:Apache Parquet Documentation

Question 60

- (Topic 3)
What does Snowflake recommend regarding database object ownership? (Select TWO).

A. Create objects with ACCOUNTADMIN and do not reassign ownership.

B. Create objects with SYSADMIN.

C. Create objects with SECURITYADMIN to ease granting of privileges later.

D. Create objects with a custom role and grant this role to SYSADMIN.

E. Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

Correct Answer:BD
Snowflake recommends creating objects with a role that has the necessary privileges and is not overly permissive. SYSADMIN is typically used for managing system- level objects and operations. Creating objects with a custom role and granting this role to SYSADMIN allows for more granular control and adherence to the principle of least privilege. References: Based on best practices for database object ownership and role management.

START COF-C02 EXAM