Home / Snowflake / COF-R02

Question list

List of questions

Question 1

(0)

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

Question 2

(0)

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

Question 3

(0)

Which of the following statement is true of Snowflake? Select one.

Question 4

(0)

The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

Question 5

(0)

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

Question 6

(0)

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

Question 7

(0)

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

Question 8

(0)

Which type of table corresponds to a single Snowflake session?

Question 9

(0)

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

Question 10

(0)

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

Question 133 - COF-R02 discussion

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Bytes scanned

Bytes sent over the network

Number of partitions scanned

Percentage scanned from cache

External bytes scanned

Show Answer

asked 23/09/2024

Piotr Szwajkowski

37 questions

Your answer: A B C D E

0 comments

Sorted by