Pass the Snowflake SnowPro Core Certification COF-R02 Questions and answers with CertsForce

Viewing page 2 out of 10 pages
Viewing questions 11-20 out of questions
Questions # 11:

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

Options:

A.

True


B.

False


Expert Solution
Questions # 12:

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Options:

A.

To accommodate more queries


B.

To accommodate more users


C.

To accommodate fluctuations in workload


D.

To accommodate a more complex workload


Expert Solution
Questions # 13:

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Options:

A.

Custom


B.

Economy


C.

Optimized


D.

Standard


Expert Solution
Questions # 14:

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

Options:

A.

True


B.

False


Expert Solution
Questions # 15:

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Options:

A.

4


B.

16


C.

32


D.

128


Expert Solution
Questions # 16:

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

Options:

A.

A Schema may contain one or more Databases


B.

A Database may contain one or more Schemas


C.

A Schema is a logical grouping of Database Objects


D.

Each Schema is contained within a Warehouse


Expert Solution
Questions # 17:

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

Options:

A.

True


B.

False


Expert Solution
Questions # 18:

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

Options:

A.

True


B.

False


Expert Solution
Questions # 19:

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

Options:

A.

True


B.

False


Expert Solution
Questions # 20:

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

Options:

A.

True


B.

False


Expert Solution
Viewing page 2 out of 10 pages
Viewing questions 11-20 out of questions