Snowflake Exam ARA-R01 Topic 2 Question 28 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 28
Topic #: 2

[All ARA-R01 Questions]

What are characteristics of Dynamic Data Masking? (Select TWO).

AA masking policy that Is currently set on a table can be dropped.

BA single masking policy can be applied to columns in different tables.

CA masking policy can be applied to the value column of an external table.

DThe role that creates the masking policy will always see unmasked data In query results

EA masking policy can be applied to a column with the GEOGRAPHY data type.

Show Suggested Answer

Suggested Answer: C

For the configuration of data unloading in Snowflake, the valid option among the provided choices is 'C.' This is because Snowflake supports unloading data into Google Cloud Storage using the COPY INTO <location> command with specific configurations. The configurations listed in option C, such as Parquet file format with UTF-8 encoding and gzip compression, are all supported by Snowflake. Notably, Parquet is a columnar storage file format, which is optimal for high-performance data processing tasks in Snowflake. The UTF-8 file encoding and gzip compression are both standard and widely used settings that are compatible with Snowflake's capabilities for data unloading to cloud storage platforms. Reference:

Snowflake Documentation on COPY INTO command

Snowflake Documentation on Supported File Formats

Snowflake Documentation on Compression and Encoding Options

by Denny at Feb 12, 2025, 05:45 AM

Limited Time Offer

25%

Off

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Luis

10 days ago

Wait, can you apply Dynamic Data Masking to the data in my crystal ball? That would be a real magic trick!

upvoted 0 times

...

Vivienne

12 days ago

C is a bit of a head-scratcher. Applying a masking policy to an external table's value column? Hmm, I'm not so sure about that one.

upvoted 0 times

...

Elmer

13 days ago

E is probably not correct. I don't think Dynamic Data Masking can be applied to a GEOGRAPHY data type column. That just seems a bit too specific.

upvoted 0 times

...

Clemencia

1 months ago

D sounds like it could be a valid answer too. If the role that creates the masking policy can see the unmasked data, that's an important characteristic of Dynamic Data Masking.

upvoted 0 times

Carissa

3 days ago

A) A masking policy that Is currently set on a table can be dropped.

upvoted 0 times

...

Belen

2 months ago

I'm not sure about option D. I think it might be option A and option C instead.

upvoted 0 times

...

Ocie

2 months ago

I agree with Weldon. Applying a single masking policy to columns in different tables and the role creating the policy always seeing unmasked data make sense.

upvoted 0 times

...

2 months ago

I think characteristics of Dynamic Data Masking include option B and option D.

upvoted 0 times

...