New Year Special Sale - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: spcl70

Practice Free COF-R02 SnowPro Core Recertification Exam Exam Questions Answers With Explanation

We at Crack4sure are committed to giving students who are preparing for the Snowflake COF-R02 Exam the most current and reliable questions . To help people study, we've made some of our SnowPro Core Recertification Exam exam materials available for free to everyone. You can take the Free COF-R02 Practice Test as many times as you want. The answers to the practice questions are given, and each answer is explained.

Get Full 330 Questions Search Other Snowflake Exam
Question # 6

How many resource monitors can be assigned at the account level?

A.

1

B.

2

C.

3

D.

4

Question # 7

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

Question # 8

How can a row access policy be applied to a table or a view? (Choose two.)

A.

Within the policy DDL

B.

Within the create table or create view DDL

C.

By future APPLY for all objects in a schema

D.

Within a control table

E.

Using the command ALTER ADD ROW ACCESS POLICY ;

Question # 9

True or False: Pipes can be suspended and resumed.

A.

True

B.

False

Question # 10

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

A.

Number of users

B.

Warehouse size

C.

Amount of data processed

D.

# of clusters for the Warehouse

Question # 11

What is a best practice after creating a custom role?

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

Question # 12

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?

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

Question # 13

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

A.

Tables

B.

Schemas

C.

Databases

D.

Stages

Question # 14

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

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.

Question # 15

How long is Snowpipe data load history retained?

A.

As configured in the create pipe settings

B.

Until the pipe is dropped

C.

64 days

D.

14 days

Question # 16

The fail-safe retention period is how many days?

A.

1 day

B.

7 days

C.

45 days

D.

90 days

Question # 17

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

A.

Roles

B.

Databases

C.

Warehouses

D.

Users

E.

Accounts

Question # 18

True or False: It is possible to load data into Snowflake without creating a named File Format object.

A.

True

B.

False

Question # 19

Which data type can be used to store geospatial data in Snowflake?

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Question # 20

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

A.

True

B.

False

Question # 21

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

A.

Users

B.

Tables

C.

Databases

D.

Internal Stages

Question # 22

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

A.

Column-level security

B.

SOC 2 type II certification

C.

Multi-factor Authentication (MFA)

D.

Object-level access control

Question # 23

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

A.

Data can be filtered by an optional where clause

B.

Incoming data can be joined with other tables

C.

Columns can be reordered

D.

Columns can be omitted

E.

Row level access can be defined

Question # 24

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

A.

Standard

B.

Premium

C.

Enterprise

D.

Business Critical

Question # 25

True or False: Snowflake charges a premium for storing semi-structured data.

A.

True

B.

False

Question # 26

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

Question # 27

Which type of table corresponds to a single Snowflake session?

A.

Temporary

B.

Translent

C.

Provisional

D.

Permanent

Question # 28

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

Question # 29

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

A.

Masking policy

B.

Stored procedure

C.

Task

D.

External table

Question # 30

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

A.

COPY INTO

B.

GET

C.

WRITE

D.

EXTRACT INTO

Question # 31

Which copy INTO command outputs the data into one file?

A.

SINGLE=TRUE

B.

MAX_FILE_NUMBER=1

C.

FILE_NUMBER=1

D.

MULTIPLE=FAISE

Question # 32

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

Question # 33

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

(Choose all that apply.)

A.

JDBC

B.

SnowSQL

C.

Snowflake Web Interface (UI)

D.

ODBC

E.

Python

D18912E1457D5D1DDCBD40AB3BF70D5D

Question # 34

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.

A.

True

B.

False

Question # 35

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

Question # 36

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

Question # 37

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

Question # 38

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

A.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

B.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

C.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

D.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Question # 39

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

Question # 40

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

A.

VARIANT

B.

ARRAY

C.

VARCHAR

D.

XML

E.

BLOB

Question # 41

True or False: Fail-safe can be disabled within a Snowflake account.

A.

True

B.

False

Question # 42

