Microsoft 70-473 Actual Free Exam Questions & Community Discussion

You plan to move a database to Microsoft Azure.
Users of the database will be located in the United States, Europe, and Asia. All modifications to the database will originate from the United States.
You need to recommend a database solution that will minimize latency for all of the users. The solution must minimize costs.
What should you recommend? To answer, drag the appropriate solutions to the correct locations. Each solution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

You need to implement monitoring for the ListTest database.
Which three 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.

You have a Microsoft Azure SQL database. You need to audit the data access of the database owners who use Microsoft SQL Server Management Studio.
What should you enable?

You have a Microsoft Azure SQL database.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

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.

You need to recommend a solution to meet the reporting requirements of App3.
What should you include in the recommendation?

You need to recommend a solution to meet the reporting requirements of App3.
What should you include in the recommendation?

You have a Microsoft Azure SQL database named DB1 attached to a server named Server 1. A web application named App1 connects to Server1.
You configure Active Geo-Replication for DB1. For the replica, you deploy another Azure SQL database server named ServerFailover to a different region.
You plan to use a failover group named FG1 that will have a read-write listener.
You need to configure App1 to reconnect to the database automatically after a failover.
Which value should you include in the connection string of App1?

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 a Microsoft Azure subscription that contains an AlwaysOn availability group named AG01. AG01 contains two nodes named DB01 and DB02 and a database named DATABASE1.
You plan to add additional nodes to AG01.
You need to minimize the administrative effort required to add the node. The solution must ensure that AG01 is configured to prevent data loss and can fail over without manual intervention.
Which statement should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You plan to create a data warehouse in Microsoft Azure for development purposes.
The data warehouse must not exceed 10 terabytes (TB) in size. You must minimize costs for the environment.
You need to create the data warehouse.
Which Transact-SQL statement should you run?

You need to recommend a disaster recovery solution for the CRM application that meets the business requirements.
What should you recommend?

You have a Microsoft Azure virtual machine that has Microsoft SQL Server installed. The virtual machine contains five databases. You need to identify whether the performance of queries to the databases has degraded during the last two weeks. Which SQL Server feature should you use?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Azure tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the CREATE DB command from the mysql command prompt.
Does this meet the goal?

Which three components are required to meet the encryption requirements for the ListTest database? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.