COF-C02 Practice Questions

A.  

MODIFY

B.  

READ

C.  

SELECT

D.  

USAGE

A.  

GET_STATE_LOCATION

B.  

GET_PRESENT_URL

C.  

BUILD_SCOPED_FILE_URL

D.  

BUILD_STAGE_FILE_URL

A.  

Worksheets can be grouped under folder, and a folder of folders.

B.  

Each worksheet is a unique Snowflake session.

C.  

Users are limited to running only one on a worksheet.

D.  

The Snowflake session ends when a user switches worksheets.

E.  

Users can import worksheets and share them with other users.

A.  

Partitions scanned

B.  

Partitions total

C.  

Bytes scanned

D.  

Bytes read from result

E.  

Bytes written

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake (VPS)

A.  

PARSE_HEADER = TRUE

B.  

SKIP_HEADER = < integer >

C.  

HEADER = TRUE

D.  

HEADER = ( ' < header_1 > ' = ' < value_1 > ' )

A.  

Clone the data from the production account to the non-production account.

B.  

Create a data share from the production account to the non-production account.

C.  

Create a subscription in the production account and have it publish to the non-production account.

D.  

Create a reader account using the production account and link the reader account to the non-production account.

A.  

They are a set of rules that define the network routes within Snowflake.

B.  

They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

C.  

They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

D.  

They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connectto Snowflake.

A.  

ACCOUNTADMIN

B.  

SECURITYADMIN

C.  

SYSADMIN

D.  

ORGADMIN

A.  

The access to a single table

B.  

The access to data stored in stage objects

C.  

The list of values provided with the VALUES clause

D.  

The records generated using the TABLE (GENERATOR (...)) construct

A.  

User stage

B.  

Table stage

C.  

Named internal stage

D.  

Named external stage

A.  

Cloud services

B.  

Query processing

C.  

Elastic memory

D.  

Database storage

A.  

File URL

B.  

Scoped URL

C.  

Pre-signed URL

D.  

Scoped file URL

A.  

(12,2)

B.  

(10,4)

C.  

(14,8)

D.  

(15,9)

A.  

1 hour

B.  

2 hours

C.  

4 hours

D.  

8 hours

A.  

60 minutes

B.  

24 hours

C.  

14 days

D.  

30 days

A.  

Snowflake will resolve them according to the SEARCH_PATH parameter.

B.  

Snowflake will only check the schema the UDF belongs to.

C.  

Snowflake will first check the current schema, and then the schema the previous query used

D.  

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

A.  

Avro

B.  

CSV

C.  

JSON

D.  

Parquet

A.  

A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)

B.  

A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)

C.  

A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)

D.  

A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

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.