070-765 試験問題を無料オンラインアクセス

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals.
You have a mission-critical application that stores data in a Microsoft SQL Server instance. The application runs several financial reports. The reports use a SQL Server-authenticated login named Reporting_User. All queries that write data to the database use Windows authentication.
Users report that the queries used to provide data for the financial reports take a long time to complete. The queries consume the majority of CPU and memory resources on the database server. As a result, read-write queries for the application also take a long time to complete.
You need to improve performance of the application while still allowing the report queries to finish.
Solution: You configure the Resource Governor to limit the amount of memory, CPU, and IOPS used for the pool of all queries that the Reporting_user login can run concurrently.
Does the solution meet the goal?

• A.No
• B.Yes

A company uses several Microsoft Azure elastic pools with Azure SQL Database instances.
You have two pools named Pool1 and Pool2. Pool2 is near maximum capacity and cannot accommodate the database move.
You need to move the database from Pool1 to Pool2.
Which PowerShell cmdlets should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

Explanation:
References:
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/set-azurermsqlelasticpool?view=azurermps-6.12.0
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/set-azurermsqldatabase?view=azurermps-6.12.0

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 need to run a Transact-SQL script against a Microsoft Azure SQL database daily at 01:00.
Solution: You deploy Microsoft SQL Server to an Azure virtual machine, and then you use the SQL Server Agent to schedule a job.
Does this meet the goal?

• A.No
• B.Yes

You administer a Microsoft SQL Server 2014 database that includes a table named Application.Events. Application.Events contains millions of records about user activity in an application.
Records in Application.Events that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts.
You need to be able to modify Application.Events without requiring any changes to the applications that utilize Application.Events.
Which type of solution should you use?

• A.Change tracking
• B.Partitioned tables
• C.Change data capture
• D.Online index rebuild

S178
VM size D3
Storage Location Drive E
Storage type Standard
Tempdb location Drive C
The workload on this instance has of the tembdb load.
You need to maximize the performance of the tempdb database.
Solution: You use a D- Series VM and store the tempdb database on drive D.
Does this meet the goal?

• A.No
• B.Yes