Snowflake Updated COF-C02 Exam Questions and Answers by jad

To restrict access to Snowsight from a specific location, a network policy must be configured.

The network policy allows only specific IP addresses (e.g., home or office networks) to access the Snowflake account.

Example:

CREATE NETWORK POLICY my_policy

ALLOWED_IP_LIST = ('192.168.1.1', '203.0.113.0/24');

ALTER ACCOUNT SET NETWORK_POLICY = my_policy;

References:

Snowflake Documentation: Network Policies

The correct function to find the query ID of the second query executed in the current session is SELECT LAST_QUERY_ID(-2). The LAST_QUERY_ID function returns the query ID for the most recent query executed in the session when called with no arguments. When used with an argument, it can retrieve the ID of previous queries within the same session, where -2 would reference the second most recent query executed.

References:

There's a clarification needed here; Snowflake's documentation indicates LAST_QUERY_ID() function does not accept arguments. It returns the ID of the last query executed in the session. To find the query ID of the second last executed query, users typically need to track query IDs manually or use session history views.

Snowsight is the modern web interface for Snowflake with several advanced features:

Worksheet Sharing (A): Users can collaborate by sharing worksheets directly in Snowsight.

Snowflake Marketplace (C): Users can explore and access datasets and applications from third-party providers.

Why Other Options Are Incorrect:

B. Referencing SnowSQL: SnowSQL is a CLI tool, unrelated to Snowsight.

D. Changing the cloud provider: This cannot be performed from Snowsight.

E. Downloading results larger than 100 MB: This is a system limitation unrelated to Snowsight.

References:

Snowsight Overview

====================

Masking policies in Snowflake are created and applied at the column level. These policies are used to obfuscate sensitive data by masking the values in a specific column. Masking policies can enforce data privacy and protection measures by dynamically masking the data based on the role of the user querying the data.

References:

Snowflake Documentation: Dynamic Data Masking