COF-C02 Snowflake Exam Questions and Free Practice Test

Question 127

- (Topic 1)
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X- Small Warehouse.

A. True

B. False

Correct Answer:A
Provisioning time can vary based on the size of the warehouse. A 4X-Large Warehouse typically has more resources and may take longer to provision compared to a X-Small Warehouse, which has fewer resources and can generally be provisioned more quickly.References: Understanding and viewing Fail-safe | Snowflake Documentation

Question 128

- (Topic 6)
Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

A. Persisted query results

B. QUERY_HISTORY View

C. Query acceleration service

D. Query Profile

Correct Answer:D
The Snowflake feature that helps troubleshoot issues in SQL query expressions and commonly identify performance bottlenecks is theQuery Profile. The Query Profile provides a detailed breakdown of a query's execution plan, including each operation's time and resources consumed. It visualizes the steps involved in the query execution, highlighting areas that may be causing inefficiencies, such as full table scans, large joins, or operations that could benefit from optimization.
By examining the Query Profile, developers and database administrators can identify and troubleshoot performance issues, optimize query structures, and make informed decisions about potential schema or indexing changes to improve performance.
References:
✑ Snowflake Documentation on Query Profile: Using the Query Profile

Question 129

- (Topic 2)
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

A. Tri-Secret Secure

B. Time Travel

C. Fail-safe

D. Data encryption

E. External stages

Correct Answer:BC
The features associated with Continuous Data Protection (CDP) that require additional Snowflake-provided data storage are Time Travel and Fail-safe. Time Travel allows users to access historical data within a defined period, while Fail-safe provides an additional layer of data protection beyond the Time Travel period. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 130

- (Topic 4)
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi- Factor Authentication (MFA) token valid for?

A. 1 hour

B. 2 hours

C. 4 hours

D. 8 hours

Correct Answer:C
When using the ALLOW_CLIENT_MFA_CACHING parameter, a cached Multi-Factor Authentication (MFA) token is valid for up to 4 hours. This allows for continuous, secure connectivity without users needing to respond to an MFA prompt at the start of each connection attempt to Snowflake within this timeframe2.

Question 131

- (Topic 3)
Which file format will keep floating-point numbers from being truncated when data is unloaded?

A. CSV

B. JSON

C. ORC

D. Parquet

Correct Answer:D
The Parquet file format is known for preserving the precision of floating-point numbers when data is unloaded, preventing truncation of the values3.

Question 132

- (Topic 4)
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

A. CREATE TABLE <table_name> LIKE TABLE_A;

B. CREATE VIEW AS SELECT * FROM TABLE_A;

C. CREATE TABLE

AS SELECT * FROM TABLE_A;

D. CREATE MATERIALIZED VIEW AS SELECT * FROM TABLE A;

Correct Answer:C
When a tag object is assigned to a table, using the statement CREATE TABLE <table_name> AS SELECT * FROM TABLE_A will automatically assign the TABLE_A tag to the newly created table2.

START COF-C02 EXAM