What can a Snowflake user do with the information included in the details section of a Query Profile?

Determine the total duration of the query.

Determine the role of the user who ran the query.

Determine the source system that the queried table is from.

Determine if the query was on structured or semi-structured data.

What is the recommended way to change the existing file format type in my format from CSV to JSON?

ALTER FILE FORMAT my_format SET TYPE=JSON;

ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

REPLACE FILE FORMAT my format TYPE-JSON;

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

Information_schema.warehouse_load_history

Information schema.warehouse metering history

What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

A column with very high cardinality

A column that is most actively used in selective filters

A column with very low cardinality

A column with very high cardinality

A column that is most actively used in selective filters

A column that is most actively used in join predicates

Which of the following describes the Snowflake Cloud Services layer?

Coordinates activities in the Snowflake account

Executes queries submitted by the Snowflake account users

Manages quotas on the Snowflake account storage

Manages the virtual warehouse cache to speed up queries

What does Snowflake recommend regarding database object ownership? (Select TWO).

Create objects with a custom role and grant this role to SYSADMIN.

Create objects with ACCOUNTADMIN and do not reassign ownership.

Create objects with SECURITYADMIN to ease granting of privileges later.

Create objects with a custom role and grant this role to SYSADMIN.

Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

What happens when a database is cloned?

It does not retain any privileges granted on the source object.

It replicates all granted privileges on the corresponding source objects.

It replicates all granted privileges on the corresponding child objects.

It replicates all granted privileges on the corresponding child schema objects.

How does a scoped URL expire?

When the persisted query result period ends.

The encoded URL access is permanent.

The length of time is specified in the expiration_time argument.

Which features make up Snowflake's column level security? (Select TWO).

Continuous Data Protection (CDP)

What is the difference between a stored procedure and a User-Defined Function (UDF)?

Stored procedures can execute database operations while UDFs cannot.

Returning a value is required in a stored procedure while returning values in a UDF is optional.

Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

When managing a steady workload

When the compute must be available with no delay or lag time

When users will be using compute at different times throughout a 24/7 period

When managing a steady workload

When the compute must be available with no delay or lag time

When the user does not want to have to manually turn on the warehouse each time it is needed

When the warehouse is shared across different teams

How does Snowflake handle the bulk unloading of data into single or multiple files?

It assigns each unloaded data file a unique name.

It uses the put command to download the data by default.

It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.

It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.

Which statement accurately describes a characteristic of a materialized view?

Data accessed through materialized views can be stale.

A materialized view can query only a single table.

Data accessed through materialized views can be stale.

Materialized view refreshes need to be maintained by the user.

Querying a materialized view is slower than executing a query against the base table of the view.

What can a Snowflake user do in the Activity section in Snowsight?

Explore executed query performance.

What does Snowflake's search optimization service support?

Tables and views that are not protected by row access policies

Casts on table columns (except for fixed-point numbers cast to strings)

What action can a user take to address query concurrency issues?

Add additional clusters to the virtual warehouse

Enable the query acceleration service.

Add additional clusters to the virtual warehouse

Resize the virtual warehouse to a larger instance size.

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Until the expiration time is exceeded

Until the retention_time is met

Until the expiration time is exceeded

Which parameter prevents streams on tables from becoming stale?

MTN_DATA_RETENTION_TTME_TN_DAYS

A user needs to create a materialized view in the schema MYDB.MYSCHEM

Which statements will provide this access?

GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K'-'SCHEMA TO USER! ;

GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

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

How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

A.

Create a view.

B.

Cluster a table.

C.

Enable the search optimization service.

D.

Enable Time Travel.

E.

Index a table.

Snowflake SnowPro Core Practice Test 8

Question

Snowflake SnowPro Core Practice Tests

Practice Tests