Microsoft AZ-305 Online Practice Questions and Exam Preparation

Microsoft AZ-305 Online Questions & Answers

• Question 131:

  DRAG DROP

  You have an Azure Synapse instance named AS1 and an Azure Cosmos DB SQL API account named CDB1. CDB1 hosts a container that stores continuously updated operational data.

  You plan to use AS1 to analyze the operational data daily.

  You need to configure CDB1 to support the analysis by AS1. The solution must meet the following requirements:

  1. Ensure that AS1 can analyze the operational data without reducing the performance of operations.

  2. Ensure that the analyzed data is deleted automatically.

  Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

  Select and Place:

  

  

  ---

  Step 1: Create a container that has the analytic store enabled.

  Create an analytical store enabled container.

  You can turn on analytical store when creating an Azure Cosmos DB container by using one of the following options.

  1. Sign in to the Azure portal or the Azure Cosmos DB Explorer.

  2. Navigate to your Azure Cosmos DB account and open the Data Explorer tab.

  3. Select New Container and enter a name for your database, container, partition key and throughput details. Turn on the Analytical store option.

  4. If you have previously not enabled Synapse Link on this account, it will prompt you to do so because it's a pre-requisite to create an analytical store enabled container.

  Step 2: Enable Synapse link

  Azure Synapse Link allows you to directly access Azure Cosmos DB analytical store using Azure Synapse Analytics without complex data movement. Any updates made to the operational data are visible in the analytical store in near real-time with no ETL or change feed jobs.

  Step 3: Modify the TTL parameter of the container After you enable the analytical store, it creates a container with analytical TTL property set to the default value of -1 (infinite retention). This setting can be changed later.

  References:

  https://docs.microsoft.com/en-us/azure/cosmos-db/configure-synapse-link

• Question 132:

  What should you include in the identity management strategy to support the planned changes?

  A. Deploy domain controllers for corp.fabrikam.com to virtual networks in Azure.
  B. Move all the domain controllers from corp.fabrikam.com to virtual networks in Azure.
  C. Deploy a new Azure AD tenant for the authentication of new R&D projects.
  D. Deploy domain controllers for the rd.fabrikam.com forest to virtual networks in Azure.
  A. Deploy domain controllers for corp.fabrikam.com to virtual networks in Azure.

  ---

  Explanation

  Directory synchronization between Azure Active Directory (Azure AD) and corp.fabrikam.com must not be affected by a link failure between Azure and the on-premises network. (This requires domain controllers in Azure).

  Users on the on-premises network must be able to authenticate to corp.fabrikam.com if an Internet link fails. (This requires domain controllers on-premises).

• Question 133:

  You have an application named App1. App1 generates log files that must be archived for five years. The log files must be readable by App1 but must not be modified.

  Which storage solution should you recommend for archiving?

  A. Ingest the log files into an Azure Log Analytics workspace
  B. Use an Azure Blob storage account and a time-based retention policy
  C. Use an Azure Blob storage account configured to use the Archive access tier
  D. Use an Azure file share that has access control enabled
  B. Use an Azure Blob storage account and a time-based retention policy

  ---

  Explanation

  Immutable storage for Azure Blob storage enables users to store business-critical data objects in a WORM (Write Once, Read Many) state.

  Immutable storage supports:

  Time-based retention policy support: Users can set policies to store data for a specified interval. When a time-based retention policy is set, blobs can be created and read, but not modified or deleted. After the retention period has expired, blobs can be deleted but not overwritten.

  References:

  https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-immutable-storage

• Question 134:

  HOTSPOT

  Your organization has developed and deployed several Azure App Service Web and API applications. The applications use Azure Key Vault to store several authentication, storage account, and data encryption keys. Several departments have the following requests to support the applications:

  

  You need to recommend the appropriate Azure service for each department request.

  What should you recommend? To answer, configure the appropriate options in the dialog box in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  https://docs.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/overview

