COF-C02 Online Practice Questions and Answers

True or False: Snowpipe via RFST API can only reference External Stages as source.

A. True

B. False

Which of the following items does the Cloud services Layer manage? Choose 4 answers

A. user authentication

B. Metadata

C. Query compilation and optimization

D. external blob storage

E. Data security

When can a newly configured virtual warehouse start running SQL queries?

A. After 50% of the warehouse provisioning has completed

B. During the time slots defined by the ACCOUNTADMIN

C. When the warehouse provisioning is completed

D. After the warehouse replication is completed

Snowflake's approach to the management of system access combines which of the following models? (Choose two.)

A. Security Assertion Markup Language (SAML)

B. Role-Based Access Control (RBAC)

C. Identity Access Management (AM)

D. Create, Read, Update, and Delete (CRUD)

E. Discretionary Access Control (DAC)

F. Mandatory Access Control (MAC)

What is a recommended approach for optimizing query performance in Snowflake?

A. Use subqueries whenever possible.

B. Use a large number of joins to combine data from multiple tables.

C. Select all columns from tables, even if they are not needed in the query.

D. Use a smaller number of larger tables rather than a larger number of smaller tables.

Which COPY INTO statement accurately describes how to unload data from a Snowflake table?

A. The default value for the SINGLE option is set to TRUE.

B. By default, COPY INTO statements do not separate table data into a set of output files.

C. The OBJECT_CONSTRUCT function can be combined with the COPY command to convert the rows in a relational table to a single VARIANT column.

D. If the COMPRESSION option is set to TRUE, a file's name can be specified with the appropriate file extension so that the output file can be compressed.

What is the advantage of using a reader account?

A. It can be used by a client that does not have a Snowflake account

B. It is read-only and prevents the shared data from being updated by the provider.

C. It can be connected to a Snowflake account in a different region.

D. It provides limited access to the data share and is therefore cheaper for the data provider.

How are URLs that access unstructured data in external stages retrieved?

A. From the Snowsight navigation menu

B. By querying a directory table

C. By creating an external function

D. By using the INFORMATION_USAGE schema

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

A. Create a task that runs a copy into operation from an external stage every 5 minutes

B. Create a task that puts the files in an internal stage and automate the data loading wizard

C. Create a task that runs a GET operation to intermittently check for new files

D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Which of the following accurately describes shares?

A. Tables, secure views, and secure UDFs can be shared

B. Shares can be shared

C. Data consumers can clone a new table from a share

D. Access to a share cannot be revoked once granted