COF-C03 Practice Questions

A.  

File URL

B.  

Scoped URL

C.  

Relative URL

D.  

Pre-Signed URL

A.  

A single data type, with one or more conditions, and one or more masking functions

B.  

A single data type, with only one condition, and only one masking function

C.  

Multiple data types, with only one condition, and one or more masking functions

D.  

Multiple data types, with one or more conditions, and one or more masking functions

A.  

Secure view

B.  

Materialized view

C.  

Temporary table

D.  

Transient table

A.  

Bytes scanned

B.  

Partitions scanned

C.  

Bytes spilled to local storage

D.  

Bytes spilled to remote storage

E.  

Percentage scanned from cache

A.  

Object owner

B.  

Schema owner

C.  

Database owner

D.  

SYSADMIN

A.  

RETURN_-1_R0WS

B.  

RETURN_n_ROWS

C.  

RETURN_ERRORS

D.  

RETURN ALL ERRORS

A.  

Copy data into files.

B.  

Manage different databases and schemas.

C.  

Troubleshoot network connections to Snowflake.

D.  

Write SELECT queries to retrieve data from external tables.

A.  

Partitions scanned

B.  

Partitions total

C.  

Bytes scanned

D.  

Bytes read from result

E.  

Bytes written

A.  

CREATE STAGE

B.  

COPY INTO < table >

C.  

COPY INTO < location >

D.  

CREATE PIPE

A.  

Data Replication

B.  

Secure Data Sharing

C.  

Data Exchange

D.  

Snowflake Marketplace

A.  

Network policy

B.  

End-to-end encryption

C.  

Multi-Factor Authentication (MFA)

D.  

Role-Based Access Control (RBAC)

A.  

Views

B.  

Materialized views

C.  

Tables

D.  

External tables

E.  

Future grants

A.  

GRANT

B.  

SELECT

C.  

MODIFY

D.  

OWNERSHIP

E.  

CREATE USER

A.  

COPY INTO

B.  

GET

C.  

LIST

D.  

PUT

E.  

REMOVE

A.  

TO_OBJECT

B.  

TO_JSON

C.  

TO_VARIANT

D.  

OBJECT CONSTRUCT

A.  

Load the data into a CSV file.

B.  

Load the data into a relational table.

C.  

Use the VALlDATlON_MODE - SQL statement.

D.  

Use the validation mode = return rows statement.

A.  

The account type

B.  

The storage file format

C.  

The cloud region used by the account

D.  

The type of data being stored

E.  

The cloud platform being used

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.  

Add and remove members.

B.  

Delete data categories.

C.  

Approve and deny listing approval requests.

D.  

Transfer listing ownership.

E.  

Transfer ownership of a provider profile.

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;