Question 270
An application team must address both issues before release. A query needs to return a computed tax multiplier for one input amount, and a team proposes a full trigger-based process. A team grants a view SELECT permission and assumes this alone makes rows from every underlying table safe for all tenants. Which response best addresses these needs?
Explanation
Correct Answer
First, a scalar calculation produces one result from inputs without needing write-time side effects. Second, view access alone is not proof of full tenant isolation without evaluating underlying access paths.
Incorrect Answers
Use a deterministic scalar function or expression appropriate to the platform and performance requirements.
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: a scalar calculation produces one result from inputs without needing write-time side effects.
Use a deterministic scalar function or expression appropriate to the platform and performance requirements; create a view exposing only approved columns and predicates with appropriate permissions and schema review: view access alone is not proof of full tenant isolation without evaluating underlying access paths.



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