Microsoft Designing and Implementing Cloud Data Platform Solutions

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 you identify?

You need to ensure that the performance statistics for the research department are collected. What should you enable?

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?

You need to design a security strategy to support the planned changes for the customer databases. The solution must meet the security requirements. Which two security roles should you grant to the customers? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You need to implement a disaster recovery solution that meets the technical requirements. The solution must NOT require customers to modify their connection strings. Which disaster recovery solution should you implement?

You need to recommend a database strategy to support the planned new customers. The solution must minimize costs. What should you recommend?

You have an on-premises Microsoft SQL Server 2014 database in an AlwaysOn availability group. You are planning a backup solution for the database. Backups will run on a secondary replica. You need to create a backup procedure for the database. The solution must ensure that the backups are stored on-premises and in Microsoft Azure Blob storage. Which two actions should you perform? Each correct answer presents part of the solution.

You have a hybrid Microsoft SQL Server environment that has multiple servers and services that run in both Microsoft Azure and on-premises. It the network fails, you need to ensure that users can authenticate and connect to the resources available in Azure. Which two server roles should you deploy to Azure? Each correct answer presents part of the solution.

You have a Microsoft Azure SQL data warehouse. During peak usage, you discover that the data warehouse fails to meet performance expectations. You need to provide additional resources to the data warehouse. What should you do?

Your company has two offices. The offices are located in London and New York. The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24. You have a Microsoft SQL Server database that is hosted on a Microsoft Azure virtual machine. Currently, only the users in the London office use the database. You need to create a new firewall rule to provide the users in the New York office with access to the database. The solution must protect the database from being accessed by users on the public Internet. What should you do?