A merger is planned between your company and another similar sized company. The other company manages proprietary databases, XML files, and PDF files of scanned documents on an on-premises data infrastructure. What data flow and storage solution would you choose if you need a way to quickly place this data in the cloud for analysis?

If you need to perform a one-time bulk data transfer knowing that your company has an Azure subscription, which storage solution for batch processing would you recommend that meets the following requirements: *The solution allows the pause of cluster once computation is finished *Allows relational data storage *Allows fast scaling out *Offers in-memory caching of data support.

Which is the appropriate tool to use if you want to monitor database for performance tuning and review recommendations for indexes, considering you have an Azure SQL Database instance with one database?

Which is the best solution to opt if you are required to create an authentication solution that verifies: 1) Applied on-premises AD security policies, 2) Passwords not stored on cloud, 3) On-premises AD validates the passwords. This is in a hybrid environment that includes an on-premises Active Directory environment and Azure Active Directory (Azure AD)

While moving to Azure your company plans to create a virtual machine (VM) for one of its SQL Server instances. The VM will not be connected via a site-to-site VPN in the beginning, and port 1433 will help users to access the SQL Server instance. What should you recommend if you are to provide a solution that guarantees secure VM and asks for minimal administration overhead?

Your company runs SQL Server 2016 on an on-premises virtual machine (VM) with a 2 TB database. 120 GB of data in the database has aged only three months, and other is historical data. If you are required to shift the historical data to Azure and create a solution that is able to move all data older than three months to Azure automatically, while allowing users to query the historical data without writing custom code which two Azure components should you configure? Each correct answer presents part of the solution.

You are performing a custom search of Azure Log Analytics data and create this alert: Heartbeat I summarize LastCall = max(TimeGenerated) by Computer. Unfortunately, this alert is giving result and incorrect information. You are required to make changes to the alert and get results displaying only data from the previous 24 hours. What should you add?

In order to detect anomalies, you plan to create a real-time stream processing system. The business logic that you write code for must run immediately upon data being ingested. The business logic can be frequently changed and also depends on the type of data. What should you do if you have to be sure the business logic does not keep data between executions?

A company has subscribed to Azure with two separate subscriptions, associated with the same Active Directory (AD) tenant. One of them, Subscription), consists of the following virtual network: *Name: VNET1 *Address space: 10.1.0.0/16 *Location: (US) Central US *Number of connected virtual machines (VMs): 200. The other, Subscription2, consists of the following virtual network: *Name: VNET2 *Address space: 192.168.0.0/16 *Location: (Europe) North Europe *Number of connected virtual machines (VMs): 100. What would you recommend if you are the Azure Architect required to offer a connectivity solution that enable the VMs on VNET1 and VNET2 to communicate over the Microsoft backbone infrastructure?

Your organization requires a data archiving solution. The solution is for a web application that is hosted on an Azure virtual machine. There are hundreds of files totaling around 10 GB data, that often accessed and staged for processing. Which access tier would you recommend if you are asked to provide a solution that makes data access more cost efficient?

If you are organizing your Azure resources by using tagging and want to make sure new resources are tagged automatically instead of manually, what would you do?

While monitoring the performance of an Azure SQL database, the resulting chart displayed zero percent. Upon opening the Metrics blade, you had set the time range to Last 3 days and added the DTU Used metric to the chart. What does this metric indicate?

A company with a small Windows service running on a development server and using port 80 to take requests has zero dependencies. It accesses a third-party API and returns results to the caller. If your job is to move this service’s functionality to Azure by using the least amount of management, what is the appropriate resource you would use?

You are using autoscaling to optimize cost and performance of a business critical application, running on Azure Kubernetes Service (AKS). You need an autoscaling strategy that helps you keep track of the replica applications running at a time. Choose the best suitable strategy in this situation.

Select one of the following situations where your IT team should consider using Azure Active Directory (AD) Connect?

Which of these mechanisms is most suitable if you need to setup authentication while designing a hybrid identity solution for your company where the solution meets these requirements: *Minimize administrative effort to deploy and maintain, and *Allow a user who logs in to his or her on-premises account to automatically authenticate in Azure AD to access Azure services.

Your company manages domain user accounts via Azure Active Directory (AD). With these accounts you can access Azure resources. What should you do if there is a need to reduce the risk of AD credential misuse?

In order to make sure you are aware when user credentials of Azure are compromised and placed on the dark web, while designing an Azure identity solution for your company, what step should you take?

If you are crafting a strategy to load large volume of data to Azure Data Warehouse and want the data load process to be as fast as possible, which solution should you recommend?

A third-party application is using DB1, your Microsoft SQL Server Database that is on-premises and contains 5 TB of data. Every month 200 GB of fresh data is added into it. You are asked to provide a solution that archives unused data, allows access to archived data, lets DB1 remain on-premises and avoids changes to the third-party application. Which best Azure service would you identify as best suitable?

You are asked to design a monitoring strategy to monitor synchronization between on-premises Active Directory (AD) domain and Azure AD on a hybrid authentication model. Which of these would you recommend?

You are asked to advise a storage solution for a company that plans to use PolyBase as a data loading solution for Azure SQL Data Warehouse. Your advised solution must allow to scale and the store unstructured data in large volumes. Which two of these storage solutions should you recommend? Each correct answer presents a complete solution.

Which Azure service is best suitable to create security alerts against suspicious Azure AD sign-in attempts if your company has Azure Active Directory (Azure AD) synchronized with on-premises Active Directory (AD)?

You are to move the database on each of the four on-premises SQL Server 2016 instances your company has, to Azure. With usage requirements different for each database, you should opt for a solution that saves cost and requires optimal maintenance, that also ensures almost 100% compatibility with your on-premises instances. Which solution would you pick?