What happens when a network policy includes values that appear in both the allowed and blocked IP address list?

Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.

Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.

Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list

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.

Snowflake COF-C02 Practice Test 14 - Free Online Exam Prep & Questions

How can a user get the MOST detailed information about individual table storage details in Snowflake?

Become a Premium Member for full access

Unlock Premium Member

Snowflake COF-C02 Practice Test 14

Question

Snowflake COF-C02 Practice Tests

Practice Tests