McAfee Secured

Exam Code: DP-800

Exam Name: Developing AI-Enabled Database Solutions

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: SQL AI Developer Associate

100% Microsoft DP-800 Guaranteed Success With Testking Training Materials

Get Real DP-800 Exam Questions & Expert Verified Answers as Experienced on the Real Exam!

101 Questions & Answers with Testing Engine

"Developing AI-Enabled Database Solutions Exam", also known as DP-800 exam, is a Microsoft certification exam.

Pass your tests with the always up-to-date DP-800 Exam Engine. Your DP-800 training materials keep you at the head of the pack!

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Was: $137.49
Now: $124.99

Microsoft DP-800 Practice Test 22

Question 210

An integration routine needs to set an existing JSON state field. The target SQL engine supports the named T-SQL feature. Which technical choice addresses this need?

  1. Use JSON_ARRAYAGG for an array aggregated from rows
  2. Use OPENJSON to transform a JSON array into a relational rowset
  3. Use JSON_MODIFY to change one property in JSON text
  4. Use JSON_QUERY to extract an object or array fragment

Explanation

Correct Answer

C:

This approach returns updated JSON content at a selected path.

Incorrect Answers

A:

That technique combines multiple SQL row values into one JSON array. This does not meet the need for a method that returns updated JSON content at a selected path.

B:

This choice expands array elements into table-shaped rows. This does not meet the need for a method that returns updated JSON content at a selected path.

D:

This choice returns JSON-shaped nested content rather than a scalar. This does not meet the need for a method that returns updated JSON content at a selected path.

Question 211

A sanitizer replaces each matched token pattern with a fixed marker. What is the most appropriate next design step?

  1. Use JARO_WINKLER_DISTANCE for name-oriented fuzzy comparison
  2. Use EDIT_DISTANCE for character-edit similarity analysis
  3. Use a recursive CTE for a bounded hierarchy traversal
  4. Use REGEXP_REPLACE to replace portions matching a regular expression

Explanation

Correct Answer

D:

This implementation transforms substrings identified by a regex.

Incorrect Answers

A:

This option measures likeness of string pairs especially near their prefixes. This does not meet the need for a method that transforms substrings identified by a regex.

B:

This alternative measures edit operations needed between two strings. This does not meet the need for a method that transforms substrings identified by a regex.

C:

This choice repeatedly joins a parent-child relationship across levels. This does not meet the need for a method that transforms substrings identified by a regex.

Question 212

An enrichment job records how many structured tokens appear in a free-text note. Which approach would you recommend?

  1. Use REGEXP_COUNT to count matches of a pattern
  2. Use a graph MATCH query over node and edge tables
  3. Use a recursive CTE for a bounded hierarchy traversal
  4. Use REGEXP_REPLACE to replace portions matching a regular expression

Explanation

Correct Answer

A:

This approach returns the number of regex occurrences.

Incorrect Answers

B:

This choice follows graph-pattern relationships stored in graph tables. This does not meet the need for a method that returns the number of regex occurrences.

C:

This option repeatedly joins a parent-child relationship across levels. This does not meet the need for a method that returns the number of regex occurrences.

D:

This option transforms substrings identified by a regex. This does not meet the need for a method that returns the number of regex occurrences.

Question 213

A diagnostic query pulls one matching reference token out of a stored message. Which solution is most directly applicable?

  1. Use REGEXP_LIKE for a regular-expression predicate on supported engines
  2. Use a graph MATCH query over node and edge tables
  3. Use a recursive CTE for a bounded hierarchy traversal
  4. Use REGEXP_SUBSTR to extract a regex-matched fragment

Explanation

Correct Answer

D:

This approach returns a portion of text matching a pattern.

Incorrect Answers

A:

This alternative evaluates whether a string matches a regex expression. This does not meet the need for a method that returns a portion of text matching a pattern.

B:

This option follows graph-pattern relationships stored in graph tables. This does not meet the need for a method that returns a portion of text matching a pattern.

C:

This alternative repeatedly joins a parent-child relationship across levels. This does not meet the need for a method that returns a portion of text matching a pattern.

Question 214

A prize list explicitly skips numeric places occupied by ties. The target SQL engine supports the named T-SQL feature. Which solution is most directly applicable?

  1. Use LAG() to compare a row with its preceding ordered value
  2. Use RANK() when tied positions should leave ranking gaps
  3. Use NTILE(4) OVER to divide ordered rows into four buckets
  4. Use LEAD() to inspect the next row in a series

Explanation

Correct Answer

B:

This implementation fits because it models competition-style positions with ties. That addresses the stated technical constraint.

Incorrect Answers

A:

That technique accesses a prior row without a self-join. This does not meet the need for a method that models competition-style positions with ties.

C:

This choice assigns approximate quantile groups by ordered position. This does not meet the need for a method that models competition-style positions with ties.

D:

This option accesses following rows inside an ordered partition. This does not meet the need for a method that models competition-style positions with ties.

Question 215

A record linkage prototype compares small variations in person names. What is the most appropriate next design step?

  1. Use REGEXP_SUBSTR to extract a regex-matched fragment
  2. Use REGEXP_COUNT to count matches of a pattern
  3. Use a graph MATCH query over node and edge tables
  4. Use JARO_WINKLER_DISTANCE for name-oriented fuzzy comparison

Explanation

Correct Answer

D:

This implementation measures likeness of string pairs especially near their prefixes.

Incorrect Answers

A:

This alternative returns a portion of text matching a pattern. This does not meet the need for a method that measures likeness of string pairs especially near their prefixes.

B:

This choice returns the number of regex occurrences. This does not meet the need for a method that measures likeness of string pairs especially near their prefixes.

C:

This choice follows graph-pattern relationships stored in graph tables. This does not meet the need for a method that measures likeness of string pairs especially near their prefixes.

Question 216

A donor ledger needs cumulative contributions without collapsing individual donations. What is the most appropriate design decision?

  1. Use SUM(amount) OVER(PARTITION BY ... ORDER BY ...) with an appropriate frame
  2. Use NTILE(4) OVER to divide ordered rows into four buckets
  3. Use AVG() OVER(PARTITION BY ...) for a group statistic on each detail row
  4. Use ROW_NUMBER() OVER with a deterministic partition and order

Explanation

Correct Answer

A:

This approach calculates a running total while retaining detail rows.

Incorrect Answers

B:

This option assigns approximate quantile groups by ordered position. This does not meet the need for a method that calculates a running total while retaining detail rows.

C:

This option preserves each input row while exposing its peer-group average. This does not meet the need for a method that calculates a running total while retaining detail rows.

D:

That technique assigns a distinct row position inside each group. This does not meet the need for a method that calculates a running total while retaining detail rows.

Question 217

A course roster includes each student's section average without losing student-level records. Which solution best satisfies the stated constraint?

  1. Use DENSE_RANK() for tied rankings without numeric gaps
  2. Use AVG() OVER(PARTITION BY ...) for a group statistic on each detail row
  3. Use ROW_NUMBER() OVER with a deterministic partition and order
  4. Use RANK() when tied positions should leave ranking gaps

Explanation

Correct Answer

B:

This implementation preserves each input row while exposing its peer-group average.

Incorrect Answers

A:

This alternative assigns equal ranks for ties and consecutive distinct ranks. This does not meet the need for a method that preserves each input row while exposing its peer-group average.

C:

That technique assigns a distinct row position inside each group. This does not meet the need for a method that preserves each input row while exposing its peer-group average.

D:

This alternative models competition-style positions with ties. This does not meet the need for a method that preserves each input row while exposing its peer-group average.

Question 218

A user-name deduplication routine needs a string edit distance instead of an exact equality test. The target SQL engine supports the named T-SQL feature. Which solution best satisfies the stated constraint?

  1. Use REGEXP_LIKE for a regular-expression predicate on supported engines
  2. Use REGEXP_SUBSTR to extract a regex-matched fragment
  3. Use REGEXP_REPLACE to replace portions matching a regular expression
  4. Use EDIT_DISTANCE for character-edit similarity analysis

Explanation

Correct Answer

D:

This choice measures edit operations needed between two strings.

Incorrect Answers

A:

That technique evaluates whether a string matches a regex expression. This does not meet the need for a method that measures edit operations needed between two strings.

B:

This alternative returns a portion of text matching a pattern. This does not meet the need for a method that measures edit operations needed between two strings.

C:

This alternative transforms substrings identified by a regex. This does not meet the need for a method that measures edit operations needed between two strings.

Question 219

An event report chooses the actual completion date or a fallback estimate when absent. What is the most appropriate next design step?

  1. Use NOT EXISTS for an anti-join condition
  2. Use OUTER APPLY to preserve left rows without matches
  3. Use STRING_AGG to combine multiple row strings into one delimited output
  4. Use COALESCE to select the first non-null expression

Explanation

Correct Answer

D:

This implementation supplies a fallback among ordered nullable values.

Incorrect Answers

A:

This alternative keeps rows with no matching counterpart. This does not meet the need for a method that supplies a fallback among ordered nullable values.

B:

That technique extends a correlated table expression while retaining unmatched outer rows. This does not meet the need for a method that supplies a fallback among ordered nullable values.

C:

That technique aggregates text values over a group. This does not meet the need for a method that supplies a fallback among ordered nullable values.

Question 220

An API response needs named properties composed from projected SQL values. What is the most appropriate next design step?

  1. Use ISJSON before processing untrusted JSON text
  2. Use JSON_MODIFY to change one property in JSON text
  3. Use JSON_OBJECT to construct a JSON object from relational values
  4. Use JSON_ARRAYAGG for an array aggregated from rows

Explanation

Correct Answer

C:

This implementation serializes named SQL expressions into a single JSON object.

Incorrect Answers

A:

This alternative tests whether input has valid JSON structure. This does not meet the need for a method that serializes named SQL expressions into a single JSON object.

B:

This alternative returns updated JSON content at a selected path. This does not meet the need for a method that serializes named SQL expressions into a single JSON object.

D:

This choice combines multiple SQL row values into one JSON array. This does not meet the need for a method that serializes named SQL expressions into a single JSON object.

Developing AI-Enabled Database Solutions (DP-800) Practice Tests