Exam SnowPro Advanced Architect topic 1 question 87 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 87
Topic #: 1

[All SnowPro Advanced Architect Questions]

The following table exists in the production database:

A regulatory requirement states that the company must mask the username for events that are older than six months based on the current date when the data is queried.

How can the requirement be met without duplicating the event data and making sure it is applied when creating views using the table or cloning the table?

A. Use a masking policy on the username column using an entitlement table with valid dates.
B. Use a row level policy on the user_events table using an entitlement table with valid dates.
C. Use a masking policy on the username column with event_timestamp as a conditional column.
D. Use a secure view on the user_events table using a case statement on the username column.

Show Suggested Answer

Suggested Answer: C 🗳️

by NachoPrendes at July 18, 2024, 12:09 p.m.

Comments

Submit Cancel

ywan1600

3 weeks, 2 days ago

Selected Answer: C

C is correct, as ukpino explained in his second comment.

upvoted 1 times

...

ukpino

3 months ago

Selected Answer: A

C does not seem right, because event_timestamp does not matter, current date being queried does. A seems more accurate.

upvoted 1 times

ukpino

3 months ago

Actually changing to C, event-timestamp would be the column to be compared against the current datetime, C makes sense

upvoted 1 times

...

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam

Exam SnowPro Advanced Architect topic 1 question 87 discussion

Comments

ywan1600

ukpino

ukpino

SY0-701