Valentine Day Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 2493360325

Good News !!! COF-R02 SnowPro Core Recertification Exam is now Stable and With Pass Result

COF-R02 Practice Exam Questions and Answers

SnowPro Core Recertification Exam

Last Update 4 weeks ago
Total Questions : 330

COF-R02 is stable now with all latest exam questions are added 4 weeks ago. Just download our Full package and start your journey with Snowflake SnowPro Core Recertification Exam certification. All these Snowflake COF-R02 practice exam questions are real and verified by our Experts in the related industry fields.

COF-R02 PDF

COF-R02 PDF (Printable)
$48
$119.99

COF-R02 Testing Engine

COF-R02 PDF (Printable)
$56
$139.99

COF-R02 PDF + Testing Engine

COF-R02 PDF (Printable)
$70.8
$176.99
Question # 1

What is the minimum Snowflake edition required to create a materialized view?

Options:

A.  

Standard Edition

B.  

Enterprise Edition

C.  

Business Critical Edition

D.  

Virtual Private Snowflake Edition

Discussion 0
Question # 2

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

Options:

A.  

True

B.  

False

Discussion 0
Question # 3

What is the MOST performant file format for loading data in Snowflake?

Options:

A.  

CSV (Unzipped)

B.  

Parquet

C.  

CSV (Gzipped)

D.  

ORC

Discussion 0
Question # 4

What is the recommended file sizing for data loading using Snowpipe?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 5

Which of the following objects can be shared through secure data sharing?

Options:

A.  

Masking policy

B.  

Stored procedure

C.  

Task

D.  

External table

Discussion 0
Question # 6

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

Options:

A.  

True

B.  

False

Discussion 0
Question # 7

Which command can be used to load data files into a Snowflake stage?

Options:

A.  

JOIN

B.  

COPY INTO

C.  

PUT

D.  

GET

Discussion 0
Question # 8

Which formats does Snowflake store unstructured data in? (Choose two.)

Options:

A.  

GeoJSON

B.  

Array

C.  

XML

D.  

Object

E.  

BLOB

Discussion 0
Question # 9

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Options:

A.  

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B.  

An error will occur, as views with qualified references cannot be cloned.

C.  

An error will occur, as stored objects cannot be cloned.

D.  

The stored procedures and views will refer to tables in the source database.

Discussion 0
Question # 10

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Options:

A.  

Configure the warehouse to a size larger than generally required

B.  

Set the minimum and maximum clusters to autoscale

C.  

Use the standard warehouse scaling policy

D.  

Use the economy warehouse scaling policy

Discussion 0
Question # 11

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

Options:

A.  

Use auto-ingest Snowpipes to load large files in a serverless model.

B.  

Produce the largest files possible, reducing the overall number of files to process.

C.  

Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

D.  

Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Discussion 0
Question # 12

Which of the following statements describe features of Snowflake data caching? (Choose two.)

Options:

A.  

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

B.  

When the data cache is full, the least-recently used data will be cleared to make room.

C.  

A user can only access their own queries from the query result cache.

D.  

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

E.  

The RESULT_SCAN table function can access and filter the contents of the query result cache.

Discussion 0
Question # 13

What is the maximum Time Travel retention period for a temporary Snowflake table?

Options:

A.  

90 days

B.  

1 day

C.  

7 days

D.  

45 days

Discussion 0
Question # 14

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Options:

A.  

Files

B.  

External tables

C.  

Secure User-Defined Functions (UDFs)

D.  

Sequences

E.  

Streams

Discussion 0
Question # 15

Which of the following significantly improves the performance of selective point lookup queries on a table?

Options:

A.  

Clustering

B.  

Materialized Views

C.  

Zero-copy Cloning

D.  

Search Optimization Service

Discussion 0
Question # 16

A user has unloaded data from a Snowflake table to an external stage.

Which command can be used to verify if data has been uploaded to the external stage named my_stage?

Options:

A.  

view @my_stage

B.  

list @my_stage

C.  

show @my_stage

D.  

display @my_stage

Discussion 0
Question # 17

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

Options:

A.  

No virtual warehouse will be used, data will be read from the result cache.

B.  

No virtual warehouse will be used, data will be read from the local disk cache.

C.  

The default virtual warehouse will be used to read all data.

D.  

The virtual warehouse that is defined at the session level will be used to read all data.

Discussion 0
Question # 18

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Options:

A.  

The columns that are queried in the select clause.

B.  

The columns with very high cardinality.

C.  

The columns with many different values.

D.  

The columns most actively used in the select filters.

Discussion 0
Question # 19

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Options:

A.  

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B.  

Allows a user to import the files in a sequential order

C.  

Increases the latency staging and accuracy when loading the data

D.  

Allows optimization of parallel operations

Discussion 0
Question # 20

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Options:

A.  

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

B.  

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

C.  

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

D.  

Data is available without copying or moving.

E.  

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

Discussion 0
Question # 21

Which file formats are supported for unloading data from Snowflake? (Choose two.)

Options:

A.  

Avro

B.  

JSON

C.  

ORC

D.  

XML

E.  

Delimited (CSV, TSV, etc.)

Discussion 0
Question # 22

True or False: During data unloading, only JSON and CSV files can be compressed.

Options:

A.  

True

B.  

False

Discussion 0
Question # 23

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

Options:

