Microsoft AZ-305 Online Practice Questions and Exam Preparation

Microsoft AZ-305 Online Questions & Answers

• Question 171:

  What two parameters would you recommend set up to ensure that the new IPSCustomers database will scale to meet the workload demands?

  A. Define the maximum of CPU cores
  B. Define the maximum resource limit per group of databases
  C. Define the maximum of Database Transaction Units
  D. Define the maximum of the allocated storage
  E. Define the maximum size for a database
  C. Define the maximum of Database Transaction Units
  E. Define the maximum size for a database

• Question 172:

  You have an Azure subscription that contains 1,000 virtual machines and a Log Analytics workspace named Workspace1.

  You plan to collect custom JSON logs from the virtual machines and store the logs in a custom table in Workspace1.

  You need to ensure that the logs are collected by using the Logs Ingestion API. The solution must prevent access to Workspace1 from the internet.

  What should you include in the solution?

  A. an Azure Monitor Private Link Scope (AMPLS)
  B. the linked storage account of Workspace1
  C. an Azure Peering Service connection
  D. Service Connector
  A. an Azure Monitor Private Link Scope (AMPLS)

• Question 173:

  HOTSPOT

  You have an Azure subscription that contains the resources shown in the following table.

  

  You create an Azure SQL database named DB1 that is hosted in the East US region.

  To DB1, you add a diagnostic setting named Settings1. Settings1 archives SQLInsights to storage1 and sends SQLInsights to Workspace1.

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selections is worth one point.

  

  

  ---

  Box 1: Yes

  Box 2: Yes

  Box 3: Yes

  For more information on Azure SQL diagnostics , you can visit the below link

  https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure

• Question 174:

  You store web access logs data in Azure Blob storage. You plan to generate monthly reports from the access logs.

  You need to recommend an automated process to upload the data to Azure SQL Database every month.

  What should you include in the recommendation?

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

  ---

  Explanation

  Azure Data Factory is the platform that solves such data scenarios. It is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Using Azure Data Factory, you can create and schedule data-driven workflows (called pipelines) that can ingest data from disparate data stores. You can build complex ETL processes that transform data visually with data flows or by using compute services such as Azure HDInsight Hadoop, Azure Databricks, and Azure SQL Database.

  References:

  https://docs.microsoft.com/en-gb/azure/data-factory/introduction

• Question 175:

  HOTSPOT

  You have two on-premises Microsoft SQL Server 2017 instances that host an Always On availability group named AG1. AG1 contains a single database named DB1.

  You have an Azure subscription that contains a virtual machine named VM1VM1 runs Linux and contains a SQL Server 2019 instance.

  You need to migrate DB1 to VMI. The solution must minimize downtime on DBI. What should you do? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 176:

  You have an Active Directory forest named contoso.com.

  You install and configure AD Connect to use password hash synchronization as the single sign-on(SSO) method. Staging mode is enabled.

  You review the synchronization results and discover that the Synchronization Service Manager does not display any sync jobs.

  You need to ensure that the synchronization completes successfully.

  What should you do?

  A. From Azure PowerShell, run Start-AdSyncSycnCycle olicyType Initial.
  B. Run Azure AD Connect and set the SSO method to Pass-through Authentication.
  C. From Synchronization Service Manager, run a full import.
  D. Run Azure AD Connect and disable staging mode.
  D. Run Azure AD Connect and disable staging mode.

  ---

  Explanation

  In staging mode, the server is active for import and synchronization, but it does not run any exports. A server in staging mode is not running password sync or password writeback, even if you selected these features during installation. When you disable staging mode, the server starts exporting, enables password sync, and enables password writeback.

  References:

  https://docs.microsoft.com/en-us/azure/active-directory/hybrid/how-to-connect-sync-staging-serverhttps://docs.microsoft.com/en-us/azure/active-directory/hybrid/how-to-connect-sync-operations

• Question 177:

  HOTSPOT

  You have an Azure logic app named App1 and an Azure Service Bus queue named Queue1.

  You need to ensure that App1 can read messages from Queue1. App1 must authenticate by using Azure Active Directory (Azure AD).

  What should you do? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  On App1: Turn on the managed identity

  To use Service Bus with managed identities, you need to assign the identity the role and the appropriate scope. The procedure in this section uses a simple application that runs under a managed identity and accesses Service Bus resources.

  Once the application is created, follow these steps: Go to Settings and select Identity.

  Select the Status to be On.

  Select Save to save the setting.

  On Queue1: Configure Access Control (IAM)

  Azure Active Directory (Azure AD) authorizes access rights to secured resources through role-based access control (RBAC). Azure Service Bus defines a set of built-in RBAC roles that encompass common sets of permissions used to access Service Bus entities and you can also define custom roles for accessing the data.

  Assign RBAC roles using the Azure portal

  In the Azure portal, navigate to your Service Bus namespace. Select Access Control (IAM) on the left menu to display access control settings for the namespace. If you need to create a Service Bus namespace.

  Select the Role assignments tab to see the list of role assignments. Select the Add button on the toolbar and then select Add role assignment.

  References:

  https://docs.microsoft.com/en-us/azure/service-bus-messaging/authenticate-applicationhttps://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-managed-service-identity

• Question 178:

  You have an on-premises network and an Azure subscription. The on-premises network has several branch offices.

  A branch office in Toronto contains a virtual machine named VM1 that is configured as a file server. Users access the shared files on VM1 from all the offices.

  You need to recommend a solution to ensure that the users can access the shares files as quickly as possible if the Toronto branch office is inaccessible.

  What should you include in the recommendation?

  A. a Recovery Services vault and Azure Backup
  B. an Azure file share and Azure File Sync
  C. Azure blob containers and Azure File Sync
  D. a Recovery Services vault and Windows Server Backup
  B. an Azure file share and Azure File Sync

  ---

  Explanation

  Use Azure File Sync to centralize your organization's file shares in Azure Files, while keeping the flexibility, performance, and compatibility of an on-premises file server. Azure File Sync transforms Windows Server into a quick cache of your Azure file share.

  You need an Azure file share in the same region that you want to deploy Azure File Sync.

  References:

  https://docs.microsoft.com/en-us/azure/storage/files/storage-sync-files-deployment-guide

• Question 179:

  You have an Azure subscription named Subscription1.

  You deploy a Linux virtual machine named VM1 to Subscription1.

  You need to monitor the metrics and the logs of VM1.

  What should you use?

  A. the Azure PerformanceDiagnostics extension
  B. Azure Analytic Services
  C. Linux Diagnostic Extension (LAD) 10
  D. Azure HDinsight
  A. the Azure PerformanceDiagnostics extension

  ---

  Explanation

  You can use extensions to configure diagnostics on your VMs to collect additional metric data.

  The basic host metrics are available, but to see more granular and VM-specific metrics, you need to install the Azure diagnostics extension on the VM. The Azure diagnostics extension allows additional monitoring and diagnostics data to be retrieved from the VM.

  References:

  https://docs.microsoft.com/en-us/azure/virtual-machines/linux/tutorial-monitoring

• Question 180:

  DRAG DROP

  You plan to import data from your on-premises environment to Azure. The data Is shown in the following table.

  

  What should you recommend using to migrate the data? To answer, drag the appropriate tools to the correct data sources-Each tool 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:

  

  

  ---

  

  References:

  https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sqlhttps://docs.microsoft.com/en-us/azure/cosmos-db/import-data