1. In Star Schema Dimension tables are: |
| Short and Fat |
| Long and Thin |
| Long and Fat |
Short and thin
|
2. The data in Data Warehouse is generally |
| Clean Data |
| Dirty Data |
| Clean and Dirty Data |
None of above
|
3. In which type of SCD(Slowly changing dimensions) do we preserve history of data: |
| Type One |
| Type Two |
| Type Three |
None of above
|
4. During ETL load we generally have |
| Unsorted data for Aggregator |
| Sorted data for Aggregator |
| Does not matter if we use Sorted or Unsorted data for Aggregation |
|
5. Sequence of jobs to load data in to warehouse |
| First load data into fact tables then dimension tables, then Aggregates if any |
| First load data into dimension tables, then fact tables, then Aggregates if any |
| First Aggregates then load data into dimension tables, then fact tables |
Does not matter if we load either of fact, dimensions, or aggregates
|
6. Snowflaking means |
| Normalizing the data |
| Denormalizing the data |
| None of Above |
|
7. Drill Across generally use the following join to generate report: |
| Self Join |
| Inner Join |
| Outter Join |
|
8. In general data in Data Warehousing is : |
| Normalized |
| Denormalized |
| none |
All of the above
|
9. Consolidated data mart is: |
| First level data mart |
| Second level data mart |
| All of these |
None of Above
|
10. In datamarts stovepipe means: |
| Similar Data |
| Isolated data |
| None of Above |
|
11. In 4 step dimensional process, declaring grain of business process is: |
| First Step |
| Second Step |
| Third Step |
Fourth Step
|
12. Centipede fact table means: |
| Fact table with no dimensions |
| Factless fact table |
| Fact table with two or three dimensions |
Fact table with to many dimensions
|
13. Dimensions are Confirmed when: |
| They are different |
| They are either same or one is subset of another |
| When they can be compared mathematically |
None of these
|
14. Degenerate Dimensions(DD) |
| Transaction Number, bill of lading number, invoice number may be DD. |
| DD has no attributes |
| DD does not join to actual dimension table |
A, B, C are correct.
|
15. Consolidated data mart is: |
| Second level data mart |
| First level data mart |
| All of these |
None of above
|
16. In datamarts stovepipe means: |
| Similar Data |
| Isolated data |
| Similar Data |
None of Above
|
17. The data in Data Warehouse is generally: |
| Clean Data |
| Dirty Data |
| Clean and Dirty Data |
None of above
|
18. The ROI or value proposition for developing and delivering a data warehouse has no influence on the project direction. |
| True |
| False |
|
|
19. When gathering business information requirements, you should focus only on the requirements provided by the business groups. |
| True |
| False |
|
|
20. Support and commitment from both management and business units are important to the success of the data warehouse project. |
| True |
| False |
|
|
