Microsoft DP-800 Exam Dumps, Practice Test Questions

100% Latest & Updated Microsoft DP-800 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

Microsoft DP-800  Premium File
$54.99
$49.99

DP-800 Premium File

  • Premium File: 101 Questions & Answers. Last update: Nov 9, 2026
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

DP-800 Premium File

Microsoft DP-800  Premium File
  • Premium File: 101 Questions & Answers. Last update: Nov 9, 2026
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$54.99
$49.99

Microsoft DP-800 Practice Test 70

Question 690

An application needs REST access to curated SQL tables without building a custom service. The team selects: Use Data API builder to expose approved SQL entities. Which implementation action puts this design into practice?

  1. Configure relationship cardinality and foreign-key mapping
  2. Define DAB config datasource, entity mapping and REST route
  3. Map procedure and limit callable methods/roles
  4. Enable change tracking and persist last_sync_version

Explanation

Correct Answer

B:

Define DAB config datasource, entity mapping and REST route. This is the concrete setup for use data api builder to expose approved sql entities, and call authorized route and inspect json response supplies a direct confirmation.

Incorrect Answers

A:

Configure relationship cardinality and foreign-key mapping. This concerns traverse customer-to-order relationships. Instead, define DAB config datasource, entity mapping and REST route.

C:

Map procedure and limit callable methods/roles. This concerns exposing a stored procedure safely. Instead, define DAB config datasource, entity mapping and REST route.

D:

Enable change tracking and persist last_sync_version. This concerns knowing which rows changed since last sync. Instead, define DAB config datasource, entity mapping and REST route.

Question 691

An application needs REST access to curated SQL tables without building a custom service. After implementing the design, which check most directly validates the expected behavior?

  1. Call authorized route and inspect JSON response
  2. Update a tracked row and observe function invocation
  3. Insert/update/delete and inspect captured changes
  4. Query CHANGETABLE changes after checkpoint

Explanation

Correct Answer

A:

Call authorized route and inspect JSON response. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that entity mapping or route was not configured.

Incorrect Answers

B:

Update a tracked row and observe function invocation. This concerns a serverless processor reacts when a SQL row changes. Here, call authorized route and inspect JSON response.

C:

Insert/update/delete and inspect captured changes. This concerns committed change events with old/new row images. Here, call authorized route and inspect JSON response.

D:

Query CHANGETABLE changes after checkpoint. This concerns knowing which rows changed since last sync. Here, call authorized route and inspect JSON response.

Question 692

An application needs REST access to curated SQL tables without building a custom service. A test instead finds: REST endpoint returns 404 for expected entity. Which underlying issue best explains this finding?

  1. Distributed tracing correlation was not configured
  2. Sync process lacks change tracking version logic
  3. Diagnostic destination or category is disabled
  4. Entity mapping or route was not configured

Explanation

Correct Answer

D:

Entity mapping or route was not configured. It accounts for the specific observed failure: rest endpoint returns 404 for expected entity. The intended solution is use data api builder to expose approved sql entities with the required setup.

Incorrect Answers

A:

Distributed tracing correlation was not configured. This is relevant when a SQL timeout has no linked request identifier. Here, entity mapping or route was not configured.

B:

Sync process lacks change tracking version logic. This concerns client full-scans table every poll. Here, entity mapping or route was not configured.

C:

Diagnostic destination or category is disabled. This concerns log analytics contains no SQL diagnostic records. Here, entity mapping or route was not configured.

Question 693

A GraphQL client needs to traverse customer-to-order relationships. Which database design or engineering approach most directly meets this requirement?

  1. Use Data API builder to expose approved SQL entities
  2. Expose a DAB GraphQL relationship in schema config
  3. Configure DAB procedure entity with scoped execute permissions
  4. Configure Data API builder entity caching where supported

Explanation

Correct Answer

B:

