COF-C03 Practice Questions

A.  

GRANT

B.  

SELECT

C.  

MODIFY

D.  

OWNERSHIP

E.  

CREATE USER

A.  

SHOW

B.  

MERGE

C.  

INSERT

D.  

DELETE

E.  

DESCRIBE

A.  

Tag

B.  

Task

C.  

Stream

D.  

Stored procedure

A.  

USAGE_VIEWER

B.  

GOVERNANCE_VIEWER

C.  

OBJECT_VIEWER

D.  

SECURITY_VIEWER

A.  

To profile how many times a particular query was executed and analyze its u^age statistics over time.

B.  

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

C.  

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

D.  

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

A.  

Bytes scanned

B.  

Partitions scanned

C.  

Bytes spilled to local storage

D.  

Bytes spilled to remote storage

E.  

Percentage scanned from cache

A.  

COPY INTO

B.  

GET

C.  

LIST

D.  

PUT

E.  

REMOVE

A.  

DATABASE_STORAGE_USAGE_HISTORY

B.  

TABLE_STORAGE_METRICS

C.  

STORAGE_DAILY_HISTORY

D.  

STAGE STORAGE USAGE HISTORY

A.  

CREATE TABLE < table_name > LIKE TABLE_A;

B.  

CREATE VIEW < view_name > AS SELECT * FROM TABLE_A;

C.  

CREATE TABLE < table_name > AS SELECT * FROM TABLE_A;

D.  

CREATE MATERIALIZED VIEW < view name > AS SELECT * FROM TABLE A;

A.  

ACCESS_HISTORY

B.  

COPY_HISTORY

C.  

QUERY_HISTORY

D.  

ROW ACCESS POLICIES

A.  

File URL

B.  

Scoped URL

C.  

Relative URL

D.  

Pre-Signed URL

A.  

Standard Edition

B.  

Enterprise Edition

C.  

Business Critical Edition

D.  

Virtual Private Snowflake Edition

A.  

File URL

B.  

Staged URL

C.  

Scoped URL

D.  

Pre-signed URL

A.  

Range of values

B.  

Distinct values

C.  

Index values

D.  

Sorted values

E.  

Null values

A.  

The user will be unable to enter a password.

B.  

The user will encounter an error, and will not be able to log in.

C.  

The user will be able to log into Snowflake successfully.

D.  

After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

A.  

TO_CHAR

B.  

TO_VARIANT

C.  

TO_VARCHAR

D.  

STRIP NULL VALUE

A.  

RETURN_-1_R0WS

B.  

RETURN_n_ROWS

C.  

RETURN_ERRORS

D.  

RETURN ALL ERRORS

A.  

Warehouses that are multi-cluster can have nodes of different sizes.

B.  

Warehouses can be started and stopped at any time.

C.  

Warehouses can be resized at any time, even while running.

D.  

Warehouses are billed on a per-minute usage basis.

E.  

Warehouses can only be used for querying and cannot be used for data loading.

A.  

Flatten the data and store it in structured data types in a flattened table. Query the table.

B.  

Store the data in a table with a variant data type. Query the table.

C.  

Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.

D.  

Store the data in an external stage and create views on top of it. Query the views.

A.  

Use COPY INTO < external stage > followed by a GET command to download the file.

B.  

Use COPY INTO < internal stage > followed by a put command to download the file.

C.  

Use COPY INTO < internal stage > with SINGLE = TRUE followed by a GET command to download the file.

D.  

Use COPY INTO < external stage > with SINGLE = TRUE followed by a PUT command to download the file.