Question 220
A module must perform controlled work using a designated execution principal instead of the caller's full original context. What is the most appropriate design decision?
- Ownership chaining
- EXECUTE AS execution context
- Module signing
- EXECUTE permission
- INSTEAD OF DELETE trigger
Explanation
Correct Answer
B:EXECUTE AS switches a supported module's permission-checking context, and should be used with explicit least-privilege considerations.
Incorrect Answers
A:Ownership chaining can allow access through a module when ownership and permission conditions are satisfied; cross-owner paths are different; for the stated conditions, the deciding feature is EXECUTE AS execution context rather than this behavior.
C:Module signing can associate certificate-based permissions with module execution, avoiding blanket grants to all application principals; this differs from the EXECUTE AS execution context requirement described in the scenario.
D:Granting EXECUTE on the procedure permits calling that module without granting unrestricted base-table DML, subject to ownership and execution context; the required capability here is EXECUTE AS execution context, which this operation does not supply.
E:An INSTEAD OF DELETE trigger can replace a requested deletion with custom SQL logic, including soft-delete behavior; the alternative cannot substitute for EXECUTE AS execution context under the given constraints.
Question 221
An invoice needs an expression-derived gross amount based on net amount and tax percentage without manual synchronization on every write. Which database mechanism should be chosen?
- Separate detail table
- Computed tax total
- Appropriate VARCHAR length
- Junction table
Explanation
Correct Answer
B:A computed column expresses the derivation in the database, reducing the risk of independently maintained contradictory values.
Incorrect Answers
A:A separate OrderLine child table models one-to-many details relationally with a foreign key and allows unbounded line counts; the condition in the stem is resolved by Computed tax total, not by this feature alone.
C:Using a bounded variable-length string type expresses the data contract and avoids needlessly applying large-object semantics; that function is not interchangeable with Computed tax total for the requested result.
D:A junction table resolves the many-to-many association and holds attributes belonging to a specific pairing; for the stated conditions, the deciding feature is Computed tax total rather than this behavior.
Question 222
A new lookup table exists after schema publication and now needs mandatory static seed rows. Which mechanism addresses the requirement?
- DACPAC dependency-aware publish
- Build dependency validation
- Pre-deployment script
- Post-deployment script
Explanation
Correct Answer
D:A post-deployment script runs after main schema changes and can populate approved reference data.
Incorrect Answers
A:DacFx's deployment plan accounts for model dependencies when generating schema changes for the target; this differs from the Post-deployment script requirement described in the scenario.
B:Building the SQL project validates supported references against the modeled database schema; the required capability here is Post-deployment script, which this operation does not supply.
C:A pre-deployment script executes at the designated stage of database project publishing and must be designed safely and idempotently; the alternative cannot substitute for Post-deployment script under the given constraints.
Question 223
A reusable data-cleaning calculation must return exactly one normalized string to be consumed in an expression. Which option would you recommend?
- Scalar function
- Inline table-valued function
- Stored procedure
- Multi-statement table-valued function
Explanation
Correct Answer
A:A scalar UDF returns a single scalar value, although calling patterns and implementation determine its performance.
Incorrect Answers
B:An inline TVF returns the result of a single SELECT definition and is commonly optimized similarly to a parameterized view; for the stated conditions, the deciding feature is Scalar function rather than this behavior.
C:A stored procedure is an executable unit suited to procedural database operations; it is not directly a relational table expression; it addresses a different step; the question calls for Scalar function.
D:A multi-statement TVF declares a table return variable and populates it with multiple statements, subject to different optimizer behavior than inline TVFs; this differs from the Scalar function requirement described in the scenario.
Question 224
A stored procedure has a documented successful input scenario; reviewers must assert its exact return values after a code change. Which option would you recommend?
- Positive-path unit test
- Boundary-value test
- Migration integration test
- Permission-negative test
Explanation
Correct Answer
A:Positive-path unit tests validate intended output and state changes against known inputs.
Incorrect Answers
B:Boundary tests target conditions at and near validation thresholds where logic defects commonly occur; the condition in the stem is resolved by Positive-path unit test, not by this feature alone.
C:Integration tests after migration exercise live data transformations, object dependencies, and application-critical behavior; the missing behavior is Positive-path unit test; this mechanism does something else.
D:Negative authorization tests verify forbidden operations fail with the actual application principal rather than assuming intended grants; that function is not interchangeable with Positive-path unit test for the requested result.
Question 225
The model answers poorly because the needed passage is missing from the top results, even when the generator follows its prompt. What should be configured to meet this objective?
- Answer-latency budget
- Retrieval recall benchmark
- Citation correctness check
- Groundedness evaluation
Explanation
Correct Answer
B:Measuring retrieval recall on labeled questions isolates missing-evidence failures from generation mistakes.
Incorrect Answers
A:Stage-level latency instrumentation attributes end-to-end delay to retrieval, context assembly, and generation for targeted optimization; it addresses a different step; the question calls for Retrieval recall benchmark.
C:Citation evaluation checks correspondence between produced claims and referenced evidence instead of merely counting links; the required capability here is Retrieval recall benchmark, which this operation does not supply.
D:Groundedness evaluation compares answer claims with supplied evidence, helping flag unsupported generation; the alternative cannot substitute for Retrieval recall benchmark under the given constraints.
Question 226
A team enables an AI chat extension that can invoke external tools and wants to review which actions the assistant is authorized to perform. Which action is justified by these conditions?
- Review tool audit trail
- Chat tool permissions
- Chat model selection
- MCP server configuration
- Repository copilot-instructions.md
Explanation
Correct Answer
B:Tool permission and approval settings control reachable actions in the assistant session and need restriction before permitting database access.
Incorrect Answers
A:Recording tool-call identities, operations, and outcomes supports accountability and incident investigation independently of conversation text; the missing behavior is Chat tool permissions; this mechanism does something else.
C:The assistant's model selection controls model behavior in the supported chat tool, not the runtime semantics of deployed T-SQL; for the stated conditions, the deciding feature is Chat tool permissions rather than this behavior.
D:Configuring an MCP server endpoint tells an MCP-capable client which tool host it may contact, subject to authentication and policy; it addresses a different step; the question calls for Chat tool permissions.
E:A repository instruction file can communicate persistent project-specific guidance to compatible GitHub Copilot tooling, without changing database enforcement rules; this differs from the Chat tool permissions requirement described in the scenario.
Question 227
A result page supplied a continuation token, and the caller needs the following page instead of restarting from the first records. Which technique applies to this scenario?
- `$after`
- `$select`
- `$orderby`
- `$filter`
Explanation
Correct Answer
A:The after parameter advances keyset-style pagination using a continuation value supplied by DAB.
Incorrect Answers
B:The REST select parameter chooses output fields for the request and reduces unneeded projection; the alternative cannot substitute for `$after` under the given constraints.
C:The REST orderby parameter requests sorting by eligible exposed fields and directions; the condition in the stem is resolved by `$after`, not by this feature alone.
D:The DAB REST filter query parameter applies server-side row filtering according to the configured entity's capabilities; the missing behavior is `$after`; this mechanism does something else.
Question 228
Security teams need to query and correlate collected SQL diagnostic records over time using centralized log queries. Which database mechanism should be chosen?
- Azure Monitor alerts
- SQL auditing
- Query Store
- Log Analytics workspace
Explanation
Correct Answer
D:Log Analytics stores supported telemetry for KQL-based investigation when diagnostics are configured to send records there.
Incorrect Answers
A:Azure Monitor evaluates selected signals against alert rules and can notify or trigger responses; it is not a row-authorization mechanism; for the stated conditions, the deciding feature is Log Analytics workspace rather than this behavior.
B:SQL auditing records configured database or server actions to an audit target, supporting investigations rather than blocking the statements themselves; it addresses a different step; the question calls for Log Analytics workspace.
C:Query Store persists execution-plan and runtime-performance information for eligible queries rather than serving as an authentication audit log; this differs from the Log Analytics workspace requirement described in the scenario.
Question 229
A document search service needs one candidate list for exact terms, one for semantic similarity, and a rank-based combination that avoids equating raw keyword scores with vector distances. Which THREE pipeline components deliver this? Choose THREE.
- Vector candidate pipeline
- Lexical candidate pipeline
- Semantic vector search
- Exact SQL vector functions
- RRF fusion stage
- Final document authorization check
Explanation
Correct Answers
A:Vector-neighbor retrieval produces semantic candidate IDs and distance-based order for the second fusion input; used in combination with Lexical candidate pipeline, RRF fusion stage, it handles a separate requirement of this combined workflow.
B:Full-text predicates or table-valued search functions can produce lexical matches and optional rank values as one fusion input; used in combination with RRF fusion stage, Vector candidate pipeline, it handles a separate requirement of this combined workflow.
E:RRF converts each result rank into reciprocal contributions and sums them across available lists; used in combination with Lexical candidate pipeline, Vector candidate pipeline, it handles a separate requirement of this combined workflow.
Incorrect Answers
C:Vector search compares embedding representations and can retrieve semantic neighbors despite different literal words; that function is not interchangeable with Vector candidate pipeline and Lexical candidate pipeline and RRF fusion stage for the requested result.
D:VECTOR and VECTOR_DISTANCE provide exact vector operations separately from optional approximate index support; for the stated conditions, the deciding feature is Vector candidate pipeline and Lexical candidate pipeline and RRF fusion stage rather than this behavior.
F:Authorization-aware source hydration prevents relevant-but-private candidate rows from becoming unauthorized LLM context; this differs from the Vector candidate pipeline and Lexical candidate pipeline and RRF fusion stage requirement described in the scenario.
Question 230
Two otherwise similar candidates differ only because one is 2nd and the other 20th in the same component list. Which technique applies to this scenario?
- Dual-list presence
- Higher rank position
- Rank fusion without score calibration
- Reciprocal-rank contribution
Explanation
Correct Answer
B:Reciprocal rank scoring gives a larger contribution to the higher-ranked item because its rank denominator is smaller.
Incorrect Answers
A:RRF aggregates contributions across lists, so consistently highly ranked documents can outrank one-list specialists; this differs from the Higher rank position requirement described in the scenario.
C:RRF works on rank positions, avoiding a need to equate arbitrary lexical and vector score magnitudes; the alternative cannot substitute for Higher rank position under the given constraints.
D:RRF sums reciprocal-rank terms for each ranking list where a document appears, so missing-list contributions are simply absent; the condition in the stem is resolved by Higher rank position, not by this feature alone.