COF-C02 Practice Questions

A.  

Account

B.  

Database

C.  

Organization

D.  

Schema

E.  

Virtual warehouse

A.  

Scale up the existing warehouse.

B.  

Create separate warehouses for each user.

C.  

Create separate warehouses for each workload.

D.  

Stop loading and querying data at the same time.

A.  

SHOW MASKING POLICIES

B.  

DESCRIBE MASKING POLICY

C.  

GET_DDL

D.  

LIST MASKING POLICIES

A.  

Reorder the rows in a relational table and then unload the rows into a file

B.  

Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

C.  

Reorder the data columns according to a target table definition and then unload the rows into the table.

D.  

Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

A.  

8MB

B.  

16MB

C.  

32MB

D.  

128MB

A.  

The number of queries executed

B.  

The number of active users assigned to the warehouse

C.  

The size of the virtual warehouse

D.  

The length of time the warehouse is running

E.  

The duration of the queries that are executed

A.  

Indefinitely

B.  

Until the result_cache expires

C.  

Until the retention_time is met

D.  

Until the expiration time is exceeded

A.  

External tables

B.  

Materialized views

C.  

Tables and views that are not protected by row access policies

D.  

Casts on table columns (except for fixed-point numbers cast to strings)

A.  

Analyze query performance.

B.  

Write queries and execute them.

C.  

Provide an overview of the listings in the Snowflake Marketplace.

D.  

Connect to Snowflake partners to explore extended functionality.

A.  

Rename listings.

B.  

Delete provider profiles.

C.  

Modify listings properties.

D.  

Modify incoming listing access requests.

E.  

Submit listings for approval/publishing.

A.  

DISABLED

B.  

MINS TO BYPASS MFA

C.  

MINS TO BYPASS NETWORK POLICY

D.  

MINS TO UNLOCK

A.  

A logical grouping of objects that belongs to a single database

B.  

A logical grouping of objects that belongs to multiple databases

C.  

A named Snowflake object that includes all the information required to share a database

D.  

A uniquely identified Snowflake account within a business entity

A.  

A materialized view can query only a single table.

B.  

Data accessed through materialized views can be stale.

C.  

Materialized view refreshes need to be maintained by the user.

D.  

Querying a materialized view is slower than executing a query against the base table of the view.

A.  

COPY INTO

B.  

GET

C.  

PUT

D.  

TRANSFER

A.  

All columns in a micro-partition

B.  

Any columns accessed during the query

C.  

The columns in the result set of the query

D.  

All rows accessed during the query

A.  

External tables

B.  

Secure views

C.  

Materialized views

D.  

User-Defined Functions (UDFs)

A.  

Schema Stage

B.  

User Stage

C.  

Database Stage

D.  

Table Stage

E.  

External Named Stage

F.  

Internal Named Stage

A.  

8-16 MB

B.  

16-24 MB

C.  

10-99 MB

D.  

100-250 MB

A.  

SHOW STORAGE BY TABLE;

B.  

SHOW TABLES;

C.  

Information Schema -> TABLE_HISTORY

D.  

Information Schema -> TABLE_FUNCTION

E.  

Information Schema -> TABLE_STORAGE_METRICS

A.  

Configure the maximum clusters setting to "Maximum."

B.  

Turn on the additional clusters manually after starting the warehouse.

C.  

Set the minimum Clusters and maximum Clusters settings to the same value.

D.  

Set the minimum clusters and maximum clusters settings to different values.