最新のDEA-C02問題集で試験を準備する

Snowflake DEA-C02 試験概要:

Snowflake DEA-C02 試験シラバストピック:

Snowflake SnowPro Advanced: Data Engineer (DEA-C02) 認定 DEA-C02 試験問題：

問題 #1

A data engineering team is responsible for an ELT pipeline that loads data into Snowflake. The pipeline has two distinct stages: a high- volume, low-complexity transformation stage using SQL on raw data, and a low-volume, high-complexity transformation stage using Python UDFs that leverages an external service for data enrichment. The team is experiencing significant queueing during peak hours, particularly impacting the high-volume stage. You need to optimize warehouse configuration to minimize queueing. Which combination of actions would be MOST effective?

A. Create two separate warehouses: a Small warehouse configured for auto-suspend after 5 minutes for the high-volume, low-complexity transformations and a Large warehouse configured for auto-suspend after 60 minutes for the low-volume, high-complexity transformations.
B. Create a single, large (e.g., X-Large) warehouse and rely on Snowflake's automatic scaling to handle the workload.
C. Create two separate warehouses: a Medium warehouse for the high-volume, low-complexity transformations and an X-Small warehouse for the low-volume, high-complexity transformations.
D. Create two separate warehouses: a Large, multi-cluster warehouse configured for auto-scale for the high-volume, low-complexity transformations and a Small warehouse for the low-volume, high-complexity transformations.
E. Create a single, X-Small warehouse and rely on Snowflake's query acceleration service to handle the workload.

問題 #2

You are tasked with implementing a projection policy in Snowflake to restrict access to certain columns of the 'EMPLOYEE table based on the user's role. The table contains columns like 'EMPLOYEE 'NAME, 'SALARY', and 'DEPARTMENT. Users with the 'HR MANAGER role should have access to all columns, while other users should only be able to see 'EMPLOYEE ID, 'NAME, and DEPARTMENT. The initial attempt to create the projection policy results in an error. What could be the reasons?

A. The user attempting to create the projection policy does not have the 'OWNERSHIP' privilege on the 'EMPLOYEE table.
B. The projection policy definition might contain syntax errors or reference non-existent roles or columns.
C. Projection policies are not supported in Snowflake.
D. The EMPLOYEE table must have row-level security policies enabled before applying a projection policy.
E. Projection policies can only be applied at the database level, not at the table level.

問題 #3

A provider account is sharing a database named 'SHARED DB' through a share named 'MY SHARE. The consumer account has created a database named 'CONSUMER DB' from the share. The provider account revokes access to a table named 'SALES DATA within 'SHARED DB'. What will happen when a user in the consumer account attempts to query 'CONSUMER DB.SHARED SCHEMA.SALES DATA'?

A. The query will execute successfully, but the user will receive an empty result set.
B. The query will execute successfully, but only return data that existed before the access was revoked.
C. The query will be cached based on the initial access, so users can continue query previous result based on same SQL
D. The query will be automatically re-routed to another available share containing 'SALES DATA'.
E. The query will fail with an error message indicating that the table does not exist or the user does not have privileges.

問題 #4

You are tasked with creating a Snowpark Java stored procedure to calculate a complex, custom rolling average for a time series dataset. This rolling average requires access to external libraries for statistical calculations. Which of the following steps are necessary to successfully deploy and execute this stored procedure?

A. Package the Java code and all necessary external libraries into a single JAR file.
B. Upload the JAR file to a Snowflake stage.
C. Grant the necessary privileges on the stage and the database to the role executing the stored procedure.
D. Create a stored procedure in Snowflake, specifying the fully qualified path to the JAR file in the stage, the handler class, and the return type.
E. All of the above.

問題 #5

A data engineering team is using Snowflake's data lineage features, and they need to audit changes to data masking policies applied to a table named 'EMPLOYEES'. They want to identify when a masking policy was added, modified, or removed from specific columns.
What are the recommended Snowflake features or audit logs that the data engineering team could use to get these requirements?

A. The 'OBJECT DEPENDENCIES' view in the ACCOUNT USAGE schema will directly track changes related to masking policies applied to tables since that is the best place for lineage information.
B. The Account Usage view 'POLICY REFERENCES coupled with 'QUERY HISTORY, filtering for 'ALTER TABLE MODIFY COLUMN SET MASKING POLICY statements and also comparing snapshots of the 'POLICY_REFERENCES' view over time.
C. The 'INFORMATION SCHEMA.POLICY REFERENCES view to determine what masking policies are currently in place. Then, combine that with the use of Snowflake's Alerting framework to get notified on the creation/removal of tables, and also on changes on the masking policies via SYSTEM$GET_PRIVILEGES() function.
D. Snowflake's native Data Lineage feature automatically captures all changes to data masking policies without any additional configuration, and those changes are then available to the data steward through the user interface.
E. Snowflake event tables provide complete audit trail capabilities. These tables capture all the events including policies.

解説：