DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Number of columns is high, number of rows is high
|
|
|
Number of columns is high, number of rows is low
|
|
|
Number of columns is low, number of rows is high
|
|
|
Number of columns is low, number of rows is low
|
Detailed explanation-1: -There are two key columns in a fact table. The first column consists of foreign keys that will help connect the data with the dimension-type table, while the second column consists of descriptive attributes and the data to be analyzed.
Detailed explanation-2: -Fact tables are deep whereas dimension tables are wide as fact tables will have a higher number of rows and a lesser number of columns.
Detailed explanation-3: -A fact table is the central table in a star schema of a data warehouse. A fact table stores quantitative information for analysis and is often denormalized. A fact table works with dimension tables.
Detailed explanation-4: -A fact table is defined by its grain or most atomic level, whereas a Dimension table should be wordy, descriptive, complete, and of assured quality. The fact table helps to store report labels, whereas Dimension table contains detailed data.