A data cleaning process needs to identify customer names that are likely duplicates due to typos, such as 'Jon Smith' vs 'John Smith'. The process should return pairs with a similarity score above 0.8. Which function should you use in the query?

SOUNDEX to compare phonetic similarity

EDIT_DISTANCE to count the number of character changes needed

JARO_WINKLER_DISTANCE between the two name columns

REGEXP_LIKE to check if the names contain the same letters

In a correlated subquery, how often is the subquery typically executed?

Once for each row processed by the outer query

Only when the outer query returns no rows

Microsoft Certified:SQL AI Developer Associate

Domain 1Objective 3

Write Advanced T-SQL Code DP-800 Practice Questions (Page 5)

Part of the Design and develop database solutions domain, which accounts for 35–40% of the DP-800 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~18–32 in this domain), expect 5–8 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

8concepts

35–40%of the exam

Questions 21–25

21application · medium
A data cleaning process needs to identify customer names that are likely duplicates due to typos, such as 'Jon Smith' vs 'John Smith'. The process should return pairs with a similarity score above 0.8. Which function should you use in the query?
Select an answer first
22foundation · easy
You are writing a T-SQL query that must reference a derived result set multiple times within the same query. Which T-SQL construct is designed to define a temporary named result set that can be referenced in a SELECT, INSERT, UPDATE, or DELETE statement within the scope of a single query?
Select an answer first
23foundation · easy
In a correlated subquery, how often is the subquery typically executed?
Select an answer first
24foundation · easy
In SQL Server, which function is used to perform regular expression pattern matching in a query?
Select an answer first
25foundation · easy
In SQL Server graph tables, which T-SQL clause is used to specify a graph traversal pattern in a query?
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.

Write Advanced T-SQL Code DP-800 Practice Questions (Page 5)

Questions 21–25

A data cleaning process needs to identify customer names that are likely duplicates due to typos, such as 'Jon Smith' vs 'John Smith'. The process should return pairs with a similarity score above 0.8. Which function should you use in the query?

You are writing a T-SQL query that must reference a derived result set multiple times within the same query. Which T-SQL construct is designed to define a temporary named result set that can be referenced in a SELECT, INSERT, UPDATE, or DELETE statement within the scope of a single query?

In a correlated subquery, how often is the subquery typically executed?

In SQL Server, which function is used to perform regular expression pattern matching in a query?

In SQL Server graph tables, which T-SQL clause is used to specify a graph traversal pattern in a query?

Keep studying — Design and develop database solutions