You need to identify which service tier to use for the research department databases. The solution must meet the business goals and the department requirements. What should you identify? A. an Azure virtual machine on the Basic service tier B.…
You establish a site-to-site VPN to Microsoft Azure. You need to implement a high-availability solution for the data warehouse. The solution must meet the business goals and the technical requirements. Which two actions should you perform? Each correct answer presents…
DRAG DROP You need to implement a storage architecture for the Azure virtual machines that will host the OLTP database. The solution must meet the business goals and technical requirements. Which three actions should you perform in sequence? To answer,…
You need to ensure that the performance statistics for the research department are collected. What should you enable? A. Query Performance Insight B. Scale and Configuration C. Dynamic Data Masking D. Index advisor
You need to tell the research project leaders how to migrate their databases. Which task should you instruct the leaders to use from SQL Server Management Studio? A. Extract Data-tier Application B. Deploy Database to a Microsoft Azure VM C.…
You are evaluating the use of active geo-replication for one of the research department databases. You need to identify which service tier to use for the database. The solution must meet the department requirements and the business requirements. What should…
Overview Contoso, Ltd. is a national scientific research company that has sales, marketing, and research departments. Contoso has a main office in Dallas and more than 20 satellite offices across the United States. Some employees work off-site at customer locations.…
You need to recommend an auditing solution that meets the business goals. Which three events should you include in the recommendation? Each correct answer presents part of the solution. A. Transaction Management B. Stored Procedure C. Plain SQL D. Login…
You are designing the data warehouse. You need to recommend a solution that meets the business goals and the technical requirements. What should you recommend? A. Create an AlwaysOn availability group between SQL03 and SQL04. B. Host the data warehouse…
DRAG DROP You need to recommend a solution to implement high availability for the Listings database. Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer…