100% Latest & Updated Microsoft DP-800 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 430
A developer needs secure GraphQL field access for different roles. The team selects: Apply DAB entity and role permissions to GraphQL. Which implementation action puts this design into practice?
- Configure authenticated role mappings and field restrictions
- Configure private DNS and network access policies
- Create database principal for function identity and GRANT EXECUTE
- Use supported key rotation workflow with Key Vault and drivers
Explanation
Correct Answer
A:Configure authenticated role mappings and field restrictions. This is the concrete setup for apply dab entity and role permissions to graphql, and run role-specific queries for visible and hidden fields supplies a direct confirmation.
Incorrect Answers
B:Configure private DNS and network access policies. This concerns internal-only database access from azure workloads. Instead, configure authenticated role mappings and field restrictions.
C:Create database principal for function identity and GRANT EXECUTE. This concerns permission to call a database. Instead, configure authenticated role mappings and field restrictions.
D:Use supported key rotation workflow with Key Vault and drivers. This concerns secure key rotation for always encrypted. Instead, configure authenticated role mappings and field restrictions.
Question 431
A developer needs secure GraphQL field access for different roles. After implementing the design, which check most directly validates the expected behavior?
- Verify encryption state via supported sys.dm_database_encryption_keys
- Verify clients decrypt data after key rotation
- Run tests under analyst role against report and private objects
- Run role-specific queries for visible and hidden fields
Explanation
Correct Answer
D:Run role-specific queries for visible and hidden fields. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that role permissions were configured only at ui tier.
Incorrect Answers
A:Verify encryption state via supported sys.dm_database_encryption_keys. This concerns encryption of database files and backups at rest. Instead, run role-specific queries for visible and hidden fields.
B:Verify clients decrypt data after key rotation. This concerns secure key rotation for always encrypted. Instead, run role-specific queries for visible and hidden fields.
C:Run tests under analyst role against report and private objects. This concerns reading only a specific schema. Instead, run role-specific queries for visible and hidden fields.
Question 432
A developer needs secure GraphQL field access for different roles. A test instead finds: A low-privilege token selects a private GraphQL field. Which underlying issue best explains this finding?
- The application built SQL by concatenating user input
- Permission arrives from a different role or ownership chain
- Keys were rotated without re-encrypting or updating dependent keys
- Role permissions were configured only at UI tier
Explanation
Correct Answer
D:Role permissions were configured only at UI tier. It accounts for the specific observed failure: a low-privilege token selects a private graphql field. The intended solution is apply dab entity and role permissions to graphql with the required setup.
Incorrect Answers
A:The application built SQL by concatenating user input. This concerns input with a quote executes appended SQL. Here, role permissions were configured only at UI tier.
B:Permission arrives from a different role or ownership chain. This concerns unexpected access persists after revoking direct grant. Here, role permissions were configured only at UI tier.
C:Keys were rotated without re-encrypting or updating dependent keys. This concerns old encryption metadata breaks all clients. Here, role permissions were configured only at UI tier.
Question 433
A team exposes SQL metadata through an MCP endpoint. Which database design or engineering approach most directly meets this requirement?
- Use SQL data classification metadata
- Use managed identity and scoped endpoint permissions
- Require scoped authentication and permissioned tools
- Enable appropriate SQL auditing for schema events
Explanation
Correct Answer
C:Require scoped authentication and permissioned tools. The implementation is bind mcp server to least-privilege sql identity and secure transport; success can be checked by attempt unauthorized metadata discovery and confirm denial. The method addresses the stated data and workload constraint.
Incorrect Answers
A:Use SQL data classification metadata. This concerns searchable sensitivity tags on columns. Instead, require scoped authentication and permissioned tools.
B:Use managed identity and scoped endpoint permissions. This is relevant when a production ai model endpoint is called from SQL. Instead, require scoped authentication and permissioned tools.
D:Enable appropriate SQL auditing for schema events. This concerns security officers need a durable record of database schema changes. Instead, require scoped authentication and permissioned tools.
Question 434
A team exposes SQL metadata through an MCP endpoint. The team selects: Require scoped authentication and permissioned tools. Which implementation action puts this design into practice?
- Use fn_my_permissions or supported catalog views under principal
- Assign workload identity to endpoint access role
- Bind typed SQL parameters instead of string concatenation
- Bind MCP server to least-privilege SQL identity and secure transport
Explanation
Correct Answer
D:Bind MCP server to least-privilege SQL identity and secure transport. This is the concrete setup for require scoped authentication and permissioned tools, and attempt unauthorized metadata discovery and confirm denial supplies a direct confirmation.
Incorrect Answers
A:Use fn_my_permissions or supported catalog views under principal. This concerns preventing accidental broad grants from roles. Here, bind MCP server to least-privilege SQL identity and secure transport.
B:Assign workload identity to endpoint access role. This is relevant when a production ai model endpoint is called from SQL. Here, bind MCP server to least-privilege SQL identity and secure transport.
C:Bind typed SQL parameters instead of string concatenation. This concerns protecting sensitive data from SQL injection. Here, bind MCP server to least-privilege SQL identity and secure transport.
Question 435
A team exposes SQL metadata through an MCP endpoint. After implementing the design, which check most directly validates the expected behavior?
- Attempt unauthorized metadata discovery and confirm denial
- Confirm authorized call succeeds and disallowed call fails
- Inspect classified metadata and reporting output
- Run role-specific queries for visible and hidden fields
Explanation
Correct Answer
A:Attempt unauthorized metadata discovery and confirm denial. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that mcp server credential can access unapproved database objects.
Incorrect Answers
B:Confirm authorized call succeeds and disallowed call fails. This is relevant when a production ai model endpoint is called from SQL. Here, attempt unauthorized metadata discovery and confirm denial.
C:Inspect classified metadata and reporting output. This concerns searchable sensitivity tags on columns. Here, attempt unauthorized metadata discovery and confirm denial.
D:Run role-specific queries for visible and hidden fields. This concerns secure graphql field access for different roles. Here, attempt unauthorized metadata discovery and confirm denial.
Question 436
A team exposes SQL metadata through an MCP endpoint. A test instead finds: Agent lists protected schemas despite low privilege. Which underlying issue best explains this finding?
- Keys were rotated without re-encrypting or updating dependent keys
- Private DNS zone linkage or endpoint configuration is missing
- Endpoint authentication was not migrated to managed identity
- MCP server credential can access unapproved database objects
Explanation
Correct Answer
D:MCP server credential can access unapproved database objects. It accounts for the specific observed failure: agent lists protected schemas despite low privilege. The intended solution is require scoped authentication and permissioned tools with the required setup.
Incorrect Answers
A:Keys were rotated without re-encrypting or updating dependent keys. This concerns old encryption metadata breaks all clients. The relevant SQL or system operation is MCP server credential can access unapproved database objects.
B:Private DNS zone linkage or endpoint configuration is missing. This concerns private workload resolves a public endpoint unexpectedly. The relevant SQL or system operation is MCP server credential can access unapproved database objects.
C:Endpoint authentication was not migrated to managed identity. This concerns SQL service sends a hard-coded endpoint key in clear configuration. The relevant SQL or system operation is MCP server credential can access unapproved database objects.
Question 437
A distributed SQL application must protect connections in transit. Which TWO listed actions form the most appropriate database design and its concrete implementation? (Choose TWO.)
- Configure enforce encryption and valid trusted certificate
- Require scoped authentication and permissioned tools
- Apply DAB entity and role permissions to GraphQL
- Parameterize statements and restrict SQL principal rights
- Require encrypted TLS connections with certificate validation
Explanation
Correct Answers
A:This is the concrete configuration of the specified design: configure enforce encryption and valid trusted certificate. The choice makes the implementation testable in the given workload.
E:Require encrypted TLS connections with certificate validation. The implementation is configure enforce encryption and valid trusted certificate; success can be checked by check negotiated tls and reject a forged certificate. The method addresses the stated data and workload constraint.
Incorrect Answers
B:Require scoped authentication and permissioned tools. This concerns a team exposes SQL metadata through an mcp endpoint. Instead, configure enforce encryption and valid trusted certificate.
C:Apply DAB entity and role permissions to GraphQL. This concerns secure graphql field access for different roles. Instead, configure enforce encryption and valid trusted certificate.
D:Parameterize statements and restrict SQL principal rights. This concerns protecting sensitive data from SQL injection. Instead, configure enforce encryption and valid trusted certificate.
Question 438
A distributed SQL application must protect connections in transit. The team selects: Require encrypted TLS connections with certificate validation. Which implementation action puts this design into practice?
- Reference protected secret variables at runtime only
- Bind typed SQL parameters instead of string concatenation
- Configure enforce encryption and valid trusted certificate
- Create a report reader role with scoped GRANT SELECT
Explanation
Correct Answer
C:Configure enforce encryption and valid trusted certificate. This is the concrete setup for require encrypted tls connections with certificate validation, and check negotiated tls and reject a forged certificate supplies a direct confirmation.
Incorrect Answers
A:Reference protected secret variables at runtime only. This is relevant when an application uses a SQL credential in a deployment pipeline. Instead, configure enforce encryption and valid trusted certificate.
B:Bind typed SQL parameters instead of string concatenation. This concerns protecting sensitive data from SQL injection. Instead, configure enforce encryption and valid trusted certificate.
D:Create a report reader role with scoped GRANT SELECT. This concerns reading only a specific schema. Instead, configure enforce encryption and valid trusted certificate.
Question 439
A distributed SQL application must protect connections in transit. After implementing the design, which check most directly validates the expected behavior?
- Test injection-like strings and inspect query behavior
- Query as admin without keys and confirm ciphertext stays opaque
- Check negotiated TLS and reject a forged certificate
- Acquire token and connect while no SQL password is stored
Explanation
Correct Answer
C:Check negotiated TLS and reject a forged certificate. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that trust validation was disabled or server certificate was not verified.
Incorrect Answers
A:Test injection-like strings and inspect query behavior. This concerns protecting sensitive data from SQL injection. Instead, check negotiated TLS and reject a forged certificate.
B:Query as admin without keys and confirm ciphertext stays opaque. This concerns a hospital protects payment numbers even from database administrators. Instead, check negotiated TLS and reject a forged certificate.
D:Acquire token and connect while no SQL password is stored. This concerns authenticating without storing a SQL password. Instead, check negotiated TLS and reject a forged certificate.
Question 440
A distributed SQL application must protect connections in transit. A test instead finds: Clients accept a man-in-the-middle certificate silently. Which underlying issue best explains this finding?
- Identity-based authentication was not configured end to end
- Trust validation was disabled or server certificate was not verified
- MCP server credential can access unapproved database objects
- The application built SQL by concatenating user input
Explanation
Correct Answer
B:Trust validation was disabled or server certificate was not verified. It accounts for the specific observed failure: clients accept a man-in-the-middle certificate silently. The intended solution is require encrypted tls connections with certificate validation with the required setup.
Incorrect Answers
A:Identity-based authentication was not configured end to end. This concerns connection falls back to embedded SQL credentials. Here, trust validation was disabled or server certificate was not verified.
C:MCP server credential can access unapproved database objects. This concerns agent lists protected schemas despite low privilege. Here, trust validation was disabled or server certificate was not verified.
D:The application built SQL by concatenating user input. This concerns input with a quote executes appended SQL. Here, trust validation was disabled or server certificate was not verified.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests