Curious about Actual Snowflake SnowPro Certification (COF-C02) Exam Questions?

Correct : B

The query acceleration service in Snowflake is beneficial for workloads that include on-demand data analyses. This service optimizes query performance by dynamically allocating additional resources to execute queries faster, particularly useful for ad-hoc analysis where data volume and complexity can vary.

References:

Snowflake Documentation: Query Acceleration Service

Correct : C, E

To convert rows in a relational table to a single VARIANT column and unload the rows into a file in JSON format, you can use the COPY command in combination with the OBJECT_CONSTRUCT function. The OBJECT_CONSTRUCT function converts the row into a JSON object stored in a VARIANT column, and the COPY command can then be used to unload this data into a JSON file.

References:

Snowflake Documentation: OBJECT_CONSTRUCT

Snowflake Documentation: COPY INTO <location>

Top of Form

Bottom of Form

Correct : C

Snowflake recommends removing data files from the staging area after they have been loaded into the target table. This practice ensures that the data is only loaded once and prevents accidental reloading of the same data. By removing the files, you eliminate the risk of duplicate data loads.

Stage the Data: Upload the data files to a Snowflake stage (internal or external).

Load the Data: Use the COPY INTO command to load the data from the stage into the Snowflake table.

Remove the Data Files: After successfully loading the data, remove the data files from the stage using the REMOVE command.

References:

Snowflake Documentation: Loading Data into Snowflake

Snowflake Documentation: Staging Data Files

Snowflake Documentation: COPY INTO Command

Correct : A

In Snowflake, the APPLY privilege is required to set a masking policy on a table or view column. This privilege allows a user to associate a masking policy with a specific column, thereby controlling how data in that column is masked or hidden.

Create a Masking Policy: Define a masking policy using the CREATE MASKING POLICY command.

Grant APPLY Privilege: Grant the APPLY privilege on the masking policy to the relevant roles or users.

Apply the Masking Policy: Use the ALTER TABLE or ALTER VIEW command to apply the masking policy to a column.

References:

Snowflake Documentation: Data Masking

Snowflake Documentation: CREATE MASKING POLICY

Snowflake Documentation: Privileges for Masking Policies

Correct : A

The Query Profile in Snowflake provides detailed insights into the execution of a query. It helps in troubleshooting performance issues by showing the steps of the query execution and the resources consumed. One of the key aspects it reveals is whether the virtual warehouse memory was sufficient for the query.

Access Query Profile: Navigate to the Query History page and select the query you want to analyze.

Examine Query Execution Steps: The Query Profile displays the different stages of the query execution, including the time taken and resources used at each step.

Identify Memory Issues: Look for indicators of memory issues, such as spilling to disk or memory errors, which suggest that the virtual warehouse memory might be too small.

References:

Snowflake Documentation: Query Profile

Snowflake Documentation: Optimizing Queries