Scribd Logo
Upload

Welcome to Scribd!

  • 741 views

    Quiz 1 DW II SEM 09022017 Ver 3

    Uploaded by

    Smita Srivastava
    This document contains a 15 question quiz about data warehousing concepts. The questions cover topics like the number of star schemas a data warehouse can have, dimensions in a data mart, dimensional modeling, granularity, types of facts, synchronous systems, commonalities between Inmon and Kimball approaches, surrogate keys, operational data stores, types of queries, and characteristics of an operational data store.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Quiz 1 DW II SEM 09022017 Ver 3

    Uploaded by

    Smita Srivastava
    741 views3 pages
    This document contains a 15 question quiz about data warehousing concepts. The questions cover topics like the number of star schemas a data warehouse can have, dimensions in a data mart, dimensional modeling, granularity, types of facts, synchronous systems, commonalities between Inmon and Kimball approaches, surrogate keys, operational data stores, types of queries, and characteristics of an operational data store.

    Original Description:

    Some questions for Data Warehousing

    Original Title

    Quiz 1 DW II SEM 09022017 Ver 3.Docx

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a 15 question quiz about data warehousing concepts. The questions cover topics like the number of star schemas a data warehouse can have, dimensions in a data mart, dimensional modeling, granularity, types of facts, synchronous systems, commonalities between Inmon and Kimball approaches, surrogate keys, operational data stores, types of queries, and characteristics of an operational data store.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    741 views3 pages

    Quiz 1 DW II SEM 09022017 Ver 3

    Uploaded by

    Smita Srivastava
    This document contains a 15 question quiz about data warehousing concepts. The questions cover topics like the number of star schemas a data warehouse can have, dimensions in a data mart, dimensional modeling, granularity, types of facts, synchronous systems, commonalities between Inmon and Kimball approaches, surrogate keys, operational data stores, types of queries, and characteristics of an operational data store.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3
    At a glance
    Powered by AI
    The document discusses different concepts related to data warehousing including dimensional modeling, ETL processes, granularity, surrogate keys, and the differences between Inmon and Kimball approaches. Some key dimensions mentioned are time, product, promotion, and store for a grocery warehouse.

    The document mentions daily, performance, registration, and attendance as different levels of granularity that can be captured. Finer and coarser granularities are also referenced in comparison to an OLTP system.

    Examples given of a semi-additive fact are sales units and of a fully additive fact are sales revenue. Transaction count and account balance are also listed as examples.

    Quiz 1 (DW)

    1. How many star schemas a data warehouse of an organization can have:

    Select one:
    a. 1
    b. not fixed
    c. 3
    d. 5

    2. In a grocery store sales data mart, the promotion dimension has:

    Select one:
    a. One record for each combination of promotions
    b. As many records as there are individual promotions
    c. Significantly large number of records than the product dimension
    d. As many records for individual promotions as many times they were
    in effect

    3. In dimensional modeling:

    Select one:
    a. No dimension table is normalized
    b. All dimension tables must be normalized
    c. Some dimension tables can be normalized
    d. Fact tables can be normalized

    4. Largest dimension in a grocery store sales data mart (assume daily


    granularity):

    Select one:
    a. Store Dimension
    b. Promotion dimension
    c. Product Dimension
    d. Time Dimension

    5. In a university data warehouse, which processes have the same


    granularity:

    Select one:
    a. Performance & Registration
    b. Attendance, Performance, & Registration have the same
    granularity
    c. Attendance & Registration
    d. Attendance & Performance

    6. Example of a semi-additive and a fully-additive fact:

    Select one:
    a. Account_balance, Sales_units
    b. Transaction_count, Account_balance
    c. Sales_revenue, Sales_units
    d. Amount_withdrawn, Amount_deposited

    7. Which system is synchronous with the OLTP system:

    Select one:
    a. Data Mart
    b. Data Warehouse
    c. Operational Data Store
    d. Super Mart

    8. Commonality between Inmon's & Kimball's approach:

    Select one:
    a. Data warehouse is modelled using Dimensional Modeling
    b. Data Marts are modelled using Dimensional Modeling
    c. Data Warehouse is modelled using ER modeling
    d. Dimension Tables are normalized to 3NF

    9. The load on ETL system is lowest when the DW is at:

    Select one:
    a. The same granularity level as the OLTP system
    b. Choice of granularity has no impact on ETL
    c. Finer granularity than that of OLTP system
    d. Coarser granularity than that of OLTP system

    10. False statement about surrogate keys:

    Select one:
    a. In fact table, surrogate keys help in saving space
    b. In look-up tables tables, there is always a 1:1 mapping between
    surrogate keys and natural keys
    c. In dimension tables, there is a M:1 mapping between surrogate keys
    and natural keys
    d. Surrogagte keys are generated in OLTP systems

    11. Which class ODS contains enriched data:

    Select one:
    a. Class III ODS
    b. Class II ODS
    c. Class IV ODS
    d. Class I ODS

    12. Which approach to Data Warehousing is more popular:

    Select one:
    a. Neither Inmon's approach nor Kimball's
    b. Hybrid approach by Kimball
    c. Purely Top-down approach by Inmon
    d. Bottom-up approach
    13. Most common type of queries in a Data Warehouse:

    Select one:
    a. Queries on fact tables only
    b. Outside-in queries
    c. Queries on dimension tables only
    d. Inside-out queries

    14. Granularity of the operational systems is definitely captured in:

    Select one:
    a. Data mart
    b. Operational data store
    c. Super mart
    d. Data warehouse

    15. ODS is NOT:

    Select one:
    a. Current valued
    b. Subject oriented
    c. Non-volatile
    d. Integrated

    You might also like