Question
Which of the following is true about the difference between OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing)? A. OLTP databases are typically denormalized
Which of the following is true about the difference between OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing)?
A. | OLTP databases are typically denormalized with fewer tables, but OLAP databases are highly normalized with many tables. | |
B. | OLAP reveals a snapshot of ongoing business process, but OLTP uses multi-dimensional views of various kinds of business activities. | |
C. | The purpose of OLTP is to control and run fundamental business tasks, but OLAP is to help with planning, problem solving, and decision support. | |
D. | OLAP is the original source of the data, but OLTP data comes from the various OLAP databases. |
Most data mining techniques have existed for decades, but it has been increasingly used since 1990s. Which of the following is the reason? (Choose all the apply).
A. | Data are being produced and warehoused. | |
B. | Computing power is more affordable. | |
C. | Competitive pressures are enormous. | |
D. | Both commercial and open-source data mining software is available |
Which of the following is true of data preparation and integration?
A. | In order to reduce the potential influence of information silos, data must be stored in multiple databases separately. | |
B. | In order to increase decision efficiency and data security, data must be isolated in separate information systems. | |
C. | Vertical data integration enriches existing information while horizontal data integration merges tables that hold the same information. | |
D. | Compared with data analysis, the entire process of data collection, preparation, and integration consumes a much larger amount of time. |
Which of the following statements about Naive Bayes is wrong?
A. | Attributes are statistically dependent of one another given the class value. | |
B. | Attributes can be nominal or numeric. | |
C. | Attributes are equally important. | |
D. | Adding too many redundant attributes will cause problems. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started