MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 34 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
An enormous collection of data on various topics from a variety of internal and external sources, compiled by a firm for its own use or for use by its clients, is called : |
| A. | Data-base |
| B. | Data warehouse |
| C. | Data mining |
| D. | M.I.S |
| Answer» C. Data mining | |
| 2. |
An Enterprise Resource Planning application is an example of a(n) ______. |
| A. | Single-user database application |
| B. | Multiuser database application |
| C. | E-commerce database application |
| D. | Data mining database application |
| Answer» C. E-commerce database application | |
| 3. |
_________ is an intermediate storage area used for data processing during the extract, transform and load process of data warehousing . |
| A. | Buffer |
| B. | Virtual memory |
| C. | Staging area |
| D. | inter-storage area |
| Answer» D. inter-storage area | |
| 4. |
Most NoSQL databases support automatic _____ meaning that you get high availability and disaster recovery. |
| A. | Processing |
| B. | Scalability |
| C. | Replication |
| D. | All of the options |
| Answer» D. All of the options | |
| 5. |
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 6. |
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 7. |
Static extract is used for ongoing warehouse maintenance. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 8. |
Every key used to join the fact table with a dimensional table should be a surrogate key. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 9. |
Periodic data are data that are physically altered once added to the store. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 10. |
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 11. |
Data in the data warehouse are loaded and refreshed from operational systems. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 12. |
The role of the ETL process is to identify erroneous data and to fix them. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 13. |
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 | |
| 14. |
Fact tables are which of the following? |
| A. | Completely denoralized |
| B. | Partially denoralized |
| C. | Completely normalized |
| D. | Partially normalized |
| Answer» D. Partially normalized | |
| 15. |
Both status data and event data can be stored in a database. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 16. |
Data in operational systems are typically fragmented and inconsistent. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 17. |
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 | |
| 18. |
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. | |
| 19. |
Joining is the process of partitioning data according to predefined criteria. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 20. |
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. | |
| 21. |
Most operational systems are based on the use of transient data. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 22. |
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. | |
| 23. |
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 24. |
Independent data marts are often created because an organization focuses on a series of short-term business objectives. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 25. |
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 | |
| 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 | |
| 27. |
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. | |
| 28. |
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. | |
| 29. |
The load and index is which of the following? |
| A. | A process to reject data from the data warehouse and to create the necessary indexes |
| B. | A process to load the data in the data warehouse and to create the necessary indexes |
| C. | A process to upgrade the quality of data after it is moved into a data warehouse |
| D. | A process to upgrade the quality of data before it is moved into a data warehouse |
| Answer» C. A process to upgrade the quality of data after it is moved into a data warehouse | |
| 30. |
A data mart is designed to optimize the performance for well-defined and predicable uses. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 31. |
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 | |
| 32. |
The @active 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» E. | |
| 33. |
A snowflake schema is which of the following types of tables? |
| A. | Fact |
| B. | Dimension |
| C. | Helper |
| D. | All of the above |
| Answer» E. | |
| 34. |
Data scrubbing is which of the following? |
| A. | A process to reject data from the data warehouse and to create the necessary indexes |
| B. | A process to load the data in the data warehouse and to create the necessary indexes |
| C. | A process to upgrade the quality of data after it is moved into a data warehouse |
| D. | A process to upgrade the quality of data before it is moved into a data warehouse |
| Answer» E. | |