Question: Scenario: You are a data analyst working for a large e-commerce company that collects and stores vast amounts of data from multiple sources. The company
Scenario: You are a data analyst working for a large e-commerce company that collects and stores vast amounts of data from multiple sources. The company is facing the challenge of managing data collection and storage effectively. The management team is unsure whether to utilize a traditional relational database, a data warehouse, or a data lake for their data storage needs. The company has to store (a) customer information (b) transaction records (c) emails (d) social media data (e) website log files and (f) images of products in inventory. Question: How can you determine the most suitable data storage solution, whether it be a database, data warehouse, data lake, or a combination of multiple solutions for managing data collection and storage with various data structures? (4 points) In your response, you may consider the characteristics, benefits, and/or limitations of each storage option (database, data warehouse, and data lake). You should assess the suitability of each solution based on a variety of data structures (structured, semi-structured, and unstructured data).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