• Question 135:

  You have a landing zone that contains multiple Azure subscriptions.

  You need to automate the deployment of resources to the subscriptions. The solution must meet the following requirements:

  Support parameters.

  Support versioning and source control.

  Which two options can you use? Each correct answer presents a complete solution.

  NOTE Each correct selection is worth one point.

  A. Azure Resource Manager (ARM) templates
  B. Azure Policy
  C. Azure Automation
  D. Bleep files
  E. Azure Functions
  A. Azure Resource Manager (ARM) templates
  D. Bleep files

• Question 136:

  HOTSPOT

  You manage a database environment for a Microsoft Volume Licensing customer named Contoso, Ltd. Contoso uses License Mobility through Software Assurance.

  You need to deploy 50 databases. The solution must meet the following requirements:

  Support automatic scaling.

  Minimize Microsoft SQL Server licensing costs.

  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.

  

  

  ---

  Box 1: vCore

  Virtual core (vCore)-based purchasing model (recommended). This purchasing model provides a choice between a provisioned compute tier and a serverless compute tier. With the provisioned compute tier, you choose the exact amount of compute resources that are always provisioned for your workload. With the serverless compute tier, you specify the autoscaling of the compute resources over a configurable compute range

  Box 2: An Azure SQL Database Elastic pool Azure SQL Database provides the following deployment options for a database: Single database represents a fully managed, isolated database. Elastic pool is a collection of single databases with a shared set of resources, such as CPU or memory. Single databases can be moved into and out of an elastic pool.

• Question 137:

  You need to recommend a solution to generate a monthly report of all the new Azure Resource Manager resource deployments in your subscription.

  What should you include in the recommendation?

  A. Azure Analysis Services
  B. Application Insights
  C. Azure Monitor action groups
  D. Azure Log Analytics
  D. Azure Log Analytics

  ---

  Explanation

  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:

  1. what operations were taken on the resources in your subscription who started the operation

  2. when the operation occurred

  3. the status of the operation 4. the values of other properties that might help you research the operation

  References:

  https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/view-activity-logshttps://docs.microsoft.com/en-us/azure/automation/change-tracking

• Question 138:

  HOTSPOT

  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.

  

  

  ---

  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)

  References:

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

• Question 139:

  You have 100 Microsoft SQL Server Integration Services (SSIS) packages that are configured to use 10 on-premises SQL Server databases as their destinations.

  You plan to migrate the 10 on-premises databases to Azure SQL Database.

  You need to recommend a solution to host the SSIS packages in Azure. The solution must ensure that the packages can target the SQL Database instances as their destinations.

  What should you include in the recommendation?

  A. SQL Server Migration Assistant (SSMA)
  B. Data Migration Assistant
  C. Azure Data Catalog
  D. Azure Data Factory
  D. Azure Data Factory

  ---

  Explanation

  https://docs.microsoft.com/bs-cyrl-ba/azure/sql-database/sql-database-managed-instancemigrate

  Quote from that page "Azure SQL Database and SQL Server databases in an Azure Virtual Machine. DMS is the recommended method of migration for your enterprise workloads. If you use SQL Server Integration Services (SSIS) on your SQL Server on premises, DMS does not yet support migrating SSIS catalog (SSISDB) that stores SSIS packages, but you can provision Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF) that will create a new SSISDB in a managed instance and then you can redeploy your packages to it, see Create Azure-SSIS IR in ADF. To learn more about this scenario and configuration steps for DMS, see Migrate your onpremises database to managed instance using

  DMS."

  https://docs.microsoft.com/en-us/azure/data-factory/how-to-migrate-ssis-job-ssms

• Question 140:

  You have an on-premises Microsoft SQL Server 2008 instance that hosts a 50-GB database.

  You need to migrate the database to an Azure SQL managed instance. The solution must minimize downtime.

  What should you use?

  A. Azure Migrate
  B. Azure Data Studio
  C. WANdisco LiveData Platform for Azure
  D. SQL Server Management Studio (SSMS)
  B. Azure Data Studio

  ---

  Explanation

  Migrate using the Azure SQL migration extension for Azure Data Studio (minimal downtime) To perform a minimal downtime migration using Azure Data Studio.

  References:

  https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-guide