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:
Answer(s): A
Box 1: Microsoft Purview Data MapFor 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 MapIt 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 AnalyticsFor 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 choicesWhen 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.
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
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:
Box 1: Just-in-time (JIT) VN accessLock 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.
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
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?
Answer(s): D
Azure Policy definitions deployIfNotExists effectDeployIfNotExists 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.
https://learn.microsoft.com/en-us/azure/governance/policy/concepts/effect-deploy-if-not-exists
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?
Correct:* Azure Activity Log* Azure Log AnalyticsIncorrect:* Application Insights* Azure Advisor* Azure Analysis Services* Azure Arc* Azure Monitor action groups* Azure Monitor metricsNote:* Azure Activity LogActivity 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 AnalyticsThe 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 archivingNote: 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.
https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/view-activity-logs
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 workspaceWhat 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:
Box 1: An Azure Monitor data collection endpointForwards JSON-formatted logs from the virtual machines to a Log Analytics workspaceData collection endpoints (DCEs) provide a connection for certain data sources of Azure Monitor.Data sources that use DCEsThe following data sources currently use DCEs:Azure Monitor Agent when network isolation is requiredLogs ingestion APILogs Ingestion API in Azure MonitorThe 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 operationYour 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 workspaceBox 2: A KQL queryTransforms the logs and stores the data in a table in the Log Analytics workspaceTransformations 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 structureThe 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 statementAdds a new column using the extend operatorFormats the output to match the columns of the target table using the project operatorKusto| where severity == "Critical"| extend Properties = parse_json(properties)| projectTimeGenerated = todatetime(["time"]),Category = category,StatusDescription = StatusDescription,EventName = name,EventId = tostring(Properties.EventId)
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
Post your Comments and Discuss Microsoft AZ-305 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the AZ-305 content, but please register or login to continue.