Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?

Multi-Factor Authentication (MFA)

Which of the following SQL statements will list the version of the drivers currently being used?

Execute SELECT CURRENT_JDBC_VERSION() ; from SnowSQL

Execute SELECT CURRENT_ODBC_CLlENT(); from the Web Ul

Execute SELECT CURRENT_JDBC_VERSION() ; from SnowSQL

Execute SELECT CURRENT_CLIENT(); from an application

Execute SELECT CURRENT_VERSION (); from the Python Connector

When should a stored procedure be created with caller's rights?

When the stored procedure needs to run with the privileges of the role that called the stored procedure

When the caller needs to be prevented from viewing the source code of the stored procedure

When the caller needs to run a statement that could not execute outside of the stored procedure

When the stored procedure needs to run with the privileges of the role that called the stored procedure

When the stored procedure needs to operate on objects that the caller does not have privileges on

What happens to the privileges granted to Snowflake system-defined roles?

The privileges cannot be revoked.

The privileges can be revoked by an ACCOUNTADMIN.

The privileges can be revoked by an orgadmin.

The privileges can be revoked by any user-defined role with appropriate privileges.

When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY <expression> parameter option?

To split the output into multiple files, one for each distinct value of the specified expression.

To sort the contents of the output file by the specified expression.

To delimit the records in the output file using the specified expression.

To include a new column in the output using the specified window function expression.

To split the output into multiple files, one for each distinct value of the specified expression.

What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?

Slower query performance and increased storage consumption

Faster query performance and increased storage consumption

Slower query performance and increased storage consumption

Faster query performance and decreased storage consumption

Slower query performance and decreased storage consumption

How does the Access_History view enhance overall data governance pertaining to read and write operations? (Select TWO).

Provides a unified picture of what data was accessed and when it was accessed

Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy

Shows how the accessed data was moved from the source lo the target objects

Provides a unified picture of what data was accessed and when it was accessed

Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime

Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data

Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy

When does a materialized view get suspended in Snowflake?

When a column is dropped from the base table

When a column is added to the base table

When a column is dropped from the base table

When a DML operation is run on the base table

When the base table is reclustered

What does a table with a clustering depth of 1 mean in Snowflake?

The table has no overlapping micro-partitions.

The table has only 1 micro-partition.

The table has 1 overlapping micro-partition.

The table has no overlapping micro-partitions.

The table has no micro-partitions.

What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

The length of time the compute resources in each cluster run

The type of SQL statements executed

The number of tables or databases queried

The amount of data stored in the warehouse

The length of time the compute resources in each cluster run

What does the Activity area of Snowsight allow users to do? (Select TWO).

Explore each step of an executed query.

Monitor queries executed by users in an account.

Schedule automated data backups.

Explore each step of an executed query.

Monitor queries executed by users in an account.

Create and manage user roles and permissions.

Access Snowflake Marketplace to find and integrate datasets.

When a Snowflake user loads CSV data from a stage, which copy into <table> command guideline should they follow?

The number of columns in each row should be consistent.

The CSV field delimiter must be a comma character (*,'),

The number of columns in each row should be consistent.

The data file in the stage must be in a compressed format.

The data file must have the same number of columns as the target table.

Who can activate a network policy for users in a Snowflake account? (Select TWO)

Any role that has the global ATTACH POLICY privilege

Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?

MODIFY, MONITOR and OPERATE privileges

APPLYBUDGET and audit privileges

MANAGE LISTING ADTOTOLFillment and resolve all privileges

In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).

Column-level security limits access to specific columns within a table based on user privileges

Column-level security allows the application of a masking policy to a column within a table or view.

Implementation of column-level security will optimize query performance.

Column-level security supports encryption of the entire database.

Column-level security ensures that only the table owner can access the data.

Column-level security limits access to specific columns within a table based on user privileges

Column-level security allows the application of a masking policy to a column within a table or view.

How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?

Create transient tables and periodically copy them to permanent tables.

Create temporary tables and periodically copy them to permanent tables

Create regular tables with extended Time Travel and Fail-safe settings.

Create regular tables with default Time Travel and Fail-safe settings

How does Snowflake utilize clustering information to improve query performance?

It prunes unnecessary micro-partitions based on clustering metadata.

It compresses the data within micro-partitions for faster querying.

It automatically allocates additional resources to improve query execution.

It organizes clustering information to speed-up data retrieval from storage

How can staged files be removed during data loading once the files have loaded successfully?

Use the LOAD UNCERTAIN FILES copy option.

When an object is created in Snowflake. who owns the object?

The current active primary role

What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY view?

Virtual Private Snowflake (VPS)

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

Spam

Selling illegal goods, money scams etc.

Hate Speech

Serious attack on a group.

Harassment and bullying

Harassing an individual (including doxing)

Harmful activities

Threatening or glorifying violence or serious harm, including self-harm

Adult content (Consensual)

Nudity/Sexual content

Sexual exploitation and abuse (child safety)

Sexually explicit or suggestive imagery or writing involving minors

Sexual exploitation and abuse (adults and animals)

Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans

Plagiarism

Reusing content without attribution (link and blockquotes)

Poorly written

Not in English or has very bad formatting, grammar, and spelling

Inappropriate credential

Author's credential is offensive, spam, or impersonation

Other

Ex. Illegal content, incomplete question...

Snowflake COF-C02 Practice Test 16

Question

Snowflake COF-C02 Practice Tests

Practice Tests