+1(316)4441378

+44-141-628-6690

Archive for the ‘SQL Database Study’ Category

Data Warehouses and Data Lakes

n this assignment you will grapple with the issue of when to use a data warehouse and when to use a data lake. By doing this assignment you will sharpen your understanding the considerations involved in making these decisions.

Objectives
This assignment supports the following objectives:

Identify the defining characteristics of a data warehouse
Describe the difference between a data warehouse and a data lake
Identify situations in which a data lake should be used over a data warehouse and vice versa.
Details
For each of these scenarios, decide whether you will use a data warehouse or a data lake to store and manage the data. Justify your answer in terms of the variety of data, the volume of the data, and the velocity of the data as well as what sorts of applications need to be supported in these scenarios.

Scenario 1
A car rental company has over 600,000 cars. Each car has about 30 sensors which the car rental company wants to monitor at 15 minute