What features does Snowflake Time Travel enable?

A.

Querying data-related objects that were created within the past 365 days

B.

Restoring data-related objects that have been deleted within the past 90 days

C.

Conducting point-in-time analysis for Bl reporting

D.

Analyzing data usage/manipulation over all periods of time

Question # 43

What is the default File Format used in the COPY command if one is not specified?

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Question # 44

What feature can be used to reorganize a very large table on one or more columns?

A.

Micro-partitions

B.

Clustering keys

C.

Key partitions

D.

Clustered partitions

Question # 45

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

A.

ROLES

B.

POLICY_REFERENCES

C.

QUERY_HISTORY

D.

RESOURCE_MONIT ORS

E.

ACCESS_HISTORY

Question # 46

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

A.

Bytes scanned

B.

Bytes sent over the network

C.

Number of partitions scanned

D.

Percentage scanned from cache

E.

External bytes scanned

Question # 47

Where would a Snowflake user find information about query activity from 90 days ago?

A.

account__usage . query history view

B.

account__usage.query__history__archive View

C.

information__schema . cruery_history view

D.

information__schema - query history_by_ses s i on view

Question # 48

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

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 # 49

What tasks can be completed using the copy command? (Select TWO)

A.

Columns can be aggregated

B.

Columns can be joined with an existing table

C.

Columns can be reordered

D.

Columns can be omitted

E.

Data can be loaded without the need to spin up a virtual warehouse

Question # 50

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

A.

True

B.

False

Question # 51

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

A.

True

B.

False

Question # 52

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

Question # 53

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

Question # 54

How often are encryption keys automatically rotated by Snowflake?

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days

Question # 55

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

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 # 56

True or False: Data Providers can share data with only the Data Consumer.

A.

True

B.

False

Question # 57

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

Question # 58

The PUT command: (Choose two.)

A.

Automatically creates a File Format object

B.

Automatically uses the last Stage created

C.

Automatically compresses files using Gzip

D.

Automatically encrypts files

Question # 59

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

A.

True

B.

False

Question # 60

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

A.

Columnar shared nothing

B.

Shared disk

C.

Multi-cluster, shared data

D.

Cloud-native shared memory

Question # 61

Which of the following statement is true of Snowflake?

Select one.

A.

It was built specifically for the cloud

B.

it was built as an on-premises solution and then potted to the cloud

C.

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

D.

It was built for Hadoop architecture

E.

It's based on an Oracle Architecture

Question # 62

What privileges are required to create a task?

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 # 63

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

A.

Concurrency

B.

Performance

Question # 64

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

A.

To accommodate more queries

B.

To accommodate more users

C.

To accommodate fluctuations in workload

D.

To accommodate a more complex workload

Question # 65

When can a Virtual Warehouse start running queries?

A.

12am-5am

B.

Only during administrator defined time slots

C.

When its provisioning is complete

D.

After replication

Question # 66

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

Question # 67

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

A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

Question # 68

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

A.

Custom

B.

Economy

C.

Optimized

D.

Standard

Question # 69

Which of the following statements is true of Snowflake?

A.

It was built specifically for the cloud

B.

It was built as an on-premises solution and then ported to the cloud

C.

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

D.

It was built for Hadoop architecture

E.

It's based on an Oracle Architecture

Question # 70

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

A.

COPY INTO @stage

B.

EXPORT TO @stage

C.

INSERT INTO @stage

D.

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

Question # 71

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.

A.

True

B.

False

Question # 72

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

A.

Auto-suspend

B.

Auto-resume

C.

Local SSD size

D.

User count

Question # 73

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

A.

True

B.

False

Question # 74

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

A.

True

B.

False

Question # 75

Where is Snowflake metadata stored?

A.

Within the data files

B.

In the virtual warehouse layer

C.

In the cloud services layer

D.

In the remote storage layer

Question # 76

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

A.

CHECK_OPTION

B.

IS_SECURE

C.

IS_UPDATEABLE

D.

