Microsoft DP-800 (Developing AI-Enabled Database Solutions) Practice Test 9

Question 80

Continuous delivery must apply a reviewed DACPAC's desired schema to a target Azure SQL database. What should be configured to meet this objective?

  1. Script action
  2. DeployReport action
  3. Extract action
  4. Publish action

Explanation

Correct Answer

D:

Publish compares the DACPAC model with the target and performs required schema operations, with configurable deployment safeguards.

Incorrect Answers

A:

Script produces the deployment operations as SQL text for inspection before a separately authorized execution; the alternative cannot substitute for Publish action under the given constraints.

B:

DeployReport emits an XML description of deployment changes rather than applying them directly; the condition in the stem is resolved by Publish action, not by this feature alone.

C:

Extract captures a database schema into a package suitable for inspection and project initialization, without being a full table-data export; the missing behavior is Publish action; this mechanism does something else.

Question 81

An agent pulls thousands of long chunks into the prompt, exceeding model context windows and increasing cost without improving answer relevance. What should the developer implement?

  1. Retry transient model throttling
  2. Limit retrieved context
  3. Redact confidential fields
  4. Audit retrieved sources

Explanation

Correct Answer

B:

Limiting and ranking context passages keeps input within token budgets and reduces irrelevant material sent to the generator.

Incorrect Answers

A:

Rate-limit-aware retries and idempotent request handling reduce failures without overwhelming the inference service; it addresses a different step; the question calls for Limit retrieved context.

C:

Redaction and data minimization remove unnecessary secrets or identifiers before leaving the SQL trust boundary; the required capability here is Limit retrieved context, which this operation does not supply.

D:

Logging approved source identifiers and prompt metadata creates a traceable record for investigation without storing unrestricted sensitive content; the alternative cannot substitute for Limit retrieved context under the given constraints.

Question 82

Every country designation is exactly two single-byte characters and a fixed-length representation is desired. Which option satisfies the desired behavior most directly?

  1. VARCHAR(80)
  2. DATE type
  3. CHAR(2)
  4. DECIMAL(12,2)

Explanation

Correct Answer

C:

CHAR stores fixed-length non-Unicode character data, with padding semantics for shorter supplied values.

Incorrect Answers

A:

VARCHAR holds variable-length non-Unicode text subject to the column's collation/code page, with less storage than NVARCHAR for many such values; the missing behavior is CHAR(2); this mechanism does something else.

B:

DATE represents a date without a time-of-day portion, simplifying comparisons that should ignore clock time; that function is not interchangeable with CHAR(2) for the requested result.

D:

DECIMAL provides exact base-ten precision and a declared scale appropriate to financial arithmetic; it addresses a different step; the question calls for CHAR(2).

Question 83

Several short evidence snippets must be joined into one delimited prompt string with a predictable separator. Which database mechanism should be chosen?

  1. STRING_AGG
  2. JSON_ARRAYAGG
  3. FOR JSON PATH
  4. JSON_OBJECT

Explanation

Correct Answer

A:

STRING_AGG concatenates values across rows with a selected delimiter, subject to ordering and type considerations.

Incorrect Answers

B:

JSON_ARRAYAGG aggregates expressions into JSON arrays using supported SQL engine functionality; the alternative cannot substitute for STRING_AGG under the given constraints.

C:

FOR JSON PATH transforms SQL query results into JSON structures using explicit alias-based paths; the condition in the stem is resolved by STRING_AGG, not by this feature alone.

D:

JSON_OBJECT composes named key-value JSON data without fragile manual quote and comma concatenation; the missing behavior is STRING_AGG; this mechanism does something else.

Question 84

An inventory REST client requires rows ordered by updated timestamp to display the oldest pending changes first. Which approach should the team select?

  1. `$select`
  2. `$filter`
  3. `$orderby`
  4. `$after`

Explanation

Correct Answer

C:

The REST orderby parameter requests sorting by eligible exposed fields and directions.

Incorrect Answers

A:

The REST select parameter chooses output fields for the request and reduces unneeded projection; for the stated conditions, the deciding feature is `$orderby` rather than this behavior.

B:

The DAB REST filter query parameter applies server-side row filtering according to the configured entity's capabilities; it addresses a different step; the question calls for `$orderby`.

D:

The after parameter advances keyset-style pagination using a continuation value supplied by DAB; the required capability here is `$orderby`, which this operation does not supply.

Question 85

The tool server must access Azure SQL without distributing an administrator password among assistant users. Which database mechanism should be chosen?

  1. Authorization policy on tool calls
  2. Database service identity
  3. MCP tool server
  4. MCP client

Explanation

Correct Answer

B:

A managed or workload identity can acquire authorized tokens for compatible SQL access, requiring appropriate database grants.

Incorrect Answers

A:

Tool-side authorization and command restrictions should enforce permitted operations independently of natural-language prompt instructions; the condition in the stem is resolved by Database service identity, not by this feature alone.

C:

An MCP server exposes tool capabilities to a compatible client; the tool's database permissions still depend on its backend identity; that function is not interchangeable with Database service identity for the requested result.

D:

An MCP client connects to configured servers and consumes advertised capabilities while respecting its security controls; for the stated conditions, the deciding feature is Database service identity rather than this behavior.

Question 86

