2026년 현재 Snowflake SnowPro Advanced: Data Engineer (DEA-C02)은 IT 인증 가운데서도 높은 관심을 받는 시험입니다. KoreaDumps의 DEA-C02 연습문제로 이 인기 자격에 도전해 보시기 바랍니다.

Snowflake DEA-C02 시험 개요:

Snowflake DEA-C02 시험 요강 주제:

DEA-C02 시험 준비, 자주 묻는 질문으로 정리했습니다

최신 SnowPro Advanced DEA-C02 무료샘플문제

문제 #1

You are building a data pipeline in Snowflake using Snowpark Python. As part of the pipeline, you need to create a dynamic SQL query to filter records from a table named 'PRODUCT REVIEWS based on a list of product categories. The list of categories is passed to a stored procedure as a string argument, where categories are comma separated. The filtered data needs to be further processed within the stored procedure. Which of the following approaches are MOST efficient and secure ways to construct and execute this dynamic SQL query using Snowpark?

A. Using Snowpark's on the list of product categories after converting them into a Snowflake array, and then using 'session.sql()' to execute the query.
B. Using Python's string formatting along with the and 'session.sql()' functions to build and execute the SQL query securely, avoiding SQL injection vulnerabilities.
C. Using Python's string formatting to build the SQL query directly, and then executing it using 'session.sql()'.
D. Constructing the SQL query using 'session.sql()' and string concatenation, ensuring proper escaping of single quotes within the product categories string.
E. Using the Snowpark "functions.lit()' function to create literal values from the list of product categories and incorporating them into the SQL query, then use 'session.sql()' to run it.

문제 #2

You are tasked with building a data pipeline that incrementally loads data from an external cloud storage location (AWS S3) into a Snowflake table named 'SALES DATA'. You want to optimize the pipeline for cost and performance. Which combination of Snowflake features and configurations would be MOST efficient and cost-effective for this scenario, assuming the data volume is substantial and constantly growing?

A. Develop a custom Python script that uses the Snowflake Connector for Python to connect to Snowflake and execute a COPY INTO command. Schedule the script to run on an EC2 instance using cron.
B. Use a Snowflake Task to regularly truncate and reload 'SALES DATA" from S3 using COPY INTO. This ensures data consistency.
C. Employ a third-party ETL tool to extract data from S3, transform it, and load it into Snowflake using JDBC. Schedule the ETL process using the tool's built-in scheduler.
D. Create an external stage pointing to the S3 bucket. Create a Snowpipe with auto-ingest enabled, using an AWS SNS topic and SQS queue for event notifications. Configure the pipe with an error notification integration to monitor ingestion failures.
E. Use a Snowflake Task scheduled every 5 minutes to execute a COPY INTO command from S3, with no file format specified, assuming the data is CSV and auto-detection will work.

문제 #3

You are tasked with creating a development environment from a production database named 'PROD DB'. This database contains sensitive data, and you need to mask the data in the development environment. You decide to use cloning and a transformation function during the cloning process. What is the MOST efficient approach to clone 'PROD DB' into a development database 'DEV DB' and mask sensitive data in the process?

A. Create a clone of 'PROD named 'DEV DB', then create views on 'DEV DB' using masking policies. Cloning the Views from 'PROD will automatically copy the masking policies.
B. Create a clone of 'PROD named 'DEV DB'. Define masking policies on the columns in 'PROD DB' before cloning. These policies will be automatically applied to the cloned tables in "DEV_DB' ensuring all data is masked during query time in the DEV environment.
C. Create a clone of 'PROD named 'DEV DB'. Create stored procedures on 'DEV DB' which apply masking at the query level. Cloning databases does not preserve masking policies from the Source database
D. Create a clone of 'PROD named 'DEV DB'. Create a warehouse for running masking policies. Then apply masking policies to the tables in 'DEV DB' Cloning masks the underlying data directly.
E. Clone 'PROD to ' DEV DB'. Export the data from 'DEV DB', transform it using a scripting language (e.g., Python), and then load the transformed data back into replacing the original data.

문제 #4

You are responsible for ensuring data consistency across multiple Snowflake tables involved in a financial reporting system. You've noticed discrepancies in aggregate calculations between a 'TRANSACTIONS" table and a summary table 'MONTHLY REPORTS'. The 'TRANSACTIONS' table is frequently updated via streams and tasks. Which combination of the following strategies would be MOST effective in identifying and resolving these inconsistencies in near real-time?

A. Utilize Snowflake's Time Travel feature to compare the ' TRANSACTIONS' table and 'MONTHLY _ REPORTS' table at a specific point in time and identify the changes that led to the discrepancies.
B. Implement data validation checks within the data pipeline (streams and tasks) that update the 'TRANSACTIONS' table to reject transactions that violate predefined business rules.
C. Create a Snowflake alert that triggers when the difference in the total 'SALE_AMOUNT between the 'TRANSACTIONS' table and 'MONTHLY REPORTS' exceeds a predefined threshold within a specified time window.
D. Use Snowflake's row access policies to restrict access to the 'TRANSACTIONS' table, forcing users to only access the 'MONTHLY REPORTS table.
E. Implement a Snowflake task that periodically recalculates the 'MONTHLY_REPORTS' table from the 'TRANSACTIONS table and compares the results with the existing data, logging any discrepancies. Use a smaller warehouse size to minimize cost.

문제 #5

You have a table 'EMPLOYEE DATA' containing Personally Identifiable Information (PII), including 'salary' and 'email'. You need to implement column-level security such that: 1) The 'salary' column is only visible to users in the 'FINANCE ROLE. 2) The 'email' column is masked with a SHA256 hash for all users except those in the 'HR ROLE. You create the following masking policies:

Which of the following SQL statements correctly applies these masking policies to the 'EMPLOYEE DATA table?

A. ALTER TABLE EMPLOYEE_DATA MODIFY COLUMN salary SET MASKING POLICY mask_salary; ALTER TABLE EMPLOYEE_DATA MODIFY COLUMN email SET MASKING POLICY mask email;
B. ALTER TABLE EMPLOYEE_DATAAPPLY MASKING POLICY mask_salary ON COLUMN salary; ALTER TABLE EMPLOYEE_DATAAPPLY MASKING POLICY mask email ON COLUMN email;
C. CREATE OR REPLACE TAG employee_data.salary VALUE 'mask_salary'; CREATE OR REPLACE TAG employee_data.email VALUE 'mask_email';
D. ALTER TABLE EMPLOYEE_DATA MODIFY COLUMN salary SET MASKING POLICY = mask_salary; ALTER TABLE EMPLOYEE_DATA MODIFY COLUMN email SET MASKING POLICY = mask email;
E. ALTER TABLE EMPLOYEE_DATAALTER COLUMN salary SET MASKING POLICY mask_salary; ALTER TABLE EMPLOYEE_DATAALTER COLUMN email SET MASKING POLICY mask email;

질문과 대답: