Question 850
A scheduled job needs to create records but its credential also permits DROP DATABASE and changing security principals. Which action best addresses the database requirement?
Explanation
Correct Answer
Least privilege limits the impact of compromised automation credentials and reduces accidental destructive changes.
Incorrect Answers
Grant narrowly scoped SELECT and EXECUTE rights to the intended objects and remove unnecessary elevated server roles: grant narrowly scoped SELECT and EXECUTE rights to the intended objects and remove unnecessary elevated server roles: object-level privileges satisfy specific application needs without broad database administration authority; Assign a constrained service identity with the minimum insert and procedure rights needed for the job.
Explicitly review and grant supported object or schema permissions for each authorized role: explicitly review and grant supported object or schema permissions for each authorized role: object ownership and user authorization are different concepts and should not be conflated; Assign a constrained service identity with the minimum insert and procedure rights needed for the job.
Review all effective role memberships and revoke the unauthorized base-table access before relying on the view as a boundary: review all effective role memberships and revoke the unauthorized base-table access before relying on the view as a boundary: permissions are cumulative through roles; hiding a column in one view does not revoke other direct paths; Assign a constrained service identity with the minimum insert and procedure rights needed for the job.



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