COF-C02 Practice Test Questions

498 Questions


Topic 1: Exam pool A

A user has unloaded data from Snowflake to a stage. Which SQL command should be used to validate which data was loaded into the stage?


A.

list @file__stage


B.

show @file__stage


C.

view @file__stage


D.

verify @file__stage





Query compilation occurs in which architecture layer of the Snowflake Cloud Data
Platform?


A.

Compute layer


B.

Storage layer


C.

Cloud infrastructure layer


D.

Cloud services layer





Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)


A.

ROLES


B.

POLICY_REFERENCES


C.

QUERY_HISTORY


D.

RESOURCE_MONIT ORS


E.

ACCESS_HISTORY





Which data types does Snowflake support when querying semi-structured data? (Select TWO)


A.

VARIANT


B.

ARRAY


C.

VARCHAR


D.

XML


E.

BLOB





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 are not recoverable


E.

When dropping an internal stage, only selected files are deleted with the stage and are not recoverable





What is a limitation of a Materialized View?


A.

A Materialized View cannot support any aggregate functions


B.

A Materialized View can only reference up to two tables


C.

A Materialized View cannot be joined with other tables


D.

A Materialized View cannot be defined with a JOIN





What Snowflake role must be granted for a user to create and manage accounts?


A.

ACCOUNTADMIN


B.

ORGADMIN


C.

SECURITYADMIN


D.

SYSADMIN





Which of the following describes how clustering keys work in Snowflake?


A.

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.


B.

Clustering keys sort the designated columns over time, without blocking DML operations


C.

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns


D.

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time





Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?


A.

Pipe


B.

External stage


C.

Task


D.

Stream





What features does Snowflake Time Travel enable?


A.

Querying data-related objects that were created within the past 365 days


B.

Restoring data-related objects that have been deleted within the past 90 days


C.

Conducting point-in-time analysis for Bl reporting


D.

Analyzing data usage/manipulation over all periods of time





True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.


A.

True


B.

False





What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)


A.

Data can be filtered by an optional where clause


B.

Incoming data can be joined with other tables


C.

Columns can be reordered


D.

Columns can be omitted


E.

Row level access can be defined






Page 6 out of 42 Pages
Previous