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 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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
Historical convenience does not bypass privacy and records lifecycle requirements.
Incorrect Answers
Partitioning can make range maintenance practical when keys and boundaries match retention policy. Historical convenience does not bypass privacy and records lifecycle requirements.
Indexes should match useful predicates and sort requirements rather than being added indiscriminately. Historical convenience does not bypass privacy and records lifecycle requirements.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answers
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.
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 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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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
- Microsoft DP-800 Practice Test 76 - 10 Questions (Last Reviewed 29-Oct-2026)
- Microsoft DP-800 Practice Test 77 - 10 Questions (Last Reviewed 28-Oct-2026)
- 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)