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 80
Question 790
A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
An authorized nested query returns correct variants while excluded records remain inaccessible. A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured.
Incorrect Answers
The endpoint rejects unapproved filters and returns correct authorized shipment matches. A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. An authorized nested query returns correct variants while excluded records remain inaccessible.
Allowed requests invoke the intended procedure and crafted SQL payloads are rejected. A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. An authorized nested query returns correct variants while excluded records remain inaccessible.
A bounded query or optimized mapping meets latency targets under representative load. A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. An authorized nested query returns correct variants while excluded records remain inaccessible.
Question 791
Several services must assign database-generated batch identifiers without assuming they are gapless when transactions roll back. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Use a SEQUENCE object and document its caching and gap behavior for consumers. This gives the verification result for the issue: Several services must assign database-generated batch identifiers without assuming they are gapless when transactions roll back.
Concurrent test inserts receive distinct identifiers and the business accepts documented gaps. This gives the verification result for the issue: Several services must assign database-generated batch identifiers without assuming they are gapless when transactions roll back.
Incorrect Answers
A rehearsed partition switch completes and representative queries retain acceptable plans. This gives the verification result for the issue: Several services must assign database-generated batch identifiers without assuming they are gapless when transactions roll back. Concurrent test inserts receive distinct identifiers and the business accepts documented gaps.
Evaluate an appropriate memory-optimized table design and durability choice under the platform's supported features. This gives the verification result for the issue: Several services must assign database-generated batch identifiers without assuming they are gapless when transactions roll back. Use a SEQUENCE object and document its caching and gap behavior for consumers.
Design date-aligned partitions and a tested retention or sliding-window maintenance procedure. This gives the verification result for the issue: Several services must assign database-generated batch identifiers without assuming they are gapless when transactions roll back. Use a SEQUENCE object and document its caching and gap behavior for consumers.
Question 792
A catalog stores JSON tags for products and users need to filter records containing a specified membership value without substring false positives. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Evaluate JSON_CONTAINS or another supported JSON-aware predicate for the target engine and index design. JSON membership semantics differ from arbitrary text matching and depend on feature support.
Incorrect Answers
Use an exact validated pattern and a supported REGEXP_COUNT function where available. JSON membership semantics differ from arbitrary text matching and depend on feature support. Evaluate JSON_CONTAINS or another supported JSON-aware predicate for the target engine and index design.
Evaluate a graph MATCH query against the node and edge model and check result completeness. JSON membership semantics differ from arbitrary text matching and depend on feature support. Evaluate JSON_CONTAINS or another supported JSON-aware predicate for the target engine and index design.
Use LAG partitioned by product and ordered by report month, then check handling for missing months. JSON membership semantics differ from arbitrary text matching and depend on feature support. Evaluate JSON_CONTAINS or another supported JSON-aware predicate for the target engine and index design.
Question 793
A public inventory endpoint returns an unbounded number of rows and one client can exhaust resources by requesting the entire catalog. What is the underlying reason for the corrective step?
Explanation
Correct Answer
API pagination is a reliability and access-control design choice, not just a UI feature.
Incorrect Answers
Low-code automation must still enforce event selection, recipient controls, and auditability. API pagination is a reliability and access-control design choice, not just a UI feature.
Protecting data includes constraining searchable predicates as well as displayed columns. API pagination is a reliability and access-control design choice, not just a UI feature.
Change Tracking is suited to changed-row identification rather than full change payload history. API pagination is a reliability and access-control design choice, not just a UI feature.
Question 794
A finance report repeats a complicated eligibility expression in several joins and inconsistent copies give different quarter totals. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Use a common table expression to define the intermediate eligible set once and validate its filters. CTEs improve composability and readability but are not automatically materialized performance caches.
Incorrect Answers
Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step. CTEs improve composability and readability but are not automatically materialized performance caches. Use a common table expression to define the intermediate eligible set once and validate its filters.
Benchmark JARO_WINKLER_DISTANCE or related supported measures against labeled name pairs. CTEs improve composability and readability but are not automatically materialized performance caches. Use a common table expression to define the intermediate eligible set once and validate its filters.
Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection. CTEs improve composability and readability but are not automatically materialized performance caches. Use a common table expression to define the intermediate eligible set once and validate its filters.
Question 795
A pull request changes a large NVARCHAR column to a smaller type and the deployment tool warns of potential data truncation. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Deployment preserves required values or uses a documented approved transformation without silent truncation. The corresponding check is whether block promotion until data impact and an approved migration strategy are verified.
Block promotion until data impact and an approved migration strategy are verified. Deployment preserves required values or uses a documented approved transformation without silent truncation.
Incorrect Answers
Version reference data in a reviewed idempotent deployment process with migration tests. Deployment preserves required values or uses a documented approved transformation without silent truncation.
Add end-to-end integration tests using compatible staged SQL schema and actual API configuration. Deployment preserves required values or uses a documented approved transformation without silent truncation.
A tested failing pull request is blocked and approved changes follow the defined merge path. Deployment preserves required values or uses a documented approved transformation without silent truncation. The corresponding check is whether deployment preserves required values or uses a documented approved transformation without silent truncation.
Question 796
A retailer's analytical orders table holds hundreds of millions of immutable rows and monthly reports scan most columns while the original rowstore design causes excessive I/O. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
Execution plans show wide table scans and high read counts on report aggregations over historical rows. Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested.
Incorrect Answers
The critical path performs single-cart updates and point lookups rather than large aggregations. Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Execution plans show wide table scans and high read counts on report aggregations over historical rows.
A test shows the old index rejects valid same-code invoices in different tenants but permits duplicate codes within one tenant under some paths. Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Execution plans show wide table scans and high read counts on report aggregations over historical rows.
Columnstore DMV measurements show poor compression and substantial deleted-row percentages after the update surge. Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Execution plans show wide table scans and high read counts on report aggregations over historical rows.
Question 797
A procedure filters customers by region, usually returns ten rows but occasionally one region contains half the table; a cached plan performs poorly for the outlier. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
A plan reused from a selective parameter performs extensive key lookups for the large region. Procedure performance can vary with parameter cardinality even when SQL text is unchanged.
Incorrect Answers
A privileged test account can still select restricted rows despite the trigger firing on writes. Procedure performance can vary with parameter cardinality even when SQL text is unchanged. A plan reused from a selective parameter performs extensive key lookups for the large region.
A single business update produces multiple trigger invocations and unexpectedly many row writes. Procedure performance can vary with parameter cardinality even when SQL text is unchanged. A plan reused from a selective parameter performs extensive key lookups for the large region.
One service omits a date filter and another returns rows from the wrong tenant. Procedure performance can vary with parameter cardinality even when SQL text is unchanged. A plan reused from a selective parameter performs extensive key lookups for the large region.
Question 798
A support platform stores optional case attributes in a JSON column and filters on a frequent nested risk-level property at scale. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
Queries find the correct risk values with less CPU and no loss of document validity.
Incorrect Answers
The reviewed process handles personal data in both periods according to retention obligations. Queries find the correct risk values with less CPU and no loss of document validity.
Checkout transaction latency remains stable while reporting queries use purpose-built structures. Queries find the correct risk values with less CPU and no loss of document validity.
An aged partition is archived or removed through approved procedures without disrupting active payment queries. Queries find the correct risk values with less CPU and no loss of document validity.
Question 799
A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
The validated remedy shortens lock waits and separate deadlock monitoring remains stable. A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks.
Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks. A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership.
Incorrect Answers
A selective maintenance plan avoids unnecessary work and preserves measured query service goal. A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. The validated remedy shortens lock waits and separate deadlock monitoring remains stable.
Assess a covering index or query projection change with real selectivity and write overhead. A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks.
Evaluate parameter-sensitive plan features and validated mitigation for the engine version. A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks.
Question 800
A shipment search API permits filtering on private customer fields that are not part of its documented public data contract. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
The endpoint rejects unapproved filters and returns correct authorized shipment matches. The accompanying action is to restrict exposed fields and filtering operations to approved entity properties.
Restrict exposed fields and filtering operations to approved entity properties. The endpoint rejects unapproved filters and returns correct authorized shipment matches.
Incorrect Answers
Configure appropriate pagination, result limits, and role-level filtering in DAB. The endpoint rejects unapproved filters and returns correct authorized shipment matches. Restrict exposed fields and filtering operations to approved entity properties.
Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities. The endpoint rejects unapproved filters and returns correct authorized shipment matches. Restrict exposed fields and filtering operations to approved entity properties.
The service returns current approved prices within the agreed freshness interval after a change. The endpoint rejects unapproved filters and returns correct authorized shipment matches.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 78 - 10 Questions (Last Reviewed 27-Oct-2026)
- Microsoft DP-800 Practice Test 79 - 10 Questions (Last Reviewed 26-Oct-2026)
- Microsoft DP-800 Practice Test 80 - 10 Questions (Last Reviewed 25-Oct-2026)