SOL-C01 Question #222: Real Exam Question with Answer & Explanation

Question

You are working with a Snowflake database that contains sensitive personal data. You need to create a development environment for testing purposes, but you want to ensure that the personal data in the development environment is anonymized while maintaining referential integrity between tables. You have the following tables with foreign key relationships: 'CUSTOMERS' (CustomerlD, FirstName, LastName, Email, Phone) 'ORDERS (OrderlD, CustomerlD, OrderDate, TotalAmount) Which of the following approaches would be the most secure and efficient for creating the anonymized development environment, while still enabling the referential integrity between the tables?

Options

• AClone the 'CUSTOMERS and `ORDERS tables to the development environment. Then, manually
• BClone the 'CUSTOMERS' and 'ORDERS' tables to the development environment. Create masking
• CExport the data from the 'CUSTOMERS' and `ORDERS tables to cloud storage, anonymize the
• DClone the `CUSTOMERS and 'ORDERS' tables to the development environment. Create a new
• EClone the `CUSTOMERS and 'ORDERS' tables to the development environment. Create masking

Explanation

Option D represents the best balance of security, efficiency, and maintainability of referential integrity. Cloning the table and then creating a new table with masked data and sequential numbering will keep ORDERS' and 'CUSTOMER referentially valid for testing. Options A and C involve manual processes, which are less secure and difficult to scale. Option B doesn't resolve the 'CUSTOMERID' problem when masking is required, but also ensures that it is updated with new sequential values in 'ORDER table, thus not the best answer. Option E relies on the masking of the columns but doesn't address changing the identifying CUSTOMERID column.

No community discussion yet for this question.