Microsoft DP-800 Practice Test 70
Question 690
Pinecrest Operations is responsible for an Azure SQL or Microsoft SQL workload. A team copies vector-index DDL from Azure SQL to SQL Server 2025. Operational evidence: Vector feature support and preview status differ by platform. What operational condition would provide the earliest useful regression warning?
- Track recall loss after index changes
- Monitor full-text population lag and stoplist changes
- Monitor failed conversions and vector schema changes
- Monitor feature changes and migration incompatibilities
Explanation
Correct Answer
D:
Vector feature support and preview status differ by platform. Monitor feature changes and migration incompatibilities.
Incorrect Answers
A:
“Track recall loss after index changes” addresses the ann versus exact tradeoff situation—aNN tuning could miss a few true nearest matches. The observed failure is: Vector feature support and preview status differ by platform. Monitor feature changes and migration incompatibilities.
B:
“Monitor full-text population lag and stoplist changes” concerns LIKE contains pattern scans large text columns; the reported problem instead is Vector feature support and preview status differ by platform. Monitor feature changes and migration incompatibilities.
C:
“Monitor failed conversions and vector schema changes” concerns Numeric similarity queries are slow and error-prone; the reported problem instead is Vector feature support and preview status differ by platform. Monitor feature changes and migration incompatibilities.
Question 691
At Marigold Banking, a semantic search system compares text embeddings trained for cosine similarity. The observed constraint is: Euclidean distance changes ranking for varying-length vectors. What initial check best narrows the technical cause without altering business data?
- Inspect model version recorded for each chunk and target similarity
- Inspect index metric and query plan warnings
- Review corpus size, metric and exactness requirement
- Inspect model recommended similarity metric and normalization
Explanation
Correct Answer
D:
Euclidean distance changes ranking for varying-length vectors. Inspect model recommended similarity metric and normalization.
Incorrect Answers
A:
“Inspect model version recorded for each chunk and target similarity” concerns New query embeddings and historical vectors are incompatible semantically; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Inspect model recommended similarity metric and normalization.
B:
“Inspect index metric and query plan warnings” concerns Compatible ANN index may not be selected; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Inspect model recommended similarity metric and normalization.
C:
“Review corpus size, metric and exactness requirement” concerns Approximate index recall is unnecessary for this dataset; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Inspect model recommended similarity metric and normalization.
Question 692
A database engineer at Riverbend Retail is investigating this case: A semantic search system compares text embeddings trained for cosine similarity. The relevant finding is: Euclidean distance changes ranking for varying-length vectors. The embedding model was trained and evaluated for COSINE similarity, not Euclidean distance. Which change explicitly selects the cosine metric consistently for both indexing and querying?
- Regenerate index vectors and rebuild/revalidate compatible index
- Configure Euclidean distance in the index while continuing to score requests using cosine similarity
- Validate vector property compatibility before index or query execution
- Use matching cosine metric consistently in index and query
Explanation
Correct Answer
D:
Euclidean distance changes ranking for varying-length vectors. Use matching cosine metric consistently in index and query.
Incorrect Answers
A:
“Regenerate index vectors and rebuild/revalidate compatible index” concerns New query embeddings and historical vectors are incompatible semantically; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Use matching cosine metric consistently in index and query.
B:
A Euclidean index with cosine-scored queries uses mismatched distance semantics and may produce a different ranking for vectors of varying norms. The required change is to select the cosine metric consistently in both index and query, as in D.
C:
“Validate vector property compatibility before index or query execution” concerns Queries fail during similarity calculation; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Use matching cosine metric consistently in index and query.
Question 693
Prairie Logistics is responsible for an Azure SQL or Microsoft SQL workload. A semantic search system compares text embeddings trained for cosine similarity. Operational evidence: Euclidean distance changes ranking for varying-length vectors. What isolated pilot would provide the strongest evidence before rollout?
- Run exact phrase and inflection tests on sample texts
- Insert sample vectors with intended dimension into test schema
- Fuse two small ranked lists and check resulting order
- Compare sample ranked pairs under cosine and euclidean
Explanation
Correct Answer
D:
Euclidean distance changes ranking for varying-length vectors. Compare sample ranked pairs under cosine and euclidean.
Incorrect Answers
A:
“Run exact phrase and inflection tests on sample texts” concerns LIKE contains pattern scans large text columns; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Compare sample ranked pairs under cosine and euclidean.
B:
“Insert sample vectors with intended dimension into test schema” concerns Queries fail during similarity calculation; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Compare sample ranked pairs under cosine and euclidean.
C:
“Fuse two small ranked lists and check resulting order” concerns Raw score addition unfairly favors one system; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Compare sample ranked pairs under cosine and euclidean.
Question 694
At Silverpine Labs, a semantic search system compares text embeddings trained for cosine similarity. The observed constraint is: Euclidean distance changes ranking for varying-length vectors. Which acceptance result most directly demonstrates the requirement has been satisfied?
- Chosen retrieval meets pre-agreed relevance and latency thresholds
- Keyword matches return expected documents efficiently
- Chosen metric returns expected semantic rankings
- Search relevance meets benchmark using a consistent model version
Explanation
Correct Answer
C:
Euclidean distance changes ranking for varying-length vectors. Chosen metric returns expected semantic rankings.
Incorrect Answers
A:
“Chosen retrieval meets pre-agreed relevance and latency thresholds” concerns Latency metric alone says nothing about retrieval quality; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Chosen metric returns expected semantic rankings.
B:
“Keyword matches return expected documents efficiently” concerns LIKE contains pattern scans large text columns; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Chosen metric returns expected semantic rankings.
D:
“Search relevance meets benchmark using a consistent model version” concerns New query embeddings and historical vectors are incompatible semantically; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Chosen metric returns expected semantic rankings.
Question 695
A database engineer at Briarfield Foods is investigating this case: A semantic search system compares text embeddings trained for cosine similarity. The relevant finding is: Euclidean distance changes ranking for varying-length vectors. What operational condition would provide the earliest useful regression warning?
- Monitor metric mismatches between index and requests
- Monitor recall loss after index changes
- Monitor mixed-version vectors and staleness
- Monitor ANN recall, index health and plan selection
Explanation
Correct Answer
A:
Euclidean distance changes ranking for varying-length vectors. Monitor metric mismatches between index and requests.
Incorrect Answers
B:
“Monitor recall loss after index changes” concerns ANN tuning could miss a few true nearest matches; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Monitor metric mismatches between index and requests.
C:
“Monitor mixed-version vectors and staleness” concerns New query embeddings and historical vectors are incompatible semantically; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Monitor metric mismatches between index and requests.
D:
“Monitor ANN recall, index health and plan selection” concerns Exact full scans miss API latency target; the reported problem instead is Euclidean distance changes ranking for varying-length vectors. Monitor metric mismatches between index and requests.
Question 696
Northstar Analytics is responsible for an Azure SQL or Microsoft SQL workload. A vector search workflow compares dot products but embeddings have different magnitudes. Operational evidence: Magnitude dominates scores when direction matters. What initial check best narrows the technical cause without altering business data?
- Inspect vector norms and scoring requirement
- Inspect engine VECTOR support and embedding dimension
- Inspect exactness requirement and phrase specificity
- Review corpus size, metric and exactness requirement
Explanation
Correct Answer
A:
Magnitude dominates scores when direction matters. Inspect vector norms and scoring requirement.
Incorrect Answers
B:
“Inspect engine VECTOR support and embedding dimension” concerns Numeric similarity queries are slow and error-prone; the reported problem instead is Magnitude dominates scores when direction matters. Inspect vector norms and scoring requirement.
C:
“Inspect exactness requirement and phrase specificity” concerns Semantic nearest-neighbor may return related but incorrect codes; the reported problem instead is Magnitude dominates scores when direction matters. Inspect vector norms and scoring requirement.
D:
“Review corpus size, metric and exactness requirement” concerns Approximate index recall is unnecessary for this dataset; the reported problem instead is Magnitude dominates scores when direction matters. Inspect vector norms and scoring requirement.
Question 697
At Maple Harbor Research, a vector search workflow compares dot products but embeddings have different magnitudes. The observed constraint is: Magnitude dominates scores when direction matters. Which proposed change is the most suitable response to the observed constraint?
- Use supported VECTOR_DISTANCE ordering to compute exact pairwise distances
- Use supported VECTOR type with correct dimensions for numeric embeddings
- Use supported vector index with VECTOR_SEARCH latest syntax when applicable
- Use VECTOR_NORMALIZE or equivalent supported normalization before dot product when appropriate
Explanation
Correct Answer
D:
Magnitude dominates scores when direction matters. Use VECTOR_NORMALIZE or equivalent supported normalization before dot product when appropriate.
Incorrect Answers
A:
“Use supported VECTOR_DISTANCE ordering to compute exact pairwise distances” concerns Approximate index recall is unnecessary for this dataset; the reported problem instead is Magnitude dominates scores when direction matters. Use VECTOR_NORMALIZE or equivalent supported normalization before dot product when appropriate.
B:
“Use supported VECTOR type with correct dimensions for numeric embeddings” concerns Numeric similarity queries are slow and error-prone; the reported problem instead is Magnitude dominates scores when direction matters. Use VECTOR_NORMALIZE or equivalent supported normalization before dot product when appropriate.
C:
“Use supported vector index with VECTOR_SEARCH latest syntax when applicable” concerns Exact full scans miss API latency target; the reported problem instead is Magnitude dominates scores when direction matters. Use VECTOR_NORMALIZE or equivalent supported normalization before dot product when appropriate.
Question 698
A database engineer at Juniper Commerce is investigating this case: A vector search workflow compares dot products but embeddings have different magnitudes. The relevant finding is: Magnitude dominates scores when direction matters. What isolated pilot would provide the strongest evidence before rollout?
- Compare approximate top-k results with exact baseline on test vectors
- Query synthetic vectors from tenant A and B under An identity
- Normalize synthetic equal-direction unequal-length vectors
- Insert sample vectors with intended dimension into test schema
Explanation
Correct Answer
C:
Magnitude dominates scores when direction matters. Normalize synthetic equal-direction unequal-length vectors.
Incorrect Answers
A:
“Compare approximate top-k results with exact baseline on test vectors” concerns Exact full scans miss API latency target; the reported problem instead is Magnitude dominates scores when direction matters. Normalize synthetic equal-direction unequal-length vectors.
B:
“Query synthetic vectors from tenant A and B under An identity” addresses the tenant-scoped vector retrieval situation—top-k results may contain another tenant's content. The observed failure is: Magnitude dominates scores when direction matters. Normalize synthetic equal-direction unequal-length vectors.
D:
“Insert sample vectors with intended dimension into test schema” concerns Queries fail during similarity calculation; the reported problem instead is Magnitude dominates scores when direction matters. Normalize synthetic equal-direction unequal-length vectors.
Question 699
Summit Logistics is responsible for an Azure SQL or Microsoft SQL workload. A vector search workflow compares dot products but embeddings have different magnitudes. Operational evidence: Magnitude dominates scores when direction matters. Which acceptance result most directly demonstrates the requirement has been satisfied?
- Only exact intended identifier is treated as match
- Final ranking reflects both signals without mixing incompatible raw units
- Chosen retrieval meets pre-agreed relevance and latency thresholds
- Normalized similarity reflects intended angular relationship
Explanation
Correct Answer
D:
Magnitude dominates scores when direction matters. Normalized similarity reflects intended angular relationship.
Incorrect Answers
A:
“Only exact intended identifier is treated as match” concerns Semantic nearest-neighbor may return related but incorrect codes; the reported problem instead is Magnitude dominates scores when direction matters. Normalized similarity reflects intended angular relationship.
B:
“Final ranking reflects both signals without mixing incompatible raw units” concerns Raw score addition unfairly favors one system; the reported problem instead is Magnitude dominates scores when direction matters. Normalized similarity reflects intended angular relationship.
C:
“Chosen retrieval meets pre-agreed relevance and latency thresholds” concerns Latency metric alone says nothing about retrieval quality; the reported problem instead is Magnitude dominates scores when direction matters. Normalized similarity reflects intended angular relationship.
Question 700
At BrightPath Studios, a vector search workflow compares dot products but embeddings have different magnitudes. The observed constraint is: Magnitude dominates scores when direction matters. What operational condition would provide the earliest useful regression warning?
- Monitor hybrid precision and token query failures
- Monitor zero vectors and normalization failures
- Monitor drift in search quality and zero-result rates
- Monitor mixed-version vectors and staleness
Explanation
Correct Answer
B:
Magnitude dominates scores when direction matters. Monitor zero vectors and normalization failures.
Incorrect Answers
A:
“Monitor hybrid precision and token query failures” concerns Vector-only retrieval misses exact part number matches; the reported problem instead is Magnitude dominates scores when direction matters. Monitor zero vectors and normalization failures.
C:
“Monitor drift in search quality and zero-result rates” concerns Latency metric alone says nothing about retrieval quality; the reported problem instead is Magnitude dominates scores when direction matters. Monitor zero vectors and normalization failures.
D:
“Monitor mixed-version vectors and staleness” concerns New query embeddings and historical vectors are incompatible semantically; the reported problem instead is Magnitude dominates scores when direction matters. Monitor zero vectors and normalization failures.