DAS-C01 · Question #167
A company uses Amazon Redshift as its data warehouse. A new table includes some columns that contain sensitive data and some columns that contain non-sensitive data. The data in the table eventually w
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #167. The question stem and answer options stay visible for context.
Question
A company uses Amazon Redshift as its data warehouse. A new table includes some columns that contain sensitive data and some columns that contain non-sensitive data. The data in the table eventually will be referenced by several existing queries that run many times each day. A data analytics specialist must ensure that only members of the company's auditing team can read the columns that contain sensitive data. All other users must have read-only access to the columns that contain non-sensitive data. Which solution will meet these requirements with the LEAST operational overhead?
Options
- AGrant the auditing team permission to read from the table
- BGrant all users read-only permissions to the columns that contain non-sensitive data
- CGrant all users read-only permissions to the columns that contain non-sensitive data
- DGrant the auditing team permission to read from the table
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.