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 plan to configure auditing for a Microsoft SQL Server instance that contains 17 databases.
You need to audit all of the SELECT statements that are executed against all of the databases. The solution must ensure that all gathered information is written to the application log.
Solution: You create a Database Audit Specification in each database.
Does this meet the goal?

• A. No
• B. Yes

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.

Your company has a Microsoft Azure subscription that contains 20 Azure SQL databases on a single Microsoft SQL Server.
You need to ensure that you can aggregate results from the databases in a single query.
Which five components should you create in sequence? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

You are designing a hybrid data analytics solution that contains an on-premises Microsoft SQL Server environment and a Microsoft Azure SQL data warehouse.
You need to load data warehouse from the SQL Server environment as quickly as possible.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Your company has a data center located in Europe. The company has a 10 Mbps connection to the Internet that is 80 percent saturated on average. You have an on-premises Microsoft SQL Server database that is 6 TB. You plan to migrate the database the database to Microsoft Azure.
You need to recommend a solution to migrate the database to Azure. The solution must meet the following requirements:
- Ensure that the database is hosted in the West US region.
- Minimize any changes to the current network infrastructure.
- Minimize the amount of time required to migrate the database.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.

• A. Use a database DACPAC file to export the database.
• B. Configure Azure ExpressRoute and copy the data files to a virtual machine.
• C. Use the Azure Import/Export service.
• D. Use a database BACPAC file to export the database.
• E. Use the BACKUP to URL option and use Azure Blob storage as the location.