COF-R02 SnowPro Core Recertification Exam Questions and Answers

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

True

False

Privileges on the database

Existing child objects within the database

Future child objects within the database

Privileges on the schemas within the database

Only schemas and tables within the database

Configure the user to be initially disabled.

Force an immediate password change.

Set a default role for the user.

Set the number of minutes to unlock to 15 minutes.

Set the user's access to expire within a specified timeframe.

5 MB

8 GB

16 MB

32 MB

Schema stage

Named stage

User stage

Stream stage

Table stage

Database stage

SINGLE=TRUE

MULTIPLE=TRUE

MULTIPLE=FALSE

SINGLE=FALSE

The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

The Data Consumer pays only for compute resources to query the shared data.

Compute

Data storage

Cloud services

Cloud provider

True

False

Tables

Named File Formats

Schemas

Shares

Databases

Users

They happen approximately weekly

They roll up and release approximately monthly, but customers can request early release application

During a release, new customer requests/queries/connections transparently move over to the newer

version

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the

system will be unavailable and customer is upgraded

4

16

32

128

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

The global privilege create task is required to create a new task.

Tasks are created at the Application level and can only be created by the Account Admin role.

Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

The role must have access to the target schema and the create task privilege on the schema itself.

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

D18912E1457D5D1DDCBD40AB3BF70D5D

True

False

True

False

It was built specifically for the cloud

It was built as an on-premises solution and then ported to the cloud

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

It was built for Hadoop architecture

It's based on an Oracle Architecture

Custom

Economy

Optimized

Standard

True

False

True

False

Create a task that runs a copy into operation from an external stage every 5 minutes

Create a task that puts the files in an internal stage and automate the data loading wizard

Create a task that runs a GET operation to intermittently check for new files

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Queries against large tables where frequent DML occurs

Queries against tables larger than 1 TB

Selective point lookup queries

Queries against a subset of columns in a table

True

False

Custom Edition

Virtual Private Snowflake

Business Critical Edition

Standard Edition

Enterprise Edition

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

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

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

Data is available without copying or moving.

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

10-50 MB

100-250 MB

300-500 MB

1000-1500 MB

Data expires from Time Travel

Data expires from Fail-safe

Data is deleted from a table

Data is truncated from a table

The filtering or disregarding of micro-partitions that are not needed to return a query.

The return of micro-partitions values that overlap with each other to reduce a query's runtime.

A service that is handled by the Snowflake Cloud Services layer to optimize caching.

The ability to allow the result of a query to be accessed as if it were a table.

The user who created the object

The SYSADMIN role

Ownership depends on the type of object

The role used to create the object

ACCOUNTADMIN

ORGADMIN

SECURITYADMIN

SYSADMIN

CSV

JSON

Parquet

XML

The primary cluster in the virtual warehouse

The entire virtual warehouse

The database in which the virtual warehouse resides

The Queries currently being run on the virtual warehouse

The table contains a column that has very low cardinality

DML statements that are being issued against the table are blocked

The table has a small number of micro-partitions

Queries on the table are running slower than expected

The clustering depth for the table is large

Clustering

Indexing

Fragmenting

Using INDEX__HINTS

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FAISE

ROLEADMIN

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

USERADMIN

30 Days

60 Days

90 Days

365 Days

CREATE SHARE

ALTER WAREHOUSE

DROP ROLE

SHOW SCHEMAS

DESCRBE TABLE

UTF-8

UTF-16

ISO S859-1

ANSI_X3.A

As configured in the create pipe settings

Until the pipe is dropped

64 days

14 days

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

To call code that executes outside of Snowflake

To run a function in another Snowflake database

To share data in Snowflake with external parties

To ingest data from on-premises data sources

list @mytable;

list @%raytable;

list @ %m.ystage;

list @mystage;