exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 129 discussion

A company stores customer data tables that include customer addresses in an AWS Lake Formation data lake. To comply with new regulations, the company must ensure that users cannot access data for customers who are in Canada.

The company needs a solution that will prevent user access to rows for customers who are in Canada.

Which solution will meet this requirement with the LEAST operational effort?

  • A. Set a row-level filter to prevent user access to a row where the country is Canada.
  • B. Create an IAM role that restricts user access to an address where the country is Canada.
  • C. Set a column-level filter to prevent user access to a row where the country is Canada.
  • D. Apply a tag to all rows where Canada is the country. Prevent user access where the tag is equal to “Canada”.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
AgboolaKun
5 months, 3 weeks ago
Selected Answer: A
The solution that will meet the requirement with the least operational effort is A. Here's why: Row-level security: AWS Lake Formation provides built-in row-level security, which allows you to control access to specific rows in a table based on conditions. This is precisely what's needed in this scenario. Least operational effort: Once set up, this filter will automatically apply to all queries without needing to modify the data or create complex IAM policies. Scalability: As new data is added to the table, the filter will automatically apply, requiring no additional effort. Precision: It directly addresses the requirement by preventing access to rows where the country is Canada, without affecting other data.
upvoted 1 times
...
komorebi
8 months, 3 weeks ago
Selected Answer: A
Answer is A
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago