An HR team wants staff to query employee records without seeing salary columns. The administrator defines a saved SELECT that exposes only the permitted columns. Which object does this describe?
Show answer and explanation
Answer: A
A view is a named query that behaves as a virtual table. It can omit sensitive columns, so users see only what they are permitted to see. Its results are derived from the base tables when queried, unless it is an indexed view. A full backup copies the database, an index orders storage for lookups, and a trigger runs in response to data changes.
Why the other options are wrong
- B. A full database backup is a copy of the database used for recovery. It does not filter which columns users can query in a live database.
- C. A clustered index determines the physical order of rows. It has no role in restricting which columns a user is permitted to read.
- D. A trigger runs code automatically when rows are inserted, updated or deleted. It is not a saved query that presents a subset of columns.