A.  

True

B.  

False

Discussion 0
Question # 24

Select the different types of Internal Stages: (Choose three.)

Options:

A.  

Named Stage

B.  

User Stage

C.  

Table Stage

D.  

Schema Stage

Discussion 0
Question # 25

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 26

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

Options:

A.  

True

B.  

False

Discussion 0
Question # 27

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

Options:

A.  

True

B.  

False

Discussion 0
Question # 28

What are the three layers that make up Snowflake’s architecture?

Choose 3 answer

Options:

A.  

Compute

B.  

Tri-Secret Secure

C.  

Storage

D.  

Cloud Services

Discussion 0
Question # 29

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Options:

A.  

4

B.  

16

C.  

32

D.  

128

Discussion 0
Question # 30

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Select one.

Options:

A.  

More micro-partitions

B.  

Better query scheduling

C.  

Double the numbers of servers In the compute duster

D.  

Higher storage costs

Discussion 0
Question # 31

Which of the following statements are true of Snowflake releases: (Choose two.)

Options:

A.  

They happen approximately weekly

B.  

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

C.  

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

version

D.  

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

Discussion 0
Question # 32

What are the three things customers want most from their enterprise data warehouse solution?

Choose 3 answers

Options:

A.  

On-premise availability

B.  

Simplicity

C.  

Open source based

D.  

Concurrency

E.  

Performance

Discussion 0
Question # 33

Snowflake is designed for which type of workloads? (Choose two.)

Options:

A.  

OLAP (Analytics) workloads

B.  

OLTP (Transactional) workloads

C.  

Concurrent workloads

D.  

On-premise workloads

Discussion 0
Question # 34

Which interfaces can be used to create and/or manage Virtual Warehouses?

Options:

A.  

The Snowflake Web Interface (UI)

B.  

SQL commands

C.  

Data integration tools

D.  

All of the above

Discussion 0
Question # 35

When can a Virtual Warehouse start running queries?

Options:

A.  

12am-5am

B.  

Only during administrator defined time slots

C.  

When its provisioning is complete

D.  

After replication

Discussion 0
Question # 36

True or False: Snowflake supports federated authentication in all editions.

Options:

A.  

True

B.  

False

Discussion 0
Question # 37

True or False: An active warehouse is required to run a COPY INTO statement.

Options:

A.  

True

B.  

False

Discussion 0
Question # 38

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Options:

A.  

To accommodate more queries

B.  

To accommodate more users

C.  

To accommodate fluctuations in workload

D.  

To accommodate a more complex workload

Discussion 0
Question # 39

User-level network policies can be created by which of the following roles? (Select TWO).

Options:

A.  

ROLEADMIN

B.  

ACCOUNTADMIN

C.  

SYSADMIN

D.  

SECURITYADMIN

E.  

USERADMIN

Discussion 0
Question # 40

Which command can be used to stage local files from which Snowflake interface?

Options:

A.  

SnowSQL

B.  

Snowflake classic web interface (Ul)

C.  

Snowsight

D.  

.NET driver

Discussion 0
Question # 41

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

Options:

A.  

The user has the appropriate privileges on the objects associated with the query

B.  

Micro-partitions have been reclustered since the query was last run

C.  

The new query is run using the same virtual warehouse as the previous query

D.  

The query includes a User Defined Function (UDF)

E.  

The query has been run within 24 hours of the previously-run query

Discussion 0
Question # 42

Which command is used to unload data from a Snowflake table into a file in a stage?

Options:

A.  

COPY INTO

B.  

GET

C.  

WRITE

D.  

EXTRACT INTO

Discussion 0
Question # 43

True or False: Loading data into Snowflake requires that source data files be no larger than 16M

B.  

Options:

A.  

True

B.  

False

Discussion 0
Question # 44

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Options:

A.  

Bytes scanned

B.  

Bytes sent over the network

C.  

Number of partitions scanned

D.  

Percentage scanned from cache

E.  

External bytes scanned

Discussion 0
Question # 45

A user has unloaded data from Snowflake to a stage

Which SQL command should be used to validate which data was loaded into the stage?

Options:

A.  

list @file__stage

B.  

show @file__stage

C.  

view @file__stage

D.  

verify @file__stage

Discussion 0
Question # 46

Which Snowflake partner specializes in data catalog solutions?

Options:

A.  

Alation

B.  

DataRobot

C.  

dbt

D.  

Tableau

Discussion 0
Question # 47

Which of the following can be executed/called with Snowpipe?

Options:

A.  

A User Defined Function (UDF)

B.  

A stored procedure

C.  

A single copy_into statement

D.  

A single insert__into statement

Discussion 0
Question # 48

A user needs to create a materialized view in the schema MYD

B.  

MYSCHEM

A.  

Which statements will provide this access?

Options:

A.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

MYSCHEMA TO ROLE MYROLE;

B.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

MYSCHEMA TO USER USER1;

C.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

MYSCHEMA TO USER1;

D.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

MYSCHEMA TO MYROLE;

Discussion 0
Question # 49

Which Snowflake technique can be used to improve the performance of a query?

Options:

A.  

Clustering

B.  

Indexing

C.  

Fragmenting

D.  

Using INDEX__HINTS

Discussion 0
Get COF-R02 dumps and pass your exam in 24 hours!

Free Exams Sample Questions