IBM Exam C2090-101 Topic 10 Question 28 Discussion

Actual exam question for IBM's C2090-101 exam

Question #: 28
Topic #: 10

[All C2090-101 Questions]

Which is a benefit of row oriented table design?

AWhen writing a new row, if all of the row data is supplied at the same time the entire row can be written with a single disk seek

BWhen columns of a single row are required at the same time, the entire row can be retrieved with a single disk seek regardless of row size

CWhen new values of a column are supplied for all rows at once, that column data can be written efficiently and replace old column data without touching any other columns for the rows

DWhen an aggregate needs to be computed over many rows but only a notably smaller subset of all columns of data, reading that smaller subset of data can be faster than reading all data

Show Suggested Answer

Suggested Answer: B

http://www.ijoart.org/docs/Column-Oriented-Databases-to-Gain-High-Performance-for-Data- Warehouse-System.pdf (7)

by Cecil at May 05, 2022, 12:46 PM

Limited Time Offer

25%

Off

Get Premium C2090-101 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!