DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Highly Denormalized
|
|
|
Highly Normalised
|
|
|
A and B
|
|
|
None of the Above
|
Detailed explanation-1: -Data warehouses often use denormalized or partially denormalized schemas (such as a star schema) to optimize query performance. OLTP systems often use fully normalized schemas to optimize update/insert/delete performance, and to guarantee data consistency.
Detailed explanation-2: -Dependent, Independent, and Hybrid Data Marts Three basic types of data marts are dependent, independent, and hybrid.
Detailed explanation-3: -Data warehouses are relational environments that are used for data analysis, particularly of historical data. Organizations use data warehouses to discover patterns and relationships in their data that develop over time.
Detailed explanation-4: -A data lake contains all an organization’s data in a raw, unstructured form, and can store the data indefinitely-for immediate or future use. A data warehouse contains structured data that has been cleaned and processed, ready for strategic analysis based on predefined business needs.