Question 310 An integration architecture needs both transport confidentiality and least-privilege access. Which approach would you recommend? Enable SQL auditing for sensitive access and changes Use managed identity for an Azure-hosted model endpoint call Use network-level TLS and application authorization together Use a private endpoint or restricted networking for a sensitive SQL service Explanation Correct Answer C:This approach combines encrypted transport with verified caller permissions. Incorrect Answers A:This choice records reviewable database events for investigation and compliance. This does not meet the need for a method that combines encrypted transport with verified caller permissions. B:This option avoids embedding static model API credentials in SQL code. This does not meet the need for a method that combines encrypted transport with verified caller permissions. D:This alternative reduces exposure of the database endpoint to untrusted networks. This does not meet the need for a method that combines encrypted transport with verified caller permissions.
Question 311 An external API must allow read-only operations for one group while denying mutations. Which solution is most directly applicable? Secure a Data API builder endpoint with authentication and entity permissions Use a private endpoint or restricted networking for a sensitive SQL service Enable SQL auditing for sensitive access and changes Validate the identity and authorization of an MCP tool caller Explanation Correct Answer A:Secure a Data API builder endpoint with authentication and entity permissions fits because it prevents anonymous broad access to SQL objects through REST or GraphQL. 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 prevents anonymous broad access to SQL objects through REST or GraphQL. C:That technique records reviewable database events for investigation and compliance. This does not meet the need for a method that prevents anonymous broad access to SQL objects through REST or GraphQL. D: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.
Question 312 An audited process has to perform privileged SQL work through a reviewed code boundary. What should the engineer choose? Use DENY or remove unintended inherited broad access after reviewing effective permissions 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 C:This implementation lets a stored procedure perform controlled work without general caller rights. Incorrect Answers A:This choice addresses a specific overbroad authorization path. This does not meet the need for a method that lets a stored procedure perform controlled work without general caller rights. B:That technique exposes only approved projected data. This does not meet the need for a method that lets a stored procedure perform controlled work without general caller rights. D:This alternative 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.
Question 313 A service must prevent on-path observers from reading SQL connection traffic. Which change most directly meets the requirement? Use TLS-encrypted connections with certificate validation Use Microsoft Entra authentication or managed identity where supported Use Transparent Data Encryption for database files at rest Use Always Encrypted for designated sensitive columns with supported client drivers Explanation Correct Answer A:This choice protects data moving between clients and the database endpoint. Incorrect Answers B:This alternative avoids application-stored long-lived SQL passwords. This does not meet the need for a method that protects data moving between clients and the database endpoint. C:That technique encrypts database files and backups without changing each column query. This does not meet the need for a method that protects data moving between clients and the database endpoint. D:This option 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 314 A help desk report should hide most of a phone number from nonexempt readers. Which solution is most directly applicable? Implement Row-Level Security with a validated security predicate Use Dynamic Data Masking for supported nonprivileged query display Grant SELECT on a narrowly scoped view instead of the base table Use DENY or remove unintended inherited broad access after reviewing effective permissions Explanation Correct Answer B:This implementation fits because it obscures selected output values without replacing true access controls. That addresses the stated technical constraint. Incorrect Answers A:This choice filters rows according to an execution context or predicate. This does not meet the need for a method that obscures selected output values without replacing true access controls. C:This alternative exposes only approved projected data. This does not meet the need for a method that obscures selected output values without replacing true access controls. D:This option 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.
Question 315 A vendor dashboard can view its own orders but not global commercial pricing details. Which approach would you recommend? Use separate key vault access policies for encryption operators Apply both row filtering and column projection for tenant privacy Revoke obsolete service account access after deployment Use server-side validation of user-supplied tenant identity Explanation Correct Answer B:This approach limits records and sensitive attributes exposed to users. Incorrect Answers A:This choice confines ability to unwrap sensitive encrypted columns. This does not meet the need for a method that limits records and sensitive attributes exposed to users. C:This alternative removes credential paths no longer required by running workloads. 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 316 A hosted database stores regulated identification numbers that DBAs must not read in plaintext. What is the most appropriate next design step? Use column-level encryption when applications can manage selected ciphertext values Use Always Encrypted for designated sensitive columns with supported client drivers Use TLS-encrypted connections with certificate validation Use Microsoft Entra authentication or managed identity where supported Explanation Correct Answer B:This choice protects designated values from exposure to ordinary database-engine operators. Incorrect Answers A: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. C:This option 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:That technique 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.
Question 317 A local performance benchmark requires representative but non-sensitive sample values. What is the most appropriate next design step? Use server-side validation of user-supplied tenant identity Use authorized test data instead of production PII for development Use separate key vault access policies for encryption operators Apply both row filtering and column projection for tenant privacy Explanation Correct Answer B:This implementation protects customer information in CI test pipelines. Incorrect Answers A:This alternative rejects tenant IDs chosen solely through client parameters. This does not meet the need for a method that protects customer information in CI test pipelines. C:This choice confines ability to unwrap sensitive encrypted columns. This does not meet the need for a method that protects customer information in CI test pipelines. D:That technique limits records and sensitive attributes exposed to users. This does not meet the need for a method that protects customer information in CI test pipelines.
Question 318 A migration is complete but the temporary elevated deploy identity remains enabled. Which technical choice addresses this need? Use authorized test data instead of production PII for development Revoke obsolete service account access after deployment Use separate key vault access policies for encryption operators Apply both row filtering and column projection for tenant privacy Explanation Correct Answer B:Revoke obsolete service account access after deployment fits because it removes credential paths no longer required by running workloads. That addresses the stated technical constraint. Incorrect Answers A:This alternative protects customer information in CI test pipelines. This does not meet the need for a method that removes credential paths no longer required by running workloads. C:This option confines ability to unwrap sensitive encrypted columns. This does not meet the need for a method that removes credential paths no longer required by running workloads. D:This choice limits records and sensitive attributes exposed to users. This does not meet the need for a method that removes credential paths no longer required by running workloads.
Question 319 An application team controls key access and wants deliberate encryption of chosen SQL values. Which implementation is the best fit? Use Microsoft Entra authentication or managed identity where supported 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 B:This approach 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. C:That technique 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. 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 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.