An organization needs to store daily transactional data such as customer records and purchase history. The data follows a consistent schema and is cross-referenced. Which type of service should the or

Non-relational databases are schema-flexible and optimized for unstructured or semi-structured data, but lack native support for cross-referencing data via relational joins.

A data warehouse is optimized for large-scale analytical queries and reporting, not for day-to-day transactional workloads that require frequent reads and writes.

Relational databases store data in structured tables with defined schemas and support SQL queries including JOINs, which are necessary for cross-referencing related data such as customers and purchase history. They provide ACID compliance for transactional integrity, making them ideal for this use case.

A data lake stores raw, unstructured, or semi-structured data at scale for future analysis and is not appropriate for structured transactional record storage.