Exam DEA-C02 Topic 1 Question 303 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 303
Topic #: 1
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.

Suggested Answer: B,E Vote an answer

Options B and E are the most secure and maintainable. Storing the masking rules in a separate Snowflake table allows for easy modification and version control without altering the stored procedure code. Javascript UDFs make the logic reusable, maintainable and dynamic. Hardcoding the rules (A) makes maintenance difficult. JSON objects within code (C) are an improvement but are still embedded within the code. Using external stages (D) introduces dependencies and potential security risks if not managed carefully.

by Spring at Jul 17, 2025, 10:14 AM

Limited Time Offer

15%

Off

Get Premium DEA-C02 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10