Expose a DAB GraphQL relationship in schema config. The implementation is configure relationship cardinality and foreign-key mapping; success can be checked by run nested graphql query and verify order list. The method addresses the stated data and workload constraint.

Incorrect Answers

A:

Use Data API builder to expose approved SQL entities. This concerns rest access to curated SQL tables without building a custom service. Instead, expose a DAB GraphQL relationship in schema config.

C:

Configure DAB procedure entity with scoped execute permissions. This concerns exposing a stored procedure safely. Instead, expose a DAB GraphQL relationship in schema config.

D:

Configure Data API builder entity caching where supported. This concerns controlled caching for repeated reference queries. Instead, expose a DAB GraphQL relationship in schema config.

Question 694

A GraphQL client needs to traverse customer-to-order relationships. The team selects: Expose a DAB GraphQL relationship in schema config. Which implementation action puts this design into practice?

  1. Configure relationship cardinality and foreign-key mapping
  2. Define DAB config datasource, entity mapping and REST route
  3. Enable CDC for database and selected tables
  4. Configure telemetry correlation IDs and tracing

Explanation

Correct Answer

A:

Configure relationship cardinality and foreign-key mapping. This is the concrete setup for expose a dab graphql relationship in schema config, and run nested graphql query and verify order list supplies a direct confirmation.

Incorrect Answers

B:

Define DAB config datasource, entity mapping and REST route. This concerns rest access to curated SQL tables without building a custom service. Instead, configure relationship cardinality and foreign-key mapping.

C:

Enable CDC for database and selected tables. This concerns committed change events with old/new row images. Instead, configure relationship cardinality and foreign-key mapping.

D:

Configure telemetry correlation IDs and tracing. This concerns correlate SQL errors with web request traces. Instead, configure relationship cardinality and foreign-key mapping.

Question 695

A GraphQL client needs to traverse customer-to-order relationships. After implementing the design, which check most directly validates the expected behavior?

  1. Run nested GraphQL query and verify order list
  2. Query CHANGETABLE changes after checkpoint
  3. Change record and verify workflow run history
  4. Request successive pages and confirm no missing/duplicate rows

Explanation

Correct Answer

A:

Run nested GraphQL query and verify order list. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that graphql relationship mapping is incorrect.

Incorrect Answers

B:

Query CHANGETABLE changes after checkpoint. This concerns knowing which rows changed since last sync. Instead, run nested GraphQL query and verify order list.

C:

Change record and verify workflow run history. This concerns a workflow starts after database changes and calls downstream services. Instead, run nested GraphQL query and verify order list.

D:

Request successive pages and confirm no missing/duplicate rows. This concerns paginate a large SQL result. Instead, run nested GraphQL query and verify order list.

Question 696

A GraphQL client needs to traverse customer-to-order relationships. A test instead finds: Nested order field returns an unrelated set. Which underlying issue best explains this finding?

  1. GraphQL relationship mapping is incorrect
  2. Role mapping or database principal is too broad
  3. CDC was never enabled for that table
  4. Entity mapping or route was not configured

Explanation

Correct Answer

A:

GraphQL relationship mapping is incorrect. It accounts for the specific observed failure: nested order field returns an unrelated set. The intended solution is expose a dab graphql relationship in schema config with the required setup.

Incorrect Answers

B:

Role mapping or database principal is too broad. This concerns caller accesses unrelated tables through API. Here, graphQL relationship mapping is incorrect.

C:

CDC was never enabled for that table. This concerns change feed misses updates to targeted table. Here, graphQL relationship mapping is incorrect.

D:

Entity mapping or route was not configured. This concerns rest endpoint returns 404 for expected entity. Here, graphQL relationship mapping is incorrect.

Question 697

A public API must paginate a large SQL result. Which database design or engineering approach most directly meets this requirement?

  1. Use Data API builder to expose approved SQL entities
  2. Configure DAB procedure entity with scoped execute permissions
  3. Configure bounded pagination on data endpoint
  4. Configure Data API builder entity caching where supported

