Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual C# .NET

Authors: Ying Bai

1st Edition

0470467274, 978-0470467275

More Books

Students also viewed these Databases questions

Question

Complete this statement to increment y: y = _ _ _ _ _

Answered: 1 week ago

Question

=+ Should the MNE belong (why, why not)?

Answered: 1 week ago

Question

=+ What is the role of government in bargaining?

Answered: 1 week ago