While working on Azure SQL Database, you want to use data compression to decrease the size of the database. From the given options, select the database objects on which you can configure row and page compression?

Answer options:

A.A whole nonclustered index
B.A whole indexed view
C.A whole table that has been stored as a heap.
D.A whole table that has been stored as a clustered index.
E.All the above

Correct Answer: E 
Row and page compression can be configured on the following database objects: 

Option A is incorrect. You can configure row and page compression not only on a whole nonclustered index but all given database objects.
Option B is incorrect. Row and page compression can be configured not only on a whole indexed view but all given database objects.
Option C is incorrect. Row and page compression can be configured not only on A whole table that has been stored as a heap but also all given database objects.
Option D is incorrect. Row and page compression can be configured not only on A whole table that has been stored as a clustered index but also all given database objects.
Option E is correct. Row and page compression can be configured for all the given database objects.
Reference:
To know more about Data Compression, please visit the below-given link: 

https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver15