Labour Day Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-R02 - SnowPro Core Recertification Exam

COF-R02 Exam Dumps - SnowPro Core Recertification Exam

Question # 4

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

A.

True

B.

False

Full Access
Question # 5

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

A.

Via the Snowflake Web Interface (Ul)

B.

Via the data_share=true parameter

C.

Via SQL commands

D.

Via Virtual Warehouses

Full Access
Question # 6

Which stage type can be altered and dropped?

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Full Access
Question # 7

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

A.

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

B.

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

C.

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D.

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Full Access
Question # 8

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

A.

Execute a COPY command

B.

Updating data

C.

Snowpipe

D.

AUTOMATIC__CLUSTERING

E.

Scaling up a warehouse

Full Access
Question # 9

Which command can be used to load data into an internal stage?

A.

LOAD

B.

copy

C.

GET

D.

PUT

Full Access
Question # 10

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A.

The ability to scale up warehouses

B.

The use of warehouse auto scaling

C.

The ability to resize warehouses

D.

Use of multi-clustered warehouses

E.

The use of warehouse indexing

Full Access
Question # 11

Which of the following are benefits of micro-partitioning? (Select TWO)

A.

Micro-partitions cannot overlap in their range of values

B.

Micro-partitions are immutable objects that support the use of Time Travel.

C.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

D.

Rows are automatically stored in sorted order within micro-partitions

E.

Micro-partitions can be defined on a schema-by-schema basis

Full Access
Question # 12

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

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

Full Access
Question # 13

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

A.

True

B.

False

Full Access
Question # 14

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

A.

OLAP (Analytics) workloads

B.

OLTP (Transactional) workloads

C.

Concurrent workloads

D.

On-premise workloads

Full Access
Question # 15

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

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

Full Access
Question # 16

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

A.

Named Stage

B.

User Stage

C.

Table Stage

D.

Schema Stage

Full Access
Question # 17

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A.

Custom

B.

Economy

C.

Optimized

D.

Standard

Full Access
Question # 18

Which of the following DML commands isn’t supported by Snowflake?

A.

UPSERT

B.

MERGE

C.

UPDATE

D.

TRUNCATE TABLE

Full Access
Question # 19

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

A.

The Snowflake Web Interface (UI)

B.

SQL commands

C.

Data integration tools

D.

All of the above

Full Access
Question # 20

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

A.

A Schema may contain one or more Databases

B.

A Database may contain one or more Schemas

C.

A Schema is a logical grouping of Database Objects

D.

Each Schema is contained within a Warehouse

Full Access
Question # 21

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

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

Full Access
Question # 22

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

A.

Concurrency

B.

Performance

Full Access
Question # 23

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

A.

True

B.

False

Full Access
Question # 24

Which of the following objects can be cloned? (Choose four.)

A.

Tables

B.

Named File Formats

C.

Schemas

D.

Shares

E.

Databases

F.

Users

Full Access
Question # 25

How a Snowpipe charges calculated?

A.

Per-second/per Warehouse size

B.

Per-second/per-core granularity

C.

Number of Pipes in account

D.

Total storage bucket size

Full Access
Question # 26

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

A.

CSV (Unzipped)

B.

Parquet

C.

CSV (Gzipped)

D.

ORC

Full Access
Question # 27

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

A.

The tables are now orphaned

B.

The user that deleted the role

C.

SYSADMIN

D.

The assumed role that dropped the role

Full Access
Question # 28

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

A.

True

B.

False

Full Access
Question # 29

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.

A.

True

B.

False

Full Access
Question # 30

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

A.

Authentication

B.

Resource management

C.

Virtual warehouse caching

D.

Query parsing and optimization

E.

Query execution

F.

Physical storage of micro-partitions

Full Access
Question # 31

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

A.

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

B.

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

C.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

D.

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Full Access
Question # 32

Which data type can store more than one type of data structure?

A.

JSON

B.

BINARY

C.

VARCHAR

D.

VARIANT

Full Access
Question # 33

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A.

Roles

B.

Databases

C.

Warehouses

D.

Users

E.

Accounts

Full Access
Question # 34

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

A.

Configure the user to be initially disabled.

B.

Force an immediate password change.

C.

Set a default role for the user.

D.

Set the number of minutes to unlock to 15 minutes.

E.

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

Full Access
Question # 35

What is the default file size when unloading data from Snowflake using the COPY command?

A.

5 MB

B.

8 GB

C.

16 MB

D.

32 MB

Full Access
Question # 36

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?

A.

4 minutes

B.

10 minutes

C.

14 minutes

D.

24 minutes

Full Access
Question # 37

How often are the Account and Table master keys automatically rotated by Snowflake?

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days.

Full Access
Question # 38

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

A.

Use the DROP command after the load completes.

B.

Specify the TEMPORARY option when creating the file format.

C.

Specify the PURGE copy option in the COPY INTO

command.

D.

Use the REMOVE command after the load completes.

E.

Use the DELETE LOAD HISTORY command after the load completes.

Full Access
Question # 39

Which Snowflake architectural layer is responsible for a query execution plan?

A.

Compute

B.

Data storage

C.

Cloud services

D.

Cloud provider

Full Access
Question # 40

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?

A.

Row access policies

B.

Data masking policies

C.

Data encryption

D.

Role based access control

Full Access
Question # 41

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

A.

Custom Edition

B.

Virtual Private Snowflake

C.

Business Critical Edition

D.

Standard Edition

E.

Enterprise Edition

Full Access
Question # 42

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

A.

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

B.

The transient table version cannot be retrieved after 24 hours.

C.

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

D.

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Full Access
Question # 43

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

A.

Schema

B.

View

C.

Internal stage

D.

Table

E.

User

F.

Role

Full Access
Question # 44

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

A.

In the metadata of the target table for 14 days

B.

In the metadata of the pipe for 14 days

C.

In the metadata of the target table for 64 days

D.

In the metadata of the pipe for 64 days

Full Access
Question # 45

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

A.

True

B.

False

Full Access
Question # 46

Which of the following describes how clustering keys work in Snowflake?

A.

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

B.

Clustering keys sort the designated columns over time, without blocking DML operations

C.

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

D.

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Full Access
Question # 47

What is a key feature of Snowflake architecture?

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

Full Access
Question # 48

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

A.

ROLEADMIN

B.

ACCOUNTADMIN

C.

SYSADMIN

D.

SECURITYADMIN

E.

USERADMIN

Full Access
Question # 49

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

A.

Internal stages

B.

Incremental backups

C.

Time Travel

D.

Zero-copy clones

E.

Fail-safe

Full Access

Hot Exams

ADM-201 Dumps
Sales-Cloud-Consultant Dumps
PCNSE Dumps
Service-Cloud-Consultant Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
Associate-Cloud-Engineer Dumps
350-701 Dumps
AZ-104 Dumps
CKA Dumps
SY0-601 Dumps
NCSE-Core Dumps