Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: merry71

Free SnowPro Core Recertification Exam Practice Questions

Question # 21

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.)

Discussion 0
Question # 22

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

Options:

A.  

True

B.  

False

Discussion 0
Question # 23

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

Options:

A.  

True

B.  

False

Discussion 0
Question # 24

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

Options:

A.  

Named Stage

B.  

User Stage

C.  

Table Stage

D.  

Schema Stage

Discussion 0
Question # 25

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 26

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

Options:

A.  

True

B.  

False

Discussion 0
Question # 27

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.

Options:

A.  

True

B.  

False

Discussion 0
Question # 28

What are the three layers that make up Snowflake’s architecture?

Choose 3 answer

Options:

A.  

Compute

B.  

Tri-Secret Secure

C.  

Storage

D.  

Cloud Services

Discussion 0
Question # 29

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

Options:

A.  

4

B.  

16

C.  

32

D.  

128

Discussion 0
Question # 30

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Select one.

Options:

A.  

More micro-partitions

B.  

Better query scheduling

C.  

Double the numbers of servers In the compute duster

D.  

Higher storage costs

Discussion 0

COF-R02 PDF

COF-R02 PDF (Printable)
$46.5
$154.99

COF-R02 Testing Engine

COF-R02 PDF (Printable)
$51
$169.99

COF-R02 PDF + Testing Engine

COF-R02 PDF (Printable)
$63.9
$212.99

Free Exams Sample Questions