Free Practice Questions for Snowflake COF-C02 Exam

Answer : A, C

Snowflake allows secure data sharing for specific database objects to ensure data is shared securely and efficiently. The primary objects that can be shared securely are tables and secure views.

Tables: Share actual data stored in tables.

Secure Views: Share derived data while protecting the underlying table structures and any sensitive information.

Snowflake Documentation: Introduction to Secure Data Sharing

Snowflake Documentation: Creating Secure Views

Answer : A, D

When creating a virtual warehouse in Snowflake, users have the option to set several properties to manage its behavior and resource usage. Two of these optional properties are Auto-suspend and Resource monitor.

Auto-suspend: This property defines the period of inactivity after which the warehouse will automatically suspend. This helps in managing costs by stopping the warehouse when it is not in use.

CREATE WAREHOUSE my_warehouse

WITH WAREHOUSE_SIZE = 'XSMALL'

AUTO_SUSPEND = 300; -- Auto-suspend after 5 minutes of inactivity

Resource monitor: Users can assign a resource monitor to a warehouse to control and limit the amount of credit usage. Resource monitors help in setting quotas and alerts for warehouse usage.

CREATE WAREHOUSE my_warehouse

WITH WAREHOUSE_SIZE = 'XSMALL'

RESOURCE_MONITOR = 'my_resource_monitor';

Snowflake Documentation: Creating Warehouses

Snowflake Documentation: Resource Monitors

Answer : D

The VALIDATE command in Snowflake is used to check for errors that occurred during the execution of a COPY INTO <table> statement. This command helps users identify and resolve data loading issues.

Run the COPY INTO Statement: Execute the COPY INTO <table> command to load data from a stage into a table.

COPY INTO my_table

FROM @my_stage

FILE_FORMAT = (FORMAT_NAME = 'my_format');

Validate the Load: Use the VALIDATE function to see if there were any errors during the data load.

SELECT *

FROM TABLE(VALIDATE(my_table, JOB_ID => 'my_copy_job_id'));

Review Errors: The VALIDATE function will return details about any errors that occurred, such as parsing errors or data type mismatches.

Snowflake Documentation: Validating Data Loads

Snowflake Documentation: COPY INTO <table>

Answer : D

The TO_JSON function in Snowflake is used to convert a relational table or individual rows into JSON format. This function is helpful for exporting data in JSON format.

Using TO_JSON Function:

SELECT TO_JSON(OBJECT_CONSTRUCT(*))

FROM my_table;

Exporting Data: The TO_JSON function converts the table rows into JSON format, which can then be exported to a file.

Snowflake Documentation: TO_JSON Function

Snowflake Documentation: Exporting Data

Answer : B

The most effective way for a data provider to validate secure view configurations is to create a data share for a test data consumer account. This method allows the provider to review and confirm that only the intended data is accessible in the secure view. Secure views are designed to mask or restrict data visibility, so creating a test share replicates the consumer's experience and ensures data security before sharing with actual consumers.