Online Access Free DEA-C02 Practice Test
| Exam Code: | DEA-C02 |
| Exam Name: | SnowPro Advanced: Data Engineer (DEA-C02) |
| Certification Provider: | Snowflake |
| Free Question Number: | 354 |
| Posted: | Nov 15, 2026 |
A financial institution needs to implement both dynamic data masking and column-level security on the 'CUSTOMER DATA table, which contains sensitive information like 'CREDIT CARD NUMBER and 'SSN'. The requirement is: all users except those in the 'DATA ADMIN' role should see masked credit card numbers (last 4 digits unmasked) and masked SSNs. Users in 'DATA ADMIN' should see the original data'. Which of the following combination of policies and grants will achieve this?
You are designing a Snowpipe pipeline to ingest data from an AWS SQS queue. The queue contains notifications about new files arriving in an S3 bucket. However, due to network issues, some notifications are delayed, causing Snowpipe to potentially miss files. Which of the following strategies, when combined, will BEST address the problem of delayed notifications and ensure data completeness?
You are developing a Snowpark Python application that reads data from a large Snowflake table, performs several transformations, and then writes the results back to a new table. You notice that the write operation is taking significantly longer than the read and transformation steps. The target table is not clustered. Which of the following actions, either individually or in combination, would likely improve the write performance most significantly ?
You're tasked with building an external function in Snowflake that calls an API to enrich customer data with geographical information (latitude and longitude) based on their IP address. The API endpoint requires an API key passed in the headen Your external function definition looks like this: "'sql CREATE OR REPLACE EXTERNAL FUNCTION VARCHAR) RETURNS VARIANT VOLATILE MAX BATCH ROWS = 100 RETURNS NULL ON NULL INPUT API INTEGRATION = AS 'https://api.example.com/geo'; Which of the following steps are essential to ensure the external function correctly passes the API key to the external service, handles rate limiting from the API, and correctly parses the JSON response from the external service (Assume the API returns a JSON object with 'latitude' and 'longitude' fields)?
You are tasked with building a User-Defined Aggregate Function (UDAF) in Snowflake to calculate the weighted average of product prices. The weight is determined by the quantity sold for each product. You have the following table: 'SALES (product_id INTEGER, price quantity INTEGER)'. Which of the following UDAF definitions would correctly calculate the weighted average?