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

 
Home > Snowflake > SnowPro Core Certification > COF-R02

COF-R02 SnowPro Core Recertification Exam Question and Answers

Question # 4

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

A.

Masking policy

B.

Stored procedure

C.

Task

D.

External table

Full Access
Question # 5

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

A.

Compute Credits = 50 Credits Cloud Services = 10

B.

Compute Credits = 80 Credits Cloud Services = 5

C.

Compute Credits = 10 Credits Cloud Services = 9

D.

Compute Credits = 120 Credits Cloud Services = 10

E.

Compute Credits = 200 Credits Cloud Services = 26

Full Access
Question # 6

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

A.

True

B.

False

Full Access
Question # 7

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

A.

True

B.

False

Full Access
Question # 8

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

Full Access
Question # 9

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

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

Choose 3 answers

A.

On-premise availability

B.

Simplicity

C.

Open source based

D.

Concurrency

E.

Performance

Full Access
Question # 11

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

Full Access
Question # 12

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

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

Full Access
Question # 14

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

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

A.

Compute layer

B.

Storage layer

C.

Cloud infrastructure layer

D.

Cloud services layer

Full Access
Question # 16

Which of the following commands cannot be used within a reader account?

A.

CREATE SHARE

B.

ALTER WAREHOUSE

C.

DROP ROLE

D.

SHOW SCHEMAS

E.

DESCRBE TABLE

Full Access
Question # 17

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

A.

ORC

B.

XML

C.

Avro

D.

Parquet

E.

JSON

Full Access
Question # 18

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

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

A.

show grants to user USER1;

B.

show grants of user USER1;

C.

describe user USER1;

D.

show grants on user USER1;

Full Access
Question # 20

Which Snowflake partner specializes in data catalog solutions?

A.

Alation

B.

DataRobot

C.

dbt

D.

Tableau

Full Access
Question # 21

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?

A.

Okta Verify

B.

Duo Mobile

C.

Microsoft Authenticator

D.

Google Authenticator

Full Access
Question # 22

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

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Full Access
Question # 24

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A.

A single join node uses more than 50% of the query time

B.

Partitions scanned is equal to partitions total

C.

An AggregateOperacor node is present

D.

The query is spilling to remote storage

Full Access
Question # 25

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

Full Access
Question # 26

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

A.

Data is hashed by the cluster key to facilitate fast searches for common data values

B.

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.

Smaller micro-partitions are created for common data values to allow for more parallelism

D.

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Full Access
Question # 27

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A.

Bytes sent over network

B.

Percentage scanned from cache

C.

Partitions total

D.

Bytes spilled to local storage

E.

Partitions scanned

Full Access
Question # 28

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

Full Access
Question # 29

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

A.

The reader account will automatically use the Standard edition of Snowflake.

B.

The reader account compute will be billed to the provider account.

C.

The reader account can clone data the provider has shared, but cannot re-share it.

D.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Full Access
Question # 30

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

A.

The Pipe load history is reset to empty.

B.

The REFRESH command is executed.

C.

The stage will be purged.

D.

The destination table is truncated.

Full Access
Question # 31

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

A.

Local disk caching

B.

Authentication and access control

C.

Metadata management

D.

Query processing

E.

Database storage

Full Access
Question # 32

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.

Full Access
Question # 33

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

Full Access
Question # 34

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

When cloning a database, what is cloned with the database? (Choose two.)

A.

Privileges on the database

B.

Existing child objects within the database

C.

Future child objects within the database

D.

Privileges on the schemas within the database

E.

Only schemas and tables within the database

Full Access
Question # 36

What affects whether the query results cache can be used?

A.

If the query contains a deterministic function

B.

If the virtual warehouse has been suspended

C.

If the referenced data in the table has changed

D.

If multiple users are using the same virtual warehouse

Full Access
Question # 37

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

A.

STRIP_NULL_VALUES

B.

SKIP_BYTE_ORDER_MARK

C.

REPLACE_INVALID_CHARACTERS

D.

VALIDATION_MODE

Full Access
Question # 38

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

Full Access
Question # 39

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

A.

1

B.

2

C.

3

D.

4

Full Access
Question # 40

When loading data into Snowflake, how should the data be organized?

A.

Into single files with 100-250 MB of compressed data per file

B.

Into single files with 1-100 MB of compressed data per file

C.

Into files of maximum size of 1 GB of compressed data per file

D.

Into files of maximum size of 4 GB of compressed data per file

Full Access
Question # 41

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

Full Access
Question # 42

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

Which type of table corresponds to a single Snowflake session?

A.

Temporary

B.

Translent

C.

Provisional

D.

Permanent

Full Access
Question # 44

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

Full Access
Question # 45

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

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

Full Access
Question # 47

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

A.

True

B.

False

Full Access
Question # 48

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

A.

True

B.

False

Full Access
Question # 49

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

Full Access
Copyright myexamcollection.com. All Right Reserved.