Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

COF-R02 SnowPro Core Recertification Exam Questions and Answers

Questions 4

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

Options:

A.

True

B.

False

Buy Now
Questions 5

True or False: Pipes can be suspended and resumed.

Options:

A.

True

B.

False

Buy Now
Questions 6

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

Buy Now
Questions 7

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Options:

A.

Number of users

B.

Warehouse size

C.

Amount of data processed

D.

# of clusters for the Warehouse

Buy Now
Questions 8

Which of the following objects is not covered by Time Travel?

Options:

A.

Tables

B.

Schemas

C.

Databases

D.

Stages

Buy Now
Questions 9

The number of queries that a Virtual Warehouse can concurrently process is determined by:

Choose 2 answers

Options:

A.

The complexity of each query

B.

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

C.

The size of the data required for each query

D.

The tool that s executing the query

Buy Now
Questions 10

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

Options:

A.

True

B.

False

Buy Now
Questions 11

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Options:

A.

True

B.

False

Buy Now
Questions 12

True or False: The COPY command must specify a File Format in order to execute.

Options:

A.

True

B.

False

Buy Now
Questions 13

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

Buy Now
Questions 14

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

Options:

A.

True

B.

False

Buy Now
Questions 15

How a Snowpipe charges calculated?

Options:

A.

Per-second/per Warehouse size

B.

Per-second/per-core granularity

C.

Number of Pipes in account

D.

Total storage bucket size

Buy Now
Questions 16

Which of the following roles is recommended to be used to create and manage users and roles?

Options:

A.

SYSADMIN

B.

SECURITYADMIN

C.

PUBLIC

D.

ACCOUNTADMIN

Buy Now
Questions 17

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?

(Choose all that apply.)

Options:

A.

JDBC

B.

SnowSQL

C.

Snowflake Web Interface (UI)

D.

ODBC

E.

Python

D18912E1457D5D1DDCBD40AB3BF70D5D

Buy Now
Questions 18

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Options:

A.

Tri-Secret Secure

B.

Time Travel

C.

Fail-safe

D.

Data encryption

E.

External stages

Buy Now
Questions 19

When loading data into Snowflake, how should the data be organized?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 20

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

Options:

A.

4 minutes

B.

10 minutes

C.

14 minutes

D.

24 minutes

Buy Now
Questions 21

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

Options:

A.

UPDATE TABLE FROM STREAM

B.

SELECT FROM STREAM

C.

INSERT INTO TABLE SELECT FROM STREAM

D.

ALTER TABLE AS SELECT FROM STREAM

E.

BEGIN COMMIT

Buy Now
Questions 22

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Options:

A.

SELECT SUM (ORDER_AMT) FROM SALES;

B.

SELECT AVG(ORDER_QTY) FROM SALES;

C.

SELECT MIN(ORDER_AMT) FROM SALES;

D.

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Buy Now
Questions 23

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Options:

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Buy Now
Questions 24

How can a user change which columns are referenced in a view?

Options:

A.

Modify the columns in the underlying table

B.

Use the ALTER VIEW command to update the view

C.

Recreate the view with the required changes

D.

Materialize the view to perform the changes

Buy Now
Questions 25

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Options:

A.

10-50 MB

B.

100-250 MB

C.

300-500 MB

D.

1000-1500 MB

Buy Now
Questions 26

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO

command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

Options:

A.

Compress the file and load the compressed file.

B.

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

C.

Use a larger-sized warehouse.

D.

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Buy Now
Questions 27

What happens when an external or an internal stage is dropped? (Select TWO).

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Buy Now
Questions 28

What data is stored in the Snowflake storage layer? (Select TWO).

Options:

A.

Snowflake parameters

B.

Micro-partitions

C.

Query history

D.

Persisted query results

E.

Standard and secure view results

Buy Now
Questions 29

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

Buy Now
Questions 30

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Options:

A.

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

B.

