Mis430 Data Warehousing Final

52 Questions | Total Attempts: 248

Mis430 Data Warehousing Final - Quiz

MIS 430 FINAL data warehousing at gmu university

Questions and Answers
  • 1. 
    ---------------- schema is a normalized version of the STAR schema in which dimension tables are partially or fully normalized. Not generally recommended because it compromises query performance and simplicity for understanding.
  • 2. 
    ------------------- schema is the arrangement of the collection of fact and dimension tables in the dimensional data model , resembling a star formation, with the fact table placed in the middle surrounded by the dimension tables. Each dimension table is in a one to many relationship with the fact table.
  • 3. 
    ----------------- normal form, data is atomic, no repeating groups, primary key.
  • 4. 
    -------------------- normal form, relates to rows in a table, no duplicate data in rows, duplicate data moved to another table, every attribute depends on the entire key.
  • 5. 
    ---------------------- normal form, relates to relationships between tables, no transitive dependency, every attribute depends on the primary key.
  • 6. 
    ------------------- looks like a table, acts like a table, not a table.-Restores intrusiveness to a database-Eases user querying-Data Security    abstracts the database implementation    allows for database changes behind the scenes as well    limit access to sensitive information
  • 7. 
    --------------- indexes, the order in which the data is physically stored.
  • 8. 
    -------------- indexes, internal table that points to actual data locations.
  • 9. 
    Database ------------- reduces data duplication, increases data integrity.
  • 10. 
    ---------------- break all composite attributes into single attributes, data is not duplicated in columns.
  • 11. 
    --------------------- attributes, not allowed in a normalized database, use another table.
  • 12. 
    --------------- attributes, not stored in the relational tables.
  • 13. 
    These characteristics describe ---------------- of a data warehouse?- 1. Source data ( comes from transactional databases or data mart)- 2. Data staging ( data gets filtered and cleaned)- 3. Data storage ( data gets stored)- 4. Information delivery (how users get the data ex report, query)
  • 14. 
    These characteristics describe -------------- of a data warehouse?- Tables are normalized- Consists of Fact and Dimension tables.- Information is read only
  • 15. 
    These characteristics describe -------------- tables?- A table in data ware house were measures are placed- Aggregation happens in this table- Many records in this table.- Numeric data
  • 16. 
    These characteristics describe -------------- tables?-These tables ask a question-Used to slice and dice the data- If numeric data use as a buffer- Has more columns or fields
  • 17. 
    ------------------ databases are normalized, they rely on referential integrity, relationships are important, use primary and foreign keys to relate to each other.
  • 18. 
    Type ------- dimension you simply change errors no history is maintained. Ex. Customer Key     FName     LName        Location          Gender        101                   john          smith        Washington          male--he moved from Washington to ChicagoFix  Customer Key    FName      LName        Location          Gender         101                  john           smith        Chicago               male
  • 19. 
    Type ----------- dimension, true changes in the source system, history must be preserved, partitions the history in the data warehouse, every change for the same attribute must be preserved. Ex. Customer Key      Fname         Lname       Location           Gender        101                       john          smith          washington        male         102                      john          smith           chicago             male
  • 20. 
    Type ------------------ dimension, tentative changes in the source system, need to keep old and new value, ability to track forward and backward.Ex. Customer Key      Fname       Lname        Location        Gender        101                    john           smith           washington    male        Customer Key    Fname       Lname        O location         N location      Gender        101                    john            smith          washington      chicago          male
  • 21. 
    These characteristics describe --------------------?- Family of STARS-Must have conformed dimensions-Must share 2 dimensions-Conformed fact tables -Snow flaking ( used to relate fact tables with different granularity)
  • 22. 
    ------------------ dimensions at least two fact tables share two dimensions.Power behind the data warehouse- Adding facts-Adding dimensions-Adding measures -Adding dimension attributes
  • 23. 
    ---------------- is filtering data in a cube?
  • 24. 
    ------------ looking at data in a different way, not data change just change, way rows in a column looks.
  • 25. 
    -----------------  to finer level of detail.
Back to Top Back to top

Here's an interesting quiz for you.

We have other quizzes matching your interest.