Weekend Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale65best

Free Snowflake COF-R02 Practice Exam with Questions & Answers | Set: 9

Questions 81

How a Snowpipe charges calculated?

Options:
A.

Per-second/per Warehouse size

B.

Per-second/per-core granularity

C.

Number of Pipes in account

D.

Total storage bucket size

Snowflake COF-R02 Premium Access
Questions 82

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

Options:
A.

True

B.

False

Questions 83

True or False: A single database can exist in more than one Snowflake account.

Options:
A.

True

B.

False

Questions 84

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

Options:
A.

True

B.

False

Questions 85

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

Options:
A.

Auto-suspend

B.

Auto-resume

C.

Local SSD size

D.

User count

Questions 86

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

Questions 87

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

Questions 88

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

Options:
A.

The tables are now orphaned

B.

The user that deleted the role

C.

SYSADMIN

D.

The assumed role that dropped the role

Questions 89

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

Options:
A.

COPY INTO @stage

B.

EXPORT TO @stage

C.

INSERT INTO @stage

D.

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

Questions 90

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

Choose 3 answers

Options:
A.

On-premise availability

B.

Simplicity

C.

Open source based

D.

Concurrency

E.

Performance