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 47
Question 460
A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. What would be a valid post-database-change verification?
Explanation
Correct Answer
The analysis identifies specific statements and a tested change reduces peak resource use. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources.
Incorrect Answers
The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. The analysis identifies specific statements and a tested change reduces peak resource use.
Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. The analysis identifies specific statements and a tested change reduces peak resource use.
The chosen change lowers total reads without an unacceptable index maintenance penalty. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. The analysis identifies specific statements and a tested change reduces peak resource use.
Question 461
A pipeline uses a shared administrator password to publish SQL Database Project changes to multiple production databases. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Automated deployment identities should be scoped to the resources and actions they operate.
Incorrect Answers
Schema evolution should account for clients with independent deployment cycles. Automated deployment identities should be scoped to the resources and actions they operate.
Database CI/CD needs separation of development activity from production authorization. Automated deployment identities should be scoped to the resources and actions they operate.
Database merge conflicts can affect schema semantics beyond textual file overlap. Automated deployment identities should be scoped to the resources and actions they operate.
Question 462
A multitenant database serves a tiny customer and a giant enterprise through the same stored procedure; one cached plan is poor for the other. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Evaluate parameter-sensitive plan features and validated mitigation for the engine version. Cardinality skew can make a single cached plan suboptimal across parameter values.
Incorrect Answers
Assess a covering index or query projection change with real selectivity and write overhead. Cardinality skew can make a single cached plan suboptimal across parameter values. Evaluate parameter-sensitive plan features and validated mitigation for the engine version.
Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements. Cardinality skew can make a single cached plan suboptimal across parameter values. Evaluate parameter-sensitive plan features and validated mitigation for the engine version.
Choose transactional locking or isolation that enforces the reservation invariant under concurrency. Cardinality skew can make a single cached plan suboptimal across parameter values. Evaluate parameter-sensitive plan features and validated mitigation for the engine version.
Question 463
A SQL service searches FAQ text with broad LIKE predicates across millions of records and response time increases as data grows. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Full-text search provides token-aware retrieval beyond ordinary substring filters.
Incorrect Answers
Indexed vector search trades computation and index behavior against recall and resource cost. Full-text search provides token-aware retrieval beyond ordinary substring filters.
Top-k selection and filtering order affect both relevance and security. Full-text search provides token-aware retrieval beyond ordinary substring filters.
Vector normalization and distance metrics must be consistent across indexing and querying. Full-text search provides token-aware retrieval beyond ordinary substring filters.
Question 464
A procedure posts an invoice and then calls a failing validation routine; the customer balance remains changed because the error is swallowed. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
The validation error results in a fully consistent rollback and a diagnostic error response. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.
Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.
Incorrect Answers
The graph query returns the verified two-hop relationships without inventing direct account links. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller. The validation error results in a fully consistent rollback and a diagnostic error response.
Use supported JSON construction and aggregation functions with an explicit schema and null treatment. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.
Use LAG partitioned by product and ordered by report month, then check handling for missing months. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.
Question 465
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 corrective action best fits the observed symptoms?
Explanation
Correct Answer
Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority.
Incorrect Answers
Verify tenant/workspace enablement, permissions, and responsible AI policy before configuring Copilot in Fabric. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Scope the connector to approved lakehouse data and verify the selected identity and workspace permissions. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Question 466
A supplier sends one JSON payload containing an array of shipment items and the importer currently saves the array as an opaque string. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
The database stores one row per shipment but cannot query per-item quantities or product codes. OPENJSON supports transforming structured arrays into queryable relational data.
Incorrect Answers
A basic replace misses some token variations and leaves identifiers in test messages. OPENJSON supports transforming structured arrays into queryable relational data. The database stores one row per shipment but cannot query per-item quantities or product codes.
The existing query performs repeated nested scans and does not order same-time events predictably. OPENJSON supports transforming structured arrays into queryable relational data. The database stores one row per shipment but cannot query per-item quantities or product codes.
The existing self-join misses a product because its previous month is absent. OPENJSON supports transforming structured arrays into queryable relational data. The database stores one row per shipment but cannot query per-item quantities or product codes.
Question 467
A help-desk knowledge table is updated frequently but its embeddings are only generated during an initial import, leaving search results stale. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. Embedding stores need a maintenance strategy that follows authoritative source changes.
Incorrect Answers
Use an approved secure identity or secret-management mechanism supported by the SQL platform and model endpoint. Embedding stores need a maintenance strategy that follows authoritative source changes. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
Version the model configuration and compare outputs, latency, and contracts before controlled replacement. Embedding stores need a maintenance strategy that follows authoritative source changes. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
Store approved model/version, source ID, timestamp, and change state alongside embeddings. Embedding stores need a maintenance strategy that follows authoritative source changes. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
Question 468
A cloud database enables disk encryption but an application team assumes that prevents its overly privileged SQL login from reading confidential rows. What technical finding would substantiate this root cause?
Explanation
Correct Answer
The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage. Encryption at rest does not replace database access controls for authenticated query operations.
Incorrect Answers
A blocked test returns no rows but produces no actionable signal in the team's audit workflow. Encryption at rest does not replace database access controls for authenticated query operations. The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage.
A nearest-neighbor query or reconstruction-related audit reveals sensitive customer-derived content in search results. Encryption at rest does not replace database access controls for authenticated query operations. The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage.
A test prompt can invoke an ALTER TABLE through the assistant without human authorization. Encryption at rest does not replace database access controls for authenticated query operations. The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage.
Question 469
A data quality team sanitizes narratives that may include a recognizable account-number format before an AI summarization step. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
A basic replace misses some token variations and leaves identifiers in test messages. Regex substitution supports structured redaction only when patterns are thoroughly validated.
Incorrect Answers
A query treats a discount string of 100 as lower than 20 under character ordering. Regex substitution supports structured redaction only when patterns are thoroughly validated. A basic replace misses some token variations and leaves identifiers in test messages.
The existing query performs repeated nested scans and does not order same-time events predictably. Regex substitution supports structured redaction only when patterns are thoroughly validated. A basic replace misses some token variations and leaves identifiers in test messages.
The existing self-join misses a product because its previous month is absent. Regex substitution supports structured redaction only when patterns are thoroughly validated. A basic replace misses some token variations and leaves identifiers in test messages.
Question 470
A search team stores vectors but omits the source document version and model identifier, making comparisons after model changes unverifiable. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Store approved model/version, source ID, timestamp, and change state alongside embeddings. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution.
Incorrect Answers
Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Store approved model/version, source ID, timestamp, and change state alongside embeddings.
Create a compatible versioned embedding migration with dimension checks and rebuild the affected index where required. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Store approved model/version, source ID, timestamp, and change state alongside embeddings.
Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Store approved model/version, source ID, timestamp, and change state alongside embeddings.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 45 - 10 Questions (Last Reviewed 03-Oct-2026)
- Microsoft DP-800 Practice Test 46 - 10 Questions (Last Reviewed 02-Oct-2026)
- 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)