Microsoft DP-200 Implementing an Azure Data Solution Exam Practice Test Questions
DP-200 Exam Features
In Just $59 You can Access
- Includes All Official Question Types
- Practice Tests on a Web-Based Software (no downloads needed)
- No Need To Install Any Software
- Customize Your Practice Sessions (Free Demo Available)
- Customer Support Available 24/7
-
A company plans to use Azure SQL Database to support a mission-critical application.The application must be highly available without performance degradation during maintenance windows.You need to implement the solution.Which three technologies should you implement? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
Answer: 1, 5, 6 Next -
A company runs Microsoft Dynamics CRM with Microsoft SQL Server on-premises. SQL Server Integration Services (SSIS) packages extract data from Dynamics CRM APIs, and load the data into a SQL Server data warehouse.The datacenter is running out of capacity. Because of the network configuration, you must extract on premises data to the cloud over https. You cannot open any additional ports. The solution must implement the least amount of effort.You need to create the pipeline system.Which component should you use? To answer, select the appropriate technology in the dialog box in the answer area.NOTE: Each correct selection is worth one point.References:
Answer:Next
-
You need to implement an Azure Databricks cluster that automatically connects to Azure Data Lake Storage Gen2 by using Azure Active Directory (Azure AD) integration.How should you configure the new cluster? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.References:
Answer:Next
-
You have an Azure SQL database named DB1 in the Each US 2 region.You need to build a secondary geo-replicated copy of DB1 in the West US region on a new server.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.References:
Answer:Next
-
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You are developing a solution that will use Azure Stream Analytics. The solution will accept an Azure Blob storage file named Customers. The file will contain both in-store and online customer details. The online customers will provide a mailing address.You have a file in Blob storage named LocationIncomes that contains based on location. The file rarely changes.You need to use an address to look up a median income based on location. You must output the data to Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention.Solution: You implement a Stream Analytics job that has one streaming input, one reference input, two queries, and four outputs.Does this meet the goal?
Answer: 1 Next