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
According to documentation A,B,D are available. C is not.
A, B, D
D is the right answer
D is right.
Why D and not B?
I would say A, B, D
ABD