COF-C02 Practice Questions

A.  

True

B.  

False

A.  

Data is live, ready-to-query, and can be personalized.

B.  

Data needs to be loaded into a cloud provider as a consumer account.

C.  

Data is not available for copying or moving to an individual Snowflake account.

D.  

Data is available without copying or moving.

E.  

Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

A.  

4

B.  

8

C.  

16

D.  

32

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake (VPC)

A.  

Snowflake leverages a Role-Based Access Control (RBAC) model.

B.  

Snowflake requires a user to configure an IAM user to connect to the database.

C.  

All data in Snowflake is encrypted.

D.  

Snowflake can run within a user's own Virtual Private Cloud (VPC).

E.  

All data in Snowflake is compressed.

A.  

Fail-safe makes data available up to 1 day, recoverable by user operations.

B.  

Fail-safe makes data available for 7 days, recoverable by user operations.

C.  

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

D.  

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

A.  

Java

B.  

Javascript

C.  

Scala

D.  

Python

E.  

SQL

A.  

INTERSECT

B.  

MFRCK

C.  

MINUS

D.  

UNION

A.  

Resource monitor

B.  

Account_usage. query_history

C.  

Information_schema.warehouse_load_history

D.  

Information schema.warehouse metering history

A.  

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B.  

Use the ENCODING file format option to change the encoding from the default UTF-8.

C.  

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

D.  

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E.  

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

A.  

The data from the permanent table.

B.  

The data from the temporary table.

C.  

An error stating that the view could not be compiled.

D.  

An error stating that the referenced object could not be uniquely identified.

A.  

Create a view.

B.  

Cluster a table.

C.  

Enable the search optimization service.

D.  

Enable Time Travel.

E.  

Index a table.

A.  

The reader account will automatically use the Standard edition of Snowflake.

B.  

The reader account compute will be billed to the provider account.

C.  

The reader account can clone data the provider has shared, but cannot re-share it.

D.  

The reader account can create a copy of the shared data using CREATE TABLE AS...

A.  

File

B.  

Pre-signed

C.  

Scoped

D.  

Virtual-hosted style

A.  

Within the data files

B.  

In the virtual warehouse layer

C.  

In the cloud services layer

D.  

In the remote storage layer

A.  

Table definition

B.  

Stage definition

C.  

Session level

D.  

COPY INTO TABLE statement

A.  

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

B.  

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

C.  

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

D.  

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

A.  

Scale up the virtual warehouse.

B.  

Scale out the virtual warehouse.

C.  

Enable standard warehouse scaling.

D.  

Enable economy warehouse scaling.

A.  

Enable the query acceleration service.

B.  

Enable the search optimization service.

C.  

Add additional clusters to the virtual warehouse

D.  

Resize the virtual warehouse to a larger instance size.

A.  

history

B.  

config

C.  

snowsqLcnf

D.  

snowsql.pubkey