Weekend Sale Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-R02 - SnowPro Core Recertification Exam

Snowflake COF-R02 SnowPro Core Recertification Exam Exam Practice Test

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

SnowPro Core Recertification Exam Questions and Answers

Question 1

What is a limitation of a Materialized View?

Options:

A.

A Materialized View cannot support any aggregate functions

B.

A Materialized View can only reference up to two tables

C.

A Materialized View cannot be joined with other tables

D.

A Materialized View cannot be defined with a JOIN

Question 2

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

Options:

A.

VARIANT

B.

ARRAY

C.

VARCHAR

D.

XML

E.

BLOB

Question 3

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

Options:

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Question 4

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

Options:

A.

Query against the result set cache

B.

Query against a virtual warehouse cache

C.

Query against the most-recently created micro-partition

D.

Query against the metadata excite

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:

A.

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

B.

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

C.

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

D.

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

Question 6

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 7

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

Options:

A.

Metadata cache

B.

Result cache

C.

Remote cache

D.

Local file cache

Question 8

What data is stored in the Snowflake storage layer? (Select TWO).

Options:

A.

Snowflake parameters

B.

Micro-partitions

C.

Query history

D.

Persisted query results

E.

Standard and secure view results

Question 9

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 10

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

Options:

A.

True

B.

False

Question 11

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 12

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?

Options:

A.

Standard

B.

Premium

C.

Enterprise

D.

Business Critical

Question 13

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

Options:

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Question 14

Which statement about billing applies to Snowflake credits?

Options:

A.

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

B.

Credits are used to pay for cloud data storage usage

C.

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

D.

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

Question 15

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 16

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 17

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

Options:

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Question 18

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

Options:

A.

To accommodate more queries

B.

To accommodate more users

C.

To accommodate fluctuations in workload

D.

To accommodate a more complex workload

Question 19

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

Options:

A.

The Snowflake Web Interface (UI)

B.

SQL commands

C.

Data integration tools

D.

All of the above

Question 20

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

Options:

A.

True

B.

False

Question 21

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

Options:

A.

A Schema may contain one or more Databases

B.

A Database may contain one or more Schemas

C.

A Schema is a logical grouping of Database Objects

D.

Each Schema is contained within a Warehouse

Question 22

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 23

True or False: Pipes can be suspended and resumed.

Options:

A.

True

B.

False

Question 24

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

Options:

A.

Named Stage

B.

User Stage

C.

Table Stage

D.

Schema Stage

Question 25

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

Options:

A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

Question 26

True or False: The COPY command must specify a File Format in order to execute.

Options:

A.

True

B.

False

Question 27

Which of the following statements is true of Snowflake?

Options:

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 28

True or False: You can query the files in an External Stage directly without having to load the data into a table.

Options:

A.

True

B.

False

Question 29

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

Options:

A.

True

B.

False

Question 30

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

Options:

A.

True

B.

False

Question 31

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Options:

A.

Configure the Maximum Clusters setting to “Auto-Scale”

B.

Set the Warehouse type to “Auto”

C.

Set the Minimum Clusters and Maximum Clusters settings to the same value

D.

Set the Minimum Clusters and Maximum Clusters settings to the different values

Question 32

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.

Options:

A.

True

B.

False

Question 33

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

Options:

A.

Number of users

B.

Warehouse size

C.

Amount of data processed

D.

# of clusters for the Warehouse

Question 34

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 35

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Options:

A.

The columns that are queried in the select clause.

B.

The columns with very high cardinality.

C.

The columns with many different values.

D.

The columns most actively used in the select filters.

Question 36

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

Options:

A.

The shared objects are transferred.

B.

The shared objects are copied.

C.

The shared objects become accessible.

D.

The shared objects can be re-shared.

Question 37

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

Options:

A.

Create a zero-copy clone of the worksheet and grant permissions to teammates

B.

Create a private Data Exchange so that any teammate can use the worksheet

C.

Share the worksheet with teammates within Snowsight

D.

Create a database and grant all permissions to teammates

Question 38

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 39

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Options:

A.

Materialized view

B.

Sequence

C.

Secure view

D.

Transient table

E.

Clustered table

Question 40

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

Options:

A.

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

B.

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

C.

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

D.

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

E.

grant SELECT on all tables in database DB1 to role MYROLE;

F.

grant SELECT on future tables in database DB1 to role MYROLE;

Question 41

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

Options:

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

Question 42

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Options:

A.

4

B.

8

C.

16

D.

32

Question 43

Which of the following are characteristics of security in Snowflake?

Options:

A.

Account and user authentication is only available with the Snowflake Business Critical edition.

B.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

C.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D.

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Question 44

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

Options:

A.

Pre-signed URL

B.

Scoped URL

C.

Signed URL

D.

File URL

Question 45

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

Options:

A.

Row level access policies

B.

Data masking policies

C.

Data encryption

D.

Time Travel

E.

External tokenization

Question 46

Which file formats are supported for unloading data from Snowflake? (Choose two.)

Options:

A.

Avro

B.

JSON

C.

ORC

D.

XML

E.

Delimited (CSV, TSV, etc.)

Question 47

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

Options:

A.

TSV

B.

JSON

C.

PDF

D.

Avro

E.

Parquet

F.

JPEG

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

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

Options:

A.

CHECK_OPTION

B.

IS_SECURE

C.

IS_UPDATEABLE

D.

TABLE_NAME

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