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

3 months 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

Louvenia

2 months ago

I believe B and D are the correct characteristics for Dynamic Data Masking.

upvoted 0 times

...

Elza

2 months ago

So, which characteristics do you think are correct for Dynamic Data Masking?

upvoted 0 times

...

Val

2 months ago

I agree, it's more likely that a masking policy can't be applied to a GEOGRAPHY data type column.

upvoted 0 times

...

Catalina

2 months ago

I think you're right, E does seem too specific for Dynamic Data Masking.

upvoted 0 times

...

4 months ago

I'm pretty sure A and B are the correct answers. Dynamic Data Masking is all about applying a policy to mask sensitive data, and that policy should be able to be dropped or applied across different tables.

upvoted 0 times