What does a masking policy consist of in Snowflake?

A single data type, with one or more conditions, and one or more masking functions

A single data type, with only one condition, and only one masking function

Multiple data types, with only one condition, and one or more masking functions

Multiple data types, with one or more conditions, and one or more masking functions

A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.How can this be achieved?

Store the data in a table with a variant data type. Query the table.

Flatten the data and store it in structured data types in a flattened table. Query the table.

Store the data in a table with a variant data type. Query the table.

Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.

Store the data in an external stage and create views on top of it. Query the views.

For which use cases is running a virtual warehouse required? (Select TWO).

When unloading data from a table

What does SnowCD help Snowflake users to do?

Troubleshoot network connections to Snowflake.

Manage different databases and schemas.

Troubleshoot network connections to Snowflake.

Write SELECT queries to retrieve data from external tables.

How is unstructured data retrieved from data storage?

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

It removes object or array elements containing null values.

It removes null values from all columns in the data.

It converts null values to empty strings during loading.

It skips rows with null values during the loading process.

It removes object or array elements containing null values.

What does a Notify & Suspend action for a resource monitor do?

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.

Send an alert notification to all account users who have notifications enabled.

Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

What type of query will benefit from the query acceleration service?

Queries with large scans and selective filters

Queries without filters or aggregation

Queries with large scans and selective filters

Queries where the GROUP BY has high cardinality

Queries of tables that have search optimization service enabled

What is a characteristic of materialized views in Snowflake?

Multiple tables can be joined in the underlying query of a materialized view.

Materialized views do not allow joins.

Clones of materialized views can be created directly by the user.

Multiple tables can be joined in the underlying query of a materialized view.

Aggregate functions can be used as window functions in materialized views.

What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

The objects enter the Fail-safe period.

The objects enter the Time Travel period.

The objects are immediately moved to the provider account.

How should clustering be used to optimize the performance of queries that run on a very large table?

Choose one high cardinality column as the clustering key.

Manually re-cluster the table regularly.

Choose one high cardinality column as the clustering key.

Use the column that is most-frequently used in query select clauses as the clustering key.

Assess the average table depth to identify how clustering is impacting the query.

What step can reduce data spilling in Snowflake?

Using a larger virtual warehouse

Increasing the virtual warehouse maximum timeout limit

Increasing the amount of remote storage for the virtual warehouse

Using a common table expression (CTE) instead of a temporary table

What is the relationship between a Query Profile and a virtual warehouse?

A Query Profile can help users right-size virtual warehouses.

A Query Profile defines the hardware specifications of the virtual warehouse.

A Query Profile can help determine the number of virtual warehouses available.

A Query Profile automatically scales the virtual warehouse based on the query complexity.

What is the primary purpose of a directory table in Snowflake?

To store file-level metadata about data files in a stage

To store actual data from external stages

To automatically expire file URLs for security

To manage user privileges and access control

To store file-level metadata about data files in a stage

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

The separation allows independent scaling of computing resources.

Compute can be scaled up or down without the requirement to add more storage.

The separation allows independent scaling of computing resources.

The separation ensures consistent data encryption across all virtual data warehouses.

The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

Storage volume growth and compute usage growth can be tightly coupled.

Compute can be scaled up or down without the requirement to add more storage.

How can performance be optimized for a query that returns a small amount of data from a very large base table?

Use the search optimization service

Use the query acceleration service

What does the LATERAL modifier for the FLATTEN function do?

Joins information outside the object with the flattened data

Casts the values of the flattened data

Extracts the path of the flattened data

Joins information outside the object with the flattened data

Retrieves a single instance of a repeating element in the flattened data

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Warehouses can be started and stopped at any time.

Warehouses can be resized at any time, even while running.

Warehouses that are multi-cluster can have nodes of different sizes.

Warehouses can be started and stopped at any time.

Warehouses can be resized at any time, even while running.

Warehouses are billed on a per-minute usage basis.

Warehouses can only be used for querying and cannot be used for data loading.

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

MAX_DATA_EXTENSION_TIME_IN_DAYS

MIN_DATA_RETENTION_TIME_IN_DAYS

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;

CREATE TABLE <table_name> LIKE TABLE_A;

CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;

CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;

CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;

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

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

Become a Premium Member for full access

Unlock Premium Member

Snowflake COF-C02 Practice Test 10

Question

Snowflake COF-C02 Practice Tests

Practice Tests