11. Which of the following is correct advantage of Update-Driven Approach in Data Warehousing?
- The data can be copied, processed, integrated, annotated, summarized and restructured in the semantic data store in advance
- This approach provides high performance
- Both A and B
- None of the mentioned
Answer : C Explanation: Advantages of Update-Driven Approach in Data Warehousing are: The data can be copied, processed, integrated, annotated, summarized and restructured in the semantic data store in advance, this approach provides high performance.
12. Data transformation includes which of the following
- A process to change data from a summary level to a detailed level
- A process to change data from a detailed level to a summary level
- Separating data from one source into various sources of data
- Joining data from one source into various sources of data
Answer : B Explanation: Data transformation includes a process to change data from a detailed level to a summary level.
13. A goal of data mining includes which of the following
- To confirm that data exists
- To analyze data for expected relationships
- To create a new data warehouse
- To explain some observed event or condition
Answer : D Explanation: A goal of data mining includes “To explain some observed event or condition”.
14. The data is stored, retrieved and updated in ________
- SMTP
- FTP
- OLTP
- OLAP
Answer : C Explanation: The data is stored, retrieved and updated in OLTP. So, option C is correct.
15. Which of the following is not involved in data mining?
- Contains numerous naming conventions and formats
- Organized around important subject areas
- Can be updated by end users
- Contains only current data
Answer : A Explanation: Data transformation is not involved in data mining. So, option A is correct.
Computer Graphics MCQ Questions And Answers
16. A data warehouse is which of the following?
- Contains only current data
- Organized around important subject areas
- Contains numerous naming conventions and formats
- Can be updated by end users
Answer : B Explanation: A data warehouse is: Organized around important subject areas.
17. Which of the following is not a kind of data warehouse application?
- Information processing
- Analytical processing
- Transaction processing
- Data mining
Answer : D Explanation: Transaction processing is not a kind of data warehouse application.
18. Business Intelligence and data warehousing is used for ________
- Analysis of large volumes of product sales data
- Forecasting
- Data mining
- All of the mentioned
Answer : D Explanation: Business Intelligence and data warehousing is used for: Analysis of large volumes of product sales data, Forecasting, Data mining, etc. So, option D is correct.
19. The @active data warehouse architecture includes which of the following
- Data that can extracted from numerous internal and external sources
- At least one data mart
- Near real-time updates
- All of the above
Answer : A Explanation: The @active data warehouse architecture includes: Data that can extracted from numerous internal and external sources, At least one data mart, Near real-time updates. So, All of the above is correct.
20. ________ is the heart of the warehouse.
- Datamart database servers
- Data warehouse database servers
- Relational data base servers
- All of the mentioned
Answer : B Explanation: Data warehouse database servers are the heart of the warehouse.
