Free AZ-305 Exam Braindumps
Designing Microsoft Azure Infrastructure Solutions Questions 95–99 (page: 22)

Updated On: 16-Nov-2026
View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an on-premises datacenter and an Azure subscription. The environment contains 100 databases of various types, including Azure SQL Database, Azure SQL Managed Instances, Azure Cosmos DB, Microsoft SQL Server, MySQL, and Oracle. Multiple apps access the databases.
You need to recommend a data solution. The solution must meet the following requirements:
-Provide a single searchable catalog of the data in all the databases. The catalog must contain metadata of the data. The solution must minimize storage requirements.
-Provide a central data lake that contains specific data from multiple databases. The solution must include a big data engine that can create machine learning models.
What should you include in the recommendation? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Microsoft Purview Data Map
For the searchable data catalog, use:
Provide a single searchable catalog of the data in all the databases. The catalog must contain metadata of the data. The solution must minimize storage requirements.
The Microsoft Purview Data Map provides the foundation for data discovery and data governance. It captures metadata about data present in analytics, software-as-a-service (SaaS), and operational systems in hybrid, on-premises, and multicloud environments.
Microsoft Purview, Data sources that connect to Data Map
It includes as required among many other: Azure SQL Database, Azure SQL Managed Instances, Azure Cosmos DB, Microsoft SQL Server, MySQL, and Oracle.
Box 2: Azure Synapse Analytics
For the central data lake, use:
Provide a central data lake that contains specific data from multiple databases. The solution must include a big data engine that can create machine learning models.
Technology choices
When you build a comprehensive data lake solution on Azure, consider the following technologies:
*-> Azure Synapse Analytics is a unified service that you can use to ingest, explore, prepare, manage, and serve data for immediate business intelligence and machine learning needs. It integrates deeply with Azure data lakes so that you can query and analyze large datasets efficiently.
* Azure Data Factory is a cloud-based data integration service that you can use to create data-driven workflows to then orchestrate and automate data movement and transformation.
* Azure Data Lake Storage combines Azure Blob Storage with data lake capabilities, which provides Apache Hadoop-compatible access, hierarchical namespace capabilities, and enhanced security for efficient big data analytics.
* Azure Databricks is a unified platform that you can use to process, store, analyze, and monetize data. It supports ETL processes, dashboards, security, data exploration, machine learning, and generative AI.


Reference:

https://learn.microsoft.com/en-us/purview/data-map https://learn.microsoft.com/en-us/purview/microsoft-purview-connector-overview https://learn.microsoft.com/en-us/azure/architecture/data-guide/scenarios/data-lake



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an Azure subscription that contains a virtual network named VNET1 and 10 virtual machines. The virtual machines are connected to VNET1.
You need to design a solution to manage the virtual machines from the internet. The solution must meet the following requirements:
-Incoming connections to the virtual machines must be authenticated by using Azure Multi-Factor Authentication (MFA) before network connectivity is allowed.
-Incoming connections must use TLS and connect to TCP port 443.
-The solution must support RDP and SSH.
What should you include in the solution? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Just-in-time (JIT) VN access
Lock down inbound traffic to your Azure Virtual Machines with Microsoft Defender for Cloud's just-in-time (JIT) virtual machine (VM) access feature. This reduces exposure to attacks while providing easy access when you need to connect to a VM.
Note: Threat actors actively hunt accessible machines with open management ports, like RDP or SSH. Your legitimate users also use these ports, so it's not practical to keep them closed.
When you enable just-in-time VM access, you can select the ports on the VM to which inbound traffic will be blocked.
To solve this dilemma, Microsoft Defender for Cloud offers JIT. With JIT, you can lock down the inbound traffic to your VMs, reducing exposure to attacks while providing easy access to connect to VMs when needed.
Box 2: A conditional Access policy that has Cloud Apps assignment set to Azure Windows VM Sign-In You can enforce Conditional Access policies such as multi-factor authentication or user sign-in risk check before authorizing access to Windows VMs in Azure that are enabled with Microsoft Entra sign in. To apply Conditional Access policy, you must select the "Azure Windows VM Sign-In" app from the cloud apps or actions assignment option and then use Sign-in risk as a condition and/or require multi-factor authentication as a grant access control.


Reference:

https://docs.microsoft.com/en-us/azure/defender-for-cloud/just-in-time-access-overview https://docs.microsoft.com/en-us/azure/active-directory/devices/howto-vm-sign-in-azure-ad-windows



View Related Case Study

You have an Azure subscription.
You need to implement a policy to ensure that all new resource groups include a value for a tag named Department. The solution must ensure that if a value is NOT entered for the Department tag, a resource group is created.
Which effect should you use?

  1. deny
  2. modify
  3. manual
  4. deployIfNotExists

Answer(s): D

Explanation:

