070-473 無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions」
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 recommend an auditing solution that meets the business goals.
Which three events should you include in the recommendation? Each correct answer presents part of the solution.
You need to recommend an auditing solution that meets the business goals.
Which three events should you include in the recommendation? Each correct answer presents part of the solution.
正解：A、B、C
解答を投票する
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?
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?
正解：C
解答を投票する
You have a Microsoft Azure SQL database that is used for reporting.
You discover that some reports complete more quickly than other reports, even though the reports retrieve approximately the same amount of data and use queries that have the same table structure.
You need to reduce the amount of time it takes to complete the reports.
What should you use?
You discover that some reports complete more quickly than other reports, even though the reports retrieve approximately the same amount of data and use queries that have the same table structure.
You need to reduce the amount of time it takes to complete the reports.
What should you use?
正解：D
解答を投票する
You need to configure server-level access to the ListTest database. adatum What statement should you use? To answer, drag the appropriate elements to the correct locations. Each element may be used 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 may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
正解：
Explanation
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine named VM1. VM1 is provisioned by using the classic deployment model and is on the Standard GS5 service tier.
The virtual machine is used for testing purposes only.
You need to minimize the costs associated with VM1 when the virtual machine is unused.
Which command should you use?
The virtual machine is used for testing purposes only.
You need to minimize the costs associated with VM1 when the virtual machine is unused.
Which command should you use?
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a report that runs against a Microsoft Azure SQL database.
The report takes more time to return results than expected.
You add an index to a table in the database.
You need to identify whether adding the index improves the performance issue.
What should you use?
The report takes more time to return results than expected.
You add an index to a table in the database.
You need to identify whether adding the index improves the performance issue.
What should you use?
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)