Microsoft DP-800 Practice Test 78 - Prepaway
Practice Exams:

Pass Microsoft DP-800 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!

30 Days Free Updates, Instant Download!

Verified By Experts
Premium File
$69.99 $76.99

DP-800 Premium ETE File


  • Premium File 101 Questions & Answers. Last Update: Nov 06, 2026
Whats Included:
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

Microsoft DP-800 Practice Test 78

Question 770

A logistics service wants a read-only REST endpoint for approved shipment status but an API prototype exposes every warehouse table by default. What should the database developer do FIRST within approved procedures?

  1. Version the DAB configuration and use environment-specific secret injection and validation during deployment.
  2. Require and test appropriate service-level authentication and network restrictions at every reachable endpoint.
  3. Design appropriate cache freshness and invalidation semantics for the business price lifecycle.
  4. Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions.

Explanation

Correct Answer

D:

Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions. Data API builder configuration determines service surface and must follow least-privilege exposure.

Incorrect Answers

A:

Version the DAB configuration and use environment-specific secret injection and validation during deployment. Data API builder configuration determines service surface and must follow least-privilege exposure. Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions.

B:

Require and test appropriate service-level authentication and network restrictions at every reachable endpoint. Data API builder configuration determines service surface and must follow least-privilege exposure. Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions.

C:

Design appropriate cache freshness and invalidation semantics for the business price lifecycle. Data API builder configuration determines service surface and must follow least-privilege exposure. Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions.

Question 771

A team puts a remote inference call inside a database trigger so every customer update must wait for an embedding service response. Which next step most directly resolves this SQL solution issue?

  1. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
  2. Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk.
  3. Design section-aware chunks with appropriate overlap and metadata, then measure answer evidence coverage.
  4. Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks.

Explanation

Correct Answer

B:

Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk. Synchronous external calls inside write transactions can couple availability to a remote inference service.

Incorrect Answers

A:

Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. Synchronous external calls inside write transactions can couple availability to a remote inference service. Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk.

C:

Design section-aware chunks with appropriate overlap and metadata, then measure answer evidence coverage. Synchronous external calls inside write transactions can couple availability to a remote inference service. Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk.

D:

Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks. Synchronous external calls inside write transactions can couple availability to a remote inference service. Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk.

Question 772

A payroll application stores compensation values in Azure SQL but database administrators should not see their plaintext through routine SQL queries. Which technical principle explains the correct response?

  1. RLS predicate quality depends on the integrity of the identity information it consumes.
  2. Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly.
  3. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.
  4. Row-level security enforces data visibility in the database independently of application query discipline.

Explanation

Correct Answer

B:

Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly.

Incorrect Answers

A:

RLS predicate quality depends on the integrity of the identity information it consumes. Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly.

C:

Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly.

D:

Row-level security enforces data visibility in the database independently of application query discipline. Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly.

Question 773

A product catalog stores an occasionally filtered JSON status and developers want a reliable indexed search across supported SQL versions. Which next step most directly resolves this SQL solution issue?

  1. Assess rowgroup health and tune loading or maintenance patterns based on measured behavior.
  2. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.
  3. Add supported CHECK and DEFAULT constraints consistent with the application contract.
  4. Use a suitable native JSON type or a validity check supported on the target database engine.

Explanation

Correct Answer

B:

Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate. Semi-structured filtering benefits from access-path design tied to engine/version capabilities.

Incorrect Answers

A:

Assess rowgroup health and tune loading or maintenance patterns based on measured behavior. Semi-structured filtering benefits from access-path design tied to engine/version capabilities. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.

C:

Add supported CHECK and DEFAULT constraints consistent with the application contract. Semi-structured filtering benefits from access-path design tied to engine/version capabilities. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.

D:

Use a suitable native JSON type or a validity check supported on the target database engine. Semi-structured filtering benefits from access-path design tied to engine/version capabilities. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.

Question 774

A customer service team enables temporal history for profile rows but forgets that privacy deletion requests also apply to history. Which concept should guide the database developer in this situation?

  1. Partitioning can make range maintenance practical when keys and boundaries match retention policy.
  2. Indexes should match useful predicates and sort requirements rather than being added indiscriminately.
  3. Historical convenience does not bypass privacy and records lifecycle requirements.
  4. A graph model can express connected entities but it is not automatically better for simple relational lookups.

Explanation

Correct Answer

C:

Historical convenience does not bypass privacy and records lifecycle requirements.

Incorrect Answers

A:

Partitioning can make range maintenance practical when keys and boundaries match retention policy. Historical convenience does not bypass privacy and records lifecycle requirements.

B:

Indexes should match useful predicates and sort requirements rather than being added indiscriminately. Historical convenience does not bypass privacy and records lifecycle requirements.

D:

A graph model can express connected entities but it is not automatically better for simple relational lookups. Historical convenience does not bypass privacy and records lifecycle requirements.

Question 775

A multitenant application uses SESSION_CONTEXT for an RLS predicate but allows ordinary users to supply any tenant identifier in the login request. Which next step most directly resolves this SQL solution issue?

  1. Bind the session context to trusted authenticated identity and prevent untrusted tenant switching.
  2. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.
  3. Evaluate Always Encrypted with appropriate client drivers and protected key management for sensitive salary columns.
  4. Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes.

Explanation

Correct Answer

A:

Bind the session context to trusted authenticated identity and prevent untrusted tenant switching. RLS predicate quality depends on the integrity of the identity information it consumes.

Incorrect Answers

B:

Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers. RLS predicate quality depends on the integrity of the identity information it consumes. Bind the session context to trusted authenticated identity and prevent untrusted tenant switching.

C:

