A real estate platform stores property listings in Azure SQL Database. Users search for 'modern apartment with city view' and expect to find listings described as 'contemporary flat overlooking downtown'. Which search method will return these semantically similar listings?

Generate embeddings for listing descriptions and use VECTOR_SEARCH to find similar listings.

Enable full-text search with a custom thesaurus mapping 'modern' to 'contemporary' and 'apartment' to 'flat'.

Use the SOUNDEX function to match phonetically similar words.

Use full-text search with CONTAINS and OR conditions for each possible synonym.

A search application uses hybrid search with full-text and vector components. The full-text results are highly relevant for exact terms, while vector results are better for conceptual matches. The team wants to combine the two ranked lists into a single result set. Which technique should they use?

Averaging the relevance scores from both methods

Using only the vector results because they are more comprehensive

Union of both result sets without re-ranking

Microsoft Certified:SQL AI Developer Associate

Domain 3Objective 2

Design and Implement Intelligent Search DP-800 Practice Questions (Page 1)

Part of the Implement AI capabilities in database solutions domain, which accounts for 25–30% of the DP-800 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~13–24 in this domain), expect 4–8 from this objective — we provide 47 practice questions to prepare you well beyond it. (estimate)

47questions here

10free pages

10concepts

25–30%of the exam

Questions 1–5

1foundation · easy
Which T-SQL function is used to perform a vector similarity search in SQL Server 2025?
Select an answer first
2foundation · easy
Which performance metric is most directly affected by the choice between ANN and ENN indexes?
Select an answer first
3application · medium
A developer wants to verify that a VECTOR column is properly configured and to check its properties, such as the number of dimensions. Which function should they use?
Select an answer first
4application · medium
A real estate platform stores property listings in Azure SQL Database. Users search for 'modern apartment with city view' and expect to find listings described as 'contemporary flat overlooking downtown'. Which search method will return these semantically similar listings?
Select an answer first
5application · medium
A search application uses hybrid search with full-text and vector components. The full-text results are highly relevant for exact terms, while vector results are better for conceptual matches. The team wants to combine the two ranked lists into a single result set. Which technique should they use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-800

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-800” is a trademark of its owner, used for identification only.

Design and Implement Intelligent Search DP-800 Practice Questions (Page 1)

Questions 1–5

Which T-SQL function is used to perform a vector similarity search in SQL Server 2025?

Which performance metric is most directly affected by the choice between ANN and ENN indexes?

A developer wants to verify that a VECTOR column is properly configured and to check its properties, such as the number of dimensions. Which function should they use?

A real estate platform stores property listings in Azure SQL Database. Users search for 'modern apartment with city view' and expect to find listings described as 'contemporary flat overlooking downtown'. Which search method will return these semantically similar listings?

A search application uses hybrid search with full-text and vector components. The full-text results are highly relevant for exact terms, while vector results are better for conceptual matches. The team wants to combine the two ranked lists into a single result set. Which technique should they use?

Keep studying — Implement AI capabilities in database solutions