70-473

A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04. 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....

You need to identity 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 tierB . an Azure SQL database on the Basic service tierC ....

You need to implement a solution to meet the technical requirements for the encryption of the data in Appl. Which two features should you enable? Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one pointA . Storage Account EncryptionB . Azure Key VaultC ....

You need to recommend a solution to migrate the Listings database to the cloud. What should you recommend?A . Stage the Listings database on an Azure virtual machine prior to the outage. During the outage, perform a data import from the main office by using SQL Server Management Studio.B ....

DRAG DROP You need to configure server-level access to the ListTest database. adatum What statement should you use? To answer, drag the appropriate elements to the correct locations. Each element may be used once, or not at all. You may need to drag the split bar between panes or scroll...

You are planning the consolidation of the databases from Host1. You need to identify which methods to use to back up the data after the consolidation completes. What are two possible methods that achieve this goal? Each correct answer presents a complete solution.A . BACKUP TO URLB . AlwaysOn failover...

HOTSPOT You need to provision the database for DB2 in Azure. How should you provision the database? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Azure Database for MySQL Azure Database for MySQL provides fully...

Topic 3, Contoso, Ltd.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. Contoso is expected to double in size...

You need to recommend a database strategy to support the planned new customers. The solution must minimize costs. What should you recommend?A . a Basic database pool that has at least 1,200 eDTUsB . a Premium database pool that has at least 1,000 eDTUsC . 30 Basic databasesD . 30...

What should you use to schedule the nightly jobs to meet the technical requirements?A . Migrate the SQL Server Agent jobs.B . Create an Azure Scheduler task.C . Create an Azure runbook.D . Implement an Elastic Database jobs.View AnswerAnswer: C Explanation: Azure Automation can play the role of SQL Server...