Pass Microsoft DP-800 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!
Microsoft DP-800 Practice Test 11
Question 100
A developer commits an Azure SQL connection string with a password into a pipeline YAML and then deletes the line after review. Which technical principle explains the correct response?
Explanation
Correct Answer
Deleting a committed secret does not remove the exposure or replace credential rotation.
Incorrect Answers
Schema changes can be structurally valid yet unsafe for existing data. Deleting a committed secret does not remove the exposure or replace credential rotation.
A project needs explicit versioned dependencies to support repeatable builds. Deleting a committed secret does not remove the exposure or replace credential rotation.
Schema drift must be detected before a declarative project deployment changes production objects. Deleting a committed secret does not remove the exposure or replace credential rotation.
Question 101
A device catalog adds hundreds of mostly empty optional fields as standard columns and read performance is deteriorating. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone.
Incorrect Answers
Design date-aligned partitions and a tested retention or sliding-window maintenance procedure. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.
Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.
Assess rowgroup health and tune loading or maintenance patterns based on measured behavior. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.
Question 102
A catalog stores JSON tags for products and users need to filter records containing a specified membership value without substring false positives. Which technical principle explains the correct response?
Explanation
Correct Answer
JSON membership semantics differ from arbitrary text matching and depend on feature support.
Incorrect Answers
Pattern specificity matters as much as the function chosen for regular-expression counts. JSON membership semantics differ from arbitrary text matching and depend on feature support.
OPENJSON supports transforming structured arrays into queryable relational data. JSON membership semantics differ from arbitrary text matching and depend on feature support.
Ranking semantics must reflect whether ties share positions or require deterministic ordered rows. JSON membership semantics differ from arbitrary text matching and depend on feature support.
Question 103
A multitenant application uses SESSION_CONTEXT for an RLS predicate but allows ordinary users to supply any tenant identifier in the login request. Which technical principle explains the correct response?
Explanation
Correct Answer
RLS predicate quality depends on the integrity of the identity information it consumes.
Incorrect Answers
Encryption strength and operational availability both depend on disciplined key lifecycle management. RLS predicate quality depends on the integrity of the identity information it consumes.
Access prevention and accountable security monitoring are complementary controls. RLS predicate quality depends on the integrity of the identity information it consumes.
Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization. RLS predicate quality depends on the integrity of the identity information it consumes.
Question 104
A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
Test queries without evidence return a clearly marked gap and a human review route. A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes.
Incorrect Answers
The request sends only approved fields and the model receives sufficient task context. A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Test queries without evidence return a clearly marked gap and a human review route.
Valid responses populate the correct schema while failures are logged and retried safely. A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Test queries without evidence return a clearly marked gap and a human review route.
The workflow meets token and latency budgets while citing the correct current clauses. A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Test queries without evidence return a clearly marked gap and a human review route.
Question 105
A support API requests top five nearest results but applies an incompatible filter after the query and often receives zero results for small tenants. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Top-k selection and filtering order affect both relevance and security.
Incorrect Answers
Full-text search provides token-aware retrieval beyond ordinary substring filters. Top-k selection and filtering order affect both relevance and security.
Semantic similarity is one retrieval signal and cannot override transactional business constraints. Top-k selection and filtering order affect both relevance and security.
Lexical and semantic relevance target different retrieval needs and are often complementary. Top-k selection and filtering order affect both relevance and security.
Question 106
A hybrid search service combines full-text and vector result rankings by adding raw scores that have incompatible scales. Which technical principle explains the correct response?
Explanation
Correct Answer
RRF combines rank positions without assuming raw search score scales are comparable.
Incorrect Answers
Top-k selection and filtering order affect both relevance and security. RRF combines rank positions without assuming raw search score scales are comparable.
Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries. RRF combines rank positions without assuming raw search score scales are comparable.
Hybrid search can combine complementary lexical precision and semantic recall. RRF combines rank positions without assuming raw search score scales are comparable.
Question 107
A financial database uses customer-managed keys but operators rotate the key without considering dependent clients or recovery. Which technical principle explains the correct response?
Explanation
Correct Answer
Encryption strength and operational availability both depend on disciplined key lifecycle management.
Incorrect Answers
Data masking is a presentation-level control and inference exposure needs separate review. Encryption strength and operational availability both depend on disciplined key lifecycle management.
Security auditing requires deliberate event selection, integrity, and lifecycle management. Encryption strength and operational availability both depend on disciplined key lifecycle management.
Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization. Encryption strength and operational availability both depend on disciplined key lifecycle management.
Question 108
A security team wants to confirm that cross-tenant access attempts are detected, not only blocked by its new row-level security predicate. What would be a valid post-database-change verification?
Explanation
Correct Answer
The negative test remains denied and generates a protected record adequate for investigation.
Incorrect Answers
Ordinary operators view masked fields while authorized limited workflows follow explicit permissions. The negative test remains denied and generates a protected record adequate for investigation.
Approved salary searches work through a supported secure design without weakening confidentiality. The negative test remains denied and generates a protected record adequate for investigation.
Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT. The negative test remains denied and generates a protected record adequate for investigation.
Question 109
Several applications use the same tenant-scoped order filter with a supplied date range and duplicate its SQL text inconsistently. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Table-valued functions encapsulate reusable relational logic and must be tested for parameter behavior.
Incorrect Answers
Triggers can react to data modifications but are not a substitute for least-privilege reads. Table-valued functions encapsulate reusable relational logic and must be tested for parameter behavior.
A stored procedure can enforce a coherent transaction boundary for related database changes. Table-valued functions encapsulate reusable relational logic and must be tested for parameter behavior.
Set-based SQL processing can avoid per-row procedural overhead when the function is compatible. Table-valued functions encapsulate reusable relational logic and must be tested for parameter behavior.
Question 110
A customer service team enables temporal history for profile rows but forgets that privacy deletion requests also apply to history. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Design a governed temporal retention and deletion procedure across current and historical data. The reviewed process handles personal data in both periods according to retention obligations.
The reviewed process handles personal data in both periods according to retention obligations.
Incorrect Answers
Define a composite uniqueness constraint across the tenant identifier and invoice code. The reviewed process handles personal data in both periods according to retention obligations.
Design JSON access and indexing according to the engine's supported JSON features and test the predicate. The reviewed process handles personal data in both periods according to retention obligations. Design a governed temporal retention and deletion procedure across current and historical data.
Queries find the correct risk values with less CPU and no loss of document validity. The reviewed process handles personal data in both periods according to retention obligations.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 9 - 10 Questions (Last Reviewed 08-Nov-2026)
- Microsoft DP-800 Practice Test 10 - 10 Questions (Last Reviewed 07-Nov-2026)
- Microsoft DP-800 Practice Test 11 - 10 Questions (Last Reviewed 06-Nov-2026)
- Microsoft DP-800 Practice Test 12 - 10 Questions (Last Reviewed 05-Nov-2026)
- Microsoft DP-800 Practice Test 13 - 10 Questions (Last Reviewed 04-Nov-2026)