Free Designing Microsoft Azure Infrastructure Solutions Exam AZ-305 Exam Practice Test

You have data files in Azure Blob Storage.You plan to transform the files and move them to Azure Data Lake Storage.You need to transform the data by using mapping data flow.Which service should you use?

• Azure Data Box Gateway
• Azure Databricks
• Azure Data Factory
• Azure Storage Sync

Your company plans to deploy various Azure App Service instances that will use Azure SQL databases. The App Service instances will be deployed at the same time as the Azure SQLdatabases.The company has a regulatory requirement to deploy the App Service instances only to specific Azure regions. The resources for the App Service instances must reside in the same region.You need to recommend a solution to meet the regulatory requirement.Solution: You recommend using an Azure policy to enforce the location of resource groups.Does this meet the goal?

• Yes
• No

Your company has offices in the United States, Europe, Asia, and Australia.You have an on-premises app named App1 that uses Azure Table storage. Each office hosts a local instance of App1.You need to upgrade the storage for App1. The solution must meet the following requirements:Enable simultaneous write operations in multiple Azure regions.Ensure that write latency is less than 10 ms.Support indexing on all columns.Minimize development effort.Which data platform should you use?

• Azure SQL Database
• Azure SQL Managed Instance
• Azure Cosmos DB
• Table storage that uses geo-zone-redundant storage (GZRS) replication

You are designing a point of sale (POS) solution that will be deployed across multiple locations and will use an Azure Databricks workspace in the Standard tier. The solution will include multiple apps deployed to the on-premises network of each location.You need to configure the authentication method that will be used by the app to access the workspace. The solution must minimize the administrative effort associated with staff turnover and credential management.What should you configure?

• a managed identity
• a service principal
• a personal access token

You have an Azure subscription that contains two applications named App1 and App2. App1 is a sales processing application. When a transaction in App1 requires shipping, a message is added to an Azure Storage account queue, and then App2 listens to the queue for relevant transactions.In the future, additional applications will be added that will process some of the shipping requests based on the specific details of the transactions.You need to recommend a replacement for the storage account queue to ensure that each additional application will be able to read the relevant transactions.What should you recommend?

• one Azure Service Bus queue
• one Azure Service Bus topic
• one Azure Data Factory pipeline
• multiple storage account queues

Your network contains an on-premises Active Directory forest.You discover that when users change jobs within your company, the membership of the user groups are not being updated. As a result, the users can access resources that are no longer relevant to their job.You plan to integrate Active Directory and Azure Active Directory (Azure AD) by using Azure AD Connect.You need to recommend a solution to ensure that group owners are emailed monthly about the group memberships they manage.What should you include in the recommendation?

• conditional access policies
• Tenant Restrictions
• Azure AD access reviews
• Azure AD Identity Protection

You plan to automate the deployment of resources to Azure subscriptions.What is a difference between using Azure Blueprints and Azure Resource Manager (ARM) templates?

• ARM templates remain connected to the deployed resources.
• Only ARM templates can contain policy definitions.
• Blueprints remain connected to the deployed resources.
• Only Blueprints can contain policy definitions.

You have an app named App1 that uses two on-premises Microsoft SQL Server databases named DB1 and DB2.You plan to migrate DB1 and DB2 to Azure.You need to recommend an Azure solution to host DB1 and DB2. The solution must meet the following requirements:* Support server-side transactions across DB1 and DB2.* Minimize administrative effort to update the solution.What should you recommend?

• two SQL Server databases on an Azure virtual machine
• two Azure SQL databases on different Azure SQL Database servers
• two Azure SQL databases in an elastic pool
• two Azure SQL databases on the same Azure SQL Database managed instance

You plan to deploy an Azure SQL database that will store Personally Identifiable Information (Pll). You need to ensure that only privileged users can view the Pll.What should you include in the solution?

• Transparent Data Encryption (TDE)
• Data Discovery & Classification
• dynamic data masking
• role-based access control (RBAC)

You have an Azure subscription.Your on-premises network contains a file server named Server1. Server 1 stores 5 TB of company files that are accessed rarely.You plan to copy the files to Azure Storage.You need to implement a storage solution for the files that meets the following requirements:* The files must be available within 24 hours of being requested.* Storage costs must be minimized.Which two possible storage solutions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• Create a general-purpose v1 storage account. Create a blob container and copy the files to the blob container.
• Create a general-purpose v2 storage account that is configured for the Hot default access tier. Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.
• Create a general-purpose v1 storage account. Create a file share in the storage account and copy the files to the file share.
• Create a general-purpose v2 storage account that is configured for the Cool default access tier. Create a file share in the storage account and copy the files to the file share.
• Create an Azure Blob storage account that is configured for the Cool default access tier. Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.