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

You have a Microsoft SQL Server instance that is hosted on a Microsoft Azure virtual machine.
You need to identify the most recent wait type for all of the currently running queries in the instance.
What should you use?

• A.the sp_who2 stored procedure
• B.the sys.syscacheobjects view
• C.the sys.dm_exec_connections view
• D.the sys.dm_exec_requests view

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.

정답:

Explanation

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.Run a full backup during the outage and restore the backup to the Azure virtual machine.
• C.Enable mirroring between the main office and the Azure virtual machine. During the planned outage, change the mirroring roles on the Azure virtual machine to become the primary server, and then break the mirror.
• D.Implement merge replication between the main office and the Azure virtual machine.

You have a Microsoft Azure SQL database named DB1 on a logical server named Serverl48923034.database.windows.net. You need to restore DB1 to another database named DB2 on the same server.
Which Azure PowerShell command should you run first? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

Explanation

You have a Microsoft Azure SQL data warehouse.
During peak usage, you discover that the data warehouse fails to meet performance expectations.
You need to provide additional resources to the data warehouse.
What should you do?

• A.Increase the number of Database Throughput Units (DTUs).
• B.Create an elastic database pool.
• C.Increase the number of Data Warehouse Units (DWUs).
• D.Create an additional storage pool.