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 45
Question 440
A multitenant application uses SESSION_CONTEXT for an RLS predicate but allows ordinary users to supply any tenant identifier in the login request. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
Unauthorized context switching is rejected and each user remains restricted to their approved tenant. The operating rule is: RLS predicate quality depends on the integrity of the identity information it consumes.
Incorrect Answers
The endpoint returns permitted entities and rejects unauthorized resource and operation combinations. The operating rule is: RLS predicate quality depends on the integrity of the identity information it consumes. Unauthorized context switching is rejected and each user remains restricted to their approved tenant.
Only approved fields are embedded and unauthorized users cannot retrieve protected source or embedding records. The operating rule is: RLS predicate quality depends on the integrity of the identity information it consumes. Unauthorized context switching is rejected and each user remains restricted to their approved tenant.
The rotation completes without lost access and recovered data can still be decrypted by authorized services. The operating rule is: RLS predicate quality depends on the integrity of the identity information it consumes. Unauthorized context switching is rejected and each user remains restricted to their approved tenant.
Question 441
A public inventory endpoint returns an unbounded number of rows and one client can exhaust resources by requesting the entire catalog. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
An unbounded request sends millions of records and overwhelms the service during peak use. API pagination is a reliability and access-control design choice, not just a UI feature.
Incorrect Answers
A crafted filter selects records based on sensitive data even when that field is hidden from output. API pagination is a reliability and access-control design choice, not just a UI feature. An unbounded request sends millions of records and overwhelms the service during peak use.
Two updates between polls collapse into one current row and intermediate changes disappear. API pagination is a reliability and access-control design choice, not just a UI feature. An unbounded request sends millions of records and overwhelms the service during peak use.
SQL shows the approved new price while the API still returns the old cached payload. API pagination is a reliability and access-control design choice, not just a UI feature. An unbounded request sends millions of records and overwhelms the service during peak use.
Question 442
A checkout database has short selective updates to active carts and a consultant proposes replacing every rowstore index with columnstore. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Checkout transaction latency remains stable while reporting queries use purpose-built structures.
Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately. Checkout transaction latency remains stable while reporting queries use purpose-built structures.
Incorrect Answers
After a tested maintenance change analytic scan cost improves and freshness commitments hold. Checkout transaction latency remains stable while reporting queries use purpose-built structures.
Add supported CHECK and DEFAULT constraints consistent with the application contract. Checkout transaction latency remains stable while reporting queries use purpose-built structures.
Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls. Checkout transaction latency remains stable while reporting queries use purpose-built structures.
Question 443
A release changes a table consumed by an older mobile API but no backward-compatibility window or rollback plan exists. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Use an expand-and-contract migration or controlled compatibility strategy with rollback testing. Schema evolution should account for clients with independent deployment cycles.
Incorrect Answers
Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. Schema evolution should account for clients with independent deployment cycles. Use an expand-and-contract migration or controlled compatibility strategy with rollback testing.
Block promotion until data impact and an approved migration strategy are verified. Schema evolution should account for clients with independent deployment cycles. Use an expand-and-contract migration or controlled compatibility strategy with rollback testing.
Resolve schema conflicts with a model diff and tests before approving the combined pull request. Schema evolution should account for clients with independent deployment cycles. Use an expand-and-contract migration or controlled compatibility strategy with rollback testing.
Question 444
A vector table stores embeddings from one model and a replacement model outputs a different dimension count but the team plans to mix both in the same index. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
The system searches vectors produced by compatible model versions at the expected dimensionality. The operating rule is: Vector dimensions and model spaces must be compatible for meaningful similarity calculations.
Incorrect Answers
A test query retrieves authorized matching image and text records with validated accuracy. The operating rule is: Vector dimensions and model spaces must be compatible for meaningful similarity calculations. The system searches vectors produced by compatible model versions at the expected dimensionality.
A reconciled manifest shows every eligible record has a valid versioned embedding or a tracked error. The operating rule is: Vector dimensions and model spaces must be compatible for meaningful similarity calculations. The system searches vectors produced by compatible model versions at the expected dimensionality.
The FAQ write commits promptly and a background worker creates a matching authorized vector. The operating rule is: Vector dimensions and model spaces must be compatible for meaningful similarity calculations. The system searches vectors produced by compatible model versions at the expected dimensionality.
Question 445
A SQL service searches FAQ text with broad LIKE predicates across millions of records and response time increases as data grows. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
Relevant terms are found with improved latency and accepted linguistic precision. The operating rule is: Full-text search provides token-aware retrieval beyond ordinary substring filters.
Incorrect Answers
An index-refresh test removes deleted records and retrieves updated relevant chunks. The operating rule is: Full-text search provides token-aware retrieval beyond ordinary substring filters. Relevant terms are found with improved latency and accepted linguistic precision.
Exact product-code queries retrieve their matching rows while conceptual requests remain useful. The operating rule is: Full-text search provides token-aware retrieval beyond ordinary substring filters. Relevant terms are found with improved latency and accepted linguistic precision.
The combined ranking balances relevant candidates from both lists according to measured relevance. The operating rule is: Full-text search provides token-aware retrieval beyond ordinary substring filters. Relevant terms are found with improved latency and accepted linguistic precision.
Question 446
A recommendation service ranks products only by vector similarity and shows discontinued items because business eligibility filters are ignored. Which technical principle explains the correct response?
Explanation
Correct Answer
Semantic similarity is one retrieval signal and cannot override transactional business constraints.
Incorrect Answers
Lexical and semantic relevance target different retrieval needs and are often complementary. Semantic similarity is one retrieval signal and cannot override transactional business constraints.
RRF combines rank positions without assuming raw search score scales are comparable. Semantic similarity is one retrieval signal and cannot override transactional business constraints.
Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries. Semantic similarity is one retrieval signal and cannot override transactional business constraints.
Question 447
An application wants new FAQ entries to receive embeddings soon after insertion without embedding generation blocking the user-facing SQL transaction. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Asynchronous embedding generation decouples inference latency from transactional writes.
Incorrect Answers
Synchronous external calls inside write transactions can couple availability to a remote inference service. Asynchronous embedding generation decouples inference latency from transactional writes.
External models are dependencies that need version governance and compatibility testing. Asynchronous embedding generation decouples inference latency from transactional writes.
Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed. Asynchronous embedding generation decouples inference latency from transactional writes.
Question 448
A web application database login has db_owner privileges solely because its installation script creates a few tables during deployment. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Least privilege distinguishes runtime data access from administrative deployment responsibilities.
Incorrect Answers
Background integrations require narrowly scoped identities just as interactive users do. Least privilege distinguishes runtime data access from administrative deployment responsibilities.
Row-level security enforces data visibility in the database independently of application query discipline. Least privilege distinguishes runtime data access from administrative deployment responsibilities.
Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. Least privilege distinguishes runtime data access from administrative deployment responsibilities.
Question 449
A legal research system chooses approximate nearest-neighbor search for speed but a small high-stakes sample requires exhaustive top-k accuracy. What technical finding would substantiate this root cause?
Explanation
Correct Answer
Fast approximate results sometimes omit the known closest passage in labeled tests. Approximate search gains speed by accepting possible recall loss relative to exact search.
Incorrect Answers
One retrieval modality dominates because its arbitrary numeric score range is larger. Approximate search gains speed by accepting possible recall loss relative to exact search. Fast approximate results sometimes omit the known closest passage in labeled tests.
The current SQL compares serialized embedding strings instead of their numeric coordinates. Approximate search gains speed by accepting possible recall loss relative to exact search. Fast approximate results sometimes omit the known closest passage in labeled tests.
The rejected rows originate from a model that returns different coordinate lengths. Approximate search gains speed by accepting possible recall loss relative to exact search. Fast approximate results sometimes omit the known closest passage in labeled tests.
Question 450
A regulated SQL system must reconstruct who changed permission grants last week but the database has no retained audit evidence. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
A test privilege change creates a protected timestamped audit record tied to the correct identity. A regulated SQL system must reconstruct who changed permission grants last week but the database has no retained audit evidence.
Incorrect Answers
The application connects with its scoped identity while no reusable database password is stored in code. A regulated SQL system must reconstruct who changed permission grants last week but the database has no retained audit evidence. A test privilege change creates a protected timestamped audit record tied to the correct identity.
Modified client filters cannot expand the account's authorized row scope. A regulated SQL system must reconstruct who changed permission grants last week but the database has no retained audit evidence. A test privilege change creates a protected timestamped audit record tied to the correct identity.
The function processes authorized events while negative access tests deny unrelated tables. A regulated SQL system must reconstruct who changed permission grants last week but the database has no retained audit evidence. A test privilege change creates a protected timestamped audit record tied to the correct identity.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 43 - 10 Questions (Last Reviewed 05-Oct-2026)
- Microsoft DP-800 Practice Test 44 - 10 Questions (Last Reviewed 04-Oct-2026)
- Microsoft DP-800 Practice Test 45 - 10 Questions (Last Reviewed 03-Oct-2026)
- Microsoft DP-800 Practice Test 46 - 10 Questions (Last Reviewed 02-Oct-2026)
- Microsoft DP-800 Practice Test 47 - 10 Questions (Last Reviewed 01-Oct-2026)