Question 450
A database architect reviews two implementation risks. A database pipeline invokes an external model using a long-lived administrative API key stored in a publicly readable table. A GraphQL endpoint allows arbitrary deeply nested queries and one client request consumes all database worker resources. Which response best addresses these needs?
Explanation
Correct Answer
First, external model connections need credential isolation and least privilege like any other remote service. Second, GraphQL authorization alone does not prevent denial of service from unbounded query execution.
Incorrect Answers
Constrain the MCP tool to approved operations and identities and treat retrieved instructions as untrusted data; apply supported query depth, complexity, rate and resource controls alongside entity permissions: external model connections need credential isolation and least privilege like any other remote service.
Move model credentials to an approved secret or managed identity boundary and restrict network and caller access; require validated authentication and per-entity authorization before exposing the API to clients: graphQL authorization alone does not prevent denial of service from unbounded query execution.
Move model credentials to an approved secret or managed identity boundary and restrict network and caller access.



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