B6

Question 1

What is a data lake?

Answer 1

Contains data that is structured and unstructured mostly being in its raw form.

Question 2

What is a data warehouse?

Answer 2

A very large data repository that is centralized and used for reporting and analysis rather than for transactional purposes. A data warehouse pulls data either directly from enterprise systems with transactional data or from an ODS.

Question 3

What is an operational data store?

Answer 3

a repository of transactional data from multiple sources and is often an interim area between a data source and data warehouses.

Question 4

What is a data mart?

Answer 4

focused on a specific purpose, such as marketing or logistics, then a data warehouse. A data mart is often a subset of a data warehouse.

Question 5

What are the steps to reduce data redundancy?

Answer 5

1. Normalizing data: All data has one peace of information (One Valuu Per Columb) and every record in every tale has a unique identifier.
2. Conform the data: Requires all non key attributes to depend on the entire primary key.
3. Ascertain: When you check to make sure that there are no non-key attributes depending on other non-key attribute.