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.
DRAG DROP -You have four Microsoft Azure SQL databases.You need to configure cross-database queries.Which four statements should you use in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.Select and Place:
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?
You have an organizational data mart that contains 3.5 TB of uncompressed data.The size of the data is expected to grow 2 annually. Reporting is performed only during business hours.You plan to move the data to the cloud.You need to design a cloud architecture for the data mart. The solution must minimize costs and administrative overhead.What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
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?
