What affects whether the query results cache can be used?

If the referenced data in the table has changed

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT SUM (ORDER_AMT) FROM SALES;

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT MIN(ORDER_AMT) FROM SALES;

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

How can a row access policy be applied to a table or a view? (Choose two.)

Using the command ALTER <object> ADD ROW ACCESS POLICY ;

Within the create table or create view DDL

By future APPLY for all objects in a schema

Using the command ALTER <object> ADD ROW ACCESS POLICY ;

When should a multi-cluster warehouse be used in auto-scaling mode?

When a large number of concurrent queries are run on the same warehouse

When it is unknown how much compute power is needed

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

If the runtime of the executed query is very slow

When a large number of concurrent queries are run on the same warehouse

In the Snowflake access control model, which entity owns an object by default?

The role used to create the object

The user who created the object

Ownership depends on the type of object

The role used to create the object

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Virtual Private Snowflake (VPC)

What is true about sharing data in Snowflake? (Choose two.)

A Snowflake account can both provide and consume shared data.

The Data Consumer pays only for compute resources to query the shared data.

The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

The Data Consumer pays only for compute resources to query the shared data.

The following JSON is stored in a VARIANT column called src of the CAR_SALES table: A user needs to extract the dealership information from the JSON.How can this be accomplished?

select src.dealership from car_sales;

select src:dealership from car_sales;

select src.dealership from car_sales;

select src:Dealership from car_sales;

select dealership from car_sales;

Which of the following accurately describes shares?

Tables, secure views, and secure UDFs can be shared

Data consumers can clone a new table from a share

Access to a share cannot be revoked once granted

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

The ACCOUNTADMIN role must be granted to only one user.

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Data is live, ready-to-query, and can be personalized.

Data is available without copying or moving.

Data is live, ready-to-query, and can be personalized.

Data needs to be loaded into a cloud provider as a consumer account.

Data is not available for copying or moving to an individual Snowflake account.

Data is available without copying or moving.

Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

How often the base table changes

Whether the materialized view has a cluster key defined

Whether or not it is also a secure view

How often the underlying base table is queried

How often the base table changes

Whether the materialized view has a cluster key defined

How often the materialized view is queried

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

An error will occur, as views with qualified references cannot be cloned.

An error will occur, as stored objects cannot be cloned.

The stored procedures and views will refer to tables in the source database.

When loading data into Snowflake, how should the data be organized?

Into single files with 100-250 MB of compressed data per file

Into single files with 1-100 MB of compressed data per file

Into files of maximum size of 1 GB of compressed data per file

Into files of maximum size of 4 GB of compressed data per file

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Virtual Private Snowflake (VPS)

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.How can this be accomplished?

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

The transient table version cannot be retrieved after 24 hours.

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

What is the following SQL command used for?Select * from table(validate(t1, job_id => '_last'));

To return errors from the last executed COPY command into table t1 in the current session

To validate external table files in table t1 across all sessions

To validate task SQL statements against table t1 in the last 14 days

To validate a file for errors before it gets executed using a COPY command

To return errors from the last executed COPY command into table t1 in the current session

The Snowflake Search Optimization Services supports improved performance of which kind of query?

Queries against large tables where frequent DML occurs

Queries against tables larger than 1 TB

Queries against a subset of columns in a table

What are common issues found by using the Query Profile? (Choose two.)

Identifying inefficient micro-partition pruning

Data spilling to a local or remote disk

Identifying queries that will likely run very slowly before executing them

Locating queries that consume a high amount of credits

Identifying logical issues with the queries

Identifying inefficient micro-partition pruning

Data spilling to a local or remote disk

What happens to historical data when the retention period for an object ends?

Time Travel on the historical data is dropped.

The data is cloned into a historical object.

Time Travel on the historical data is dropped.

The object containing the historical data is dropped.

Snowflake SnowPro Core Practice Test 5 - Free Online Exam Prep & Questions

Question 1 / 40

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

The explain plan output is available graphically.

An explain plan can be used to conduct performance analysis without executing a query.

An explain plan will handle queries with temporary tables and the query profiler will not.

An explain plan's output will display automatic data skew optimization information.

Comment (0)

Snowflake SnowPro Core Practice Test 5

Question

Snowflake SnowPro Core Practice Tests

Practice Tests