Explanation

Correct Answer

C:

Configure bounded pagination on data endpoint. The implementation is set page-size defaults and continuation handling in dab; success can be checked by request successive pages and confirm no missing/duplicate rows. The method addresses the stated data and workload constraint.

Incorrect Answers

A:

Use Data API builder to expose approved SQL entities. This concerns rest access to curated SQL tables without building a custom service. Instead, configure bounded pagination on data endpoint.

B:

Configure DAB procedure entity with scoped execute permissions. This concerns exposing a stored procedure safely. Instead, configure bounded pagination on data endpoint.

D:

Configure Data API builder entity caching where supported. This concerns controlled caching for repeated reference queries. Instead, configure bounded pagination on data endpoint.

Question 698

A public API must paginate a large SQL result. The team selects: Configure bounded pagination on data endpoint. Which implementation action puts this design into practice?

  1. Map procedure and limit callable methods/roles
  2. Set cache duration and invalidation expectations
  3. Define DAB config datasource, entity mapping and REST route
  4. Set page-size defaults and continuation handling in DAB

Explanation

Correct Answer

D:

Set page-size defaults and continuation handling in DAB. This is the concrete setup for configure bounded pagination on data endpoint, and request successive pages and confirm no missing/duplicate rows supplies a direct confirmation.

Incorrect Answers

A:

Map procedure and limit callable methods/roles. This concerns exposing a stored procedure safely. Instead, set page-size defaults and continuation handling in DAB.

B:

Set cache duration and invalidation expectations. This concerns controlled caching for repeated reference queries. Instead, set page-size defaults and continuation handling in DAB.

C:

Define DAB config datasource, entity mapping and REST route. This concerns rest access to curated SQL tables without building a custom service. Instead, set page-size defaults and continuation handling in DAB.

Question 699

A public API must paginate a large SQL result. After implementing the design, which check most directly validates the expected behavior?

  1. Call endpoint and confirm permitted procedure executes
  2. Trace one failed request from API through SQL dependency
  3. Request successive pages and confirm no missing/duplicate rows
  4. Call authorized route and inspect JSON response

Explanation

Correct Answer

C:

Request successive pages and confirm no missing/duplicate rows. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that pagination or maximum page size is not enforced.

Incorrect Answers

A:

Call endpoint and confirm permitted procedure executes. This concerns exposing a stored procedure safely. Here, request successive pages and confirm no missing/duplicate rows.

B:

Trace one failed request from API through SQL dependency. This concerns correlate SQL errors with web request traces. Here, request successive pages and confirm no missing/duplicate rows.

D:

Call authorized route and inspect JSON response. This concerns rest access to curated SQL tables without building a custom service. Here, request successive pages and confirm no missing/duplicate rows.

Question 700

A public API must paginate a large SQL result. A test instead finds: One response attempts to return entire table. Which underlying issue best explains this finding?

  1. Required SQL change tracking or binding setup is missing
  2. Trigger connection or polling settings are wrong
  3. Pagination or maximum page size is not enforced
  4. Role mapping or database principal is too broad

Explanation

Correct Answer

C:

Pagination or maximum page size is not enforced. It accounts for the specific observed failure: one response attempts to return entire table. The intended solution is configure bounded pagination on data endpoint with the required setup.

Incorrect Answers

A:

Required SQL change tracking or binding setup is missing. This concerns function never executes after an update. Here, pagination or maximum page size is not enforced.

B:

Trigger connection or polling settings are wrong. This concerns notifications are missing despite committed rows. Here, pagination or maximum page size is not enforced.

D:

Role mapping or database principal is too broad. This concerns caller accesses unrelated tables through API. Here, pagination or maximum page size is not enforced.

Developing AI-Enabled Database Solutions (DP-800) Practice Tests

UP

SPECIAL OFFER: GET 10% OFF

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 10% Off Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.