Question 1

Refer to the table above.What is the lift for Drug B being purchased given that Drug A has been purchased?

Accepted Answer

A)  .200 
B)  .250 
C)  .333 
D)  .500 
E)  .667 
A)  .200 
B)  .250 
C)  .333 
D)  .500 
E)  .667

Question 2

The combination of a data mart structure with a data warehouse architecture is known as an ________ data warehouse.

Accepted Answer

A)  enterprise 
B)  entrepreneurial 
C)  encompassing 
D)  eclectic 
E)  integrated 
A)  enterprise 
B)  entrepreneurial 
C)  encompassing 
D)  eclectic 
E)  integrated

Question 3

Reports that rely on the most current data when they are prepared are called ________ reports.

Accepted Answer

The answer of Reports that rely on the most current...

Question 4

What is data mining application?

Accepted Answer

A data mining application uses sophistic

Question 5

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

Accepted Answer

A) True 
 B)False

Question 6

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Accepted Answer

A) True 
 B)False

Question 7

The metadata maintained by a reporting system database describes all of the following except ________.

Accepted Answer

A)  reports 
B)  users 
C)  database relations 
D)  roles 
E)  groups 
A)  reports 
B)  users 
C)  database relations 
D)  roles 
E)  groups

Question 8

Most data mining techniques are simple and easy to use.

Accepted Answer

A) True 
 B)False

Question 9

Business Intelligence (BI)reporting systems can do which of the following operations?

Accepted Answer

A)  Filter data 
B)  Group data 
C)  Modify data 
D)  Both A and B 
E)  All of the above 
A)  Filter data 
B)  Group data 
C)  Modify data 
D)  Both A and B 
E)  All of the above

Question 10

What are Business Intelligence (BI)systems?

Accepted Answer

Business Intelligence (BI)systems are in

Question 11

The "R" in RFM analysis stands for ________.

Accepted Answer

A)  rank 
B)  recent 
C)  relationship 
D)  readiness 
E)  random 
A)  rank 
B)  recent 
C)  relationship 
D)  readiness 
E)  random

Question 12

Which of the following is a common unsupervised data mining technique?

Accepted Answer

A)  Cluster analysis 
B)  Regression analysis 
C)  RFM analysis 
D)  Both A and B 
E)  Neural Networks 
A)  Cluster analysis 
B)  Regression analysis 
C)  RFM analysis 
D)  Both A and B 
E)  Neural Networks

Question 13

In market basket analysis,support is defined as the probability that two items will be purchased together.

Accepted Answer

A) True 
 B)False

Question 14

Why is operational data sometimes unusable for Business Intelligence purposes?

Accepted Answer

Data in operational databases can suffer

Question 15

A data warehouse database differs from an operational database because ________.

Accepted Answer

A)  data warehouse data are not stored in tables 
B)  data warehouse databases do not have metadata 
C)  data warehouse data are often stored in a dimensional database 
D)  Both B and C 
E)  None of the above 
A)  data warehouse data are not stored in tables 
B)  data warehouse databases do not have metadata 
C)  data warehouse data are often stored in a dimensional database 
D)  Both B and C 
E)  None of the above

Question 16

Business Intelligence (BI)systems fall into which of the following categories?

Accepted Answer

A)  Processing 
B)  Reporting 
C)  Data mining 
D)  Both A and B 
E)  Both B and C 
A)  Processing 
B)  Reporting 
C)  Data mining 
D)  Both A and B 
E)  Both B and C

Question 17

Problematic data are called ________.

Accepted Answer

dirty data

Question 18

________ is a way of analyzing and ranking customers based on their purchasing patterns.

Accepted Answer

The answer of ________ is a way of analyzing and...

Question 19

An extract,transform,and load (ETL)system obtain data from ________,external data,and other internal data.

Accepted Answer

operationa

Question 20

A data warehouse is a database system that has data and programs for,as well as personnel specialized in,BI processing.

Accepted Answer

A) True 
 B)False

Refer to the table above.What is the lift for Drug B being purchased given that Drug A has been purchased?

The combination of a data mart structure with a data warehouse architecture is known as an ________ data warehouse.

Reports that rely on the most current data when they are prepared are called ________ reports.

What is data mining application?

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

The metadata maintained by a reporting system database describes all of the following except ________.

Most data mining techniques are simple and easy to use.

Business Intelligence (BI)reporting systems can do which of the following operations?

What are Business Intelligence (BI)systems?

The "R" in RFM analysis stands for ________.

Which of the following is a common unsupervised data mining technique?

In market basket analysis,support is defined as the probability that two items will be purchased together.

Why is operational data sometimes unusable for Business Intelligence purposes?

A data warehouse database differs from an operational database because ________.

Business Intelligence (BI)systems fall into which of the following categories?

Problematic data are called ________.

________ is a way of analyzing and ranking customers based on their purchasing patterns.

An extract,transform,and load (ETL)system obtain data from ________,external data,and other internal data.

A data warehouse is a database system that has data and programs for,as well as personnel specialized in,BI processing.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 17: Learn the basic concepts of business intelligence (BI)systems

Refer to the table above.What is the lift for Drug B being purchased given that Drug A has been purchased?

The combination of a data mart structure with a data warehouse architecture is known as an ________ data warehouse.

Reports that rely on the most current data when they are prepared are called ________ reports.

What is data mining application?

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

The metadata maintained by a reporting system database describes all of the following except ________.

Most data mining techniques are simple and easy to use.

Business Intelligence (BI)reporting systems can do which of the following operations?

What are Business Intelligence (BI)systems?

The "R" in RFM analysis stands for ________.

Which of the following is a common unsupervised data mining technique?

In market basket analysis,support is defined as the probability that two items will be purchased together.

Why is operational data sometimes unusable for Business Intelligence purposes?

A data warehouse database differs from an operational database because ________.

Business Intelligence (BI)systems fall into which of the following categories?

Problematic data are called ________.

________ is a way of analyzing and ranking customers based on their purchasing patterns.

An extract,transform,and load (ETL)system obtain data from ________,external data,and other internal data.

A data warehouse is a database system that has data and programs for,as well as personnel specialized in,BI processing.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn about replicated partitioned data stores for supporting clusters

Filters