A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

The data from the permanent table.

The data from the temporary table.

An error stating that the view could not be compiled.

An error stating that the referenced object could not be uniquely identified.

What is a characteristic of the Snowflake Query Profile?

It provides a graphic representation of the main components of the query processing.

It can provide statistics on a maximum number of 100 queries per week.

It provides a graphic representation of the main components of the query processing.

It provides detailed statistics about which queries are using the greatest number of compute resources.

It can be used by third-party software using the Query Profile API.

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Bytes spilled to local storage.

Bytes spilled to remote storage.

Bytes spilled to remote metastore.

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

select * from directory(@bronzestage);

select metadata$filename from @bronzestage;

select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));

When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

When using a paid listing on the Snowflake Marketplace

When using a private listing on the Snowflake Marketplace

When using a personalized listing on the Snowflake Marketplace

When using a Direct Share with another account

What are benefits of using Snowpark with Snowflake? (Select TWO).

Snowpark does not require that a separate cluster be running outside of Snowflake.

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

Snowpark uses a Spark engine to generate optimized SQL query plans.

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

Snowpark does not require that a separate cluster be running outside of Snowflake.

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

A user with a SECURITYADMIN or higher role

A role that has the ownership of the network policy

A user with an USERADMIN or higher role

A user with a SECURITYADMIN or higher role

A role that has been granted the ATTACH POLICY privilege

A role that has the NETWORK_POLlCY account parameter set

A role that has the ownership of the network policy

A permanent table and temporary table have the same name, TBL1, in a schema.What will happen if a user executes select * from TBL1 ;?

The temporary table will take precedence over the permanent table.

The permanent table will take precedence over the temporary table.

An error will say there cannot be two tables with the same name in a schema.

The table that was created most recently will take precedence over the older table.

What tasks can an account administrator perform in the Data Exchange? (Select TWO).

Approve and deny listing approval requests.

Transfer ownership of a provider profile.

What does a masking policy consist of in Snowflake?

A single data type, with one or more conditions, and one or more masking functions

A single data type, with only one condition, and only one masking function

Multiple data types, with only one condition, and one or more masking functions

Multiple data types, with one or more conditions, and one or more masking functions

A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.How can this be achieved?

Store the data in a table with a variant data type. Query the table.

Flatten the data and store it in structured data types in a flattened table. Query the table.

Store the data in a table with a variant data type. Query the table.

Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.

Store the data in an external stage and create views on top of it. Query the views.

Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).

Multi-cluster virtual warehouses

Snowflake SnowPro Core Practice Test 9 - Free Online Exam Questions 321-360

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

Become a Premium Member for full access

Unlock Premium Member

Snowflake SnowPro Core Practice Test 9

Question

Snowflake SnowPro Core Practice Tests

Practice Tests