Data Warehouse vs Data Lake — Learn free

Self-check

Questions 1–10 of 10

1. What is a data warehouse designed to do?
Question 1A. Store raw, unprocessed files of any type at any scaleB. Store and analyse structured data from various sources, providing a central repository for BI and analyticsC. Compress data to reduce cloud storage costsD. Run transactional applications such as order entryE. Replace all other data storage systems in an organisation
2. Which words describe the data typically stored in a data warehouse?
Question 2A. Raw, unprocessed and unstructuredB. Temporary, volatile and uncleansedC. Historical, integrated and cleansedD. Real-time, streaming and unformattedE. Encrypted, compressed and archived
3. How is data in a data warehouse organised and optimised?
Question 3A. Kept in its natural raw form for flexibilityB. Structured into tables and optimised for efficient querying and analysisC. Stored as images and text documentsD. Held only in memory for speedE. Scattered across spreadsheets
4. What is a data lake?
Question 4A. A centralised repository that stores all structured, semi-structured and unstructured data at any scaleB. A repository limited to cleansed, structured tablesC. A backup copy of a data warehouseD. A visualisation tool for executive dashboardsE. A transactional database for daily operations
5. Why was the term 'data lake' coined?
Question 5A. Because the data is stored in cold, offline storageB. Because data is always deleted after a set periodC. Because only water-industry companies used it at firstD. To represent a system where data flows in from various sources and resides in its most natural state, like water in a lakeE. Because the data is organised in layers like sediment
6. What primary characteristic sets data lakes apart from data warehouses?
Question 6A. Data lakes only store historical dataB. Data lakes require data to be cleansed before storageC. The flexibility and scale they offer, storing data in its original or raw format without first structuring itD. Data lakes are optimised for structured table queries onlyE. Data lakes cannot store structured data
7. Which of the following can a data lake handle, according to its description?
Question 7A. Only structured databasesB. Only images and text documentsC. Only social media postsD. Only cleansed tabular dataE. High volumes of diverse data, from structured databases to unstructured social media posts, images or text documents
8. An organisation stores raw sensor readings, customer photos and text documents in one repository without structuring them first, and later processes some of them into structured records. Which system does this describe?
Question 8A. A data lakeB. A data warehouseC. A spreadsheetD. A CRM systemE. A relational table
9. What is the relationship between data lakes and data warehouses in an organisation's architecture?
Question 9A. They are mutually exclusive; an organisation must choose oneB. A data lake always replaces a data warehouseC. A data warehouse always replaces a data lakeD. They are not mutually exclusive and often coexist, each serving different use casesE. They are the same system under two names
10. Which of the following is NOT a characteristic of a data warehouse?
Question 10A. Provides a central repository for BI and analytics applicationsB. Stores data that is typically historical and cleansedC. Stores data in its raw, natural state without structuring itD. Organises data into tables optimised for queryingE. Supports decision-making, reporting and analysis