Azure Policy definitions deployIfNotExists effect
DeployIfNotExists evaluation deployIfNotExists runs after a configurable delay when a Resource Provider handles a create or update subscription or resource request and returned a success status code. A template deployment occurs if there are no related resources or if the resources defined by existenceCondition don't evaluate to true. The duration of the deployment depends on the complexity of resources included in the template.
During an evaluation cycle, policy definitions with a DeployIfNotExists effect that match resources are marked as non-compliant, but no action is taken on that resource.


Reference:

https://learn.microsoft.com/en-us/azure/governance/policy/concepts/effect-deploy-if-not-exists



View Related Case Study

You need to recommend a solution to generate a monthly report of all the new Azure Resource Manager (ARM) resource deployments in your Azure subscription.
What should you include in the recommendation?

  1. Azure Activity Log
  2. Azure Advisor
  3. Azure Analysis Services
  4. Azure Monitor action groups

Answer(s): A

Explanation:

Correct:
* Azure Activity Log
* Azure Log Analytics
Incorrect:
* Application Insights
* Azure Advisor
* Azure Analysis Services
* Azure Arc
* Azure Monitor action groups
* Azure Monitor metrics
Note:
* Azure Activity Log
Activity logs are kept for 90 days. You can query for any range of dates, as long as the starting date isn’t more than 90 days in the past.
Through activity logs, you can determine:
-what operations were taken on the resources in your subscription who started the operation when the operation occurred the status of the operation the values of other properties that might help you research the operation
* Azure Log Analytics
The Activity log is a platform log in Azure that provides insight into subscription-level events. Activity log includes such information as when a resource is modified or when a virtual machine is started.
Activity log events are retained in Azure for 90 days and then deleted.
For more functionality, you should create a diagnostic setting to send the Activity log to one or more of these locations for the following reasons:
to Azure Monitor Logs for more complex querying and alerting, and longer retention (up to two years) to Azure Event Hubs to forward outside of Azure to Azure Storage for cheaper, long-term archiving
Note: Azure Monitor builds on top of Log Analytics, the platform service that gathers log and metrics data from all your resources. The easiest way to think about it is that Azure Monitor is the marketing name, whereas Log Analytics is the technology that powers it.


Reference:

https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/view-activity-logs



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an Azure subscription. The subscription contains 100 virtual machines that run Windows Server 2022 and have the Azure Monitor Agent installed.
You need to recommend a solution that meets the following requirements:
-Forwards JSON-formatted logs from the virtual machines to a Log Analytics workspace
-Transforms the logs and stores the data in a table in the Log Analytics workspace
What should you include in the recommendation? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: An Azure Monitor data collection endpoint
Forwards JSON-formatted logs from the virtual machines to a Log Analytics workspace
Data collection endpoints (DCEs) provide a connection for certain data sources of Azure Monitor.
Data sources that use DCEs
The following data sources currently use DCEs:
Azure Monitor Agent when network isolation is required
Logs ingestion API
Logs Ingestion API in Azure Monitor
The Logs Ingestion API in Azure Monitor lets you send data to a Log Analytics workspace using either a REST API call or client libraries. By using this API, you can send data to supported Azure tables or to custom tables that you create. You can even extend the schema of Azure tables with custom columns to accept additional data.
Basic operation
Your application sends data to a data collection endpoint (DCE), which is a unique connection point for your subscription. The payload of your API call includes the source data formatted in JSON. The call:
Specifies a data collection rule (DCR) that understands the format of the source data.
Potentially filters and transforms the data for the target table.
Directs the data to a specific table in a specific workspace.
You can modify the target table and workspace by modifying the DCR without any change to the API call or source data.

Incorrect:
* A linked storage account for the Log Analytics workspace
Box 2: A KQL query
Transforms the logs and stores the data in a table in the Log Analytics workspace
Transformations in Azure Monitor allow you to filter or modify incoming data before it's stored in a Log Analytics workspace. They are implemented as a Kusto Query Language (KQL) statement in a data collection rule (DCR).
Transformation structure
The KQL statement is applied individually to each entry in the data source. It must understand the format of the incoming data and create output in the structure of the target table. The input stream is represented by a virtual table named source with columns matching the input data stream definition. Following is a typical example of a transformation. This example includes the following functionality:
Filters the incoming data with a where statement
Adds a new column using the extend operator
Formats the output to match the columns of the target table using the project operator
Kusto
| where severity == "Critical"
| extend Properties = parse_json(properties)
| project
TimeGenerated = todatetime(["time"]),
Category = category,
StatusDescription = StatusDescription,
EventName = name,
EventId = tostring(Properties.EventId)


Reference:

https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/data-collection-endpoint-overview https://learn.microsoft.com/en-us/azure/azure-monitor/logs/logs-ingestion-api-overview https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/data-collection-transformations-structure



Viewing page 22 of 78
Viewing questions 106 - 110 out of 382 questions


Post your Comments and Discuss Microsoft AZ-305 exam prep with other Community members:

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