Snowflake DEA-C02 Actual Free Exam Questions & Community Discussion

You are a data engineer responsible for data governance in a Snowflake environment. Your company has implemented data classification using tags to identify sensitive data'. The compliance team has requested a report detailing all tables and columns that contain PII data, specifically including the tag name, tag value, the fully qualified name of the table, and the column name. You have the necessary privileges to access the Snowflake metadata views. Which of the following queries would provide the MOST comprehensive and accurate report, considering performance and ease of understanding?

Your team is implementing Snowpipe Streaming to ingest data from multiple IoT devices into a Snowflake table. Each device sends data continuously, and it's crucial to minimize latency. However, you observe that some records are occasionally missing in the target table. You have verified that the devices are sending all data and the client-side application using Snowpipe Streaming is functioning correctly. Which of the following is the MOST likely cause of the missing records, and how can you address it?

A data engineer is tasked with optimizing a Snowflake data pipeline that ingests data from multiple external sources, transforms it, and loads it into a reporting table. The pipeline uses a series of Snowflake tasks orchestrated with a root task and child tasks. Performance monitoring shows inconsistent execution times for the transformation tasks. Which of the following strategies would provide the MOST granular insights into the performance bottlenecks within the pipeline and allow for targeted optimization?

You have a table 'ORDERS in your Snowflake database. You are implementing a new data transformation pipeline. Before deploying the pipeline to production, you want to validate the changes in a development environment. You decide to use Time Travel to create a snapshot of the 'ORDERS' table before the transformation and compare it with the transformed data'. Which sequence of SQL commands would best facilitate this validation, assuming your development database and schema structure mirrors production?

You are using Snowpark Python to perform a complex data transformation involving multiple tables and several intermediate dataframes. During the transformation, an error occurs within one of the Snowpark functions, causing the entire process to halt. To ensure data consistency, you need to implement transaction management. Which of the following Snowpark DataFrameWriter options or session configurations would be MOST appropriate for rolling back the entire transformation in case of an error during the write operation to the final target table?

Consider the following Snowflake Javascript UDF designed to convert temperatures between Celsius and Fahrenheit:

Which statement regarding the UDF's security and behavior is MOST accurate?

You are tasked with creating a JavaScript stored procedure in Snowflake to perform a complex data masking operation on sensitive data within a table. The masking logic involves applying different masking rules based on the data type and the column name. Which approach would be the MOST secure and maintainable for storing and managing these masking rules? Assume performance is not your primary concern but code reuse and maintainability is the most important thing.

You are implementing Snowpipe using the REST API for a custom data ingestion process. Your application uploads data files to an internal stage named '@MY STAGE and then calls the Snowpipe REST API to trigger the data load. However, you are encountering 'insufficient privileges' errors when calling the API, even though the role used to authenticate the API requests has the 'USAGE' privilege on the stage and the 'OPERATE' privilege on the pipe. The Pipe name is 'MY PIPE'. Which of the following is the MOST LIKELY cause of this error, and what can you do to resolve it?

A data pipeline ingests clickstream data from various sources into a raw Snowflake table CRAW CLICKS). A transformation job then processes this data and loads it into a more structured 'CLICK EVENTS table, performing filtering, cleaning, and data enrichment. The data engineering team notices significant performance bottlenecks during this transformation process, leading to data freshness issues.
The team wants to optimize this process, considering the following: