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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!