You have a database that uses the following management views:
Sys.dm_os_volume_stats
Sys.dm_db_partition_stats
Sys.dm_db_file_space_usage
Sys.fulltext_indexes
You plan to migrate the database to Microsoft SQL Azure.
You need to identify which view can be used in SQL Azure.
Which view should you identify?
A.
sys.fulltext_indexes
B.
sys.dm_db_file_space_usage
C.
sys.dm_os_volume_stats
D.
sys.dm_db_partition_stats
Correct answer: A,B,D
sys.fulltext_indexes – can be used in SQL Azure:
https://msdn.microsoft.com/en-us/library/ms186903.aspx
sys.dm_db_file_space_usage – can be used in SQL Azure:
https://msdn.microsoft.com/en-us/library/ms174412.aspx
sys.dm_os_volume_stats – CANNOT be used in SQL Azure:
https://msdn.microsoft.com/en-us/library/hh223223.aspx
sys.dm_db_partition_stats – can be used in SQL Azure:
https://msdn.microsoft.com/en-us/library/ms187737.aspx
I agree – the only view which can not be used in SQL Azure is sys.dm_os_volume_stats. So probably, the question is wrong an should be:
You need to identify which view can NOT be used in SQL Azure.
Then answer C is correct.
correct ANS is D