Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

COF-R02 SnowPro Core Recertification Exam Questions and Answers

Questions 4

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

Options:

A.

True

B.

False

Buy Now
Questions 5

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Options:

A.

True

B.

False

Buy Now
Questions 6

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

Options:

A.

Masking policy

B.

Stored procedure

C.

Task

D.

External table

Buy Now
Questions 7

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
Questions 8

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Options:

A.

An FTP server with TLS encryption

B.

An HTTPS server with WebDAV

C.

A Google Cloud storage bucket

D.

A Windows server file share on Azure

Buy Now
Questions 9

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Options:

A.

Okta Verify

B.

Duo Mobile

C.

Microsoft Authenticator

D.

Google Authenticator

Buy Now
Questions 10

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

Options:

A.

SCIM

B.

Federated authentication

C.

TLS 1.2

D.

Key-pair authentication

E.

OAuth

F.

OCSP authentication

Buy Now
Questions 11

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 12

What is a best practice after creating a custom role?

Options:

A.

Create the custom role using the SYSADMIN role.

B.

Assign the custom role to the SYSADMIN role

C.

Assign the custom role to the PUBLIC role

D.

Add__CUSTOM to all custom role names

Buy Now
Questions 13

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 14

Network policies can be set at which Snowflake levels? (Choose two.)

Options:

A.

Role

B.

Schema

C.

User

D.

Database

E.

Account

F.

Tables

Buy Now
Questions 15

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Options:

A.

Compute Credits = 50 Credits Cloud Services = 10

B.

Compute Credits = 80 Credits Cloud Services = 5

C.

Compute Credits = 10 Credits Cloud Services = 9

D.

Compute Credits = 120 Credits Cloud Services = 10

E.

Compute Credits = 200 Credits Cloud Services = 26

Buy Now
Questions 16

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Options:

A.

Data is hashed by the cluster key to facilitate fast searches for common data values

B.

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.

Smaller micro-partitions are created for common data values to allow for more parallelism

D.

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Buy Now
Questions 17

What is the purpose of an External Function?

Options:

A.

To call code that executes outside of Snowflake

B.

To run a function in another Snowflake database

C.

To share data in Snowflake with external parties

D.

To ingest data from on-premises data sources

Buy Now
Questions 18

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 19

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

Options:

A.

Row level access policies

B.

Data masking policies

C.

Data encryption

D.

Time Travel

E.

External tokenization

Buy Now
Questions 20

How would a user run a multi-cluster warehouse in maximized mode?

Options:

A.

Configure the maximum clusters setting to "Maximum."

B.

Turn on the additional clusters manually after starting the warehouse.

C.

Set the minimum Clusters and maximum Clusters settings to the same value.

D.

Set the minimum clusters and maximum clusters settings to different values.

Buy Now
Questions 21

True or False: Snowpipe via REST API can only reference External Stages as source.

Options:

A.

True

B.

False

Buy Now
Questions 22

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Options:

A.

Custom Edition

B.

Virtual Private Snowflake

C.

Business Critical Edition

D.

Standard Edition

E.

Enterprise Edition

Buy Now
Questions 23

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.)

Buy Now
Questions 24

Where can a user find and review the failed logins of a specific user for the past 30 days?

Options:

A.

The USERS view in ACCOUNT_USAGE

B.

The LOGIN_HISTORY view in ACCOUNT_USAGE

C.

The ACCESS_HISTORY view in ACCOUNT_USAGE

D.

The SESSIONS view in ACCOUNT_USAGE

Buy Now
Questions 25

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Options:

A.

External Tokenization

B.

External Tables

C.

Materialized Views

D.

User-Defined Table Functions (UDTF)

Buy Now
Questions 26

Using variables in Snowflake is denoted by using which SQL character?

Options:

A.

@

B.

&

C.

$

D.

#

Buy Now
Questions 27

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Options:

A.

Reader

B.

Consumer

C.

Vendor

D.

Standard

E.

Personalized

Buy Now
Questions 28

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Options:

A.

The explain plan output is available graphically.

B.

An explain plan can be used to conduct performance analysis without executing a query.

C.

An explain plan will handle queries with temporary tables and the query profiler will not.

D.

An explain plan's output will display automatic data skew optimization information.

Buy Now
Questions 29

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

Options:

A.

Whether or not it is also a secure view

B.

How often the underlying base table is queried

C.

How often the base table changes

D.

Whether the materialized view has a cluster key defined

E.

How often the materialized view is queried

Buy Now
Questions 30

What is the minimum Snowflake edition required for row level security?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Buy Now
Questions 31

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

Options:

A.

VIEWS_HISTORY

B.

OBJECT_HISTORY

C.

ACCESS_HISTORY

D.

LOGIN_HISTORY

Buy Now
Questions 32

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

Options:

A.

Row access policies

B.

Data masking policies

C.

Data encryption

D.

Role based access control

Buy Now
Questions 33

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Options:

A.

Business Critical Edition

B.

Standard Edition

C.

Virtual Private Snowflake (VPS)

D.

Enterprise Edition

Buy Now
Questions 34

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Options:

A.

CONTENT

B.

PATH

C.

BYTE_SIZE

D.

INDEX

E.

DATATYPE

Buy Now
Questions 35

Which of the following are options when creating a Virtual Warehouse?

Options:

A.

Auto-suspend

B.

Auto-resume

C.

Local SSD size

D.

User count

Buy Now
Questions 36

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

Options:

A.

True

B.

False

Buy Now
Questions 37

True or False: A single database can exist in more than one Snowflake account.

Options:

A.

True

B.

False

Buy Now
Questions 38

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

Buy Now
Questions 39

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

Options:

A.

True

B.

False

Questions 40

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

Options:

A.

True

B.

False

Buy Now
Questions 41

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

Options:

A.

True

B.

False

Buy Now
Questions 42

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?

(Choose all that apply.)

Options:

A.

Growth of storage and compute are tightly coupled together

B.

Storage expands without the requirement to add more compute

C.

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

D.

Multiple compute clusters can access stored data without contention

Buy Now
Questions 43

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 44

Which of the following terms best describes Snowflake’s database architecture?

Options:

A.

Columnar shared nothing

B.

Shared disk

C.

Multi-cluster, shared data

D.

Cloud-native shared memory

Buy Now
Questions 45

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 46

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Options:

A.

Configure the Maximum Clusters setting to “Auto-Scale”

B.

Set the Warehouse type to “Auto”

C.

Set the Minimum Clusters and Maximum Clusters settings to the same value

D.

Set the Minimum Clusters and Maximum Clusters settings to the different values

Buy Now
Questions 47

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Options:

A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

Buy Now
Questions 48

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

Buy Now
Questions 49

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

Options:

A.

The Pipe load history is reset to empty

B.

The REFRESH parameter is set to TRUE

C.

Previously loaded files will be ignored

D.

All of the above

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

PDF + Testing Engine

$134.99

Testing Engine

$99.99

PDF (Q&A)

$84.99