Question 490
A shared DAB endpoint needs Reader/Editor operation restrictions and a second SQL-level barrier that filters records by tenant even for broad API queries. Which TWO authorization layers are needed? Choose TWO.
- Entra JWT authentication
- TLS ingress
- Local DAB runtime
- Database Row-Level Security
- DAB authorization roles
Explanation
Correct Answers
D:SQL Row-Level Security applies within the database and complements, rather than replaces, API operation permissions; used in combination with DAB authorization roles, it handles a separate requirement of this combined workflow.
E:DAB entity role permissions limit which API operations authenticated roles can invoke; used in combination with Database Row-Level Security, it handles a separate requirement of this combined workflow.
Incorrect Answers
A:An Entra-compatible authentication provider validates signed tokens for a configured audience and issuer before authorization; the missing behavior is Database Row-Level Security and DAB authorization roles; this mechanism does something else.
B:HTTPS/TLS protects requests and responses in transit while leaving entity permissions and SQL grants to separate controls; that function is not interchangeable with Database Row-Level Security and DAB authorization roles for the requested result.
C:Running DAB locally supports iterative testing and debugging using its configuration and accessible development data source; for the stated conditions, the deciding feature is Database Row-Level Security and DAB authorization roles rather than this behavior.
Question 491
A predicate should test whether a JSON document includes an optional address.postcode path without retrieving its contents. What is the most appropriate design decision?
- JSON_MODIFY
- OPENJSON WITH
- JSON_PATH_EXISTS
- JSON_CONTAINS
Explanation
Correct Answer
C:JSON_PATH_EXISTS checks whether an SQL/JSON path exists, avoiding the need to return the path's value.
Incorrect Answers
A:JSON_MODIFY updates content at a specified JSON path and returns the modified document expression; the required capability here is JSON_PATH_EXISTS, which this operation does not supply.
B:An OPENJSON WITH clause maps JSON paths to named typed relational columns during rowset extraction; the alternative cannot substitute for JSON_PATH_EXISTS under the given constraints.
D:JSON_CONTAINS evaluates containment semantics for JSON values rather than merely extracting a scalar for presentation; the missing behavior is JSON_PATH_EXISTS; this mechanism does something else.
Question 492
A social-network schema needs typed connection rows linking two node records and allowing pattern traversal. Which mechanism addresses the requirement?
- Memory-optimized OLTP row
- Graph edge records
- Ledger digests
- System-versioned history retention
Explanation
Correct Answer
B:Edge tables encode graph relationships between node instances and support relationship-centric queries.
Incorrect Answers
A:Memory-optimized tables use a specialized engine and must follow feature and schema restrictions rather than conventional disk-based indexing; for the stated conditions, the deciding feature is Graph edge records rather than this behavior.
C:Ledger digests help establish tamper-evidence for ledger content; retaining them securely is key to later verification; this differs from the Graph edge records requirement described in the scenario.
D:System-versioned temporal storage records prior row versions in a history table while maintaining a current table; the required capability here is Graph edge records, which this operation does not supply.
Question 493
A new child table has a foreign key to a new parent, and deployment should arrange creation operations in a valid order. Which SQL capability is the most direct fit?
- Post-deployment script
- DACPAC dependency-aware publish
- Pre-deployment script
- Build dependency validation
Explanation
Correct Answer
B:DacFx's deployment plan accounts for model dependencies when generating schema changes for the target.
Incorrect Answers
A:A post-deployment script runs after main schema changes and can populate approved reference data; the condition in the stem is resolved by DACPAC dependency-aware publish, not by this feature alone.
C:A pre-deployment script executes at the designated stage of database project publishing and must be designed safely and idempotently; that function is not interchangeable with DACPAC dependency-aware publish for the requested result.
D:Building the SQL project validates supported references against the modeled database schema; for the stated conditions, the deciding feature is DACPAC dependency-aware publish rather than this behavior.
Question 494
New team members should obtain the same restricted database role by joining an approved Entra security group where supported. Which option satisfies the desired behavior most directly?
- Database role membership
- Parameterized SQL statements
- Certificate-signed SQL module
- Group-based database access
- Dedicated managed identity
Explanation
Correct Answer
D:Group-backed principals allow permissions to be managed through authorized group membership while database grants remain scoped.
Incorrect Answers
A:A database role collects permissions for members and reduces the need to duplicate identical grants on individual principals; this differs from the Group-based database access requirement described in the scenario.
B:SQL parameters separate supplied values from executable query syntax and are a core mitigation against injection; the required capability here is Group-based database access, which this operation does not supply.
C:Signing an SQL module can attach narrowly scoped certificate-associated permissions during execution without broad user privilege escalation; the alternative cannot substitute for Group-based database access under the given constraints.
E:A dedicated managed identity offers a workload principal whose token authorization can be controlled independently of human account lifecycle; the missing behavior is Group-based database access; this mechanism does something else.
Question 495
A codebase should automatically flag discouraged T-SQL patterns during build or pull request checks, before an artifact is promoted. Which SQL capability is the most direct fit?
- Static analysis rule
- Database reference
- Declarative object file
- `dotnet build` of SQL project
- Target platform configuration
- SDK-style SQL database project
Explanation
Correct Answer
A:SQL code analysis can inspect modeled schema and code against configured rules as part of validation, complementing runtime tests.
Incorrect Answers
B:Database references supply schema models for external dependencies and help SQL project builds validate cross-database object references; for the stated conditions, the deciding feature is Static analysis rule rather than this behavior.
C:SQL projects store declarative object definitions, which DacFx compares with deployed schemas to derive necessary changes; it addresses a different step; the question calls for Static analysis rule.
D:Building an SDK-style SQL project validates its schema model and emits a DACPAC when the build succeeds; this differs from the Static analysis rule requirement described in the scenario.
E:SQL project target-platform settings influence build-time compatibility checks for supported database features and syntax; the required capability here is Static analysis rule, which this operation does not supply.
F:An SDK-style SQL project provides declarative schema files and cross-platform build tooling supported by Microsoft.Build.Sql; the alternative cannot substitute for Static analysis rule under the given constraints.
Question 496
The user must locate documents containing an exact rare error token within technical text and vector similarity is unnecessary. Which database mechanism should be chosen?
- Metadata predicate pushdown
- Keyword inverted index
- Exact nearest-neighbor scan
- Approximate nearest-neighbor index
Explanation
Correct Answer
B:An inverted full-text index maps terms to matching documents for lexical search over tokenized content.
Incorrect Answers
A:Applying supported metadata predicates early reduces candidate sets and enforces eligibility independently of semantic ranking; the alternative cannot substitute for Keyword inverted index under the given constraints.
C:Exact nearest-neighbor search computes distances across all eligible candidates and returns the true nearest results for the chosen metric; the missing behavior is Keyword inverted index; this mechanism does something else.
D:Approximate-neighbor indexes reduce the amount of distance work by searching a structured vector index, trading some recall for speed; that function is not interchangeable with Keyword inverted index for the requested result.
Question 497
A permitted client must create a new Product record through the GraphQL endpoint rather than submitting a read-only query. What should the developer implement?
- GraphQL aggregation
- GraphQL field selection
- GraphQL mutation
- GraphQL relationship navigation
Explanation
Correct Answer
C:GraphQL mutations express write operations exposed by the configured schema and authorized by DAB roles.
Incorrect Answers
A:Supported GraphQL aggregation fields calculate grouped or overall measures through the API instead of requiring all underlying rows at the client; it addresses a different step; the question calls for GraphQL mutation.
B:GraphQL projections let callers request only specified fields in a typed query, subject to endpoint permissions; this differs from the GraphQL mutation requirement described in the scenario.
D:Configured GraphQL relationships permit nested traversal between related API entities within one query document; the alternative cannot substitute for GraphQL mutation under the given constraints.
Question 498
A billing query must retrieve invoices where CustomerId matches exactly and InvoiceDate falls within a date interval. Which technique applies to this scenario?
- Full-text search
- Hybrid keyword-plus-vector search
- JSON_VALUE scalar extraction
- Structured relational filter
Explanation
Correct Answer
D:Ordinary indexed SQL predicates are the direct mechanism for precise structured filtering without embedding model inference.
Incorrect Answers
A:SQL full-text search indexes terms and supports linguistic predicates such as CONTAINS and FREETEXT rather than numerical vector proximity; the missing behavior is Structured relational filter; this mechanism does something else.
B:Hybrid retrieval combines lexical and embedding evidence, capturing both exact-term and conceptual relevance; that function is not interchangeable with Structured relational filter for the requested result.
C:JSON_VALUE reads a scalar from JSON stored in a column; it does not, by itself, filter ordinary relational CustomerId and InvoiceDate predicates.
Question 499
A legacy authentication-related lookup must distinguish an exact-case code 'aB1' from 'AB1' in string comparisons. Which option satisfies the desired behavior most directly?
- Binary collation
- Nonpersisted computed column
- Persisted computed column
- Case-sensitive collation
Explanation
Correct Answer
D:A case-sensitive collation changes comparison and ordering behavior so character case is significant.
Incorrect Answers
A:Binary collations compare encoded character values using binary rules, differing from culture-aware linguistic collations; the required capability here is Case-sensitive collation, which this operation does not supply.
B:A regular computed column defines an expression evaluated as needed rather than necessarily materialized on disk; the alternative cannot substitute for Case-sensitive collation under the given constraints.
C:A PERSISTED computed column materializes the computed result for eligible expressions, with extra storage and update work; the condition in the stem is resolved by Case-sensitive collation, not by this feature alone.
Question 500
A catalog contains paragraphs and needs numeric semantic representations that can be stored in a VECTOR column for similarity search. Which action is justified by these conditions?
- Structured-output language model
- Multilingual embedding model
- Text embedding model
- Multimodal model
Explanation
Correct Answer
C:An embedding model maps input content to numeric vectors for semantic comparison rather than producing a conversational answer.
Incorrect Answers
A:A generation model with schema-constrained structured output can produce predictable field layouts for downstream validation; for the stated conditions, the deciding feature is Text embedding model rather than this behavior.
B:A multilingual embedding model can represent semantically related text across supported languages in a shared vector space; it addresses a different step; the question calls for Text embedding model.
D:A multimodal model handles supported image and text inputs together, unlike text-only embedding or generation models; the required capability here is Text embedding model, which this operation does not supply.