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

Virtual Private Snowflake (VPC)

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.

Where can a user find and review the failed logins of a specific user for the past 30 days?

The LOGIN_HISTORY view in ACCOUNT_USAGE

The USERS view in ACCOUNT_USAGE

The LOGIN_HISTORY view in ACCOUNT_USAGE

The ACCESS_HISTORY view in ACCOUNT_USAGE

The SESSIONS view in ACCOUNT_USAGE

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Snowflake leverages a Role-Based Access Control (RBAC) model.

All data in Snowflake is encrypted.

Snowflake leverages a Role-Based Access Control (RBAC) model.

Snowflake requires a user to configure an IAM user to connect to the database.

All data in Snowflake is encrypted.

Snowflake can run within a user's own Virtual Private Cloud (VPC).

All data in Snowflake is compressed.

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Stopping the virtual warehouse that the query is running against

Executing the RESULTS_SCAN() table function

Removing a column from the query SELECT list

Stopping the virtual warehouse that the query is running against

Clustering of the data used by the query

Executing the RESULTS_SCAN() table function

Changing a column that is not in the cached query

Which statement is true about running tasks in Snowflake?

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task can be called using a CALL statement to run a set of predefined SQL commands.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task allows a user to execute a set of SQL commands on a predefined schedule.

A task can be executed using a SELECT statement to run a predefined SQL command.

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

When the system has enough load for 2 minutes

When the system has enough load for 6 minutes

When the system has enough load for 8 minutes

When the system has enough load for 10 minutes

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.

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Configure the warehouse to a size larger than generally required

Set the minimum and maximum clusters to autoscale

Use the standard warehouse scaling policy

Use the economy warehouse scaling policy

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Force an immediate password change.

Set a default role for the user.

Configure the user to be initially disabled.

Force an immediate password change.

Set a default role for the user.

Set the number of minutes to unlock to 15 minutes.

Set the user's access to expire within a specified timeframe.

Which statement MOST accurately describes clustering in Snowflake?

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

The clustering key must be included in the COPY command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

The clone is created almost instantly.

The clone saves space by not duplicating storage.

The clone always stays in sync with the original table.

The clone has better query performance.

The clone is created almost instantly.

The clone will have time travel history from the original table.

The clone saves space by not duplicating storage.

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

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

The user who created the object

The SYSADMIN role

Ownership depends on the type of object

The role used to create the object

Comment (0)

Snowflake COF-C02 Practice Test 5

Question

Snowflake COF-C02 Practice Tests

Practice Tests