MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 26 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 2. |
Periodic data are data that are physically altered once added to the store.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 3. |
Independent data marts are often created because an organization focuses on a series of short-term business objectives.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
Every key used to join the fact table with a dimensional table should be a surrogate key.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 6. |
Most operational systems are based on the use of transient data.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
Data in the data warehouse are loaded and refreshed from operational systems.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 9. |
Data in operational systems are typically fragmented and inconsistent.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
Static extract is used for ongoing warehouse maintenance.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 11. |
The role of the ETL process is to identify erroneous data and to fix them.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 12. |
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 13. |
Both status data and event data can be stored in a database.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 14. |
Joining is the process of partitioning data according to predefined criteria.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 15. |
A data mart is designed to optimize the performance for well-defined and predicable uses.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 16. |
*$_A multifield transformation does which of the following?? |
| A. | Converts data from one field into multiple fields |
| B. | Converts data from multiple fields into one field |
| C. | Converts data from multiple fields into multiple fields |
| D. | All of the above |
| Answer» E. | |
| 17. |
*$_Reconciled data is which of the following?? |
| A. | Data stored in the various operational systems throughout the organization. |
| B. | Current data intended to be the single source for all decision support systems. |
| C. | Data stored in one operational system in the organization. |
| D. | Data that has been selected and formatted for end-user support applications. |
| Answer» C. Data stored in one operational system in the organization. | |
| 18. |
*/*_A data warehouse is which of the following?? |
| A. | Can be updated by end users. |
| B. | Contains numerous naming conventions and formats. |
| C. | Organized around important subject areas. |
| D. | Contains only current data. |
| Answer» D. Contains only current data. | |
| 19. |
_ Transient data is which of the following?$? |
| A. | Data in which changes to existing records cause the previous version of the records to be eliminated |
| B. | Data in which changes to existing records do not cause the previous version of the records to be eliminated |
| C. | Data that are never altered or deleted once they have been added |
| D. | Data that are never deleted once they have been added |
| Answer» B. Data in which changes to existing records do not cause the previous version of the records to be eliminated | |
| 20. |
_ Data transformation includes which of the following?$? |
| A. | A process to change data from a detailed level to a summary level |
| B. | A process to change data from a summary level to a detailed level |
| C. | Joining data from one source into various sources of data |
| D. | Separating data from one source into various sources of data |
| Answer» B. A process to change data from a summary level to a detailed level | |
| 21. |
_ An operational system is which of the following?$? |
| A. | A system that is used to run the business in real time and is based on historical data. |
| B. | A system that is used to run the business in real time and is based on current data. |
| C. | A system that is used to support decision making and is based on current data. |
| D. | A system that is used to support decision making and is based on historical data. |
| Answer» C. A system that is used to support decision making and is based on current data. | |
| 22. |
_A star schema has what type of relationship between a dimension and fact table?$? |
| A. | Many-to-many |
| B. | One-to-one |
| C. | One-to-many |
| D. | All of the above |
| Answer» D. All of the above | |
| 23. |
_Fact tables are which of the following?$? |
| A. | Completely denoralized |
| B. | Partially denoralized |
| C. | Completely normalized |
| D. | Partially normalized |
| Answer» D. Partially normalized | |
| 24. |
A goal of data mining includes which of the following?$? |
| A. | To explain some observed event or condition |
| B. | To confirm that data exists |
| C. | To analyze data for expected relationships |
| D. | To create a new data warehouse |
| Answer» B. To confirm that data exists | |
| 25. |
The extract process is which of the following?? |
| A. | Capturing all of the data contained in various operational systems |
| B. | Capturing a subset of the data contained in various operational systems |
| C. | Capturing all of the data contained in various decision support systems |
| D. | Capturing a subset of the data contained in various decision support systems |
| Answer» C. Capturing all of the data contained in various decision support systems | |
| 26. |
The generic two-level data warehouse architecture includes which of the following?? |
| A. | At least one data mart |
| B. | Data that can extracted from numerous internal and external sources |
| C. | Near real-time updates |
| D. | All of the above |
| Answer» C. Near real-time updates | |