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 34
Question 330
A SQL database invokes an external model that is replaced by the provider without a tested compatibility plan. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Version the model configuration and compare outputs, latency, and contracts before controlled replacement. External models are dependencies that need version governance and compatibility testing.
Incorrect Answers
Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation. External models are dependencies that need version governance and compatibility testing. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.
Create a compatible versioned embedding migration with dimension checks and rebuild the affected index where required. External models are dependencies that need version governance and compatibility testing. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.
Store approved model/version, source ID, timestamp, and change state alongside embeddings. External models are dependencies that need version governance and compatibility testing. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.
Question 331
A team exposes SQL data through Data API builder but assumes API authentication alone prevents access to every table. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Apply DAB roles, entity permissions, and backend identity least privilege with negative tests. API exposure needs authorization at both application endpoint and SQL permission layers.
Incorrect Answers
Evaluate Always Encrypted with appropriate client drivers and protected key management for sensitive salary columns. API exposure needs authorization at both application endpoint and SQL permission layers. Apply DAB roles, entity permissions, and backend identity least privilege with negative tests.
Constrain query permissions and review inference risks rather than treating masking as sufficient protection. API exposure needs authorization at both application endpoint and SQL permission layers. Apply DAB roles, entity permissions, and backend identity least privilege with negative tests.
Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads. API exposure needs authorization at both application endpoint and SQL permission layers. Apply DAB roles, entity permissions, and backend identity least privilege with negative tests.
Question 332
A bookings database allows negative guest counts and missing initial status fields because web clients supply values inconsistently. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Add supported CHECK and DEFAULT constraints consistent with the application contract. Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces.
Incorrect Answers
Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately. Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. Add supported CHECK and DEFAULT constraints consistent with the application contract.
Implement a correctly scoped foreign key and repair existing violations before enabling trusted enforcement. Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. Add supported CHECK and DEFAULT constraints consistent with the application contract.
Evaluate system-versioned temporal tables with history retention and appropriate access controls. Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. Add supported CHECK and DEFAULT constraints consistent with the application contract.
Question 333
A finance report repeats a complicated eligibility expression in several joins and inconsistent copies give different quarter totals. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
CTEs improve composability and readability but are not automatically materialized performance caches.
Incorrect Answers
Ranking semantics must reflect whether ties share positions or require deterministic ordered rows. CTEs improve composability and readability but are not automatically materialized performance caches.
String similarity metrics have different sensitivities and must be matched to actual data. CTEs improve composability and readability but are not automatically materialized performance caches.
Window offset functions simplify ordered comparisons but do not create missing time periods. CTEs improve composability and readability but are not automatically materialized performance caches.
Question 334
A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities. GraphQL relationships need explicit API modeling beyond raw relational keys.
Incorrect Answers
Evaluate SQL change data capture availability and retention with a durable consumer checkpoint. GraphQL relationships need explicit API modeling beyond raw relational keys. Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities.
Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging. GraphQL relationships need explicit API modeling beyond raw relational keys. Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities.
Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions. GraphQL relationships need explicit API modeling beyond raw relational keys. Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities.
Question 335
A customer call-center uses Dynamic Data Masking to conceal phone numbers but grants a reporting service an overly privileged login and treats masking as encryption. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
Ordinary operators view masked fields while authorized limited workflows follow explicit permissions. The operating rule is: Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization.
Incorrect Answers
The rotation completes without lost access and recovered data can still be decrypted by authorized services. The operating rule is: Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization. Ordinary operators view masked fields while authorized limited workflows follow explicit permissions.
The application connects with its scoped identity while no reusable database password is stored in code. The operating rule is: Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization. Ordinary operators view masked fields while authorized limited workflows follow explicit permissions.
Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers. The operating rule is: Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization. Ordinary operators view masked fields while authorized limited workflows follow explicit permissions.
Question 336
A database project compiles locally but CI fails because a referenced shared database model exists only on one developer's machine. What technical finding would substantiate this root cause?
Explanation
Correct Answer
Clean-build logs show an unresolved referenced object while the local workstation builds. A project needs explicit versioned dependencies to support repeatable builds.
Incorrect Answers
Unit tests pass while a real GraphQL query fails on a missing relationship field. A project needs explicit versioned dependencies to support repeatable builds. Clean-build logs show an unresolved referenced object while the local workstation builds.
An unreviewed branch commit triggers a production database publish with no named approver. A project needs explicit versioned dependencies to support repeatable builds. Clean-build logs show an unresolved referenced object while the local workstation builds.
Staging API calls fail immediately after the database rename while some clients cannot update overnight. A project needs explicit versioned dependencies to support repeatable builds. Clean-build logs show an unresolved referenced object while the local workstation builds.
Question 337
A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
A bounded query or optimized mapping meets latency targets under representative load. A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path.
Incorrect Answers
An API test enforces page size and returns deterministic next pages without missing or duplicating items. A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. A bounded query or optimized mapping meets latency targets under representative load.
The endpoint rejects unapproved filters and returns correct authorized shipment matches. A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. A bounded query or optimized mapping meets latency targets under representative load.
The feed reproduces intended changes in order and survives a consumer restart. A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. A bounded query or optimized mapping meets latency targets under representative load.
Question 338
A multiyear events table is partitioned by event date but a nonaligned reporting index makes partition switching unexpectedly difficult. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
The maintenance command fails a prerequisite check even though the base table has the expected partitions. Index alignment and constraints are part of a working partition-maintenance design.
Incorrect Answers
A test shows the old index rejects valid same-code invoices in different tenants but permits duplicate codes within one tenant under some paths. Index alignment and constraints are part of a working partition-maintenance design. The maintenance command fails a prerequisite check even though the base table has the expected partitions.
Current application counters collide under concurrent insert attempts and operators require IDs to be unique rather than consecutive. Index alignment and constraints are part of a working partition-maintenance design. The maintenance command fails a prerequisite check even though the base table has the expected partitions.
The plan scans many rows and performs a costly sort for a small tenant-specific result. Index alignment and constraints are part of a working partition-maintenance design. The maintenance command fails a prerequisite check even though the base table has the expected partitions.
Question 339
A retrieved customer comment contains instructions telling the model to execute a database update and the application passes that text into the generation prompt. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
The model summarizes the comment without executing any unauthorized database change. The operating rule is: Source text must not cross the boundary from evidence into privileged tool instructions.
Incorrect Answers
The workflow meets token and latency budgets while citing the correct current clauses. The operating rule is: Source text must not cross the boundary from evidence into privileged tool instructions. The model summarizes the comment without executing any unauthorized database change.
Every material policy claim cites a current accessible source or is marked unsupported. The operating rule is: Source text must not cross the boundary from evidence into privileged tool instructions. The model summarizes the comment without executing any unauthorized database change.
Valid responses populate the correct schema while failures are logged and retried safely. The operating rule is: Source text must not cross the boundary from evidence into privileged tool instructions. The model summarizes the comment without executing any unauthorized database change.
Question 340
A bank needs to reconstruct the prior values of an account preference after customer service overwrote a row and the current table only stores the latest state. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Evaluate system-versioned temporal tables with history retention and appropriate access controls. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses.
Incorrect Answers
Use a suitable native JSON type or a validity check supported on the target database engine. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Evaluate system-versioned temporal tables with history retention and appropriate access controls.
Design date-aligned partitions and a tested retention or sliding-window maintenance procedure. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Evaluate system-versioned temporal tables with history retention and appropriate access controls.
Evaluate a columnstore index and validate load patterns and query performance before choosing the final storage design. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Evaluate system-versioned temporal tables with history retention and appropriate access controls.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 32 - 10 Questions (Last Reviewed 16-Oct-2026)
- Microsoft DP-800 Practice Test 33 - 10 Questions (Last Reviewed 15-Oct-2026)
- 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)