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

Question

You have a table named 'SALES DATA' in your Snowflake account. You want to create a clone of this table for testing purposes, but you also want to mask certain columns containing sensitive customer information (e.g., email addresses, phone numbers) in the cloned table. How can you achieve this with minimal impact on performance and storage?

Options

• ACreate a clone of 'SALES DATA' using 'CREATE TABLE TEST SALES DATA CLONE SALES
• BCreate a clone of 'SALES DATA' using 'CREATE TABLE TEST SALES DATA CLONE SALES
• CExport the data from 'SALES DATA' to cloud storage, apply masking to the sensitive columns
• DCreate a view on top of 'SALES DATA' with masking logic for the sensitive columns, and then
• ECreate a clone of 'SALES_DATX using 'CREATE TABLE CLONE SALES_DATA;' then create a

Explanation

The most efficient way is to clone the table and then apply masking policies on the cloned table. Masking policies ensure that data is masked dynamically without altering the underlying data in the original table. This approach minimizes storage usage (due to zero-copy cloning) and performance impact (since masking policies are optimized by Snowflake). Option A is manual and not scalable. Option C involves data export/import which is slower and consumes more resources. Cloning the view doesn't clone underlying data, so it's not suitable for testing changes on data. Option E requires ongoing processing to apply masking periodically.

No community discussion yet for this question.