Analysts need to query employee names, departments and hire dates from an employee table that also contains salary. They must never see salary, the data they query must always be current, and the DBA does not want to duplicate the data in another table. What should the DBA do?
Select an answer to reveal the explanation.
Short Explanation
A view is like giving someone a window into a room instead of the key to the door: they see exactly what you framed for them and nothing else. You grant access to the view, not the table, so the salary column simply isn't there to query. A policy memo or a hidden column in a tool is a curtain, not a wall.
Full Explanation
A view is a stored query that presents a virtual table; selecting from it runs the underlying query against the base table, so results are always current and no data is duplicated. Defining a view that includes only employee name, department and hire date, and granting analysts SELECT on the view while granting nothing on the base table, enforces column-level restriction in the database. Analysts cannot reference salary because it is not part of the object they are permitted to query. Granting SELECT on the base table with written instructions relies on user compliance; any analyst can still query salary, so the requirement that they must never see it is not technically enforced. A nightly copy into a separate table restricts columns but duplicates data and is up to a day stale, violating both the currency and no-duplication requirements. Hiding the column in a reporting tool is a presentation-layer control; anyone with SELECT on the base table can bypass the tool with another client and read salary directly. Exam caveat: some engines also support column-level privileges, but views remain the standard, portable mechanism for exposing a controlled subset and simplifying access. Operational check: create the view, grant SELECT on it to the analyst role, confirm the role has no privilege on the base table, and test as an analyst that querying salary or the base table fails.