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?

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

True or False: Snowpipe via REST API can only reference External Stages as source.

Which SQL command can be used to see the CREATE definition of a masking policy?

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

Question 182 - COF-R02 discussion

Report

What type of query benefits the MOST from search optimization?

A.

A query that uses only disjunction (i.e., OR) predicates

B.

A query that includes analytical expressions

C.

A query that uses equality predicates or predicates that use IN

D.

A query that filters on semi-structured data types

Show Answer

asked 23/09/2024

Madhanraj N

42 questions

User

Your answer: A B C D

0 comments

Sorted by

Leave a comment first