Evaluate Always Encrypted with appropriate client drivers and protected key management for sensitive salary columns. RLS predicate quality depends on the integrity of the identity information it consumes. Bind the session context to trusted authenticated identity and prevent untrusted tenant switching.

D:

Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes. RLS predicate quality depends on the integrity of the identity information it consumes. Bind the session context to trusted authenticated identity and prevent untrusted tenant switching.

Question 776

A GitHub Copilot chat connects to a SQL MCP server configured with a broad administrator identity and developers plan to run generated queries against production. Which concept should guide the database developer in this situation?

  1. MCP integrations must enforce source authorization separately from natural-language intent.
  2. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority.
  3. AI-assisted development does not remove developer responsibility for SQL authorization and correctness.
  4. Model choice is part of data governance, not merely a response-quality preference.

Explanation

Correct Answer

B:

Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority.

Incorrect Answers

A:

MCP integrations must enforce source authorization separately from natural-language intent. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority.

C:

AI-assisted development does not remove developer responsibility for SQL authorization and correctness. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority.

D:

Model choice is part of data governance, not merely a response-quality preference. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority.

Question 777

An API accepts arbitrary malformed JSON in a text field and downstream reporting intermittently fails during JSON parsing. Which next step most directly resolves this SQL solution issue?

  1. Design a targeted nonclustered index with an appropriate key order and included output columns after measuring the workload.
  2. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.
  3. Design date-aligned partitions and a tested retention or sliding-window maintenance procedure.
  4. Use a suitable native JSON type or a validity check supported on the target database engine.

Explanation

Correct Answer

D:

Use a suitable native JSON type or a validity check supported on the target database engine. Data shape and validity should be enforced as close to ingestion as practical.

Incorrect Answers

A:

Design a targeted nonclustered index with an appropriate key order and included output columns after measuring the workload. Data shape and validity should be enforced as close to ingestion as practical. Use a suitable native JSON type or a validity check supported on the target database engine.

B:

Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate. Data shape and validity should be enforced as close to ingestion as practical. Use a suitable native JSON type or a validity check supported on the target database engine.

C:

Design date-aligned partitions and a tested retention or sliding-window maintenance procedure. Data shape and validity should be enforced as close to ingestion as practical. Use a suitable native JSON type or a validity check supported on the target database engine.

Question 778

A data migration receives a semi-structured comma-separated tag field where individual tags must be validated before loading. Which TWO options together specify a corrective step and a meaningful test?

  1. A reviewed query handles absent or malformed values and computes numerical results accurately.
  2. Use supported JSON construction and aggregation functions with an explicit schema and null treatment.
  3. Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step.
  4. Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks.
  5. The parser yields exactly the valid intended tags and records malformed entries for remediation.

Explanation

Correct Answers

D:

Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks. A data migration receives a semi-structured comma-separated tag field where individual tags must be validated before loading.

E:

The parser yields exactly the valid intended tags and records malformed entries for remediation. A data migration receives a semi-structured comma-separated tag field where individual tags must be validated before loading. Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks.

Incorrect Answers

A:

A reviewed query handles absent or malformed values and computes numerical results accurately. A data migration receives a semi-structured comma-separated tag field where individual tags must be validated before loading. The parser yields exactly the valid intended tags and records malformed entries for remediation. Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks.

B:

Use supported JSON construction and aggregation functions with an explicit schema and null treatment. A data migration receives a semi-structured comma-separated tag field where individual tags must be validated before loading. Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks.

C:

Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step. A data migration receives a semi-structured comma-separated tag field where individual tags must be validated before loading. Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks.

Question 779

An SQL-backed product catalog must update semantic vectors after deletes and updates, and a nightly full rebuild exceeds the budget. Which clue best distinguishes this issue from similar incidents?

  1. The vector table retains deleted product entries and lacks vectors for recent updates.
  2. Retrieved passages contain a payment obligation but omit the adjacent exception that changes its meaning.
  3. The secret appears in developer-readable config and can invoke the endpoint outside the approved process.
  4. An analyst cannot determine whether two vectors came from the same source revision or embedding model.

Explanation

Correct Answer

A:

The vector table retains deleted product entries and lacks vectors for recent updates. Change capture can drive incremental embeddings if consumers handle event ordering and retention.

Incorrect Answers

B:

Retrieved passages contain a payment obligation but omit the adjacent exception that changes its meaning. Change capture can drive incremental embeddings if consumers handle event ordering and retention. The vector table retains deleted product entries and lacks vectors for recent updates.

C:

The secret appears in developer-readable config and can invoke the endpoint outside the approved process. Change capture can drive incremental embeddings if consumers handle event ordering and retention. The vector table retains deleted product entries and lacks vectors for recent updates.

D:

An analyst cannot determine whether two vectors came from the same source revision or embedding model. Change capture can drive incremental embeddings if consumers handle event ordering and retention. The vector table retains deleted product entries and lacks vectors for recent updates.

Question 780

A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history. Which next step most directly resolves this SQL solution issue?

  1. Implement idempotent event handling and durable progress controls for the SQL trigger binding.
  2. Use a suitable Logic Apps or event-triggered integration with narrow filters and approved recipients.
  3. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.
  4. Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging.

Explanation

Correct Answer

C:

Use supported Change Tracking with a version watermark and controlled rehydration of current rows. Change Tracking is suited to changed-row identification rather than full change payload history.

Incorrect Answers

A:

Implement idempotent event handling and durable progress controls for the SQL trigger binding. Change Tracking is suited to changed-row identification rather than full change payload history. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.

B:

Use a suitable Logic Apps or event-triggered integration with narrow filters and approved recipients. Change Tracking is suited to changed-row identification rather than full change payload history. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.

D:

Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging. Change Tracking is suited to changed-row identification rather than full change payload history. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.

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