Question 730
An AI-enabled database project needs two corrections. A reporting team repeats the same approved customer-eligibility SELECT in twelve applications and wants one centrally maintained read definition. A team grants a view SELECT permission and assumes this alone makes rows from every underlying table safe for all tenants. What is the most appropriate plan for this situation?
Explanation
Correct Answer
First, views centralize query logic and can restrict presentation but do not replace all underlying access security. Second, view access alone is not proof of full tenant isolation without evaluating underlying access paths.
Incorrect Answers
Evaluate ownership chaining and implement explicit row-level and source permissions appropriate to the tenant boundary; do not create a view exposing only approved columns and predicates with appropriate permissions and schema review: create a view exposing only approved columns and predicates with appropriate permissions and schema review.
Create a view exposing only approved columns and predicates with appropriate permissions and schema review; use a deterministic scalar function or expression appropriate to the platform and performance requirements: view access alone is not proof of full tenant isolation without evaluating underlying access paths.
Choose an appropriate table-valued function and validate its plan behavior and input filtering; evaluate ownership chaining and implement explicit row-level and source permissions appropriate to the tenant boundary: views centralize query logic and can restrict presentation but do not replace all underlying access security.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests