Free SC-500 Exam Braindumps
Implementing End-to-End Security Controls for Cloud and AI Workloads Questions 4–8 (page: 16)

Updated On: 23-Oct-2026
View Related Case Study

You have an Azure SQL Database logical server named Server1 that contains multiple databases.
The databases contain legacy SQL authentication logins that must no longer be usable for sign-in but must NOT be removed from the databases.
You need to ensure that SQL authentication is denied for connections.
What should you do?

  1. Run create USER ... FROM EXTERNAL PROVIDER on each database.
  2. Create a Conditional Access policy.
  3. Enable Microsoft Entra-only authentication for Server1.
  4. Assign the SQL Server Contributor role to Server1.

Answer(s): C

Explanation:

Microsoft Entra-only authentication on an Azure SQL logical server disables SQL authentication for all databases hosted on that server. Existing SQL authentication logins remain in the databases, but they can no longer be used to establish connections because only Microsoft Entra identities are accepted for authentication.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azu resql&tabs=azure-portal



View Related Case Study

You have an Azure subscription named Sub1 that contains an Azure Database for PostgreSQL instance. Sub1 has Microsoft Defender for Cloud enabled.
You need to configure Microsoft Defender for Databases to minimize costs.
Which Defender plan should you enable?

  1. Microsoft Defender for Servers
  2. Microsoft Defender for Open-Source Relational Databases
  3. Microsoft Defender for SQL Servers on Machines
  4. Microsoft Defender for Azure SQL Databases
  5. Microsoft Defender for Storage

Answer(s): B

Explanation:

Microsoft Defender for Open-Source Relational Databases provides threat protection specifically for Azure Database for PostgreSQL. Enabling only this database-specific plan minimizes costs because Defender for Databases offerings are priced separately, and no unrelated resource protection plans are required.


Reference:

https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-databases-introduction https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-databases-overview



View Related Case Study

You have an Azure Storage account named storage1 that contains Azure Files shares.
You have an application named App1 that uses a system-assigned managed identity to access the shares.
Administrators access the shares by using storage account keys.
You need to ensure that App1 access the shares without using the storage account keys.
What should you do on storage1?

  1. Store the storage account access keys in Azure Key Vault and regenerate them periodically.
  2. Set Allow storage account key access to Disabled.
  3. Select Default to Microsoft Entra authorization in the Azure portal.
  4. Assign the Storage File Data Privileged Reader role to the managed identity of App1.

Answer(s): D

Explanation:

Assigning the Storage File Data Privileged Reader role to App1’s managed identity grants Microsoft Entra ID-based read access to files and directories in Azure Files, overriding existing ACL restrictions where necessary. This allows the application to authenticate by using its managed identity instead of storage account keys.


Reference:

https://learn.microsoft.com/en-us/azure/storage/files/storage-files-identity-assign-share-level-permi ssions?tabs=azure-portal https://learn.microsoft.com/en-us/azure/role-based-access-control/built-in-roles



View Related Case Study

You have an Azure subscription named Sub1 that contains a storage account named storage1. Sub1 has Microsoft Defender for Storage enabled. Defender for Storage has malware scanning enabled.
You need to configure a solution that automates the remediation of malware detected in storage1.
What should you include in the solution?

  1. Application Insights
  2. Azure Event Hubs
  3. Azure Event Grid
  4. Azure Policy

Answer(s): C

Explanation:

Azure Event Grid publishes Defender for Storage malware scan results as events, enabling event-driven automated remediation workflows such as quarantining, deleting, or moving malicious files after detection.


Reference:

https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-storage-configure-malware-scan https://learn.microsoft.com/en-us/azure/defender-for-cloud/understand-malware-scan-results



View Related Case Study

DRAG DROP (Drag and Drop is not supported)
You have an Azure virtual network named VNet1 that contains three subnets named Subnet1, Subnet2, and Subnet3. A single network security group (NSG) named NSG1 is associated with all the subnets. You have the following virtual machines:
-VM1 on Subnet1
-VM2 on Subnet2
-VM3 on Subnet3
You create two application security groups named ASG1 and ASG2. VM2 is a member of ASG1, and VM3 is a member of ASG2.
You need to ensure that only VM2 can connect to VM3. The solution must continue to work if the private IP address of VM2 changes.
How should you configure the inbound rule on NSG1? To answer, drag the settings to the correct configurations. Each setting may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Note: Each correct selection is worth one point.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Source: ASG1
Destination: ASG2
ASG1 represents VM2 and ASG2 represents VM3. Configuring the inbound NSG rule by using the application security groups allows connectivity based on VM group membership rather than a specific private IP address, so the rule remains valid if VM2’s private IP address changes. To strictly permit only this traffic within VNet1, the allow rule must be processed before a deny rule that blocks other inbound traffic to ASG2, because Azure’s default AllowVNetInBound rule otherwise permits communication between resources in the same virtual network.


Reference:

https://learn.microsoft.com/en-us/azure/virtual-network/application-security-groups https://learn.microsoft.com/en-us/azure/virtual-network/network-security-groups-overview



Viewing page 16 of 43
Viewing questions 76 - 80 out of 207 questions


Post your Comments and Discuss Microsoft SC-500 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!