Generative AI Leader · Free Practice Question Medium
Question 21
A retail company has three distinct data storage needs for its AI initiatives:
A repository to store terabytes of raw, unprocessed data, including product images, videos, and web server logs.
A platform for analysts to run complex queries on years of historical, structured sales data to identify buying patterns.
A system for an AI agent to perform fast, real-time lookups of a single customer's current order status.
Which option correctly maps these needs to the appropriate data storage paradigm?
-
A
1: Database, 2: Data Warehouse, 3: Data Lake
-
B
1: Data Warehouse, 2: Data Lake, 3: Database
-
C
1: Data Lake, 2: Data Warehouse, 3: Database
-
D
1: Data Lake, 2: Database, 3: Data Warehouse
Reveal correct answer
Correct answer: C
Explanation
The question requires matching each business need to the correct architectural data store type.
INCORRECT: (All other options)
These options incorrectly map the use cases to the storage paradigms. For example, a database is not suitable for storing terabytes of raw images, and a data lake is not designed for fast, transactional lookups.CORRECT: 1: Data Lake, 2: Data Warehouse, 3: Database
This is the correct mapping:1 (Raw, unstructured files): The need to store vast quantities of raw data in various formats is the primary use case for a Data Lake (like Google Cloud Storage).
2 (Complex analysis of historical data): The need to run large-scale analytical queries on structured data is the classic use case for a Data Warehouse (like Google BigQuery).
3 (Fast, real-time lookup): The need to read or write a single record quickly for a live application is the primary use case for a Database (like Google Cloud SQL or Cloud Spanner).
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