TABLE_NAME

Question # 77

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?

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 # 78

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

A.

If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

B.

A Data Exchange allows groups of accounts to share data privately among the accounts.

C.

A Data Exchange allows accounts to share data with third, non-Snowflake parties.

D.

Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

E.

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

Question # 79

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

Question # 80

What are common issues found by using the Query Profile? (Choose two.)

A.

Identifying queries that will likely run very slowly before executing them

B.

Locating queries that consume a high amount of credits

C.

Identifying logical issues with the queries

D.

Identifying inefficient micro-partition pruning

E.

Data spilling to a local or remote disk

Question # 81

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

A.

There is no Fail-safe period for these tables.

B.

1 day

C.

7 days

D.

31 days

E.

90 days

Question # 82

Which Snowflake tool would be BEST to troubleshoot network connectivity?

A.

SnowCLI

B.

SnowUI

C.

SnowSQL

D.

SnowCD

Question # 83

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

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.

Question # 84

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A.

A directory table is a separate database object.

B.

Directory tables store data file metadata.

C.

A directory table will be automatically added to a stage.

D.

Directory tables do not have their own grantable privileges.

E.

Directory table data can not be refreshed manually.

Question # 85

What privilege should a user be granted to change permissions for new objects in a managed access schema?

A.

Grant the OWNERSHIP privilege on the schema.

B.

Grant the OWNERSHIP privilege on the database.

C.

Grant the MANAGE GRANTS global privilege.

D.

Grant ALL privileges on the schema.

Question # 86

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

A.

There is no need to have a Snowflake account in the target region, a share will be created for each user.

B.

The listing is replicated into all selected regions automatically, the data is not.

C.

The user must have the ORGADMIN role available in at least one account to link accounts for replication.

D.

Shares attached to listings in remote regions can be viewed from any account in an organization.

E.

For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Question # 87

Which of the following is a data tokenization integration partner?

A.

Protegrity

B.

Tableau

C.

DBeaver

D.

SAP

Question # 88

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

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.

Question # 89

What is the minimum Snowflake edition required to use Dynamic Data Masking?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPC)

Question # 90

How many days is load history for Snowpipe retained?

A.

1 day

B.

7 days

C.

14 days

D.

64 days

Question # 91

When should a multi-cluster warehouse be used in auto-scaling mode?

A.

When it is unknown how much compute power is needed

B.

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

C.

If the runtime of the executed query is very slow

D.

When a large number of concurrent queries are run on the same warehouse

Question # 92

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

A.

The warehouse size does not change until all queries currently running in the warehouse have completed.

B.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

C.

The warehouse size does not change until the warehouse is suspended and restarted.

D.

It does not return from the command until the warehouse has finished changing its size.

Question # 93

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

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

Question # 94

What is a responsibility of Snowflake’s virtual warehouses?

A.

Infrastructure management

B.

Metadata management

C.

Query execution

D.

Query parsing and optimization

E.

Permanent storage of micro-partitions

Question # 95

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

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

Question # 96

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

A.

Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

B.

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

C.

Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

D.

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

E.

All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

F.

Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Question # 97

Which of the following statements describes a schema in Snowflake?

A.

A logical grouping of objects that belongs to a single database

B.

A logical grouping of objects that belongs to multiple databases

C.

A named Snowflake object that includes all the information required to share a database

D.

A uniquely identified Snowflake account within a business entity

Question # 98

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

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;

Question # 99

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

A.

USERADMIN

B.

PUBLIC

C.

ORGADMIN

D.

SYSADMIN

COF-R02 PDF

$33

$109.99

3 Months Free Update

Add to Cart
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

COF-R02 PDF + Testing Engine

$52.8

$175.99

3 Months Free Update

Add to Cart
  • Exam Name: SnowPro Core Recertification Exam
  • Last Update: Dec 14, 2025
  • Questions and Answers: 330
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

COF-R02 Engine

$39.6

$131.99

3 Months Free Update

Add to Cart
  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included