Teradata Vantage Certified Associate — Question 22

A business collects sensor data from vehicles for maintenance analysis. Each model-year adds new data attributes, and occasionally obsolete attributes are dropped from the sensor data.
Which type of storage is most appropriate for this data?

Answer options

• A. Sparse join index
• B. Third-normal form relational
• C. Denormalized dimensional
• D. Semi-structured JSON

Correct answer: D

Explanation

The correct answer is D, Semi-structured JSON, because it allows for flexible storage of varying data attributes, accommodating the addition of new fields and the removal of obsolete ones. The other options, such as Third-normal form relational and Denormalized dimensional, are more rigid in structure and less suitable for evolving data schemas.