Discuss Microsoft DP-300 Exam Topic 6 Question 26

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?

Apage compression

Brow compression

Ccolumnstore compression

Dcolumnstore archival compression

Suggested Answer: D

Columnstore tables and indexes are always stored with columnstore compression. You can further reduce the size of columnstore data by configuring an additional compression called archival compression.

Note: Columnstore --- The columnstore index is also logically organized as a table with rows and columns, but the data is physically stored in a column-wise data format.

Incorrect Answers:

B: Rowstore --- The rowstore index is the traditional style that has been around since the initial release of SQL Server.

For rowstore tables and indexes, use the data compression feature to help reduce the size of the database.

https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Charlene 11 months ago

Page compression is decent, but columnstore is the way to go!

Veronika 12 months ago

Wait, are you sure about that? Sounds too good to be true.

Leah 12 months ago

Definitely columnstore archival compression for max space savings!

Rocco 1 year ago

I think row compression could work too, but not as well.

Noemi 1 year ago

Columnstore compression is the best for large datasets!

Alison 1 year ago

I’m a bit confused about the differences between row and page compression. I hope I remember the right details during the exam!

Shannon 1 year ago

I practiced a similar question where columnstore archival compression was highlighted for its efficiency with large tables.

Quentin 1 year ago

I’m not entirely sure, but I remember something about page compression being effective for reducing space too.

Rosio 1 year ago

I think columnstore compression might be the best option here since it’s designed for large datasets like this one.

Carol 1 year ago

Hmm, I'm a bit confused by some of these options. I know ESS is used for scheduling jobs, but I'm not sure about the specifics of how the job request processor and dispatcher work. I'll need to review my notes on that.

Apolonia 1 year ago

Hmm, this seems straightforward. I think the two objects are application and package.

Elli 1 year ago

I'm not sure about this one. Option C looks interesting with the `PipelineParameter`, but I'm not sure if that's the right approach for this specific question. I'll have to review the Azure ML documentation to see if that's the appropriate solution.

Microsoft DP-300 Exam - Topic 6 Question 26 Discussion