COF-R02 SnowPro Core Recertification Exam Questions and Answers

To create separate data warehouses to increase query optimization

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

To eliminate or reduce Queuing of concurrent queries

To allow the warehouse to resize automatically

1

2

3

4

True

False

Compute

Tri-Secret Secure

Storage

Cloud Services

Shared-disk

Shared-nothing

Multi-cluster shared data

Serverless query engine

Standard

Enterprise

Business Critical

Virtual Private Snowflake (VPC)

Organize files into logical paths

Store the files on the external stage to ensure caching is maintained

Use pattern matching for regular expression execution

Load the data in one large file

The Pipe load history is reset to empty.

The REFRESH command is executed.

The stage will be purged.

The destination table is truncated.

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.

Avro

JSON

ORC

XML

Delimited (CSV, TSV, etc.)

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

USERADMIN

PUBLIC

ORGADMIN

SYSADMIN

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

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

A User Defined Function (UDF)

A stored procedure

A single copy_into statement

A single insert__into statement

A multi-cluster Warehouse can add clusters automatically based on query activity

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

A multi-cluster Warehouse can scale down when query activity slows

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

12am-5am

Only during administrator defined time slots

When its provisioning is complete

After replication

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

account__usage . query history view

account__usage.query__history__archive View

information__schema . cruery_history view

information__schema - query history_by_ses s i on view

list @file__stage

show @file__stage

view @file__stage

verify @file__stage

Querying data-related objects that were created within the past 365 days

Restoring data-related objects that have been deleted within the past 90 days

Conducting point-in-time analysis for Bl reporting

Analyzing data usage/manipulation over all periods of time

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

UTF-8

UTF-16

ISO S859-1

ANSI_X3.A

STRUCT

OBJECT

BINARY

ARRAY

CLOB

Compute Credits = 50 Credits Cloud Services = 10

Compute Credits = 80 Credits Cloud Services = 5

Compute Credits = 10 Credits Cloud Services = 9

Compute Credits = 120 Credits Cloud Services = 10

Compute Credits = 200 Credits Cloud Services = 26

Query against the result set cache

Query against a virtual warehouse cache

Query against the most-recently created micro-partition

Query against the metadata excite

True

False

Okta Verify

Duo Mobile

Microsoft Authenticator

Google Authenticator

1 day

7 days

45 days

90 days

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

More micro-partitions

Better query scheduling

Double the numbers of servers In the compute duster

Higher storage costs

True

False

Each Snowflake account can be hosted in a different cloud vendor and region.

Each Snowflake account must be hosted in a different cloud vendor and region

All Snowflake accounts must be hosted in the same cloud vendor and region

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Clustering

Indexing

Fragmenting

Using INDEX__HINTS

Within the policy DDL

Within the create table or create view DDL

By future APPLY for all objects in a schema

Within a control table

Using the command ALTER