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 103 - COF-R02 discussion

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

list @mytable;

list @%raytable;

list @ %m.ystage;

list @mystage;

Show Answer

asked 23/09/2024

JP Brune

39 questions

Your answer: A B C D

0 comments

Sorted by