CompTIA Data+ (DA0-001) — All Questions

A database is optimized for many small, fast insert and update operations from a business application, such as recording individual sales transactions. Which type of system is this?

• a.OLAP (online analytical processing)
• b.OLTP (online transaction processing)✓
• c.A flat CSV export
• d.A data visualization dashboard

OLTP systems are optimized for numerous short, fast transactions such as inserts and updates from operational applications. OLAP systems, by contrast, are optimized for complex analytical queries over large historical datasets, which is a different workload.

Which description best fits semi-structured data?

• a.Data stored strictly in fixed rows and columns of a relational table
• b.Raw video footage with no organizing information at all
• c.Numeric data that can never contain text
• d.Data such as JSON or XML that has tags or keys but no rigid table schema✓

Semi-structured data, such as JSON or XML, carries organizational markers like tags or keys but does not conform to the rigid rows and columns of a relational schema. Fully structured data lives in fixed tables, while unstructured data such as raw video lacks a predefined model.

An organization stores vast amounts of raw data in its native format, both structured and unstructured, to be processed later as needed. Which environment is this?

• a.A data lake✓
• b.A normalized OLTP database
• c.A single spreadsheet
• d.A dimension table

A data lake stores large volumes of raw data in its native format, deferring structure until the data is read and used. A normalized OLTP database enforces a strict schema up front, and a spreadsheet or single dimension table cannot hold the scale and variety described.