COF-C03 Practice Questions

A.  

Temporary table

B.  

External table

C.  

Secure view

D.  

Materialized view

A.  

Last_QUERY_ID

B.  

CURRENT_STATEMENT

C.  

UUID_STRING

D.  

JOB_ID

A.  

Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.

B.  

Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

C.  

Snowflake issues an alert message and adds the duplicate IP address values lo both ' he allowed and blocked IP address lists.

D.  

Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list

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.  

Transient tables have a Fail-safe period of 7 days.

B.  

Transient tables can be cloned to permanent tables.

C.  

Transient tables persist until they are explicitly dropped.

D.  

Transient tables can be altered to make them permanent tables.

E.  

Transient tables have Time Travel retention periods of 0 or 1 day.

A.  

1

B.  

5

C.  

10

D.  

100

A.  

TABLES

B.  

TABLE_STORAGE_METRICS

C.  

STORAGE_DAILY_HISTORY

D.  

STORAGE USAGE

A.  

FLATTEN

B.  

CHECK_JSON

C.  

PARSE_JSON

D.  

TO_VARIANT

A.  

Account

B.  

Database

C.  

Schema

D.  

Table

A.  

To encrypt data that can be accessed with one of two keys

B.  

To allow multiple users to securely share data

C.  

To securely authenticate a user or an application

D.  

To enforce Multi-Factor Authentication, or MFA

A.  

User

B.  

Role

C.  

Account

D.  

Organization

A.  

Use the Snowflake Marketplace

B.  

Use a stream

C.  

Use a Data Exchange

D.  

Use a direct share

A.  

The isolation of data within a Snowflake account.

B.  

The use of Secure Data Sharing among Snowflake accounts.

C.  

A Virtual Private Network (VPN) between a user and Snowflake.

D.  

A secure, direct connection to Snowflake that does not use the internet.

A.  

A directory table is a separate database object.

B.  

Directory tables store data file metadata.

C.  

A directory table will be automatically added to a stage.

D.  

Directory tables do not have their own grantable privileges.

E.  

Directory table data can not be refreshed manually.

A.  

Scale up the virtual warehouse.

B.  

Scale out the virtual warehouse.

C.  

Enable standard warehouse scaling.

D.  

Enable economy warehouse scaling.

A.  

SnowCD

B.  

Snowpark

C.  

Snowsight

D.  

SnowSQL

A.  

External tables

B.  

Materialized views

C.  

Tables and views that are not protected by row access policies

D.  

Casts on table columns (except for fixed-point numbers cast to strings)

A.  

Snowpark uses a Spark engine to generate optimized SQL query plans.

B.  

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C.  

Snowpark does not require that a separate cluster be running outside of Snowflake.

D.  

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E.  

Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

A.  

COPY INTO

B.  

GET

C.  

PUT

D.  

TRANSFER

A.  

Cloud Services

B.  

Database Storage

C.  

Query Processing

D.  

Metadata Management