70-473 무료 덤프문제 온라인 액세스

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

• A.database mirroring
• B.SQL Server replication
• C.Azure Data Sync
• D.AlwaysOn Availability Groups

You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the Standard D3 service tier. All of the data files for the databases on the virtual machine are located on a single volume that is mounted as drive E.
The virtual machine experiences performance issues.
You view the wait statistics and discover a high number of GEIOLATCH_SH waits associated to the tempdb data files.
You need to resolve the performance issues.
What should you do?

• A.Change the service tier of the virtual machine to Standard D12.
• B.Move the tempdb data files to drive C.
• C.Change the service tier of the virtual machine to Standard DS3.
• D.Move the tempdb data files to drive D.

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

Your company has two offices 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 Azure SQL database. Currently, only the users in the London office use the database.
You plan to provide the users in the New York office with access to the database.
You need to ensure that the New York office users can access the database.
Which command should you execute?

• A.EXECUTE sp_set_database_firewall_rule N'NewYork,'131.107.15.1','131.107.15.1';
• B.EXECUTEsp_set_database_firewall_ruleN'NewYork,'131.107.15.1','255.255.255.255'
• C.EXECUTE sp_set_database_firewall_rule N'NewYork,'192.168.8.0', '255.255.255.0';
• D.EXECUTE sp_set_database_firewall_rule N'NewYork, '192.168.8.0', '192.168.8.255';

A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
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.Copy Database
• C.Deploy Database to a Microsoft Azure VM
• D.Deploy Database to a Microsoft Azure SQL Database