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 36
Question 350
A mobile inventory API requires a JSON object per warehouse containing an array of item summaries, and string concatenation produces malformed output for quoted names. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
The emitted payload parses correctly and matches required warehouse/item associations.
Incorrect Answers
Reviewers see plausible ranked candidates without automatic merges of unrelated customers. The emitted payload parses correctly and matches required warehouse/item associations.
Repeated runs produce the expected ranking and tie handling for the same data. The emitted payload parses correctly and matches required warehouse/item associations.
A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency. The emitted payload parses correctly and matches required warehouse/item associations.
Question 351
A commerce API receives order metadata JSON and analysts need a numeric discount for calculations, but lexical comparisons sort values incorrectly. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation.
Incorrect Answers
Ordered window aggregates express running calculations without repeated per-row rescans. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation.
MATCH expresses graph patterns across documented node and edge relationships. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation.
Regex substitution supports structured redaction only when patterns are thoroughly validated. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation.
Question 352
A multitenant billing application assumes invoice codes are globally unique but the actual rule requires uniqueness only within each tenant. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Uniqueness keys must encode the business scope of identity rather than an arbitrary column.
Incorrect Answers
Referential constraints express durable relationships more reliably than application-only checks. Uniqueness keys must encode the business scope of identity rather than an arbitrary column.
Index alignment and constraints are part of a working partition-maintenance design. Uniqueness keys must encode the business scope of identity rather than an arbitrary column.
Historical convenience does not bypass privacy and records lifecycle requirements. Uniqueness keys must encode the business scope of identity rather than an arbitrary column.
Question 353
A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Use full-text or exact filtering for identifiers and assess hybrid search for broader natural-language queries. A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone.
Exact product-code queries retrieve their matching rows while conceptual requests remain useful. A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Use full-text or exact filtering for identifiers and assess hybrid search for broader natural-language queries.
Incorrect Answers
Evaluate supported full-text indexing and query patterns with language-specific tokenization requirements. A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Use full-text or exact filtering for identifiers and assess hybrid search for broader natural-language queries.
Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall. A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Exact product-code queries retrieve their matching rows while conceptual requests remain useful.
An index-refresh test removes deleted records and retrieves updated relevant chunks. A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Exact product-code queries retrieve their matching rows while conceptual requests remain useful.
Question 354
A finance report repeats a complicated eligibility expression in several joins and inconsistent copies give different quarter totals. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
The revised query uses one reviewed eligibility definition and reconciles all quarter totals.
Incorrect Answers
A reviewed query handles absent or malformed values and computes numerical results accurately. The revised query uses one reviewed eligibility definition and reconciles all quarter totals.
Repeated runs produce the expected ranking and tie handling for the same data. The revised query uses one reviewed eligibility definition and reconciles all quarter totals.
Validation demonstrates calibrated candidate ranking and flagged low-confidence matches. The revised query uses one reviewed eligibility definition and reconciles all quarter totals.
Question 355
A regulated organization's pipeline automatically deploys SQL schema changes to production immediately when a developer pushes to a feature branch. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
Only authorized approved pull requests and release approvals can reach production.
Incorrect Answers
A staging API test executes representative authorized queries against deployed schema before promotion. Only authorized approved pull requests and release approvals can reach production.
Deployment preserves required values or uses a documented approved transformation without silent truncation. Only authorized approved pull requests and release approvals can reach production.
A clean rebuild and incremental deployment produce identical authorized lookup mappings. Only authorized approved pull requests and release approvals can reach production.
Question 356
An invoice line table accepts a nonexistent invoice identifier and accounting totals include orphaned lines after imports. What would be a valid post-database-change verification?
Explanation
Correct Answer
Orphan inserts fail while legitimate import ordering and transactions succeed.
Incorrect Answers
An authorized verifier detects simulated unauthorized modifications using a trusted ledger digest. Orphan inserts fail while legitimate import ordering and transactions succeed.
Malformed inputs are rejected and valid representative payloads remain queryable. Orphan inserts fail while legitimate import ordering and transactions succeed.
A time-based query returns the correct historical version and retention follows policy. Orphan inserts fail while legitimate import ordering and transactions succeed.
Question 357
A development team runs Data API builder with a local configuration but its production container lacks the approved connection settings and role maps. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image.
Incorrect Answers
An API test enforces page size and returns deterministic next pages without missing or duplicating items. A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image.
The service returns current approved prices within the agreed freshness interval after a change. A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image.
A client retrieves only changed keys since its saved version and safely handles retention gaps. A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image.
Question 358
A developer stores embeddings as comma-separated NVARCHAR values and converts them on every search operation. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
Queries spend CPU parsing strings and insert validation does not detect malformed vector dimensions. Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine.
Incorrect Answers
The current implementation computes a full-table distance comparison for each interactive request. Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine. Queries spend CPU parsing strings and insert validation does not detect malformed vector dimensions.
The query output contains a citation to another tenant's chunk under certain prompts. Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine. Queries spend CPU parsing strings and insert validation does not detect malformed vector dimensions.
Keyword search misses paraphrases while vector-only search misses rare literal error codes. Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine. Queries spend CPU parsing strings and insert validation does not detect malformed vector dimensions.
Question 359
A telemetry ingestion service sees hot-row latch contention in a small transient state table during bursty writes. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Evaluate an appropriate memory-optimized table design and durability choice under the platform's supported features. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs.
Incorrect Answers
Design JSON access and indexing according to the engine's supported JSON features and test the predicate. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs. Evaluate an appropriate memory-optimized table design and durability choice under the platform's supported features.
Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs. Evaluate an appropriate memory-optimized table design and durability choice under the platform's supported features.
Use a SEQUENCE object and document its caching and gap behavior for consumers. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs. Evaluate an appropriate memory-optimized table design and durability choice under the platform's supported features.
Question 360
A supplier sends one JSON payload containing an array of shipment items and the importer currently saves the array as an opaque string. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
OPENJSON supports transforming structured arrays into queryable relational data.
Incorrect Answers
MATCH expresses graph patterns across documented node and edge relationships. OPENJSON supports transforming structured arrays into queryable relational data.
CTEs improve composability and readability but are not automatically materialized performance caches. OPENJSON supports transforming structured arrays into queryable relational data.
JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation. OPENJSON supports transforming structured arrays into queryable relational data.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 34 - 10 Questions (Last Reviewed 14-Oct-2026)
- Microsoft DP-800 Practice Test 35 - 10 Questions (Last Reviewed 13-Oct-2026)
- Microsoft DP-800 Practice Test 36 - 10 Questions (Last Reviewed 12-Oct-2026)
- Microsoft DP-800 Practice Test 37 - 10 Questions (Last Reviewed 11-Oct-2026)
- Microsoft DP-800 Practice Test 38 - 10 Questions (Last Reviewed 10-Oct-2026)