Free Snowflake COF-R02 Practice Exam with Questions & Answers

CSV

JSON

Parquet

XML

Execute a COPY command

Updating data

Snowpipe

AUTOMATIC__CLUSTERING

Scaling up a warehouse

The ability to scale up warehouses

The use of warehouse auto scaling

The ability to resize warehouses

Use of multi-clustered warehouses

The use of warehouse indexing

Data can be filtered by an optional where clause

Incoming data can be joined with other tables

Columns can be reordered

Columns can be omitted

Row level access can be defined

Yes, because a table owner has full control and can unset masking policies.

Yes, because masking policies only apply to cloned tables.

No, because masking policies must always reference specific access roles.

No, because ownership of a table does not include the ability to change masking policies

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

Users who are trying to use the warehouse will receive an error message until the resizing is complete

True

False

Pipes

Streams

Tasks

Procedures

A compressed file size greater than 100 MB, and up to 250 MB

A compressed file size greater than 100 GB, and up to 250 GB

A compressed file size greater than 10 MB, and up to 100 MB

A compressed file size greater than 1 GB, and up to 2 GB

Variant

Object

Geometry

Geography