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.

What happens when a network policy includes values that appear in both the allowed and blocked IP address list?

Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.

Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.

Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list

Snowflake SnowPro Core 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 SnowPro Core Practice Test 13

Question

Snowflake SnowPro Core Practice Tests

Practice Tests