Question 320 A regulated workload needs private service reachability from authorized Azure subnets. What is the most appropriate next design step? Validate the identity and authorization of an MCP tool caller Use managed identity for an Azure-hosted model endpoint call Secure a Data API builder endpoint with authentication and entity permissions Use a private endpoint or restricted networking for a sensitive SQL service Explanation Correct Answer D:This implementation fits because it reduces exposure of the database endpoint to untrusted networks. That addresses the stated technical constraint. Incorrect Answers A:That technique prevents an AI agent bypassing database access controls. This does not meet the need for a method that reduces exposure of the database endpoint to untrusted networks. B:That technique avoids embedding static model API credentials in SQL code. This does not meet the need for a method that reduces exposure of the database endpoint to untrusted networks. C:This option prevents anonymous broad access to SQL objects through REST or GraphQL. This does not meet the need for a method that reduces exposure of the database endpoint to untrusted networks.
Question 321 An app login has unexpected DDL permission inherited through a built-in role. What should the SQL developer implement? Grant SELECT on a narrowly scoped view instead of the base table Implement Row-Level Security with a validated security predicate Use Dynamic Data Masking for supported nonprivileged query display Use DENY or remove unintended inherited broad access after reviewing effective permissions Explanation Correct Answer D:This approach addresses a specific overbroad authorization path. Incorrect Answers A:That technique exposes only approved projected data. This does not meet the need for a method that addresses a specific overbroad authorization path. B:This choice filters rows according to an execution context or predicate. This does not meet the need for a method that addresses a specific overbroad authorization path. C:That technique obscures selected output values without replacing true access controls. This does not meet the need for a method that addresses a specific overbroad authorization path.
Question 322 A regulated database requires separating security-key administration from application development. Which implementation is the best fit? Use column-level encryption when applications can manage selected ciphertext values Use Microsoft Entra authentication or managed identity where supported Rotate and secure database encryption keys with a governed recovery plan Use Transparent Data Encryption for database files at rest Explanation Correct Answer C:This approach manages cryptographic key lifecycle and database recoverability. Incorrect Answers A:That technique encrypts selected data using SQL cryptographic functions and key management. This does not meet the need for a method that manages cryptographic key lifecycle and database recoverability. B:That technique avoids application-stored long-lived SQL passwords. This does not meet the need for a method that manages cryptographic key lifecycle and database recoverability. D:This option encrypts database files and backups without changing each column query. This does not meet the need for a method that manages cryptographic key lifecycle and database recoverability.
Question 323 A backend service trusts application-submitted organization IDs without verifying claims. Which approach would you recommend? Audit failed authentication attempts without leaking credentials Revoke obsolete service account access after deployment Use separate key vault access policies for encryption operators Use server-side validation of user-supplied tenant identity Explanation Correct Answer D:This implementation rejects tenant IDs chosen solely through client parameters. Incorrect Answers A:This option supports detection while avoiding secret collection. This does not meet the need for a method that rejects tenant IDs chosen solely through client parameters. B:This option removes credential paths no longer required by running workloads. This does not meet the need for a method that rejects tenant IDs chosen solely through client parameters. C:This alternative confines ability to unwrap sensitive encrypted columns. This does not meet the need for a method that rejects tenant IDs chosen solely through client parameters.
Question 324 A data sharing contract permits a defined lookup view but not unrestricted table access. Which solution best satisfies the stated constraint? Create database roles and grant only the required permissions Grant SELECT on a narrowly scoped view instead of the base table Use Dynamic Data Masking for supported nonprivileged query display Apply ownership/EXECUTE AS module security only with review Explanation Correct Answer B:Grant SELECT on a narrowly scoped view instead of the base table is the appropriate choice: it exposes only approved projected data. The deployment should be tested with representative data. Incorrect Answers A:That technique reduces excessive per-user object privileges. This does not meet the need for a method that exposes only approved projected data. C:This alternative obscures selected output values without replacing true access controls. This does not meet the need for a method that exposes only approved projected data. D:This choice lets a stored procedure perform controlled work without general caller rights. This does not meet the need for a method that exposes only approved projected data.
Question 325 Security needs queryable evidence of important login and schema events. What should the SQL developer implement? Use network-level TLS and application authorization together Enable SQL auditing for sensitive access and changes Use managed identity for an Azure-hosted model endpoint call Use a private endpoint or restricted networking for a sensitive SQL service Explanation Correct Answer B:This implementation records reviewable database events for investigation and compliance. Incorrect Answers A:That technique combines encrypted transport with verified caller permissions. This does not meet the need for a method that records reviewable database events for investigation and compliance. C:This option avoids embedding static model API credentials in SQL code. This does not meet the need for a method that records reviewable database events for investigation and compliance. D:This option reduces exposure of the database endpoint to untrusted networks. This does not meet the need for a method that records reviewable database events for investigation and compliance.
Question 326 A SQL instance must defend against theft of physical database storage media. Which approach would you recommend? Rotate and secure database encryption keys with a governed recovery plan Use column-level encryption when applications can manage selected ciphertext values Use Transparent Data Encryption for database files at rest Use Always Encrypted for designated sensitive columns with supported client drivers Explanation Correct Answer C:This approach encrypts database files and backups without changing each column query. Incorrect Answers A:This choice manages cryptographic key lifecycle and database recoverability. This does not meet the need for a method that encrypts database files and backups without changing each column query. B:This choice encrypts selected data using SQL cryptographic functions and key management. This does not meet the need for a method that encrypts database files and backups without changing each column query. D:This alternative protects designated values from exposure to ordinary database-engine operators. This does not meet the need for a method that encrypts database files and backups without changing each column query.
Question 327 A SQL-based RAG service needs a supported token identity for model network access. What is the most appropriate design decision? Secure a Data API builder endpoint with authentication and entity permissions Use managed identity for an Azure-hosted model endpoint call Use a private endpoint or restricted networking for a sensitive SQL service Use network-level TLS and application authorization together Explanation Correct Answer B:This approach avoids embedding static model API credentials in SQL code. Incorrect Answers A:This alternative prevents anonymous broad access to SQL objects through REST or GraphQL. This does not meet the need for a method that avoids embedding static model API credentials in SQL code. C:This alternative reduces exposure of the database endpoint to untrusted networks. This does not meet the need for a method that avoids embedding static model API credentials in SQL code. D:This choice combines encrypted transport with verified caller permissions. This does not meet the need for a method that avoids embedding static model API credentials in SQL code.
Question 328 A security design separates database administrators from decryption-key custodians. What is the most appropriate design decision? Use authorized test data instead of production PII for development Apply both row filtering and column projection for tenant privacy Use separate key vault access policies for encryption operators Audit failed authentication attempts without leaking credentials Explanation Correct Answer C:This implementation confines ability to unwrap sensitive encrypted columns. Incorrect Answers A:This choice protects customer information in CI test pipelines. This does not meet the need for a method that confines ability to unwrap sensitive encrypted columns. B:This choice limits records and sensitive attributes exposed to users. This does not meet the need for a method that confines ability to unwrap sensitive encrypted columns. D:This option supports detection while avoiding secret collection. This does not meet the need for a method that confines ability to unwrap sensitive encrypted columns.
Question 329 A large load changes predicate selectivity and execution estimates become badly inaccurate. What is the most appropriate design decision? Update statistics when estimates are stale after material data changes Use a targeted covering index after verifying query access patterns Use Query Performance Insight when supported on Azure SQL Use Query Store to compare historical query plans and regressions Explanation Correct Answer A:Update statistics when estimates are stale after material data changes is the appropriate choice: it improves optimizer cardinality information for changed data distributions. The deployment should be tested with representative data. Incorrect Answers B:That technique can reduce repetitive lookup I/O for a selective predicate. This does not meet the need for a method that improves optimizer cardinality information for changed data distributions. C:This alternative visualizes resource-heavy database query patterns. This does not meet the need for a method that improves optimizer cardinality information for changed data distributions. D:That technique retains runtime/plan history across executions. This does not meet the need for a method that improves optimizer cardinality information for changed data distributions.
Question 330 An OLTP system has many readers blocked by concurrent short writes at READ COMMITTED. The application cannot change its transaction isolation statements, and the team wants statement-level versioned reads after compatibility review. Which database setting is most appropriate? Keep transactions short and order resource access consistently Use deadlock graphs or Extended Events to identify cycle participants Use SNAPSHOT isolation for transaction-level version consistency where appropriate Use READ COMMITTED SNAPSHOT where supported and after compatibility review Explanation Correct Answer D:This choice reduces reader-writer blocking via row versions. Incorrect Answers A:This alternative reduces lock duration and deadlock likelihood. This does not meet the need for a method that reduces reader-writer blocking via row versions. B:This alternative diagnoses competing lock requests rather than guessing. This does not meet the need for a method that reduces reader-writer blocking via row versions. C:This choice provides a consistent snapshot across statements in a transaction. This does not meet the need for a method that reduces reader-writer blocking via row versions.