Question 1

When cloning a schema, which Snowflake object will not be included in the clone?

Options :

A : An external stage

B : A named internal stage

C : A task

D : A User-Defined Function (UDF)

Answer: A

Question 2

What information does the Query Profile provide?

Options :

A : Graphical representation of the data model

B : Statistics for each component of the processing plan

C : Detailed Information about I he database schema

D : Real-time monitoring of the database operations

Answer: B

Question 3

Which Query Profile operator is considered a DML operator?

Options :

A : ExternalScan

B : Flatten

C : Merge

D : Sort

Answer: C

Question 4

By default, which role can create resource monitors?

Options :

A : ACCOUNTADMIN

B : SECURITYADMIN

C : SYSADMIN

D : USERADMIN

Answer: A

Question 5

When unloading to a stage, which of the following is a recommended practice or approach?

Options :

A : Set SINGLE: = true for larger files

B : Use OBJECT_CONSTRUCT ( * ) when using Parquet

C : Avoid the use of the CAST function

D : Define an individual file format

Answer: D

Free COF-C02 Mock Exam – Practice Online Confidently