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 |
NoneofAbove
|
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 |
NoneofAbove
|
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 |
| Customizingthedata |
Noneofthese
|
7. Drill Across generally use the following join to generate report: |
| Self Join |
| Inner Join |
| Outter Join |
Noneofthese
|
8. In general data in Data Warehousing is : |
| Normalized |
| Denormalized |
| Cusomized |
Noneofabove
|
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 |
| NormalizedData |
Noneofabove
|
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 |
1,2,3arecorrect
|
15. You need to create an index on the SALES table, which is 10 GB in size. You want your index to be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability. |
| bitmap |
| unique |
| partitioned |
reverse Key
|
16. Which type of table is usually created to enable the building of scalable applications, and is useful for large tables that can be queried or manipulated using several processes concurrently? |
| Regular table |
| clustered table |
| partitioned table |
ndex-organized table
|
17. You need to enforce these two business rules: |
| Check |
| Unique |
| Not null |
Primary Key
|
18. In which type of SCD(Slowly changing dimensions) do we preserve history of data: |
| Type One |
| Type Two |
| Type Three |
None of above
|
19. Consolidated data mart is: |
| First level data mart |
| Second level data mart |
| All of these |
None of above
|
20. 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
|
