DP-300 (Administering Relational Databases)
  • Xin chào
  • Giới thiệu
    • Liên hệ
    • More ...
  • dp-300
    • Topic 1
      • [1-10]
        • Question #1
          • Solution
        • Question #2
          • Solution
        • Question #3
          • Solution
        • Question #4
          • Solution
        • Question #5
          • Solution
          • Di chuyển SQL Server lên Azure SQL Managed Instance
        • Question #6 *
          • Solution
        • Question #7 *
          • Solution
        • Question #8 *
          • Solution
        • Question #9 *
          • Solution
        • Question #10
          • Solution
      • [11-20]
        • Question #11
          • Solution
      • More questions ...
    • More topics ...
Powered by GitBook
On this page
Export as PDF
  1. dp-300
  2. Topic 1
  3. [1-10]

Question #3

PreviousSolutionNextSolution

Last updated 2 months ago

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. You must provide the greatest reduction in space for the database and maximize performance.

Which type of compression provides the greatest space reduction for the database?

A. page compression

B. row compression

C. columnstore compression

D. columnstore archival compression