What are the default Time Travel and Fail-safe retention periods for transient tables?

Time Travel - 1 day. Fail-safe - 0 days

Time Travel - 1 day. Fail-safe - 1 day

Time Travel - 0 days. Fail-safe - 1 day

Time Travel - 1 day. Fail-safe - 0 days

Transient tables are retained in neither Fail-safe nor Time Travel

What is a best practice after creating a custom role?

Assign the custom role to the SYSADMIN role

Create the custom role using the SYSADMIN role.

Assign the custom role to the SYSADMIN role

Assign the custom role to the PUBLIC role

Add__CUSTOM to all custom role names

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Secure User Defined Functions (UDFs)

Will data cached in a warehouse be lost when the warehouse is resized?

No. because the size of the cache is independent from the warehouse size

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

No. because the size of the cache is independent from the warehouse size

Yes. became the new compute resource will no longer have access to the cache encryption key

What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

Users who are trying to use the warehouse will receive an error message until the resizing is complete

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

No, because ownership of a table does not include the ability to change masking policies

Yes, because a table owner has full control and can unset masking policies.

Yes, because masking policies only apply to cloned tables.

No, because masking policies must always reference specific access roles.

No, because ownership of a table does not include the ability to change masking policies

Which of the following describes how clustering keys work in Snowflake?

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

A Windows server file share on Azure

An FTP server with TLS encryption

A Windows server file share on Azure

What can be used to view warehouse usage over time? (Select Two).

The WAREHOUSE_METERING__HISTORY View

The billing and usage tab in the Snowflake web Ul

How would you determine the size of the virtual warehouse used for a task?

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Via the Snowflake Web Interface (Ul)

Via the data_share=true parameter

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

The primary cluster in the virtual warehouse

The database in which the virtual warehouse resides

The Queries currently being run on the virtual warehouse

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

The user has the appropriate privileges on the objects associated with the query

The query has been run within 24 hours of the previously-run query

The user has the appropriate privileges on the objects associated with the query

Micro-partitions have been reclustered since the query was last run

The new query is run using the same virtual warehouse as the previous query

The query includes a User Defined Function (UDF)

The query has been run within 24 hours of the previously-run query

Which of the following are benefits of micro-partitioning? (Select TWO)

Micro-partitions are immutable objects that support the use of Time Travel.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

Micro-partitions cannot overlap in their range of values

Micro-partitions are immutable objects that support the use of Time Travel.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

Rows are automatically stored in sorted order within micro-partitions

Micro-partitions can be defined on a schema-by-schema basis

What is the minimum Snowflake edition required to create a materialized view?

Virtual Private Snowflake Edition

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Data is hashed by the cluster key to facilitate fast searches for common data values

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Smaller micro-partitions are created for common data values to allow for more parallelism

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Which feature is only available in the Enterprise or higher editions of Snowflake?

Multi-factor Authentication (MFA)

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Queries on the table are running slower than expected

The clustering depth for the table is large

The table contains a column that has very low cardinality

DML statements that are being issued against the table are blocked

The table has a small number of micro-partitions

Queries on the table are running slower than expected

The clustering depth for the table is large

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.Which statements will provide this access?

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

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

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

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

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

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

Question 1 / 40

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

It removes the last element of the outer array.

It removes the outer array structure and loads the records into separate table rows,

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Comment (0)

Snowflake SnowPro Core Practice Test 1

Question

Snowflake SnowPro Core Practice Tests

Practice Tests