70-473日本語 無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions (70-473日本語版)」
![](https://www.jpntest.com/uploads/imgs/70-473J V14.75/70-473J_34_auto.png)
![](https://www.jpntest.com/uploads/imgs/70-473J V14.75/img_92.jpg)
正解:
![](https://www.jpntest.com/uploads/imgs/70-473J V14.75/img_93.jpg)
Explanation
![](https://www.jpntest.com/uploads/imgs/70-473J V14.75/img_95.jpg)
Box 1: Sys.dm_io_virtual_file_stats
Sys.dm_io_virtual_file_stats returns I/O statistics for data and log files.
Box 2:
Page reads/sec indicates the number of physical database page reads that are issued per second. This statistic displays the total number of physical page reads across all databases. Because physical I/O is expensive, you may be able to minimize the cost, either by using a larger data cache, intelligent indexes, and more efficient queries, or by changing the database design.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-io-virtual-
https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-cpu-usage?view=sql-ser