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.
Question 281 A production Azure SQL instance must not expose unrestricted public connectivity. Which change most directly meets the requirement? Use a private endpoint or restricted networking for a sensitive SQL service Use network-level TLS and application authorization together Secure a Data API builder endpoint with authentication and entity permissions Use managed identity for an Azure-hosted model endpoint call Explanation Correct Answer A:This choice reduces exposure of the database endpoint to untrusted networks. Incorrect Answers B:This choice combines encrypted transport with verified caller permissions. This does not meet the need for a method that reduces exposure of the database endpoint to untrusted networks. C:This alternative 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. D:This alternative 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.
Question 282 SQL connection logs need failed-login events but must never store passwords. Which solution is most directly applicable? Audit failed authentication attempts without leaking credentials Revoke obsolete service account access after deployment Use separate key vault access policies for encryption operators Use authorized test data instead of production PII for development Explanation Correct Answer A:This implementation supports detection while avoiding secret collection. Incorrect Answers B:This choice removes credential paths no longer required by running workloads. This does not meet the need for a method that supports detection while avoiding secret collection. C:This option confines ability to unwrap sensitive encrypted columns. This does not meet the need for a method that supports detection while avoiding secret collection. D:This option protects customer information in CI test pipelines. This does not meet the need for a method that supports detection while avoiding secret collection.
Question 283 A support worker must see only their tenant's cases and not full customer secrets. Which solution best satisfies the stated constraint? Apply both row filtering and column projection for tenant privacy Audit failed authentication attempts without leaking credentials Use authorized test data instead of production PII for development Use server-side validation of user-supplied tenant identity Explanation Correct Answer A:Apply both row filtering and column projection for tenant privacy fits because it limits records and sensitive attributes exposed to users. That addresses the stated technical constraint. Incorrect Answers B:This alternative supports detection while avoiding secret collection. This does not meet the need for a method that limits records and sensitive attributes exposed to users. C:This option protects customer information in CI test pipelines. This does not meet the need for a method that limits records and sensitive attributes exposed to users. D:That technique rejects tenant IDs chosen solely through client parameters. This does not meet the need for a method that limits records and sensitive attributes exposed to users.
Question 284 A new support team should inherit defined SELECT rights through a managed role. What should the SQL developer implement? Use Dynamic Data Masking for supported nonprivileged query display Implement Row-Level Security with a validated security predicate Grant SELECT on a narrowly scoped view instead of the base table Create database roles and grant only the required permissions Explanation Correct Answer D:Create database roles and grant only the required permissions fits because it reduces excessive per-user object privileges. 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 reduces excessive per-user object privileges. B:That technique filters rows according to an execution context or predicate. This does not meet the need for a method that reduces excessive per-user object privileges. C:This choice exposes only approved projected data. This does not meet the need for a method that reduces excessive per-user object privileges.
Question 285 A key custodian must rotate secrets without being granted table SELECT rights. Which implementation is the best fit? Audit failed authentication attempts without leaking credentials 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 Explanation Correct Answer D:This approach confines ability to unwrap sensitive encrypted columns. Incorrect Answers A:That technique supports detection while avoiding secret collection. This does not meet the need for a method that confines ability to unwrap sensitive encrypted columns. B:This alternative protects customer information in CI test pipelines. This does not meet the need for a method that confines ability to unwrap sensitive encrypted columns. C:This alternative 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.
Question 286 A payroll database requires authorized client-side encryption for salary values with controlled keys. What should the engineer choose? Use Always Encrypted for designated sensitive columns with supported client drivers Rotate and secure database encryption keys with a governed recovery plan Use TLS-encrypted connections with certificate validation Use column-level encryption when applications can manage selected ciphertext values Explanation Correct Answer A:This implementation protects designated values from exposure to ordinary database-engine operators. Incorrect Answers B:This option manages cryptographic key lifecycle and database recoverability. This does not meet the need for a method that protects designated values from exposure to ordinary database-engine operators. C:That technique protects data moving between clients and the database endpoint. This does not meet the need for a method that protects designated values from exposure to ordinary database-engine operators. D:This alternative 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 287 A service needs encrypted storage for a defined column while most fields stay readable. Which approach would you recommend? 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 C:This choice encrypts selected data using SQL cryptographic functions and key management. Incorrect Answers A:That technique avoids application-stored long-lived SQL passwords. This does not meet the need for a method that encrypts selected data using SQL cryptographic functions and key management. B: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. D: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.
Question 288 A recovery exercise reveals no escrow for the keys required to decrypt stored data. Which implementation is the best fit? Rotate and secure database encryption keys with a governed recovery plan Use TLS-encrypted connections with certificate validation Use Transparent Data Encryption for database files at rest Use Microsoft Entra authentication or managed identity where supported Explanation Correct Answer A:This approach manages cryptographic key lifecycle and database recoverability. Incorrect Answers B:This choice protects data moving between clients and the database endpoint. This does not meet the need for a method that manages cryptographic key lifecycle and database recoverability. C:This alternative 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. D: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.
Question 289 A compliance design requires network-scoped access to a managed database. Which implementation is the best fit? 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 Validate the identity and authorization of an MCP tool caller Explanation Correct Answer C:This implementation fits because it reduces exposure of the database endpoint to untrusted networks. That addresses the stated technical constraint. Incorrect Answers A:This choice 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. B:This choice 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. D: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.
Question 290 A permissions audit finds a group membership granting undesired writes. Which change most directly meets the requirement? 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 Create database roles and grant only the required permissions Explanation Correct Answer A:This implementation addresses a specific overbroad authorization path. Incorrect Answers B:This choice lets a stored procedure perform controlled work without general caller rights. This does not meet the need for a method that addresses a specific overbroad authorization path. C:This choice 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. D:This choice reduces excessive per-user object privileges. This does not meet the need for a method that addresses a specific overbroad authorization path.