An Azure SQL procedure is already authorized to call an external HTTPS endpoint. Its deployment standard requires authentication details to be referenced through a named SQL database-scoped security object rather than passed in a header literal on each invocation. Which object serves that purpose?

  1. DATABASE SCOPED CREDENTIAL
  2. External-endpoint permission
  3. sp_invoke_external_rest_endpoint
  4. Managed identity authorization

Explanation

Correct Answer

A:

A DATABASE SCOPED CREDENTIAL is a named database-level object that stores or references authentication information used by permitted outbound endpoint calls; the procedure need not place a literal key in each request.

Incorrect Answers

B:

EXECUTE ANY EXTERNAL ENDPOINT is the relevant database permission for calling the supported external REST procedure; the required capability here is DATABASE SCOPED CREDENTIAL, which this operation does not supply.

C:

sp_invoke_external_rest_endpoint invokes HTTPS endpoints with configured payload, headers, timeout, and credentials where supported; the alternative cannot substitute for DATABASE SCOPED CREDENTIAL under the given constraints.

D:

Managed identity authentication can authorize a supported outbound model call when the identity has the required destination role; the condition in the stem is resolved by DATABASE SCOPED CREDENTIAL, not by this feature alone.

Question 87

One shared vector index serves multiple customers and every search must constrain results to the authenticated tenant. Which feature would solve the stated problem?

  1. Embedding-model version field
  2. VECTOR(n) column
  3. DocumentId foreign key
  4. TenantId metadata field

Explanation

Correct Answer

D:

Tenant metadata supports enforced isolation filters; vector similarity alone does not authorize document access.

Incorrect Answers

A:

Recording model version alongside vectors enables matching query embeddings to the correct indexed corpus; that function is not interchangeable with TenantId metadata field for the requested result.

B:

The VECTOR type stores fixed-dimensional floating-point arrays in an optimized representation compatible with vector functions; for the stated conditions, the deciding feature is TenantId metadata field rather than this behavior.

C:

A stable relational source key links vector rows to documents independently of their numeric embedding contents; it addresses a different step; the question calls for TenantId metadata field.

Question 88

A SQL workflow calls a hosted embedding deployment and must avoid permanently storing an AI service key in query text. What is the right solution for this specific requirement?

  1. Sensitive-data minimization
  2. Managed identity to Azure AI
  3. Restricted model EXECUTE rights
  4. Endpoint rate-limit handling

Explanation

Correct Answer

B:

Managed identity authentication can replace static secrets for supported endpoints when the workload identity receives the required service roles.

Incorrect Answers

A:

Minimizing model inputs to approved fields limits unnecessary disclosure and reduces retention and compliance risk; the alternative cannot substitute for Managed identity to Azure AI under the given constraints.

C:

Model-specific EXECUTE permissions can limit who invokes the external model, separately from SELECT on its source tables; the missing behavior is Managed identity to Azure AI; this mechanism does something else.

D:

Backoff, rate-limit-aware batching, and idempotent checkpoints handle transient throttling while protecting upstream model capacity; that function is not interchangeable with Managed identity to Azure AI for the requested result.

Question 89

A data-quality workflow needs the minimum insertions, deletions, or substitutions needed to turn one normalized product name into another. What is the most appropriate design decision?

  1. EDIT_DISTANCE_SIMILARITY
  2. EDIT_DISTANCE
  3. SOUNDEX
  4. JARO_WINKLER_DISTANCE

Explanation

Correct Answer

B:

EDIT_DISTANCE measures Levenshtein-style edit operations between two strings and returns a distance rather than a similarity label.

Incorrect Answers

A:

EDIT_DISTANCE_SIMILARITY converts an edit-distance relationship into a similarity measure, making threshold comparisons easier; it addresses a different step; the question calls for EDIT_DISTANCE.

C:

SOUNDEX converts a string into a phonetic code for approximate pronunciation comparison, with limits across languages; the required capability here is EDIT_DISTANCE, which this operation does not supply.

D:

JARO_WINKLER_DISTANCE applies Jaro-Winkler name-oriented matching behavior rather than simple adjacent-edit counting; the alternative cannot substitute for EDIT_DISTANCE under the given constraints.

Question 90

A customer profile JSON result must omit an optional MiddleName property entirely if it is SQL NULL, while retaining required name and identifier fields. Which technique applies to this scenario?

  1. FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
  2. JSON_ARRAYAGG with NULL ON NULL
  3. JSON_ARRAY
  4. JSON_OBJECT with ABSENT ON NULL

Explanation

Correct Answer

D:

JSON_OBJECT with ABSENT ON NULL suppresses keys whose SQL expressions are NULL; its default NULL ON NULL behavior would instead emit those keys with JSON null values.

Incorrect Answers

A:

FOR JSON PATH with WITHOUT_ARRAY_WRAPPER removes the enclosing JSON array for a single-row result; use it only when cardinality and JSON validity are controlled; the missing behavior is JSON_OBJECT with ABSENT ON NULL; this mechanism does something else.

B:

JSON_ARRAYAGG with NULL ON NULL retains SQL NULL inputs as JSON null elements; its usual ABSENT ON NULL behavior would omit those array slots; that function is not interchangeable with JSON_OBJECT with ABSENT ON NULL for the requested result.

C:

JSON_ARRAY constructs an array value from its supplied scalar expressions; for the stated conditions, the deciding feature is JSON_OBJECT with ABSENT ON NULL rather than this behavior.

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