Partitions scanned is equal to partitions total

C.

An AggregateOperacor node is present

D.

The query is spilling to remote storage

Buy Now
Questions 31

Which feature is only available in the Enterprise or higher editions of Snowflake?

Options:

A.

Column-level security

B.

SOC 2 type II certification

C.

Multi-factor Authentication (MFA)

D.

Object-level access control

Buy Now
Questions 32

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Options:

A.

parse_json()

B.

json_extract_path_text()

C.

object_construct()

D.

flatten

Buy Now
Questions 33

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

COF-R02 Question 33

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

Options:

A.

select src:dealership from car_sales;

B.

select src.dealership from car_sales;

C.

select src:Dealership from car_sales;

D.

select dealership from car_sales;

Buy Now
Questions 34

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

Options:

A.

The validation_mode option is used when creating an Internal Stage

B.

validation_mode=return_all_errors is a parameter of the copy command

C.

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

D.

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

Buy Now
Questions 35

The PUT command: (Choose two.)

Options:

A.

Automatically creates a File Format object

B.

Automatically uses the last Stage created

C.

Automatically compresses files using Gzip

D.

Automatically encrypts files

Buy Now
Questions 36

What is cached during a query on a virtual warehouse?

Options:

A.

All columns in a micro-partition

B.

Any columns accessed during the query

C.

The columns in the result set of the query

D.

All rows accessed during the query

Buy Now
Questions 37

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Options:

A.

CREATE_SHARE on the account

B.

SHARE on databases and schemas

C.

SELECT on tables used by the secure view

D.

REFERENCE_USAGE on databases

Buy Now
Questions 38

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Buy Now
Questions 39

When unloading to a stage, which of the following is a recommended practice or approach?

Options:

A.

Set SINGLE: = true for larger files

B.

Use OBJECT_CONSTRUCT ( * ) when using Parquet

C.

Avoid the use of the CAST function

D.

Define an individual file format

Buy Now
Questions 40

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

Buy Now
Questions 41

What is a key feature of Snowflake architecture?

Options:

A.

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

B.

Software updates are automatically applied on a quarterly basis

C.

Snowflake eliminates resource contention with its virtual warehouse implementation

D.

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

E.

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

Buy Now
Questions 42

True or False: A Virtual Warehouse can be resized while suspended.

Options:

A.

True

B.

False

Buy Now
Questions 43

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

Options:

A.

CSV (Unzipped)

B.

Parquet

C.

CSV (Gzipped)

D.

ORC

Buy Now
Questions 44

What are the default Time Travel and Fail-safe retention periods for transient tables?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 45

Which stage type can be altered and dropped?

Options:

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Buy Now
Questions 46

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

Options:

A.

Yes, because a table owner has full control and can unset masking policies.

B.

Yes, because masking policies only apply to cloned tables.

C.

No, because masking policies must always reference specific access roles.

D.

No, because ownership of a table does not include the ability to change masking policies

Buy Now
Questions 47

What are ways to create and manage data shares in Snowflake? (Select TWO)

Options:

A.

Through the Snowflake web interface (Ul)

B.

Through the DATA_SHARE=TRUE parameter

C.

Through SQL commands

D.

Through the enable__share=true parameter

E.

Using the CREATE SHARE AS SELECT * TABLE command

Buy Now
Questions 48

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Options:

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Buy Now
Questions 49

What are value types that a VARIANT column can store? (Select TWO)

Options:

A.

STRUCT

B.

OBJECT

C.

BINARY

D.

ARRAY

E.

CLOB

Buy Now
Exam Code: COF-R02
Exam Name: SnowPro Core Recertification Exam
Last Update: Dec 11, 2024
Questions: 330

PDF + Testing Engine

$57.75  $164.99

Testing Engine

$43.75  $124.99
buy now COF-R02 testing engine

PDF (Q&A)

$36.75  $104.99
buy now COF-R02 pdf