You have a database that uses the following management views: ✑ Sys.dm_os_volume_stats ✑ Sys.dm_db_partition_stats ✑ Sys
Posted: Mon Oct 17, 2022 4:49 pm
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
✑ 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