What can be used to view warehouse usage over time? (Select Two).

The WAREHOUSE_METERING__HISTORY View

The billing and usage tab in the Snowflake web Ul

What does the worksheet and database explorer feature in Snowsight allow users to do?

Tag frequently accessed worksheets for ease of access.

Add or remove users from a worksheet.

Move a worksheet to a folder or a dashboard.

Combine multiple worksheets into a single worksheet.

Tag frequently accessed worksheets for ease of access.

What are characteristics of reader accounts in Snowflake? (Select TWO).

Reader account users cannot add new data to the account.

Reader accounts enable data consumers to access and query data shared by the provider.

Reader account users cannot add new data to the account.

Reader account users can share data to other reader accounts.

A single reader account can consume data from multiple provider accounts.

Data consumers are responsible for reader account setup and data usage costs.

Reader accounts enable data consumers to access and query data shared by the provider.

Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

Virtual Private Snowflake (VPS)

A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?

Grant the additional privileges to a custom role.

Grant the additional privileges to the ACCOUNTADMIN role.

Grant the additional privileges to the SYSADMIN role.

Grant the additional privileges to the ORGADMIN role.

Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

Plain text file containing XML elements

How does Snowflake describe its unique architecture?

A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)

A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)

A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)

A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

What information does the Query Profile provide?

Statistics for each component of the processing plan

Graphical representation of the data model

Statistics for each component of the processing plan

Detailed Information about I he database schema

Real-time monitoring of the database operations

Why would a Snowflake user decide to use a materialized view instead of a regular view?

The base tables do not change frequently.

The results of the view change often.

The query is not resource intensive.

The query results are not used frequently.

Which common query problems are identified by the Query Profile? (Select TWO.)

Queries too large to fit in memory

Object does not exist or not authorized

What are characteristic of Snowsight worksheet? (Select TWO.)

Worksheets can be grouped under folder, and a folder of folders.

Users can import worksheets and share them with other users.

Worksheets can be grouped under folder, and a folder of folders.

Each worksheet is a unique Snowflake session.

Users are limited to running only one on a worksheet.

The Snowflake session ends when a user switches worksheets.

Users can import worksheets and share them with other users.

A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.How will those object names be resolved during execution?

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

Snowflake will resolve them according to the SEARCH_PATH parameter.

Snowflake will only check the schema the UDF belongs to.

Snowflake will first check the current schema, and then the schema the previous query used

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

Snowflake COF-C02 Practice Test 13 - Free Online Exam Prep & Questions

Spam

Selling illegal goods, money scams etc.

Hate Speech

Serious attack on a group.

Harassment and bullying

Harassing an individual (including doxing)

Harmful activities

Threatening or glorifying violence or serious harm, including self-harm

Adult content (Consensual)

Nudity/Sexual content

Sexual exploitation and abuse (child safety)

Sexually explicit or suggestive imagery or writing involving minors

Sexual exploitation and abuse (adults and animals)

Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans

Plagiarism

Reusing content without attribution (link and blockquotes)

Poorly written

Not in English or has very bad formatting, grammar, and spelling

Inappropriate credential

Author's credential is offensive, spam, or impersonation

Other

Ex. Illegal content, incomplete question...

Snowflake COF-C02 Practice Test 13

Question

Snowflake COF-C02 Practice Tests

Practice Tests