COF-C02 Practice Questions

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 STORAGE BY TABLE;

B.  

SHOW TABLES;

C.  

Information Schema - > TABLE_HISTORY

D.  

Information Schema - > TABLE_FUNCTION

E.  

Information Schema - > TABLE_STORAGE_METRICS

A.  

8MB

B.  

16MB

C.  

32MB

D.  

128MB

A.  

ROW_NUMBER

B.  

TABLE

C.  

TABULAR

D.  

VALUES

A.  

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

B.  

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

C.  

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

D.  

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

A.  

Coordinates activities in the Snowflake account

B.  

Executes queries submitted by the Snowflake account users

C.  

Manages quotas on the Snowflake account storage

D.  

Manages the virtual warehouse cache to speed up queries

A.  

Resource monitor

B.  

Account_usage. query_history

C.  

Information_schema.warehouse_load_history

D.  

Information schema.warehouse metering history

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.  

A directory table is a separate database object.

B.  

Directory tables store data file metadata.

C.  

A directory table will be automatically added to a stage.

D.  

Directory tables do not have their own grantable privileges.

E.  

Directory table data can not be refreshed manually.

A.  

Snowpark uses a Spark engine to generate optimized SQL query plans.

B.  

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C.  

Snowpark does not require that a separate cluster be running outside of Snowflake.

D.  

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E.  

Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

A.  

SHOW MASKING POLICIES

B.  

DESCRIBE MASKING POLICY

C.  

GET_DDL

D.  

LIST MASKING POLICIES

A.  

Schema Stage

B.  

User Stage

C.  

Database Stage

D.  

Table Stage

E.  

External Named Stage

F.  

Internal Named Stage

A.  

CSV

B.  

JSON

C.  

ORC

D.  

Parquet

A.  

When the data cache clears.

B.  

When the persisted query result period ends.

C.  

The encoded URL access is permanent.

D.  

The length of time is specified in the expiration_time argument.

A.  

Infrastructure management

B.  

Metadata management

C.  

Query execution

D.  

Query parsing and optimization

E.  

Permanent storage of micro-partitions

A.  

USAGE

B.  

OPERATE

C.  

MONITOR

D.  

OWNERSHIP

A.  

ALTER FILE FORMAT my_format SET TYPE=JSON;

B.  

ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

C.  

CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

D.  

REPLACE FILE FORMAT my format TYPE-JSON;

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.  

If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

B.  

A Data Exchange allows groups of accounts to share data privately among the accounts.

C.  

A Data Exchange allows accounts to share data with third, non-Snowflake parties.

D.  

Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

E.  

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

A.  

inscrtFilcs

B.  

insertReport

C.  

GET /api/tiles/

D.  

loadHistoryScan