Winter Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dumps65

DumpsWrap Logo

Snowflake COF-R02 Dumps

Page: 1 / 33
Total 330 questions
Get COF-R02 Full Access Download COF-R02 PDF

SnowPro Core Recertification Exam Questions and Answers

Question 1

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

Question 2

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

Question 3

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

Options:

A.

Tables

B.

Named File Formats

C.

Schemas

D.

Shares

E.

Databases

F.

Users

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

What privileges are required to create a task?

Options:

A.

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

B.

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

C.

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

D.

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

Question 9

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

Options:

A.

The tables are now orphaned

B.

The user that deleted the role

C.

SYSADMIN

D.

The assumed role that dropped the role

Question 10

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

Options:

A.

True

B.

False

Question 11

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

Question 12

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

Options:

A.

True

B.

False

Question 13

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

Options:

A.

True

B.

False

Question 14

Which of the following statements would be used to export/unload data from Snowflake?

Options:

A.

COPY INTO @stage

B.

EXPORT TO @stage

C.

INSERT INTO @stage

D.

EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Question 15

True or False: Pipes can be suspended and resumed.

Options:

A.

True

B.

False

Question 16

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

Question 17

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

Question 18

How often are encryption keys automatically rotated by Snowflake?

Options:

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days

Question 19

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

Question 20

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

Question 21

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Options:

A.

Customer-managed encryption keys through Tri-Secret Secure

B.

Automatic encryption of all data

C.

Up to 90 days of data recovery through Time Travel

D.

Object-level access control

E.

Column-level security to apply data masking policies to tables and views

Question 22

Which Snowflake partner specializes in data catalog solutions?

Options:

A.

Alation

B.

DataRobot

C.

dbt

D.

Tableau

Question 23

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

Question 24

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

Question 25

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse

According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Options:

A.

Use multi-clustered warehousing to scale out warehouse capacity.

B.

Scale up the warehouse size to allow Queries to execute faster.

C.

Stop and start the warehouse to clear the queued queries

D.

Migrate some queries to a new warehouse to reduce load

E.

Limit user access to the warehouse so fewer queries are run against it.

Question 26

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

Options:

A.

Clustering

B.

Indexing

C.

Fragmenting

D.

Using INDEX__HINTS

Question 27

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Options:

A.

Users

B.

Tables

C.

Databases

D.

Internal Stages

Question 28

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

Options:

A.

True

B.

False

Question 29

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Options:

A.

Load files that are approximately 25 MB or smaller.

B.

Remove all dates and timestamps.

C.

Load files that are approximately 100-250 MB (or larger)

D.

Avoid using embedded characters such as commas for numeric data types

E.

Remove semi-structured data types

Question 30

Which copy INTO command outputs the data into one file?

Options:

A.

SINGLE=TRUE

B.

MAX_FILE_NUMBER=1

C.

FILE_NUMBER=1

D.

MULTIPLE=FAISE

Question 31

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

Question 32

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Options:

A.

STATEMENT_TIMEOUT__IN__SECONDS

B.

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.

MAX_CONCURRENCY__LEVEL

D.

QUERY_TIMEOUT_IN_SECONDS

Question 33

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

Question 34

The fail-safe retention period is how many days?

Options:

A.

1 day

B.

7 days

C.

45 days

D.

90 days

Question 35

How long is the Fail-safe period for temporary and transient tables?

Options:

A.

There is no Fail-safe period for these tables.

B.

1 day

C.

7 days

D.

31 days

E.

90 days

Question 36

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

Options:

A.

Enterprise

B.

Business Critical

C.

Standard

D.

Virtual Private Snowflake

Question 37

Which statement describes how Snowflake supports reader accounts?

Options:

A.

A reader account can consume data from the provider account that created it and combine it with its own data.

B.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Question 38

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

Options:

A.

5 MB

B.

8 GB

C.

16 MB

D.

32 MB

Question 39

Which statement is true about running tasks in Snowflake?

Options:

A.

A task can be called using a CALL statement to run a set of predefined SQL commands.

B.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

C.

A task allows a user to execute a set of SQL commands on a predefined schedule.

D.

A task can be executed using a SELECT statement to run a predefined SQL command.

Question 40

A materialized view should be created when which of the following occurs? (Choose two.)

Options:

A.

There is minimal cost associated with running the query.

B.

The query consumes many compute resources every time it runs.

C.

The base table gets updated frequently.

D.

The query is highly optimized and does not consume many compute resources.

E.

The results of the query do not change often and are used frequently.

Question 41

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

Question 42

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

Options:

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days.

Question 43

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.

Question 44

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

Question 45

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Options:

A.

PUT

B.

GET

C.

COPY

D.

SELECT

Question 46

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

Options:

A.

Gathering the hourly credit usage for an account

B.

Compiling an account's average cloud services cost over the previous month

C.

Summarizing the throughput of Snowpipe costs for an account

D.

Calculating the funds left on an account's contract

Question 47

In the Snowflake access control model, which entity owns an object by default?

Options:

A.

The user who created the object

B.

The SYSADMIN role

C.

Ownership depends on the type of object

D.

The role used to create the object

Question 48

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

Question 49

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

Options:

A.

When the system has enough load for 2 minutes

B.

When the system has enough load for 6 minutes

C.

When the system has enough load for 8 minutes

D.

When the system has enough load for 10 minutes

Load More COF-R02 Questions
Page: 1 / 33
Total 330 questions
Get COF-R02 Full Access Download COF-R02 PDF