Multiple choice technology databases

In which situation is shredding XML data recommended?

  1. When the data is naturally tabular

  2. When the number of nodes are volatile

  3. When the data by nature has sparse attributes

  4. When the data is of low volume and requires a complex star-schema topology
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Shredding XML means decomposing XML documents into relational tables. This is recommended when the XML data has a natural tabular structure - where elements consistently map to columns and rows. The data can then be queried and joined efficiently using SQL. Option B is incorrect because volatile nodes would require frequent schema changes. Option C is incorrect because sparse attributes are better handled in XML's flexible structure rather than fixed relational columns. Option D is incorrect because complex star-schema topology and low volume data don't justify the overhead of shredding.

Keep practicing — related questions