COF-C02 Practice Exam Questions and Answers

A.  

OPERATE

B.  

READ

C.  

SELECT

D.  

USAGE

A.  

Materialized View

B.  

Pipe

C.  

Stream

D.  

Task

A.  

Workloads with a predictable data volume for each query

B.  

Workloads that include on-demand data analyses

C.  

Queries with small scans and non-selective filters

D.  

Queries that do not have filters or aggregation

A.  

Faster query performance and increased storage consumption

B.  

Slower query performance and increased storage consumption

C.  

Faster query performance and decreased storage consumption

D.  

Slower query performance and decreased storage consumption

A.  

Use the automatic sharing feature for seamless access.

B.  

Drop the object and then re-add it to the database to trigger sharing.

C.  

Recreate the object with a different name in the database before sharing.

D.  

Use the grant privilege ... TO share command to grant the necessary privileges.

A.  

Monitor the performance of individual queries in real-time

B.  

Automatically allocate more storage space to a virtual warehouse

C.  

Modify the queries being executed within a virtual warehouse.

D.  

Suspend a virtual warehouse when its credit usage reaches a defined limit.

E.  

Trigger a notification to account administrators when credit usage reaches a specified threshold

A.  

Tasks

B.  

Pipes

C.  

Secure User-Defined Functions (UDFs)

D.  

Stored Procedures

A.  

A VARIANT column is more secure than a string column

B.  

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

C.  

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

D.  

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

A.  

QUALIFY

B.  

LATERAL

C.  

PIVOT

D.  

CONNECT BY

A.  

TRUNC

B.  

TRUNC(ID_NUMBER, 5)

C.  

ID_NUMBER*100

D.  

TO_CHAR

A.  

It will indicate if a virtual warehouse memory is too small to run the query

B.  

It will indicate if a user lacks the privileges needed to run the query.

C.  

It will indicate if a virtual warehouse is in auto-scale mode

D.  

It will indicate if the user has enough Snowflake credits to run the query

A.  

Multi-Factor Authentication (MFA)

B.  

Default database

C.  

Default schema

D.  

Notification

E.  

Username

A.  

Area charts

B.  

Bar charts

C.  

Column charts

D.  

Radar charts

E.  

Scorecards

A.  

Grant

B.  

Privilege

C.  

Role

D.  

Session

A.  

The file will continue to load until all contents arc loaded.

B.  

The tile will slop loading and all data up to that point will be committed.

C.  

The file loading could be aborted without any portion of the file being committed.

D.  

The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake