Snowflake COF-C02 Exam Questions Instant Access

Question 1

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

AINSERT

BPUT

CGET

DCOPY

Answer : D

The COPY command is used in Snowflake to load data from files located in an external stage into a table.This command allows for efficient and parallelized data loading from various file formats1.

References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

Question 2

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

ACreate a zero-copy clone of the worksheet and grant permissions to teammates

BCreate a private Data Exchange so that any teammate can use the worksheet

CShare the worksheet with teammates within Snowsight

DCreate a database and grant all permissions to teammates

Answer : C

Worksheets in Snowsight can be shared directly with other Snowflake users within the same account.This feature allows for collaboration and sharing of SQL queries or Python code, as well as other data manipulation tasks1.

Question 3

Which of the following accurately describes shares?

ATables, secure views, and secure UDFs can be shared

BShares can be shared

CData consumers can clone a new table from a share

DAccess to a share cannot be revoked once granted

Answer : A

Shares in Snowflake are named objects that encapsulate all the information required to share databases, schemas, tables, secure views, and secure UDFs.These objects can be added to a share by granting privileges on them to the share via a database role

Question 4

What metadata does Snowflake store concerning all rows stored in a micro-partition? (Select TWO).

AA count of the number of total values in the micro-partition

BThe range of values for each partition in the micro-partition

CThe range of values for each of the rows in the micro-partition

DThe range of values for each of the columns in the micro-partition

EThe number of distinct values for each column in the micro-partition

Answer : A, D

Question 5

Which command removes a role from another role or a user in Snowflak?

AALTER ROLE

BREVOKE ROLE

CUSE ROLE

DUSE SECONDARY ROLES

Answer : B

The REVOKE ROLE command is used to remove a role from another role or a user in Snowflake. This command is part of Snowflake's role-based access control system, allowing administrators to manage permissions and access to database objects efficiently by adding or removing roles from users or other roles.

References:

Snowflake Documentation: REVOKE ROLE

Question 6

If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

AAuto-scale mode

BMaximized mode

CEconomy scaling policy

DStandard scaling policy

Answer : A

In Snowflake, when queries begin to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately if the warehouse is set to auto-scale mode.This mode allows Snowflake to automatically add or resume additional clusters as soon as the workload increases, and similarly, shut down or pause the additional clusters when the load decreases

Question 7

Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?

AA VARIANT column is more secure than a string column

BA VARIANT column compresses data and a string column does not.

CA variant column can be used to create a data hierarchy and a string column cannot

DA VARIANT column will have a better query performance than a string column.

Answer : C

A VARIANT column in Snowflake is specifically designed to store semi-structured data, such as JSON, and allows for the creation of a data hierarchy. Unlike string columns, VARIANT columns can natively handle JSON data structures, enabling complex querying and manipulation of hierarchical data using functions designed for semi-structured data.

References:

Snowflake Documentation: VARIANT Data

Snowflake SnowPro Core Certification COF-C02 Exam Questions