What do temporary and transient tables have m common in Snowflake? (Select TWO).

Both tables have no Fail-safe period.

For both tables the retention period ends when the tables are dropped.

Both tables have no Fail-safe period.

Both tables have data retention period maximums of one day.

Both tables are visible only to a single user session.

For both tables the retention period ends when the tables are dropped.

For both tables, the retention period does not end when the session ends

Which statements reflect valid commands when using secondary roles? (Select TWO).

USE SECONDARY ROLES ADD <Role Name>

What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?

The user should be required to use Multi-Factor Authentication (MFA).

The ACCCUKTMKIN role should be set as tie user's default role.

The user should use federated authentication instead of a password

The user should be required to use Multi-Factor Authentication (MFA).

There should be just one user with the ACCOUNTADMIN role in each Snowflake account.

A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?

The file loading could be aborted without any portion of the file being committed.

The file will continue to load until all contents arc loaded.

The tile will slop loading and all data up to that point will be committed.

The file loading could be aborted without any portion of the file being committed.

The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake

Which user preferences can be set for a user profile in Snowsight? (Select TWO).

Multi-Factor Authentication (MFA)

How does the search optimization service help Snowflake users improve query performance?

II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.

It scans the micro-partitions based on the joins used in the queries and scans only join columns.

II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.

It scans the local disk cache to avoid scans on the tables used in the Query.

It keeps track of running queries and their results and saves those extra scans on the table.

How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

Access privileges are assigned to roles. which are in turn assigned to use's

A defined level of access to an object

An entity in which access can be granted

Each object has an owner, who can in turn grail access to that object.

Access privileges are assigned to roles. which are in turn assigned to use's

If a virtual warehouse is suspended, what happens to the warehouse cache?

The cache is dropped when the warehouse is suspended and is no longer available upon restart.

The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.

The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.

The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.

Who can create network policies within Snowflake? (Select TWO).

A role with the CREATE NETWORK POLICY privilege

A role with the CREATE SECURITY INTEGRATION privilege

Which statement describes Snowflake tables?

Snowflake tables arc logical representation of underlying physical data.

Snowflake tables are the physical instantiation of data loaded into Snowflake.

Snowflake tables require that clustering keys be defined lo perform optimally.

Snowflake tables are owned by a use.

What are the main differences between the account usage views and the information schema views? (Select TWO).

Account issue views contain dropped objects but information schema views do not.

Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

No active warehouse to needed to query account usage views but one is needed to query information schema views.

Account usage views do not contain data about tables but information schema views do.

Account issue views contain dropped objects but information schema views do not.

Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

Information schema views are read-only but account usage views are not.

Which Snowflake database object can be shared with other accounts?

Secure User-Defined Functions (UDFs)

Snowflake's access control framework combines which models for securing data? (Select TWO).

Discretionary Access Control (DAC)

Role-based Access Control (RBAC)

Attribute-based Access Control (ABAC 1

Discretionary Access Control (DAC)

Role-based Access Control (RBAC)

Rule-based Access Control (RuBAC)

What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?

Connect through Snowflake's JDBC or ODBC drivers

Contact Snowflake Support for a new driver.

Connect through Snowflake's JDBC or ODBC drivers

How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

Set the WAREHOUSES_SIZE to 6XL.

Set the STATEMENT_TIMEOUT_1M_SECOMES to 0.

Set the MAX_CONCURRENCY_LEVEL to a value of 12 or large.

Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

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

Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

Become a Premium Member for full access

Unlock Premium Member

Snowflake SnowPro Core Practice Test 14

Question

Snowflake SnowPro Core Practice Tests

Practice Tests