Google Cloud Data Lake vs Data Warehouse Selection

CDL By islever Editorial Last updated

Google Cloud Data Management Solutions Cloud Computing Models and Shared Responsibility

Short answer

A The organization should use a data lake to store large-scale, heterogeneous fitness data for flexible, later analysis without upfront schema constraints.

Question

An organization has created a medical fitness app and wants to store a very large amount of data
about exercise times, activity, and calories burned for later analysis.
Which data management solution should the organization use?
  1. Data lake Correct Answer
  2. Data warehouse
  3. Data field
  4. Database

Key Takeaways

The trap is assuming all app data is structured; the key insight is that 'store for later analysis' of massive volumes favors the schema-on-read flexibility of a Data Lake.

Learn why a Data Lake is the correct choice over a Data Warehouse for storing large-scale, raw fitness app data for future analysis in the CDL exam.

Common mistake: Choosing Data Warehouse because the specific metrics listed (time, calories) appear structured, ignoring the scale and potential heterogeneity of raw IoT/mobile data.

Expert Analysis

The Data Lake vs. Data Warehouse Distinction

The core of this question tests the ability to distinguish between Data Lakes (A) and Data Warehouses (B) based on data structure and ingestion strategy. The scenario specifies storing "very large amounts of data" for "later analysis," which implies a need for scalable, raw storage capable of handling diverse inputs.

Why A is Correct: A Data Lake is designed to ingest vast volumes of data in its native format—structured, semi-structured, or unstructured—without requiring a predefined schema at the time of ingestion. Fitness app data often includes varied formats: structured logs (calories), semi-structured JSON (activity types), and potentially unstructured data (images/audio). The key phrase "for later analysis" aligns with the Data Lake paradigm: store now, process/analyze later using flexible tools like BigQuery or Dataproc. This approach avoids the rigidity of schema-on-write.

Why B is Incorrect: A Data Warehouse uses a "schema-on-write" approach, requiring data to be cleaned, transformed, and structured before loading. While comments argue that fitness data is structured, Google Cloud documentation emphasizes that Data Lakes are the primary solution for ingesting massive, heterogeneous datasets from IoT or mobile apps where the final analytical use case may evolve. Using a warehouse would require upfront ETL processes that contradict the simplicity implied by just wanting to "store... for later analysis."

Why C and D are Incorrect:

  • Data field (C): This is not a recognized Google Cloud data management solution.
  • Database (D): Traditional databases (like Cloud SQL) lack the scalability and cost-efficiency for "very large amounts" of historical analytics data compared to object storage-based lakes.

Exam Strategy

When faced with storage questions, look for keywords indicating scale ('very large'), format flexibility ('raw', 'unstructured'), or deferred processing ('later analysis'). These typically point to a Data Lake. If the question emphasizes 'cleaned', 'reported', or 'dashboard-ready' data, choose a Data Warehouse. Always prioritize the ingestion model (schema-on-read vs. schema-on-write) over the apparent current structure of the data.

Frequently Asked Questions

Can a Data Warehouse handle unstructured data?

Traditional data warehouses are optimized for structured data. While some modern cloud warehouses support semi-structured data (like JSON), they still require schema definition upon ingestion, unlike Data Lakes which accept raw formats.

Is BigQuery a Data Lake or Data Warehouse?

BigQuery is primarily a Data Warehouse, but it can query data stored in GCS (which acts as a Data Lake). For pure storage of raw, diverse data for later processing, GCS-based Data Lakes are the standard recommendation.

More CDL FAQ →

Community Votes

B
53%
A
47%

53% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 21 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 21

  1. Emma412 👍 7 Answered B
    I strongly think that B is the correct answer Reasoning: I read an article from Qlik.com that compares DataLake and DataWarehouse. In that i noticed 2 factors that bring out the difference. 1. DataLake better at handling unstructured Data whereas Datawarehouse is better at structured data 2. DataLake shines are real-time analytics and nothing is said about real-time analytics for Datawarehouse. in the given question the data is primarily structured and explicitly mentions that data is required for analysis "Later". hence B should be the correct match/answer.
  2. Flexip 👍 4 Answered A
    An organization that has created a medical fitness app and wants to store a very large amount of data about exercise times, activity, and calories burned for later analysis should use a data lake (A). A data lake is a centralized repository that allows organizations to store all their structured and unstructured data at any scale. Data can be stored in its raw form and can be analyzed later using big data processing tools.
  3. chai_gpt 👍 3 Answered B
    B. Data warehouse is correct. Because the data about exercise times, activity, and calories burned etc. falls under either structured data or semi-structured data which data warhouse (like BigQuery) can handle really well. And it is mentioned in question that data is needed for later analysis. Data warehouse (like BigQuery) can help in this analysis.
  4. BTAB 👍 2 Answered B
    Agree on B. Since there is no requirement for semi-structured and unstructured data in raw form, and the data mentioned in the question large amounts of structured data, I would go with Data Warehouse.
  5. guilhermemls 👍 2 Answered B
    I would choose Data Warehouse as it is a solution to store Big Data and serve it for analytics services. For example, BigQuery has an ML solution embedded on it.
Show 16 more comments
  1. andr31 👍 2 Answered B
    The data that the fitness company wants to store is structured and/or semi-structured and there's no mention of BLOBs or anything like that. The answer is B.
  2. inner4444 👍 2
    because the data comes from the fitness app, it's most likely a structured data, I will change my answer to B
  3. gyenesge 👍 2 Answered B
    Datawarehouse is good for analysis. Datalake is more for storing semistructured data, or data in raw format.
  4. inner4444 👍 2 Answered A
    Based on AI's answer it's A - data lake
  5. Kaycee101 👍 2
    B is the correct answer here
  6. Dinraj 👍 2 Answered B
    I would go for B
  7. Mikee007 👍 1 Answered A
    The organization should use a data lake to store the large volume of data from its medical fitness app. A data lake is a centralized repository that can store raw, unstructured data like exercise times, activity, and calories burned, which can then be analyzed with various big data processing tools at a later time. A data warehouse is another option but is better suited for structured data that has been cleaned and processed.
  8. cd68849 👍 1 Answered A
    If the organization wants to store large volumes of diverse data from the app, which will be processed or analyzed later: A. Data Lake is correct. If the data is already clean, structured, and ready for dashboards or quick SQL analysis, then B. Data Warehouse would be appropriate. But in this scenario, the correct answer is A.
  9. __rajan__ 👍 1 Answered A
    A. Data lake A data lake is a centralized repository that stores all types of data, including structured, semi-structured, and unstructured data. Data lakes are often used to store large amounts of data for later analysis.
  10. Mikee007 👍 1 Answered B
    Exercise times, activity, and calories burned are examples of structured data, hence Data Warehouse should be the correct answer.
  11. hita97 👍 1 Answered A
    Data warehouse stores transformed data. For storing purpose Data Lake can be used
  12. kenatepi 👍 1 Answered A
    I prefer A, since warehouse is not for raw/unprocessed fitness logs
  13. CarloGiovanni 👍 1
    however, all data is structured so a warehouse fits better
  14. Robert12 👍 1 Answered B
    Exercise times and calories burned are structured data
  15. DPonly 👍 1
    option A , as current requirement is storing data
  16. sanchezcab 👍 1 Answered A
    ChatGPT

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Migrating Private Cloud Hypervisor Workloads to Google Cloud

S-grade

Strategic Data Analysis Service for Petabytes

S-grade

Using Google Cloud APIs for Document Search and Extraction

S-grade

Compute Engine Sustained-Use Discount Application

S-grade

Practice All CDL Questions

Access 84 questions with complete answers and detailed explanations.

View Full CDL Practice Test →

← Back to CDL Study Guide