Question 50
A warehouse should allow interns to query aggregated metrics but not raw personal records. Which test result satisfies the scenario?
Explanation
Correct Answer
This directly verifies the intended outcome: Secure projections reduce exposure while preserving useful analytic access. The accepted result is: Intern queries succeed against summaries and fail against personal records.
Incorrect Answers
Data duplication creates additional sensitive exposure.
Discovery hiding is not necessarily a SQL permission boundary.
Interns retrieve identifiable records.