database-data-warehousing Related Question Answers

1. A snowflake schema is which of the following types of tables?





2. The generic two-level data warehouse architecture includes which of the following?





3. Fact tables are which of the following?





4. Data transformation includes which of the following?





5. Reconciled data is which of the following?





6. The load and index is which of the following?





7. The extract process is which of the following?





8. A star schema has what type of relationship between a dimension and fact table?





9. Transient data is which of the following?





10. A multifield transformation does which of the following?





11. A data mart is designed to optimize the performance for well-defined and predicable uses.



12. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.



13. Data in operational systems are typically fragmented and inconsistent.



14. Most operational systems are based on the use of transient data.



15. Independent data marts are often created because an organization focuses on a series of short-term business objectives.



16. Joining is the process of partitioning data according to predefined criteria.



17. The role of the ETL process is to identify erroneous data and to fix them.



18. Data in the data warehouse are loaded and refreshed from operational systems.



19. Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.



20. Periodic data are data that are physically altered once added to the store.



21. Both status data and event data can be stored in a database.



22. Static extract is used for ongoing warehouse maintenance.



23. Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.



24. Every key used to join the fact table with a dimensional table should be a surrogate key.



25. Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.



Terms And Service:We do not guarantee the accuracy of available data ..We Provide Information On Public Data.. Please consult an expert before using this data for commercial or personal use | Powered By:Omega Web Solutions
© 2002-2017 Omega Education PVT LTD...Privacy | Terms And Conditions
Question ANSWER With Solution