COF-R02 Exam Dumps - SnowPro Core Recertification Exam

LOAD

copy

GET

PUT

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

Micro-partitions cannot overlap in their range of values

Micro-partitions are immutable objects that support the use of Time Travel.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

Rows are automatically stored in sorted order within micro-partitions

Micro-partitions can be defined on a schema-by-schema basis

When dropping an external stage, the files are not removed and only the stage is dropped

When dropping an external stage, both the stage and the files within the stage are removed

When dropping an internal stage, the files are deleted with the stage and the files are recoverable

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

True

False

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

The validation_mode option is used when creating an Internal Stage

validation_mode=return_all_errors is a parameter of the copy command

The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Named Stage

User Stage

Table Stage

Schema Stage