DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is a Star Schema?
|
|
A star schema consists of a fact table with a single table for each dimension
|
|
|
A star schema is a type of database system
|
|
|
A star schema is used when exporting data from the database
|
|
|
None of these
|
Explanation:
Detailed explanation-1: -A star schema consists of one fact table, and one or more dimension tables. The fact table contains information about changes. In the most basic kind of fact table, each row represents a transaction.
Detailed explanation-2: -What is a star schema? A star schema is a multi-dimensional data model used to organize data in a database so that it is easy to understand and analyze. Star schemas can be applied to data warehouses, databases, data marts, and other tools. The star schema design is optimized for querying large data sets.
Detailed explanation-3: -Answer» A. a star schema consists of a fact table with a single table for each dimension. View all MCQs in: Data Mining and Data Warehouse.
There is 1 question to complete.