Snowflake COF-R02 today updated questions - Verified by Snowflake Experts

SnowPro Core Recertification Exam Questions and Answers

Question 1

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

Options:

Columns can be aggregated

Columns can be joined with an existing table

Columns can be reordered

Columns can be omitted

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

Question 2

What is the recommended file sizing for data loading using Snowpipe?

Options:

A compressed file size greater than 100 MB, and up to 250 MB

A compressed file size greater than 100 GB, and up to 250 GB

A compressed file size greater than 10 MB, and up to 100 MB

A compressed file size greater than 1 GB, and up to 2 GB

Question 3

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

Options:

Data can be filtered by an optional where clause

Incoming data can be joined with other tables

Columns can be reordered

Columns can be omitted

Row level access can be defined

Question 4

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Options:

Pipes

Streams

Tasks

Procedures

Question 5

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

Options:

All data from all of the files on the stage will be appended to the table

Only data about new customers from the new files will be appended to the table

The operation will fail with the error uncertain files in stage.

All data from only the newly-added files will be appended to the table.

Question 6

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

Options:

ROLEADMIN

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

USERADMIN

Question 7

Which cache type is used to cache data output from SQL queries?

Options:

Metadata cache

Result cache

Remote cache

Local file cache

Question 8

Will data cached in a warehouse be lost when the warehouse is resized?

Options:

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

No. because the size of the cache is independent from the warehouse size

Yes. became the new compute resource will no longer have access to the cache encryption key

Question 9

Which statement about billing applies to Snowflake credits?

Options:

Credits are billed per-minute with a 60-minute minimum

Credits are used to pay for cloud data storage usage

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

Credits are consumed based on the warehouse size and the time the warehouse is running

Question 10

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Options:

Materialized views

Sequences

Procedures

Tables

Secure User Defined Functions (UDFs)

Question 11

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Options:

The table contains a column that has very low cardinality

DML statements that are being issued against the table are blocked

The table has a small number of micro-partitions

Queries on the table are running slower than expected

The clustering depth for the table is large

Question 12

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

Options:

True

False

Question 13

What is the default character set used when loading CSV files into Snowflake?

Options:

UTF-8

UTF-16

ISO S859-1

ANSI_X3.A

Question 14

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 15

What are ways to create and manage data shares in Snowflake? (Select TWO)

Options:

Through the Snowflake web interface (Ul)

Through the DATA_SHARE=TRUE parameter

Through SQL commands

Through the enable__share=true parameter

Using the CREATE SHARE AS SELECT * TABLE command

Question 16

What happens when a cloned table is replicated to a secondary database? (Select TWO)

Options:

A read-only copy of the cloned tables is stored.

The replication will not be successful.

The physical data is replicated

Additional costs for storage are charged to a secondary account

Metadata pointers to cloned tables are replicated

Question 17

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

Options:

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

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

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

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

Question 18

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Options:

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

An error will occur, as views with qualified references cannot be cloned.

An error will occur, as stored objects cannot be cloned.

The stored procedures and views will refer to tables in the source database.

Question 19

Which of the following accurately describes shares?

Options:

Tables, secure views, and secure UDFs can be shared

Shares can be shared

Data consumers can clone a new table from a share

Access to a share cannot be revoked once granted

Question 20

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

Options:

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Question 21

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

Options:

Role

Stream

Warehouse

External table

User

Question 22

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

Options:

Gathering the hourly credit usage for an account

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

Summarizing the throughput of Snowpipe costs for an account

Calculating the funds left on an account's contract

Question 23

What internal stages are available in Snowflake? (Choose three.)

Options:

Schema stage

Named stage

User stage

Stream stage

Table stage

Database stage

Question 24

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Options:

parse_json()

json_extract_path_text()

object_construct()

flatten

Question 25

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

Options:

select src:dealership from car_sales;

select src.dealership from car_sales;

select src:Dealership from car_sales;

select dealership from car_sales;

Question 26

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?

Options:

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

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.

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.

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.

Question 27

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Options:

Compute resources

Query execution

Authentication

Data storage

Metadata

Question 28

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

Options:

Authentication

Resource management

Virtual warehouse caching

Query parsing and optimization

Query execution

Physical storage of micro-partitions

Question 29

Which statement MOST accurately describes clustering in Snowflake?

Options:

The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

The clustering key must be included in the COPY command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

Question 30

What is cached during a query on a virtual warehouse?

Options:

All columns in a micro-partition

Any columns accessed during the query

The columns in the result set of the query

All rows accessed during the query

Question 31

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Options:

Tri-Secret Secure

Time Travel

Fail-safe

Data encryption

External stages

Question 32

Which minimum Snowflake edition allows for a dedicated metadata store?

Options:

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Question 33

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 34

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 35

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 36

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

Options:

Tables

Schemas

Databases

Stages

Question 37

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

Options:

Auto-suspend

Auto-resume

Local SSD size

User count

Question 38

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

Options:

A multi-cluster Warehouse can add clusters automatically based on query activity

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

A multi-cluster Warehouse can scale down when query activity slows

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

Question 39

True or False: Pipes can be suspended and resumed.

Options:

True

False

Question 40

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

Options:

UPSERT

MERGE

UPDATE

TRUNCATE TABLE

Question 41

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

Options:

Named Stage

User Stage

Table Stage

Schema Stage

Question 42

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

Options:

True

False

Question 43

What are the three things customers want most from their enterprise data warehouse solution?

Choose 3 answers

Options:

On-premise availability

Simplicity

Open source based

Concurrency

Performance

Question 44

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

Options:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

Question 45

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

Options:

60 minutes

24 hours

14 days

30 days

1 year

Question 46

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

(Choose all that apply.)

Options:

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

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

Multiple compute clusters can access stored data without contention

Question 47

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 48

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Options:

128

Question 49

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

Options:

Concurrency

Performance

Load More COF-R02 Questions

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

Snowflake COF-R02 SnowPro Core Recertification Exam Exam Practice Test

SnowPro Core Recertification Exam Questions and Answers

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options: