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 75
Question 740
A near-real-time analytical table uses clustered columnstore but frequent small updates leave fragmented rowgroups and growing delete activity. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Assess rowgroup health and tune loading or maintenance patterns based on measured behavior. Columnstore health depends on ingestion and modification patterns as well as index creation.
Incorrect Answers
Define a composite uniqueness constraint across the tenant identifier and invoice code. Columnstore health depends on ingestion and modification patterns as well as index creation. Assess rowgroup health and tune loading or maintenance patterns based on measured behavior.
Implement a correctly scoped foreign key and repair existing violations before enabling trusted enforcement. Columnstore health depends on ingestion and modification patterns as well as index creation. Assess rowgroup health and tune loading or maintenance patterns based on measured behavior.
Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. Columnstore health depends on ingestion and modification patterns as well as index creation. Assess rowgroup health and tune loading or maintenance patterns based on measured behavior.
Question 741
A multiyear events table is partitioned by event date but a nonaligned reporting index makes partition switching unexpectedly difficult. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Review partition alignment and required uniqueness keys for all indexes involved in maintenance. Index alignment and constraints are part of a working partition-maintenance design.
Incorrect Answers
Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately. Index alignment and constraints are part of a working partition-maintenance design. Review partition alignment and required uniqueness keys for all indexes involved in maintenance.
Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives. Index alignment and constraints are part of a working partition-maintenance design. Review partition alignment and required uniqueness keys for all indexes involved in maintenance.
Use a SEQUENCE object and document its caching and gap behavior for consumers. Index alignment and constraints are part of a working partition-maintenance design. Review partition alignment and required uniqueness keys for all indexes involved in maintenance.
Question 742
A logistics service wants a read-only REST endpoint for approved shipment status but an API prototype exposes every warehouse table by default. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Data API builder configuration determines service surface and must follow least-privilege exposure.
Incorrect Answers
Correlated telemetry can reveal failures that resource-average monitoring alone misses. Data API builder configuration determines service surface and must follow least-privilege exposure.
GraphQL relationships need explicit API modeling beyond raw relational keys. Data API builder configuration determines service surface and must follow least-privilege exposure.
Caching must respect correctness and freshness requirements for mutable business records. Data API builder configuration determines service surface and must follow least-privilege exposure.
Question 743
A device catalog adds hundreds of mostly empty optional fields as standard columns and read performance is deteriorating. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone.
Incorrect Answers
Index alignment and constraints are part of a working partition-maintenance design. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone.
Partitioning can make range maintenance practical when keys and boundaries match retention policy. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone.
Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone.
Question 744
A shipment search API permits filtering on private customer fields that are not part of its documented public data contract. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Restrict exposed fields and filtering operations to approved entity properties. Protecting data includes constraining searchable predicates as well as displayed columns.
Incorrect Answers
Expose only approved procedure or entity operations through supported DAB configuration with authorization. Protecting data includes constraining searchable predicates as well as displayed columns. Restrict exposed fields and filtering operations to approved entity properties.
Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions. Protecting data includes constraining searchable predicates as well as displayed columns. Restrict exposed fields and filtering operations to approved entity properties.
Capture API query shapes and SQL dependency telemetry before scaling hardware. Protecting data includes constraining searchable predicates as well as displayed columns. Restrict exposed fields and filtering operations to approved entity properties.
Question 745
A developer asks Copilot to fix a production query and reports that the database is repaired because the chat returned corrected code. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Generated SQL text is not evidence of a successful database change.
Incorrect Answers
Untrusted tool output must not acquire higher instruction priority than authorized developer intent. Generated SQL text is not evidence of a successful database change.
Tool routing must be unambiguous when an AI assistant can reach multiple data environments. Generated SQL text is not evidence of a successful database change.
Model choice is part of data governance, not merely a response-quality preference. Generated SQL text is not evidence of a successful database change.
Question 746
A recommendation service ranks products only by vector similarity and shows discontinued items because business eligibility filters are ignored. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Apply product availability and eligibility rules before or during semantic ranking and verify result scope. Semantic similarity is one retrieval signal and cannot override transactional business constraints.
Incorrect Answers
Use a supported SQL vector type with dimension compatibility checks and an appropriate data design. Semantic similarity is one retrieval signal and cannot override transactional business constraints. Apply product availability and eligibility rules before or during semantic ranking and verify result scope.
Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate. Semantic similarity is one retrieval signal and cannot override transactional business constraints. Apply product availability and eligibility rules before or during semantic ranking and verify result scope.
Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall. Semantic similarity is one retrieval signal and cannot override transactional business constraints. Apply product availability and eligibility rules before or during semantic ranking and verify result scope.
Question 747
A customer portal sends retrieved SQL policy snippets to a model but discards source IDs, making claims impossible to audit. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Include controlled document identifiers, version metadata, and explicit citation requirements in the RAG prompt. Grounded answers require verifiable provenance, not merely retrieval in the background.
Incorrect Answers
Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause. Grounded answers require verifiable provenance, not merely retrieval in the background. Include controlled document identifiers, version metadata, and explicit citation requirements in the RAG prompt.
Parse and validate the returned model response envelope and expected JSON fields before storing results. Grounded answers require verifiable provenance, not merely retrieval in the background. Include controlled document identifiers, version metadata, and explicit citation requirements in the RAG prompt.
Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage. Grounded answers require verifiable provenance, not merely retrieval in the background. Include controlled document identifiers, version metadata, and explicit citation requirements in the RAG prompt.
Question 748
A near-real-time analytical table uses clustered columnstore but frequent small updates leave fragmented rowgroups and growing delete activity. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
After a tested maintenance change analytic scan cost improves and freshness commitments hold. A near-real-time analytical table uses clustered columnstore but frequent small updates leave fragmented rowgroups and growing delete activity. Assess rowgroup health and tune loading or maintenance patterns based on measured behavior.
Assess rowgroup health and tune loading or maintenance patterns based on measured behavior. A near-real-time analytical table uses clustered columnstore but frequent small updates leave fragmented rowgroups and growing delete activity.
Incorrect Answers
Design a targeted nonclustered index with an appropriate key order and included output columns after measuring the workload. A near-real-time analytical table uses clustered columnstore but frequent small updates leave fragmented rowgroups and growing delete activity. Assess rowgroup health and tune loading or maintenance patterns based on measured behavior.
Each tenant has unique invoice codes while other tenants can reuse the same code safely. A near-real-time analytical table uses clustered columnstore but frequent small updates leave fragmented rowgroups and growing delete activity. After a tested maintenance change analytic scan cost improves and freshness commitments hold.
Design date-aligned partitions and a tested retention or sliding-window maintenance procedure. A near-real-time analytical table uses clustered columnstore but frequent small updates leave fragmented rowgroups and growing delete activity. Assess rowgroup health and tune loading or maintenance patterns based on measured behavior.
Question 749
A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
The generated exception is absent from all retrieved approved policy records. A RAG solution must acknowledge unsupported questions rather than invent source authority.
Incorrect Answers
The report returns different counts depending on which copy of the eligibility predicate was edited. A RAG solution must acknowledge unsupported questions rather than invent source authority. The generated exception is absent from all retrieved approved policy records.
Requests exceed model context budgets and irrelevant chunks dominate the prompt. A RAG solution must acknowledge unsupported questions rather than invent source authority. The generated exception is absent from all retrieved approved policy records.
The model proposes changing an invoice amount solely because the customer comment said to. A RAG solution must acknowledge unsupported questions rather than invent source authority. The generated exception is absent from all retrieved approved policy records.
Question 750
A device catalog adds hundreds of mostly empty optional fields as standard columns and read performance is deteriorating. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
The revised schema supports required searches while reducing unnecessary storage and migration burden. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.
Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.
Incorrect Answers
Checkout transaction latency remains stable while reporting queries use purpose-built structures. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. The revised schema supports required searches while reducing unnecessary storage and migration burden.
Design JSON access and indexing according to the engine's supported JSON features and test the predicate. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.
Add supported CHECK and DEFAULT constraints consistent with the application contract. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. The revised schema supports required searches while reducing unnecessary storage and migration burden.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 73 - 10 Questions (Last Reviewed 01-Nov-2026)
- Microsoft DP-800 Practice Test 74 - 10 Questions (Last Reviewed 31-Oct-2026)
- Microsoft DP-800 Practice Test 75 - 10 Questions (Last Reviewed 30-Oct-2026)
- 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)