COF-C03 Practice Questions

A.  

0 days

B.  

1 day

C.  

7 days

D.  

14 days

A.  

Binary file in Avro

B.  

Binary file in Parquet

C.  

Comma-separated JSON

D.  

Newline Delimited JSON

E.  

Plain text file containing XML elements

A.  

Use the SHOW STAGES command.

B.  

Use the DESCRIBE STAGE command.

C.  

Use the GET_ABSOLUTE_PATH function.

D.  

Use the GET_STAGE_LOCATION function.

A.  

Grant the additional privileges to a custom role.

B.  

Grant the additional privileges to the ACCOUNTADMIN role.

C.  

Grant the additional privileges to the SYSADMIN role.

D.  

Grant the additional privileges to the ORGADMIN role.

A.  

SHOW TABLES command

B.  

SHOW EXTERNAL TABLES command

C.  

TABLES view

D.  

TABLE STORAGE METRICS view

A.  

show grants to user USER1;

B.  

show grants of user USER1;

C.  

describe user USER1;

D.  

show grants on user USER1;

A.  

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B.  

Querying(select)the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C.  

If using the stored procedure to execute multiple SQL statements, it ' s best to test run the stored procedure separately to size the compute resource first

D.  

Since task infrastructure is based on running the task body on schedule, it ' s recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

A.  

True

B.  

False

A.  

CSV (Unzipped)

B.  

Parquet

C.  

CSV (Gzipped)

D.  

ORC

A.  

True

B.  

False

A.  

Data sharing within a specific region

B.  

Query result retrieval

C.  

Database replication

D.  

Loading data into Snowflake

A.  

STATEMENT_TIMEOUT__IN__SECONDS

B.  

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.  

MAX_CONCURRENCY__LEVEL

D.  

QUERY_TIMEOUT_IN_SECONDS

A.  

Zero-copy cloning creates a mirror copy of a database that updates with the original

B.  

Software updates are automatically applied on a quarterly basis

C.  

Snowflake eliminates resource contention with its virtual warehouse implementation

D.  

Multi-cluster warehouses allow users to run a query that spans across multiple clusters

E.  

Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

A.  

ACCOUNTADMIN

B.  

ORGADMIN

C.  

SECURITYADMIN

D.  

SYSADMIN

A.  

LOAD

B.  

copy

C.  

GET

D.  

PUT

A.  

True

B.  

False

A.  

Pipe

B.  

External stage

C.  

Task

D.  

Stream

A.  

ROLEADMIN

B.  

ACCOUNTADMIN

C.  

SYSADMIN

D.  

SECURITYADMIN

E.  

USERADMIN

A.  

The primary cluster in the virtual warehouse

B.  

The entire virtual warehouse

C.  

The database in which the virtual warehouse resides

D.  

The Queries currently being run on the virtual warehouse

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