COF-R02 SnowPro Core Recertification Exam Questions and Answers

True

False

True

False

True

False

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

Tables

Schemas

Databases

Stages

The complexity of each query

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

The size of the data required for each query

The tool that s executing the query

True

False

True

False

True

False

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

True

False

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

D18912E1457D5D1DDCBD40AB3BF70D5D

Tri-Secret Secure

Time Travel

Fail-safe

Data encryption

External stages

Into single files with 100-250 MB of compressed data per file

Into single files with 1-100 MB of compressed data per file

Into files of maximum size of 1 GB of compressed data per file

Into files of maximum size of 4 GB of compressed data per file

4 minutes

10 minutes

14 minutes

24 minutes

UPDATE TABLE FROM STREAM

SELECT FROM STREAM

INSERT INTO TABLE SELECT FROM STREAM

ALTER TABLE AS SELECT FROM STREAM

BEGIN COMMIT

SELECT SUM (ORDER_AMT) FROM SALES;

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT MIN(ORDER_AMT) FROM SALES;

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Compute resources

Query execution

Authentication

Data storage

Metadata

Modify the columns in the underlying table

Use the ALTER VIEW command to update the view

Recreate the view with the required changes

Materialize the view to perform the changes

10-50 MB

100-250 MB

300-500 MB

1000-1500 MB

Compress the file and load the compressed file.

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

Use a larger-sized warehouse.

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

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

Snowflake parameters

Micro-partitions

Query history

Persisted query results

Standard and secure view results

COPY INTO

GET

WRITE

EXTRACT INTO

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

Column-level security

SOC 2 type II certification

Multi-factor Authentication (MFA)

Object-level access control

parse_json()

json_extract_path_text()

object_construct()

flatten

select src:dealership from car_sales;

select src.dealership from car_sales;

select src:Dealership from car_sales;

select dealership from car_sales;

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

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

All columns in a micro-partition

Any columns accessed during the query

The columns in the result set of the query

All rows accessed during the query

CREATE_SHARE on the account

SHARE on databases and schemas

SELECT on tables used by the secure view

REFERENCE_USAGE on databases

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Set SINGLE: = true for larger files

Use OBJECT_CONSTRUCT ( * ) when using Parquet

Avoid the use of the CAST function

Define an individual file format

ROLEADMIN

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

USERADMIN

Zero-copy cloning creates a mirror copy of a database that updates with the original

Software updates are automatically applied on a quarterly basis

Snowflake eliminates resource contention with its virtual warehouse implementation

Multi-cluster warehouses allow users to run a query that spans across multiple clusters

Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

True

False

CSV (Unzipped)

Parquet

CSV (Gzipped)

ORC

Time Travel - 1 day. Fail-safe - 1 day

Time Travel - 0 days. Fail-safe - 1 day

Time Travel - 1 day. Fail-safe - 0 days

Transient tables are retained in neither Fail-safe nor Time Travel

Database stage

External stage

Table stage

User stage

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

Through the Snowflake web interface (Ul)

Through the DATA_SHARE=TRUE parameter

Through SQL commands

Through the enable__share=true parameter

Using the CREATE SHARE AS SELECT * TABLE command

Pipe

External stage

Task

Stream

STRUCT

OBJECT

BINARY

ARRAY

CLOB