Offering Free access to SnowPro Core Certification COF-R02 Exam Questions Pool Bank

SnowPro Core Recertification Exam Questions and Answers

PDF + Testing Engine

Product Type: PDF + Testing Engine

$59.5 ~~$169.99~~

Add to Cart

Testing Engine

Product Type: Testing Engine

$42 ~~$119.99~~

Add to Cart

PDF Study Guide

Product Type: PDF Study Guide

$36.75 ~~$104.99~~

Add to Cart

Question 1

What is the minimum Snowflake edition required to create a materialized view?

Options:

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

Question 2

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

Options:

Execute a COPY command

Updating data

Snowpipe

AUTOMATIC__CLUSTERING

Scaling up a warehouse

Question 3

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

Options:

COPY INTO

GET

WRITE

EXTRACT INTO

Question 4

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

Options:

CSV

JSON

Parquet

XML

Question 5

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

Options:

ORC

XML

Avro

Parquet

JSON

Question 6

When is the result set cache no longer available? (Select TWO)

Options:

When another warehouse is used to execute the query

When another user executes the query

When the underlying data has changed

When the warehouse used to execute the query is suspended

When it has been 24 hours since the last query

Question 7

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:

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

Yes, because masking policies only apply to cloned tables.

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

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

Question 8

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Options:

Compute resources

Query execution

Authentication

Data storage

Metadata

Question 9

What SQL command would be used to view all roles that were granted to user.1?

Options:

show grants to user USER1;

show grants of user USER1;

describe user USER1;

show grants on user USER1;

Question 10

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

Options:

Variant

Object

Geometry

Geography

Question 11

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

Options:

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

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

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

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

Question 12

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:

Okta Verify

Duo Mobile

Microsoft Authenticator

Google Authenticator

Question 13

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

Options:

True

False

Question 14

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

Options:

True

False

Question 15

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?

Options:

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Question 16

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

Options:

It removes the last element of the outer array.

It removes the outer array structure and loads the records into separate table rows,

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Answer:

Explanation:

Data Size Limitations

The VARIANT data type imposes a 16 MB size limit on individual rows.

For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.

If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO

command to remove the outer array structure and load the records into separate table rows:

copy into

from @~/.json

file_format = (type = 'JSON' strip_outer_array = true);

Question 17

What can be used to view warehouse usage over time? (Select Two).

Options:

The load HISTORY view

The Query history view

The show warehouses command

The WAREHOUSE_METERING__HISTORY View

The billing and usage tab in the Snowflake web Ul

Question 18

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:

True

False

Question 19

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

Options:

COPY INTO @stage

EXPORT TO @stage

INSERT INTO @stage

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

Question 20

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

Options:

The validation_mode option is used when creating an Internal Stage

validation_mode=return_all_errors is a parameter of the copy command

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

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

Question 21

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

Options:

True

False

Question 22

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

Options:

Standard

Premier

Enterprise

Business Critical Edition

Question 23

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

Options:

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

Question 24

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Options:

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

Question 25

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Options:

Is available to all Snowflake Editions

Is only available to customers with Business Critical Edition

Restricts or enables access to specific IP addresses

Is activated using an “ALTER DATABASE” command

Question 26

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

Options:

True

False

Question 27

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

Options:

Tables

Named File Formats

Schemas

Databases

Users

Question 28

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

Options:

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

Question 29

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

Options:

Columnar shared nothing

Shared disk

Multi-cluster, shared data

Cloud-native shared memory

Question 30

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

Options:

True

False

Question 31

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

Options:

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

Question 32

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

Options:

True

False

Question 33

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

Options:

True

False

Question 34

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

Options:

True

False

Question 35

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

Options:

5 MB

8 GB

16 MB

32 MB

Question 36

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:

VIEWS_HISTORY

OBJECT_HISTORY

ACCESS_HISTORY

LOGIN_HISTORY

Question 37

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

Options:

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

Question 38

Which of the following statements describe features of Snowflake data caching? (Choose two.)

Options:

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

When the data cache is full, the least-recently used data will be cleared to make room.

A user can only access their own queries from the query result cache.

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

The RESULT_SCAN table function can access and filter the contents of the query result cache.

Question 39

What is true about sharing data in Snowflake? (Choose two.)

Options:

The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

The Data Consumer pays only for compute resources to query the shared data.

Question 40

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Options:

Snowflake leverages a Role-Based Access Control (RBAC) model.

Snowflake requires a user to configure an IAM user to connect to the database.

All data in Snowflake is encrypted.

Snowflake can run within a user's own Virtual Private Cloud (VPC).

All data in Snowflake is compressed.

Question 41

How does Snowflake Fail-safe protect data in a permanent table?

Options:

Fail-safe makes data available up to 1 day, recoverable by user operations.

Fail-safe makes data available for 7 days, recoverable by user operations.

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Question 42

Which statement describes pruning?

Options:

The filtering or disregarding of micro-partitions that are not needed to return a query.

The return of micro-partitions values that overlap with each other to reduce a query's runtime.

A service that is handled by the Snowflake Cloud Services layer to optimize caching.

The ability to allow the result of a query to be accessed as if it were a table.

Question 43

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options:

Management of metadata

Computing the data

Maintaining Availability Zones

Infrastructure security

Parsing and optimizing queries

Question 44

Which statement describes how Snowflake supports reader accounts?

Options:

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

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

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

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

Question 45

What happens to historical data when the retention period for an object ends?

Options:

The data is cloned into a historical object.

The data moves to Fail-safe

Time Travel on the historical data is dropped.

The object containing the historical data is dropped.

Question 46

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

Options:

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Question 47

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Options:

PURGE

MODIFY

REMOVE

DELETE

Question 48

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

Options:

VARIANT

VARRAY

STRUCT

ARRAY

QUEUE

Question 49

Which of the following objects are contained within a schema? (Choose two.)

Options:

Role

Stream

Warehouse

External table

User

Load More COF-R02 Questions

Page: 1 / 33
Total 330 questions

Get COF-R02 Full Access Download COF-R02 PDF

Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

Snowflake COF-R02 SnowPro Core Recertification Exam Exam Practice Test

SnowPro Core Recertification Exam Questions and Answers

PDF + Testing Engine

Testing Engine

PDF Study Guide

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer: