Administering Relational Databases on Microsoft Azure (DP-300) Test 1

© examsiri.com
Question : 9 of 39
 
Marks: +1, -0
You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table.
Name Data type
SalesID Int
Product Int
Total Number Numeric (8,4)
Tax Number Numeric (8,4)
SalesRep Varchar (30)
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?
Go to Question: