Question 270 A legacy application has two extremely sensitive fields and accepts explicit encrypt/decrypt logic. What is the most appropriate design decision? Use Always Encrypted for designated sensitive columns with supported client drivers Rotate and secure database encryption keys with a governed recovery plan Use Transparent Data Encryption for database files at rest Use column-level encryption when applications can manage selected ciphertext values Explanation Correct Answer D:This choice encrypts selected data using SQL cryptographic functions and key management. Incorrect Answers A:That technique protects designated values from exposure to ordinary database-engine operators. This does not meet the need for a method that encrypts selected data using SQL cryptographic functions and key management. B:This option manages cryptographic key lifecycle and database recoverability. This does not meet the need for a method that encrypts selected data using SQL cryptographic functions and key management. C:This choice encrypts database files and backups without changing each column query. This does not meet the need for a method that encrypts selected data using SQL cryptographic functions and key management.
Question 271 A general support role should see partial account numbers for screen display. What is the most appropriate design decision? Create database roles and grant only the required permissions Use DENY or remove unintended inherited broad access after reviewing effective permissions Apply ownership/EXECUTE AS module security only with review Use Dynamic Data Masking for supported nonprivileged query display Explanation Correct Answer D:This implementation obscures selected output values without replacing true access controls. Incorrect Answers A:This alternative reduces excessive per-user object privileges. This does not meet the need for a method that obscures selected output values without replacing true access controls. B:This choice addresses a specific overbroad authorization path. This does not meet the need for a method that obscures selected output values without replacing true access controls. C:This alternative lets a stored procedure perform controlled work without general caller rights. This does not meet the need for a method that obscures selected output values without replacing true access controls.
Question 272 A reporting vendor needs approved columns but must not see base-table salary data. Which solution is most directly applicable? Use Dynamic Data Masking for supported nonprivileged query display Use DENY or remove unintended inherited broad access after reviewing effective permissions Create database roles and grant only the required permissions Grant SELECT on a narrowly scoped view instead of the base table Explanation Correct Answer D:Grant SELECT on a narrowly scoped view instead of the base table fits because it exposes only approved projected data. That addresses the stated technical constraint. Incorrect Answers A:This choice obscures selected output values without replacing true access controls. This does not meet the need for a method that exposes only approved projected data. B:This option addresses a specific overbroad authorization path. This does not meet the need for a method that exposes only approved projected data. C:This option reduces excessive per-user object privileges. This does not meet the need for a method that exposes only approved projected data.
Question 273 A multi-tenant app must prevent tenant A from reading tenant B rows in a shared table. Which technical choice addresses this need? Implement Row-Level Security with a validated security predicate Grant SELECT on a narrowly scoped view instead of the base table Apply ownership/EXECUTE AS module security only with review Create database roles and grant only the required permissions Explanation Correct Answer A:Implement Row-Level Security with a validated security predicate is the appropriate choice: it filters rows according to an execution context or predicate. The deployment should be tested with representative data. Incorrect Answers B:This choice exposes only approved projected data. This does not meet the need for a method that filters rows according to an execution context or predicate. C:This choice lets a stored procedure perform controlled work without general caller rights. This does not meet the need for a method that filters rows according to an execution context or predicate. D:That technique reduces excessive per-user object privileges. This does not meet the need for a method that filters rows according to an execution context or predicate.
Question 274 A healthcare application must keep patient identifiers encrypted while the SQL service handles queries. What should the SQL developer implement? Use Microsoft Entra authentication or managed identity where supported Use Transparent Data Encryption for database files at rest Use column-level encryption when applications can manage selected ciphertext values Use Always Encrypted for designated sensitive columns with supported client drivers Explanation Correct Answer D:This choice protects designated values from exposure to ordinary database-engine operators. Incorrect Answers A:This alternative avoids application-stored long-lived SQL passwords. This does not meet the need for a method that protects designated values from exposure to ordinary database-engine operators. B:That technique encrypts database files and backups without changing each column query. This does not meet the need for a method that protects designated values from exposure to ordinary database-engine operators. C:This option encrypts selected data using SQL cryptographic functions and key management. This does not meet the need for a method that protects designated values from exposure to ordinary database-engine operators.
Question 275 A database-side workflow calls an approved Azure AI endpoint and needs credential lifecycle control. Which technical choice addresses this need? Use managed identity for an Azure-hosted model endpoint call Use a private endpoint or restricted networking for a sensitive SQL service Enable SQL auditing for sensitive access and changes Use network-level TLS and application authorization together Explanation Correct Answer A:This implementation fits because it avoids embedding static model API credentials in SQL code. That addresses the stated technical constraint. Incorrect Answers B:This option 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. C:That technique records reviewable database events for investigation and compliance. 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 276 A cloud SQL application can read data but should not administer master keys. Which technical choice addresses this need? Use separate key vault access policies for encryption operators Revoke obsolete service account access after deployment Use server-side validation of user-supplied tenant identity Audit failed authentication attempts without leaking credentials Explanation Correct Answer A:This approach confines ability to unwrap sensitive encrypted columns. Incorrect Answers B:This alternative removes credential paths no longer required by running workloads. This does not meet the need for a method that confines ability to unwrap sensitive encrypted columns. C:That technique rejects tenant IDs chosen solely through client parameters. 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 277 A partner must invoke one approved update procedure but not edit tables directly. Which solution is most directly applicable? Apply ownership/EXECUTE AS module security only with review Create database roles and grant only the required permissions Implement Row-Level Security with a validated security predicate Use Dynamic Data Masking for supported nonprivileged query display Explanation Correct Answer A:Apply ownership/EXECUTE AS module security only with review is the appropriate choice: it lets a stored procedure perform controlled work without general caller rights. The deployment should be tested with representative data. Incorrect Answers B:This option reduces excessive per-user object privileges. This does not meet the need for a method that lets a stored procedure perform controlled work without general caller rights. C:This option filters rows according to an execution context or predicate. This does not meet the need for a method that lets a stored procedure perform controlled work without general caller rights. D:This choice obscures selected output values without replacing true access controls. This does not meet the need for a method that lets a stored procedure perform controlled work without general caller rights.
Question 278 A new DAB service exposes a confidential table over HTTP. What is the most appropriate design decision? Validate the identity and authorization of an MCP tool caller Use network-level TLS and application authorization together Use managed identity for an Azure-hosted model endpoint call Secure a Data API builder endpoint with authentication and entity permissions Explanation Correct Answer D:Secure a Data API builder endpoint with authentication and entity permissions is the appropriate choice: it prevents anonymous broad access to SQL objects through REST or GraphQL. The deployment should be tested with representative data. Incorrect Answers A:This option prevents an AI agent bypassing database access controls. This does not meet the need for a method that prevents anonymous broad access to SQL objects through REST or GraphQL. B:This option combines encrypted transport with verified caller permissions. This does not meet the need for a method that prevents anonymous broad access to SQL objects through REST or GraphQL. C:This alternative avoids embedding static model API credentials in SQL code. This does not meet the need for a method that prevents anonymous broad access to SQL objects through REST or GraphQL.
Question 279 A remote app currently connects to SQL without verifying the server certificate. Which implementation is the best fit? Use TLS-encrypted connections with certificate validation Use column-level encryption when applications can manage selected ciphertext values Rotate and secure database encryption keys with a governed recovery plan Use Always Encrypted for designated sensitive columns with supported client drivers Explanation Correct Answer A:This implementation fits because it protects data moving between clients and the database endpoint. That addresses the stated technical constraint. Incorrect Answers B:This option encrypts selected data using SQL cryptographic functions and key management. This does not meet the need for a method that protects data moving between clients and the database endpoint. C:That technique manages cryptographic key lifecycle and database recoverability. This does not meet the need for a method that protects data moving between clients and the database endpoint. D:That technique protects designated values from exposure to ordinary database-engine operators. This does not meet the need for a method that protects data moving between clients and the database endpoint.
Question 280 An agent tool endpoint can read customer tables but lacks caller-specific authorization. What should the SQL developer implement? Use a private endpoint or restricted networking for a sensitive SQL service Use managed identity for an Azure-hosted model endpoint call Enable SQL auditing for sensitive access and changes Validate the identity and authorization of an MCP tool caller Explanation Correct Answer D:Validate the identity and authorization of an MCP tool caller fits because it prevents an AI agent bypassing database access controls. That addresses the stated technical constraint. Incorrect Answers A:This option reduces exposure of the database endpoint to untrusted networks. This does not meet the need for a method that prevents an AI agent bypassing database access controls. B:That technique avoids embedding static model API credentials in SQL code. This does not meet the need for a method that prevents an AI agent bypassing database access controls. C:This choice records reviewable database events for investigation and compliance. This does not meet the need for a method that prevents an AI agent bypassing database access controls.