DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The following is not a data mart feature____
|
|
Only specific on the data according to the subject or originating from the Data Warehouse
|
|
|
Not tied to a dimensional data model
|
|
|
More specific information according to the subject/need
|
|
|
More focused on the Star Schema model
|
Explanation:
Detailed explanation-1: -Three basic types of data marts are dependent, independent, and hybrid.
Detailed explanation-2: -Which of the following is not related to dimension table attributes? Indexed. Explanation : :Equally unavailable is not related to dimension table attributes.
Detailed explanation-3: -Data Mart and Snowflake Schema Dimensions are small tables with vital information. The fact table is where the bulk of the data is stored, maybe billions of records, and can be joined to the customer table to get actual customer name and address fields.
There is 1 question to complete.