COF-C03 Practice Questions

A.  

PARSE_JSON()

B.  

ARRAY_CONSTRUCT()

C.  

OBJECT_CONSTRUCT()

D.  

GET

A.  

In-progress queries will be cancelled.

B.  

Queries will continue running, using the new warehouse size.

C.  

Queries will continue running, using the current warehouse size.

D.  

Queries will be paused and automatically reprocessed using the new warehouse size.

A.  

BUILD_STAGE_FILE_URL(@ < stage_name > , ' < relative_file_path > ' );

B.  

GET_PRESIGNED_URL(@ < stage_name > , ' < relative_file_path > ' , [ < expiration_time > ]);

C.  

GET_RELATIVE_PATH(@ < stage_name > , ' < absolute_file_path > ' );

D.  

BUILD_SCOPED_FILE_URL(@ < stage_name > , ' < relative_file_path > ' );

A.  

Query the DATABASE_STORAGE_USAGE_HISTORY view in ACCOUNT_USAG

E.  

B.  

Query the TABLE_STORAGE_METRICS view in the INFORMATION_SCHEM

A.  

C.  

Query the STORAGE_USAGE view in ACCOUNT_USAG

E.  

D.  

Use the DATABASE_STORAGE_USAGE_HISTORY table function.

A.  

File URL

B.  

Staged URL

C.  

Scoped URL

D.  

Pre-signed URL

A.  

Scale-up the warehouse.

B.  

Scale-out the warehouse.

C.  

Run the warehouse in Auto-scale mode.

D.  

Run the warehouse in Maximized mode.

E.  

Run the warehouse using an Economy policy.

A.  

External

B.  

Permanent

C.  

Temporary

D.  

Transient

A.  

To process and move data from multiple sources into Snowflake in real time

B.  

To provide a mechanism to deliver live or recorded media content to global cross-cloud users in real time

C.  

To record changes made to table data and metadata, so that the changed data can be processed

D.  

To process high volumes of data in a continuous, incremental manner using low-latency processing

A.  

Use secondary roles and primary roles.

B.  

Grant the user the ACCOUNTADMIN role.

C.  

Grant the user the parent role of the roles that have been assigned.

D.  

Create a new role and grant it to the user, then grant the existing roles to the new role.

A.  

Pipes

B.  

Tasks

C.  

Streams

D.  

Sequences

A.  

Anyone who has the URL can access the referenced file for the life of the token.

B.  

Only the user who generates the URL can use the URL to access the referenced file.

C.  

Only the users who have roles with sufficient privileges on the URL can access the referenced file.

D.  

The role specified in the GET REST API call must have sufficient privileges on the stage to access the referenced file using the URL.

A.  

ACCESS_HOSTORY

B.  

LOGIN_HISTORY

C.  

SESSIONS

D.  

QUERY HISTORY

A.  

ACCOUNTADMIN

B.  

SECURITYADMIN

C.  

SYSADMIN

D.  

USERADMIN

A.  

Auto-scale mode

B.  

Maximized mode

C.  

Standard scaling policy

D.  

Economy scaling policy

A.  

Snowflake Horizon Catalog

B.  

SnowSQL

C.  

ODBC driver

D.  

SnowCD

A.  

By generating a real-time index for all data in a database

B.  

By creating an up-to-date catalog of all of the tables in a database

C.  

By listing all of the queries that have been executed on the table data

D.  

By identifying where column-level values are located in each micro-partition

A.  

Create information_schema in a database

B.  

View usage information for all accounts in the organization.

C.  

Enable database cloning for an account in the organization.

D.  

Enable database replication for an account in the organization.

E.  

View micro-partition information for all accounts in the organization.

A.  

Keys should be stored in a secure location on the ACCOUNTADMIN file system.

B.  

Operator access should be limited to read-only access.

C.  

Key pair rotation should be automated.

D.  

Role access should be designed to cover the operations that the user account anticipates needing.

A.  

An economy scaling policy

B.  

A standard scaling policy

C.  

Maximized mode

D.  

Auto-scale mode

A.  

FLATTEN

B.  

OBJECT_KEYS

C.  

PARSE_JSON

D.  

ARRAYS_TO_OBJECT