Deck 8: Data Warehouses,Business Intelligence Systems,and Big Data

Question 1

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

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

Answer 1

E

Question 2

The term for the enormous datasets generated by Web 2.0 applications is ________.

Answer 2

Big Data

Question 3

In the MapReduce process,the first step is the ________ step.

A) column
B) super column
C) column family
D) map
E) reduce

Answer 3

D

Question 4

Non-relational DBMSs associated with the NoSQL movement include all of the following except ________.

A) Key-value
B) Document
C) Column family
D) Graph
E) Hierarchical

Question 5

Column family databases are indistinguishable from relational database tables.

Question 6

Apache Cassandra is an example of a(n)________ non-relational DBMS.

A) Key-value
B) Document
C) Column family
D) Graph
E) Object-Oriented

Question 7

Business Intelligence (BI)reporting systems are used to filter data,sort data,group data and make simple calculations based on the data.

Question 8

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

A) Analyze current and past activities
B) Predict future events
C) Record and process transactions
D) Both A and B
E) Support routine operational activities

Question 9

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

A) Filter data
B) Group data
C) Modify data
D) Both A and B
E) Secure data

Question 10

Apache Cassandra is an example of a column family database.

Question 11

NoSQL really stands for "Not only SQL."

Question 12

Business Intelligence (BI)systems support operational activities.

Question 13

Apache Cassandra is an example of a(n)________ non-relational DBMS.

Question 14

Business Intelligence (BI)systems obtain data from three possible sources.

Question 15

Business Intelligence (BI)systems are information systems that help users analyze and use data.

Question 16

Hadoop is a(n)________.

Question 17

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

Question 18

BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

Question 19

Hadoop is a(n)________.

A) RDMBS
B) OODBMS
C) distributed file system (DFS)
D) print system
E) Web server

Question 20

In the MapReduce process,the Reduce step is followed by the Map step.

Question 21

Distributed databases can be distributed by partitioning and ________.

Question 22

Why is operational data sometimes unusable for Business Intelligence use?

Question 23

Business Intelligence (BI)________ uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

Question 24

What are Business Intelligence (BI)systems?

Question 25

When distributed databases create copies of the database on different servers,this is known as ________.

A) replication
B) partitioning
C) disbursing
D) distributed two-phase locking
E) division

Question 26

What is a reporting system?

Question 27

Data Mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

Question 28

Report delivery is more important for data mining than it is for reporting systems.

Question 29

When distributed databases break the database into sections and store the sections on different servers,this is known as ________.

A) replication
B) partitioning
C) disbursing
D) distributed two-phase locking
E) None of the above

Question 30

Business Intelligence (BI)________ are used to filter data,sort data,group data and make simple calculations based on the data.

Question 31

The simplest way to lease cloud services is SaaS.

Question 32

Business Intelligence (BI)systems obtain data in ________ different ways.

Question 33

Data mining applications are used to accomplish all of the following tasks except ________.

A) classify entities
B) make predictions
C) facilitate decision making
D) incorporate results into some other report/system
E) perform what-if analysis

Question 34

A Business Intelligence (BI)reporting system that uses extensions to SQL is ________.

A) cluster analysis
B) OLAP
C) regression analysis
D) RFM analysis
E) PHP

Question 35

Business Intelligence (BI)systems fall into two broad categories: ________ and ________.

Question 36

Which of the following is true about data mining applications?

A) They use sophisticated mathematical techniques.
B) They use sophisticated statistical techniques.
C) Their report delivery is more difficult than report delivery for reporting systems.
D) Both A and B
E) All data mining applications have many different users to support.

Question 37

Objects have ________,which are computer programs that perform some task.

Question 38

Big Data is the name given to the enormous datasets generated by Web 2.0 applications.

Question 39

Problematic data include so-called "dirty data."

Question 40

A(n)________ is an information system that helps users analyze and use data.

Question 41

What is a data warehouse?

Question 42

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

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) data warehouse databases contain unrelated tables

Question 43

Problematic data are called ________.

Question 44

Describe how to create an OLAP report for a Microsoft Access 2016 database in Microsoft Excel 2016.

Question 45

A data mart is a collection of data that addresses a particular component or functional area of a business.

Question 46

A data mart differs from a data warehouse in these ways except ________.

A) it has a smaller database
B) it deals with a particular component or functional area of the business
C) data mart users do not have the data management expertise of data warehouse employees
D) data warehouses receive their data from the data marts
E) data marts receive their data from the data warehouse

Question 47

We have obtained access to the company's operational data.We examine 50 records for customers with phone numbers that should use the current area code of 345.Of these 50 records,we find 10 that still use an older area code of 567.This is an example of ________.

A) dirty data
B) inconsistent data
C) non-integrated data
D) a "wrong format" problem
E) a "too much data" problem

Question 48

What is a distributed database?

Question 49

What is a Microsoft Excel PivotTable?

Question 50

Data warehouses are populated with data prepared by extract,transform,and load (ETL)systems.

Question 51

Operational databases store historical data.

Question 52

Dimensional databases are used for analytical data processing.

Question 53

Operational databases contain a fact table.

Question 54

Dimensional databases use the star schema.

Question 55

A(n)________ is a collection of data that addresses a particular component or functional area of a business.

Question 56

What are objects,and how are they related to the object-oriented DBMS (OODBMS)?

Question 57

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

Question 58

What is a conformed dimension?

Question 59

Which of the following is a reason that operational data are difficult to read?

A) Dirty data
B) Missing values
C) Time-critical data
D) Non-integrated data
E) Inconsistent data

Question 60

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of ________.

A) dirty data
B) inconsistent data
C) non-integrated data
D) a "wrong format" problem
E) a "too much data" problem

Question 61

What is a star schema?

Question 62

Data warehouses use a(n)________.

A) operational database
B) dimensional database
C) structured storage
D) either A or B
E) distributed database

Question 63

Slowly changing dimensions are handled by a(n)________.

A) operational database
B) dimensional database
C) structured storage
D) either A or B
E) distributed database

Question 64

Star schemas have a ________ at the center of the star.

A) fact table
B) dimension table
C) map table
D) reduce table
E) None of the above

Question 65

A variant of the star schema is the ________.

Question 66

What is a slowly changing dimension?

Question 67

Compare the characteristics of an operational database and a dimensional database.

Question 68

Data warehouses are populated with data prepared by ________ programs.

Question 69

The term drill down refers to the capability of seeing the data in smaller and smaller units.

Question 70

Data warehouse data is often stored in a(n)________.

Question 71

A star schema resembles a star,with a dimension table at the center and fact tables radiating out from the center.

Question 72

In the snowflake schema,the ________ tables are normalized.

Question 73

Dimensional databases are used to track historical data and therefore must have a ________.

A) time dimension
B) customer dimension
C) sales dimension
D) either A or B
E) both A and B

Question 74

To deal with historical data values,dimensional databases use a(n)________.

Question 75

A dimensional database uses a(n)________.

Question 76

In a snowflake schema,each dimension table is normalized.

Question 77

OLAP provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

Question 78

Snowflake schemas have normalized ________.

A) fact tables
B) dimension tables
C) map tables
D) reduce tables
E) None of the above

Question 79

To create an OLAP report for an Access 2016 database,use the PivotTable tool in Access 2016.

Question 80

To deal with data values that change over time,dimensional databases use a(n)________.