A Company Uses Amazon Redshift as Its Data Warehouse

question 114

Multiple Choice

A company uses Amazon Redshift as its data warehouse. A new table has columns that contain sensitive data. The data in the table will eventually be referenced by several existing queries that run many times a day. A data analyst needs to load 100 billion rows of data into the new table. Before doing so, the data analyst must ensure that only members of the auditing group can read the columns containing sensitive data. How can the data analyst meet these requirements with the lowest maintenance overhead?

• A) Load all the data into the new table and grant the auditing group permission to read from the table. Load all the data except for the columns containing sensitive data into a second table. Grant the appropriate users read-only permissions to the second table.
• B) Load all the data into the new table and grant the auditing group permission to read from the table. Use the GRANT SQL command to allow read-only access to a subset of columns to the appropriate users.
• C) Load all the data into the new table and grant all users read-only permissions to non-sensitive columns. Attach an IAM policy to the auditing group with explicit ALLOW access to the sensitive data columns.
• D) Load all the data into the new table and grant the auditing group permission to read from the table. Create a view of the new table that contains all the columns, except for those considered sensitive, and grant the appropriate users read-only permissions to the table.

---

Definitions:

Body Alignment

The optimal positioning of body parts related to one another to maintain a good posture and reduce strain.

Feet Support

The provision of adequate cushioning, alignment, and comfort for the feet, often through specialized footwear or orthotics, to prevent or mitigate pain and injury.

Sitting Position

A posture where the weight of the body is supported by the buttocks rather than the feet and is common in many daily activities.

Metabolic Alteration

Changes in the body's metabolic processes, which can affect how it converts food and oxygen into energy.