ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
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
Go to Exam

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

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01
Question #: 157
Topic #: 1
[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

A company implements a data mesh that has a central governance account. The company needs to catalog all data in the governance account. The governance account uses AWS Lake Formation to centrally share data and grant access permissions.

The company has created a new data product that includes a group of Amazon Redshift Serverless tables. A data engineer needs to share the data product with a marketing team. The marketing team must have access to only a subset of columns. The data engineer needs to share the same data product with a compliance team. The compliance team must have access to a different subset of columns than the marketing team needs access to.

Which combination of steps should the data engineer take to meet these requirements? (Choose two.)

  • A. Create views of the tables that need to be shared. Include only the required columns.
  • B. Create an Amazon Redshift data share that includes the tables that need to be shared.
  • C. Create an Amazon Redshift managed VPC endpoint in the marketing team’s account. Grant the marketing team access to the views.
  • D. Share the Amazon Redshift data share to the Lake Formation catalog in the governance account.
  • E. Share the Amazon Redshift data share to the Amazon Redshift Serverless workgroup in the marketing team's account.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
by Parandhaman_Margan at Oct. 27, 2024, 5:17 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

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
Submit Cancel
Tester_TKK
3 days, 19 hours ago
Selected Answer: AB
B and D
upvoted 1 times
...
Eleftheriia
5 months, 3 weeks ago
Selected Answer: D
I think that D is one of the correct answers as described https://aws.amazon.com/blogs/big-data/centrally-manage-access-and-permissions-for-amazon-redshift-data-sharing-with-aws-lake-formation/
upvoted 3 times
...
ae35a02
6 months ago
i think not A because they say access and permissions are centrally managed in Lake Formation ... therefore : BD
upvoted 2 times
...
ae35a02
6 months ago
Selected Answer: BD
workgroups don't manage permission to tables and views, they manage resource allocation for queries execution.
upvoted 4 times
...
Parandhaman_Margan
6 months ago
Answer:AD
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago