Administering Relational Databases on Microsoft Azure (DP-300) Test 1
© examsnet.com
Question : 9
Total: 39
You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table.
FactSales has 6 billion rows and is loaded nightly by using a batch process.
Which type of compression provides the greatest space reduction for the database?
| Name | Data type |
|---|---|
| SalesID | Int |
| Product | Int |
| Total Number | Numeric |
| Tax Number | Numeric |
| SalesRep | Varchar |
Which type of compression provides the greatest space reduction for the database?
Go to Question: