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 21

Question 200

An address matching prototype compares candidate names by substitution and insertion cost. Which solution is most directly applicable?

  1. Use EDIT_DISTANCE for character-edit similarity analysis
  2. Use REGEXP_REPLACE to replace portions matching a regular expression
  3. Use REGEXP_LIKE for a regular-expression predicate on supported engines
  4. Use a recursive CTE for a bounded hierarchy traversal

Explanation

Correct Answer

A:

This approach measures edit operations needed between two strings.

Incorrect Answers

B:

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

C:

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.

D:

This alternative repeatedly joins a parent-child relationship across levels. This does not meet the need for a method that measures edit operations needed between two strings.

Question 201

A marketing team categorizes ordered customer lifetime values into four roughly equal segments. What should the engineer choose?

  1. Use RANK() when tied positions should leave ranking gaps
  2. Use NTILE(4) OVER to divide ordered rows into four buckets
  3. Use LAG() to compare a row with its preceding ordered value
  4. Use ROW_NUMBER() OVER with a deterministic partition and order

Explanation

Correct Answer

B:

This implementation assigns approximate quantile groups by ordered position.

Incorrect Answers

A:

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

C:

This choice accesses a prior row without a self-join. This does not meet the need for a method that assigns approximate quantile groups by ordered position.

D:

This choice assigns a distinct row position inside each group. This does not meet the need for a method that assigns approximate quantile groups by ordered position.

Question 202

A customer profile cleanup labels each duplicate row with an ordered rank for review. The target SQL engine supports the named T-SQL feature. Which implementation is the best fit?

  1. Use LEAD() to inspect the next row in a series
  2. Use RANK() when tied positions should leave ranking gaps
  3. Use LAG() to compare a row with its preceding ordered value
  4. Use ROW_NUMBER() OVER with a deterministic partition and order

Explanation

Correct Answer

D:

This choice assigns a distinct row position inside each group.

Incorrect Answers

A:

This alternative accesses following rows inside an ordered partition. This does not meet the need for a method that assigns a distinct row position inside each group.

B:

This option models competition-style positions with ties. This does not meet the need for a method that assigns a distinct row position inside each group.

C:

This option accesses a prior row without a self-join. This does not meet the need for a method that assigns a distinct row position inside each group.

Question 203

A staffing report groups ordered completion times into four similarly sized bands. What is the most appropriate design decision?

  1. Use LAG() to compare a row with its preceding ordered value
  2. Use AVG() OVER(PARTITION BY ...) for a group statistic on each detail row
  3. Use NTILE(4) OVER to divide ordered rows into four buckets
  4. Use SUM(amount) OVER(PARTITION BY ... ORDER BY ...) with an appropriate frame

Explanation

Correct Answer

C:

This choice assigns approximate quantile groups by ordered position.

Incorrect Answers

A:

This choice accesses a prior row without a self-join. This does not meet the need for a method that assigns approximate quantile groups by ordered position.

B:

That technique preserves each input row while exposing its peer-group average. This does not meet the need for a method that assigns approximate quantile groups by ordered position.

D:

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

Question 204

A department report walks a bounded tree of management levels. Which technical choice addresses this need?

  1. Use REGEXP_LIKE for a regular-expression predicate on supported engines
  2. Use a recursive CTE for a bounded hierarchy traversal
  3. Use REGEXP_REPLACE to replace portions matching a regular expression
  4. Use EDIT_DISTANCE for character-edit similarity analysis

Explanation

Correct Answer

B:

This choice repeatedly joins a parent-child relationship across levels.

Incorrect Answers

A:

This option evaluates whether a string matches a regex expression. This does not meet the need for a method that repeatedly joins a parent-child relationship across levels.

C:

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

D:

This option measures edit operations needed between two strings. This does not meet the need for a method that repeatedly joins a parent-child relationship across levels.

Question 205

A service groups multiple shipment tracking numbers into an array per order. Which implementation is the best fit?

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

Explanation

Correct Answer

A:

This choice combines multiple SQL row values into one JSON array.

Incorrect Answers

B:

This choice returns a single scalar SQL expression from a JSON path. This does not meet the need for a method that combines multiple SQL row values into one JSON array.

C:

This choice expands array elements into table-shaped rows. This does not meet the need for a method that combines multiple SQL row values into one JSON array.

D:

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

Question 206

A release log collects affected table names into one readable line per deployment. The target SQL engine supports the named T-SQL feature. Which solution is most directly applicable?

  1. Use STRING_AGG to combine multiple row strings into one delimited output
  2. Use EXISTS for a correlated existence test
  3. Use COALESCE to select the first non-null expression
  4. Use NOT EXISTS for an anti-join condition

Explanation

Correct Answer

A:

This implementation aggregates text values over a group.

Incorrect Answers

B:

That technique filters rows by presence without returning or duplicating matching children. This does not meet the need for a method that aggregates text values over a group.

C:

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

D:

This choice keeps rows with no matching counterpart. This does not meet the need for a method that aggregates text values over a group.

Question 207

A REST message contains one customerId field that a query must read. What should the engineer choose?

  1. Use JSON_OBJECT to construct a JSON object from relational values
  2. Use JSON_VALUE to extract a scalar property from a JSON document
  3. Use ISJSON before processing untrusted JSON text
  4. Use JSON_QUERY to extract an object or array fragment

Explanation

Correct Answer

B:

This approach returns a single scalar SQL expression from a JSON path.

Incorrect Answers

A:

This alternative serializes named SQL expressions into a single JSON object. This does not meet the need for a method that returns a single scalar SQL expression from a JSON path.

C:

That technique tests whether input has valid JSON structure. This does not meet the need for a method that returns a single scalar SQL expression from a JSON path.

D:

This option returns JSON-shaped nested content rather than a scalar. This does not meet the need for a method that returns a single scalar SQL expression from a JSON path.

Question 208

A cleaning query flags records with an irregular structured tag format. What should the SQL developer implement?

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

Explanation

Correct Answer

A:

This approach evaluates whether a string matches a regex expression.

Incorrect Answers

B:

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

C:

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

D:

This option transforms substrings identified by a regex. This does not meet the need for a method that evaluates whether a string matches a regex expression.

Question 209

A test harness must construct a JSON array from selected scalar variables. Which technical choice addresses this need?

  1. Use JSON_ARRAYAGG for an array aggregated from rows
  2. Use JSON_QUERY to extract an object or array fragment
  3. Use JSON_ARRAY to build an array from explicit expressions
  4. Use OPENJSON to transform a JSON array into a relational rowset

Explanation

Correct Answer

C:

This implementation fits because it creates JSON array values from supplied arguments. That addresses the stated technical constraint.

Incorrect Answers

A:

This alternative combines multiple SQL row values into one JSON array. This does not meet the need for a method that creates JSON array values from supplied arguments.

B:

This option returns JSON-shaped nested content rather than a scalar. This does not meet the need for a method that creates JSON array values from supplied arguments.

D:

This option expands array elements into table-shaped rows. This does not meet the need for a method that creates JSON array values from supplied arguments.

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.

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