Which view should you identify?

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?

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



Leave a Reply 6

Your email address will not be published. Required fields are marked *


jml

jml

According to documentation A,B,D are available. C is not.

Modi

Modi

D is the right answer

malakosa

malakosa

Why D and not B?

I would say A, B, D