Home

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.

Open VPLUS File

Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)

Which minimum Snowflake edition allows for a dedicated metadata store?

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?

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does Snowflake recommend maximizing the load performance?

Which TABLE function helps to convert semi-structured data to a relational representation?

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

What is a responsibility of Snowflake’s virtual warehouses?

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Question 246 - COF-R02 discussion

Report

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A.

Whether or not it is also a secure view

B.

How often the underlying base table is queried

C.

How often the base table changes

D.

Whether the materialized view has a cluster key defined

E.

How often the materialized view is queried

Show Answer

asked 23/09/2024

C/1094 WOLOGUEDE COTONOU â€“ BENIN NDENDE

36 questions

User

Your answer: A B C D E

0 comments

Sorted by

Leave a comment first