What information is stored in the ACCESS_HlSTORY view?

Details around the privileges that have been granted for all objects in an account

History of the files that have been loaded into Snowflake

Names and owners of the roles that are currently enabled in the session

Query details such as the objects included and the user who executed the query

Details around the privileges that have been granted for all objects in an account

In the Data Exchange, who can get or request data from the listings? (Select TWO).

Users with import share privilege

Users with manage grants privilege

What causes objects in a data share to become unavailable to a consumer account?

The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.

The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.

The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

The consumer account acquires the data share through a private data exchange.

Which types of subqueries does Snowflake support? (Select TWO).

Uncorrelated scalar subqueries in any place that a value expression can be used

EXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

Uncorrelated scalar subqueries in WHERE clauses

Uncorrelated scalar subqueries in any place that a value expression can be used

EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only

EXISTS, ANY / ALL, and IN subqueries in where clauses: these subqueries can be correlated only

EXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

A clustering key was defined on a table, but It is no longer needed. How can the key be removed?

ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY

ALTER TABLE <TABLE NAME> PURGE CLUSTERING KEY

ALTER TABLE <TABLE NAME> DELETE CLUSTERING KEY

ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY

ALTER TABLE <TABLE NAME> REMOVE CLUSTERING KEY

What are characteristics of Snowflake network policies? (Select TWO).

They can be set for any Snowflake Edition.

They restrict or enable access to specific IP addresses.

They can be set for any Snowflake Edition.

They restrict or enable access to specific IP addresses.

They are activated using ALTER DATABASE SQL commands.

They can only be managed using the ORGADMIN role.

Which categories are included in the execution time summary in a Query Profile? (Select TWO).

Percentage of data read from cache

What should be considered when deciding to use a secure view? (Select TWO).

No details of the query execution plan will be available in the query profiler.

Secure views do not take advantage of the same internal optimizations as standard views.

No details of the query execution plan will be available in the query profiler.

Once created there is no way to determine if a view is secure or not.

Secure views do not take advantage of the same internal optimizations as standard views.

It is not possible to create secure materialized views.

The view definition of a secure view is still visible to users by way of the information schema.

Which virtual warehouse consideration can help lower compute resource credit consumption?

Automating the virtual warehouse suspension and resumption settings

Setting up a multi-cluster virtual warehouse

Resizing the virtual warehouse to a larger size

Automating the virtual warehouse suspension and resumption settings

Increasing the maximum cluster count parameter for a multi-cluster virtual warehouse

A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.What should the user do?

Create a materialized view based on the query.

Add a clustering key to the table.

Add the search optimization service to the table.

Create a materialized view based on the query.

Enable the query acceleration service for the virtual warehouse.

What happens when a suspended virtual warehouse is resized in Snowflake?

The additional compute resources are provisioned when the warehouse is resumed.

The suspended warehouse is resumed and new compute resources are provisioned immediately.

The additional compute resources are provisioned when the warehouse is resumed.

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

The data retention period is temporarily extended to the stream's offset.

The data retention period is reduced to a minimum of 14 days.

The data retention period is permanently extended for the table.

The data retention period is temporarily extended to the stream's offset.

The data retention period is not affected by the stream consumption.

When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY <expression> parameter option?

To split the output into multiple files, one for each distinct value of the specified expression.

To sort the contents of the output file by the specified expression.

To delimit the records in the output file using the specified expression.

To include a new column in the output using the specified window function expression.

To split the output into multiple files, one for each distinct value of the specified expression.

What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?

Slower query performance and increased storage consumption

Faster query performance and increased storage consumption

Slower query performance and increased storage consumption

Faster query performance and decreased storage consumption

Slower query performance and decreased storage consumption

How does the Access_History view enhance overall data governance pertaining to read and write operations? (Select TWO).

Provides a unified picture of what data was accessed and when it was accessed

Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy

Shows how the accessed data was moved from the source lo the target objects

Provides a unified picture of what data was accessed and when it was accessed

Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime

Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data

Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy

When does a materialized view get suspended in Snowflake?

When a column is dropped from the base table

When a column is added to the base table

When a column is dropped from the base table

When a DML operation is run on the base table

When the base table is reclustered

What does a table with a clustering depth of 1 mean in Snowflake?

The table has no overlapping micro-partitions.

The table has only 1 micro-partition.

The table has 1 overlapping micro-partition.

The table has no overlapping micro-partitions.

The table has no micro-partitions.

What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

The length of time the compute resources in each cluster run

The type of SQL statements executed

The number of tables or databases queried

The amount of data stored in the warehouse

The length of time the compute resources in each cluster run

Snowflake SnowPro Core Practice Test 15 - Free Online Exam Questions 561-600

What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

Become a Premium Member for full access

Unlock Premium Member

Snowflake SnowPro Core Practice Test 15

Question

Snowflake SnowPro Core Practice Tests

Practice Tests