Designing and Implementing Cloud Data Platform Solutions
Microsoft 70-473 Dumps Available Here at:
Enrolling now you will get access to 33 questions in a unique set of 70- 473 dumps
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 URL
B. AlwaysOn failover clustering C. a maintenanceplan
D. AlwaysOn Availability Groups Answer: A, C
You need to recommend a disaster recovery solution for the CRM application that meets the business requirements.
What should you recommend?
A. backup and restore by using Windows Azure Storage B. log shipping
C. AlwaysOn Availability Groups
D. database mirroring
You are evaluating moving the data from WebData1 to an Azure SQL database.
You need to recommend a solution to generate the consolidated report for billing. The solution must meet the business requirements.
What should you include in the recommendation?
A. SQL Server Integration Services (SSIS) B. SQL Server Analysis Services (SSAS) C. an elastic database job
D. an elastic query
You need to recommend a backup solution for the ListTest database. What should you include in the recommendation?
A. Extract a data-tier application (DAC).
B. Use the bcp command.
C. Use the SQL Server Migration Assistant (SSMA). D. Export a data-tier application (DAC).
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. Implement log-shipping between the main office and an Azure virtual machine prior to the migration
date. During the planned outage, perform a final log backup, restore the backup to the secondary, and
then switch the secondary to the primary role.
C. Run a full backup during the outage and restore the backup to theAzure virtual machine. D. Implement merge replication between the main office and the Azure virtual machine. Answer: B
You are evaluating whether an Azure SQL Database elastic database pool suits your workload and usage patterns.
What are two possible ways to identify the elastic database transaction units (eDTUs)? Each correct answer presents a complete solution.
A. Aggregate data from sys.dm_os_wait_stats.
B. Run the Database Engine Tuning Advisor.
C. Run the Service Tier Advisor.
D. Aggregate data from sys.dm_db_resource_stats.
E. Aggregate data from sys.dm_os_performance_counters. Answer: D, E
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 on an Azure virtual machine.
C. Create an Azure HDInsight cluster.
D. Create an Azure DocumentDB database.
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?
A. Premium Ð 1 B. Premium Ð 14 C. Standard S0 D. Basic
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. Deploy Database to a Microsoft Azure SQL Database D. Copy Database
References: https://azure.microsoft.com/en-gb/documentation/articles/sql-database-cloud-migrate-compatible-using- ssms-migration-wizard/
Would you like to see more? Don't miss our 70-473 PDF file at: