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 49
Question 480
An anti-fraud application frequently traverses accounts, devices, and shared identifiers through variable-length relationships that are cumbersome in ordinary joins. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives. A graph model can express connected entities but it is not automatically better for simple relational lookups.
Incorrect Answers
Evaluate a columnstore index and validate load patterns and query performance before choosing the final storage design. A graph model can express connected entities but it is not automatically better for simple relational lookups. Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives.
Implement a correctly scoped foreign key and repair existing violations before enabling trusted enforcement. A graph model can express connected entities but it is not automatically better for simple relational lookups. Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives.
Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. A graph model can express connected entities but it is not automatically better for simple relational lookups. Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives.
Question 481
A warehouse wants ordered row changes including before-and-after data for a reporting feed, and current timestamp polling misses rapid updates. What is the underlying reason for the corrective step?
Explanation
Correct Answer
CDC captures change history that periodic current-state polling can miss.
Incorrect Answers
Deployable API configuration is part of the governed application artifact. CDC captures change history that periodic current-state polling can miss.
An API contract should expose bounded domain operations rather than unrestricted SQL execution. CDC captures change history that periodic current-state polling can miss.
Event-driven consumers need replay-safe logic even when the source binding tracks changes. CDC captures change history that periodic current-state polling can miss.
Question 482
A finance platform wants SQL records from supplier invoices, but its chosen general chat model outputs inconsistent field names and free-form commentary. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review. The operating rule is: Model choice should match structured output requirements rather than general language fluency alone.
Incorrect Answers
The index can be audited and stale or incompatible embeddings are identified and replaced. The operating rule is: Model choice should match structured output requirements rather than general language fluency alone. The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review.
A changed row's embedding is refreshed within the accepted time window and old results no longer dominate. The operating rule is: Model choice should match structured output requirements rather than general language fluency alone. The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review.
A staged migration passes regression benchmarks and retains a clear rollback route. The operating rule is: Model choice should match structured output requirements rather than general language fluency alone. The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review.
Question 483
A developer asks a coding assistant to optimize a stored procedure and accepts generated SQL that removes a tenant filter to improve latency. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis. A negative tenant-access test fails safely while approved queries retain correct row scope and performance.
A negative tenant-access test fails safely while approved queries retain correct row scope and performance. The corresponding check is whether treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
Incorrect Answers
The tool returns only approved lakehouse metadata and rejects unauthorized workspace access. A negative tenant-access test fails safely while approved queries retain correct row scope and performance. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
Scope the connector to approved lakehouse data and verify the selected identity and workspace permissions. A negative tenant-access test fails safely while approved queries retain correct row scope and performance. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets. A negative tenant-access test fails safely while approved queries retain correct row scope and performance. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
Question 484
A team switches between hosted models in a coding assistant and assumes all model endpoints have identical data handling terms. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Model choice is part of data governance, not merely a response-quality preference.
Incorrect Answers
AI assistant availability depends on environment settings, entitlements, and tenant governance. Model choice is part of data governance, not merely a response-quality preference.
Assistant context files are source-controlled assets that must follow normal information security standards. Model choice is part of data governance, not merely a response-quality preference.
MCP integrations must enforce source authorization separately from natural-language intent. Model choice is part of data governance, not merely a response-quality preference.
Question 485
A developer commits an Azure SQL connection string with a password into a pipeline YAML and then deletes the line after review. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.
Old credentials are revoked, logs are controlled, and the pipeline authenticates without committed passwords. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.
Incorrect Answers
Require appropriate protected branches, successful CI, environment approvals, and traceable release gates. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity. Old credentials are revoked, logs are controlled, and the pipeline authenticates without committed passwords.
Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity. Old credentials are revoked, logs are controlled, and the pipeline authenticates without committed passwords.
The pipeline rejects the faulty change and accepts the corrected procedure with verified results. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity. Old credentials are revoked, logs are controlled, and the pipeline authenticates without committed passwords.
Question 486
A Data API builder endpoint accepts unvalidated client-side tenant parameters while backend queries use an all-tenant database identity. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter. Security boundaries must be enforced even when clients can freely modify requests.
Incorrect Answers
Remove unnecessary unmask privileges and combine masking with real access restrictions. Security boundaries must be enforced even when clients can freely modify requests. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.
Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes. Security boundaries must be enforced even when clients can freely modify requests. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.
Classify and minimize data before embedding and protect vector storage and retrieval with appropriate permissions. Security boundaries must be enforced even when clients can freely modify requests. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.
Question 487
An Azure Function consumes SQL change events with a credential that also grants access to unrelated financial tables. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
The function principal appears in an admin role despite processing one published change feed. Background integrations require narrowly scoped identities just as interactive users do.
Incorrect Answers
A crafted query requests a hidden financial column and receives its original value. Background integrations require narrowly scoped identities just as interactive users do. The function principal appears in an admin role despite processing one published change feed.
A simulated investigation cannot retrieve last month's database permission changes because the logs expired. Background integrations require narrowly scoped identities just as interactive users do. The function principal appears in an admin role despite processing one published change feed.
A nearest-neighbor query or reconstruction-related audit reveals sensitive customer-derived content in search results. Background integrations require narrowly scoped identities just as interactive users do. The function principal appears in an admin role despite processing one published change feed.
Question 488
A checkout database has short selective updates to active carts and a consultant proposes replacing every rowstore index with columnstore. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
The critical path performs single-cart updates and point lookups rather than large aggregations. Physical storage decisions should follow transaction shapes rather than blanket performance claims.
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. Physical storage decisions should follow transaction shapes rather than blanket performance claims. The critical path performs single-cart updates and point lookups rather than large aggregations.
Nightly copies drift from the source and duplicate storage increases each reporting cycle. Physical storage decisions should follow transaction shapes rather than blanket performance claims. The critical path performs single-cart updates and point lookups rather than large aggregations.
Execution plans show wide table scans and high read counts on report aggregations over historical rows. Physical storage decisions should follow transaction shapes rather than blanket performance claims. The critical path performs single-cart updates and point lookups rather than large aggregations.
Question 489
A high-volume retail database must publish changes to downstream near-real-time consumers without exposing operational credentials to every subscriber. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Evaluate supported change event streaming with governed identity, routing, and retry policies. Change event streaming separates producer tables from subscriber access when correctly configured.
Incorrect Answers
Expose only approved procedure or entity operations through supported DAB configuration with authorization. Change event streaming separates producer tables from subscriber access when correctly configured. Evaluate supported change event streaming with governed identity, routing, and retry policies.
Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging. Change event streaming separates producer tables from subscriber access when correctly configured. Evaluate supported change event streaming with governed identity, routing, and retry policies.
Use a suitable Logic Apps or event-triggered integration with narrow filters and approved recipients. Change event streaming separates producer tables from subscriber access when correctly configured. Evaluate supported change event streaming with governed identity, routing, and retry policies.
Question 490
A vector ingestion pipeline occasionally receives model output with an unexpected shape and attempts to add it to a dimension-specific index. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Validate vector metadata using supported VECTORPROPERTY functions and the declared schema constraints. Vector metadata validation prevents mixing incompatible representations in search structures.
Incorrect Answers
Build a labeled query set and track recall at k, precision, latency, and failure slices. Vector metadata validation prevents mixing incompatible representations in search structures. Validate vector metadata using supported VECTORPROPERTY functions and the declared schema constraints.
Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate. Vector metadata validation prevents mixing incompatible representations in search structures. Validate vector metadata using supported VECTORPROPERTY functions and the declared schema constraints.
Use full-text or exact filtering for identifiers and assess hybrid search for broader natural-language queries. Vector metadata validation prevents mixing incompatible representations in search structures. Validate vector metadata using supported VECTORPROPERTY functions and the declared schema constraints.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 47 - 10 Questions (Last Reviewed 01-Oct-2026)
- Microsoft DP-800 Practice Test 48 - 10 Questions (Last Reviewed 30-Sep-2026)
- Microsoft DP-800 Practice Test 49 - 10 Questions (Last Reviewed 29-Sep-2026)
- Microsoft DP-800 Practice Test 50 - 10 Questions (Last Reviewed 28-Sep-2026)
- Microsoft DP-800 Practice Test 51 - 10 Questions (Last Reviewed 27-Sep-2026)