Business Warehousing MCQs
Business Warehousing MCQs
Answer these Business Warehousing MCQs and assess your grip on the subject of Business Warehousing.
Scroll below and get started!
1: In general data in Data Warehousing is:
A. Normalized
B. None of Above
C. Denormalized
D. Cusomized
2: In which type of SCD(Slowly changing dimensions) do we preserve history of data:
A. Type Three
B. None of these
C. Type Two
D. Type One
3: In datamarts stovepipe means:
A. Similar Data
B. None of these
C. Isolated data
D. Normalized Data
4: In 4 step dimensional process, declaring grain of business process is:
A. Second Step
B. Fourth Step
C. First Step
D. Third Step
5: Dimensions are Confirmed when:
A. They are different
B. When they can be compared mathematically
C. They are either same or one is subset of another
D. None of these
6: Centipede fact table means:
A. Fact table with no dimensions
B. Factless fact table
C. Fact table with to many dimensions
D. Fact table with two or three dimensions
7: In Star Schema Dimension tables are:
A. Long and Fat
B. Short and Fat
C. Short and thin
D. Long and Thin
8: 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?
A. Partitioned table
B. Clustered table
C. Ndex-organized table
D. Regular table
9: 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.
A. Bitmap
B. Reverse Key
C. Partitioned
D. UNIQUE
10: During ETL load we generally have
A. Unsorted data for Aggregator
B. Does not matter if we use Sorted or Unsorted data for Aggregation
C. None of these
D. Sorted data for Aggregator
11: Warehousing and ____ are substitutes for each other.
A. Transportation
B. Materials handling
C. Packaging
D. Inventory management
E. None of the above
List of Business Warehousing M...
Available in:
Business Warehousing MCQs
