Free COF-C02 Exam Dumps

Question 16

- (Topic 2)
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

A. The Pipe load history is reset to empty.
B. The REFRESH command is executed.
C. The stage will be purged.
D. The destination table is truncated.

Correct Answer:A
When a pipe is recreated using the CREATE OR REPLACE
PIPE command, the load history of the pipe is reset. This means that Snowpipe will consider all files in the stage as new and will attempt to load them, even if they were loaded previously by the old pipe2.

Question 17

- (Topic 6)
Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?

A. ACCESS_HISTORY
B. LOAD_HOSTORY
C. QUERY_HISTORY
D. COPY_HISTORY

Correct Answer:A
In Snowflake, the system-defined, read-only view that displays information on column lineage, which specifies how data flows from source to target in a SQL write operation, isACCESS_HISTORY. This view is instrumental in auditing and analyzing data access patterns, as it provides detailed insights into how and from where the data is being accessed and manipulated within Snowflake.
Reference to Snowflake documentation on ACCESS_HISTORY:
✑ Using Access History to Audit Data Access

Question 18

- (Topic 1)
What happens when an external or an internal stage is dropped? (Select TWO).

A. When dropping an external stage, the files are not removed and only the stage is dropped
B. When dropping an external stage, both the stage and the files within the stage are removed
C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
D. When dropping an internal stage, the files are deleted with the stage and the files arenot recoverable
E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Correct Answer:AD
When an external stage is dropped in Snowflake, the reference to the external storage location is removed, but the actual files within the external storage (like Amazon S3, Google Cloud Storage, or Microsoft Azure) are not deleted. This means that the data remains intact in the external storage location, and only the stage object in Snowflake is removed.
On the other hand, when an internal stage is dropped, any files that were uploaded to the stage are deleted along with the stage itself. These files are not recoverable once the internal stage is dropped, as they are permanently removed from Snowflake??s storage. References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Stages

Question 19

- (Topic 3)
What action can a user take to address query concurrency issues?

A. Enable the query acceleration service.
B. Enable the search optimization service.
C. Add additional clusters to the virtual warehouse
D. Resize the virtual warehouse to a larger instance size.

Correct Answer:C
To address query concurrency issues, a user can add additional clusters to the virtual warehouse. This allows for the distribution of queries across multiple clusters, reducing the load on any single cluster and improving overall query performance2.

Question 20

- (Topic 4)
What is a characteristic of materialized views in Snowflake?

A. Materialized views do not allow joins.
B. Clones of materialized views can be created directly by the user.
C. Multiple tables can be joined in the underlying query of a materialized view.
D. Aggregate functions can be used as window functions in materialized views.

Correct Answer:C
One of the characteristics of materialized views in Snowflake is that they allow multiple tables to be joined in the underlying query. This enables the pre-computation of complex queries involving joins, which can significantly improve the performance of subsequent queries that access the materialized view4. References: [COF-C02] SnowPro Core Certification Exam Study Guide