Deck 14: Big Data, Data-Warehouses, and Business Intelligence Systems

Question 1

Operational databases store historical data.

Answer 1

False

Question 2

Data warehouses also store the data warehouse metadata.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

Problematic data are called dirty data.

Question 5

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

Question 6

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

Question 7

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

Question 8

Dimensional databases are used for analytical data processing.

Question 9

Data warehouses often include data purchased from outside vendors.

Question 10

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

Question 11

A data warehouse is a database system that has data,programs,and personnel specialized in Business Intelligence (BI)processing.

Question 12

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

Question 13

Data warehouses are populated with data prepared by data extraction,transformation,and load (ETL)programs.

Question 14

Business Intelligence (BI)systems support operational activities.

Question 15

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

Question 16

Dimensional databases use the star schema.

Question 17

Data warehouse data are frequently denormalized.

Question 18

Business Intelligence (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

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

Question 20

Metadata about the data's source,format,assumptions,and constraints are kept in a data warehouse metadata database.

Question 21

In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" or "bad."

Question 22

An OLAP cube is limited to three axes.

Question 23

In RFM analysis,R stands for "how recently."

Question 24

Microsoft Excel 2013 allows us to connect directly to an SQL Server 2014 database when building a PivotTable.

Question 25

Operational databases contain a fact table.

Question 26

In a snowflake table,each dimension table is normalized.

Question 27

In RFM analysis,M stands for "how much money."

Question 28

In a common form of RFM analysis,customers are sorted into five groups and given an associated score depending on their group.

Question 29

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

Question 30

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

Question 31

RFM analysis is a way of analyzing and ranking customers based on online survey data.

Question 32

Although Microsoft Excel 2013 will create a PivotTable report using SQL Server 2014 data,it does not have formatting tools that can be used with the report.

Question 33

To create an OLAP report for an SQL Server 2014 database,use the PivotTable tool in SQL Server 2014.

Question 34

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.

Question 35

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

Question 36

In RFM analysis,F stands for "how frequently."

Question 37

Business Intelligence (BI)reporting systems are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.

Question 38

In a common form of RFM analysis,an RFM score of {5 1 1} means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

Question 39

When creating an OLAP report based on SQL Server 2014 data,it is often a good idea to create a view to organize the data needed for the OLAP report.

Question 40

Microsoft Excel 2013 cannot import SQL Server 2014 data directly into a PivotTable report,but must first place the data into a worksheet.

Question 41

Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict future outcomes.

Question 42

Facebook uses the Apache Software Foundation's Cassandra NoSQL database.

Question 43

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

Question 44

Most of NoSQL nonrelational database methodologies are known as structured storage.

Question 45

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 are correct

Question 46

NoSQL really stands of "Not only SQL."

Question 47

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

A)Processing
B)Reporting
C)Data mining
D)Both B and C are correct

Question 48

Structured storage column families are indistinguishable from relational database tables.

Question 49

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 are correct

Question 50

Business Intelligence (BI)systems obtain their data by all of the following means except ________.

A)read and process data from an operational database
B)process extracts from operational databases
C)process data purchased from data vendors
D)read and process data entered by BI system users

Question 51

The movement that uses different database methods than the relational model and/or SQL is called the NoSQL movement.

Question 52

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

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

Question 53

Amazon.com's Dynamo was an early example of structured storage.

Question 54

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)nonintegrated data
D)a "too much data" problem

Question 55

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

A)perform what-if analysis
B)make predications
C)facilitate decision making
D)update the database

Question 56

Google's Bigtable was an early example of structured storage.

Question 57

Most data mining techniques are simple and easy to use.

Question 58

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)nonintegrated data
D)a "wrong format" problem

Question 59

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

A)Dirty data
B)Current data
C)Nonintegrated data
D)Missing values

Question 60

Which of the following is (are)true about data mining applications?

A)They use sophisticated mathematical techniques.
B)They use sophisticated statistical techniques.
C)Their report delivery is more important than report delivery for reporting systems.
D)Both A and B are correct

Question 61

An OLAP cube is called that because some products show OLAP displays on ________ axes.

A)one
B)two
C)three
D)four

Question 62

OLAP stands for ________.

A)OnLine Analytical Processing
B)OffLine Analytical Processing
C)OnLine Analysis Process
D)Old,Lazy And Particular

Question 63

Dimensional databases are used to track historical data,and therefore must have a(n)________.

A)time dimension
B)customer dimension
C)sales dimension
D)order dimension

Question 64

In OLAP,the data item of interest is called a ________.

A)level
B)dimension
C)measure
D)member

Question 65

We have obtained access to the company's operational data.We have been asked to produce a report with an item by item analysis of sales,but the only sales figure available is the total sale value for each order.This is an example of ________.

A)dirty data
B)inconsistent data
C)nonintegrated data
D)a "wrong format" problem

Question 66

RFM analysis analyzes and ranks customers based on ________.

A)their purchasing patterns
B)their income status
C)their residential location
D)Both A and B are correct

Question 67

The term drill down means the user wants to ________.

A)summarize data
B)get older data
C)sort data
D)get more details

Question 68

The "M" in RFM analysis stands for ________.

A)money
B)mostly
C)modest
D)modern

Question 69

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

A)operational database
B)dimensional database
C)structured storage
D)object-relational data model

Question 70

A data mart differs from a data warehouse in that ________.

A)it has a larger database
B)it deals with a particular component or functional area of the business
C)data mart users must have more data management expertise than data warehouse employees
D)it is updated more frequently by the data mart users

Question 71

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 denormalized
D)Both B and C are correct

Question 72

RFM scores commonly range from ________,with ________ being the "high" or "most desirable" (from the vendor's point of view)score.

A)0 to 5;0
B)0 to 5;5
C)1 to 5;1
D)1 to 5,5

Question 73

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

A)fact table
B)dimension table
C)map table
D)reduce table

Question 74

A Business Intelligence (BI)reporting system ________.

A)creates meaningful information from disparate data sources
B)delivers information to users at the DBA's convenience
C)uses statistical procedures to predict future events
D)uses operational data

Question 75

Data warehouses use a(n)________.

A)operational database
B)dimensional database
C)structured storage
D)object-relational data model

Question 76

In OLAP,the characteristic of a measure is called a ________.

A)level
B)dimension
C)slice
D)member

Question 77

Which of the following is not a component of a data warehouse?

A)Data extract,transform,and load (ETL)preparation programs
B)Data warehouse data
C)Operational database updates
D)Data warehouse metadata

Question 78

We have done an RFM analysis on our customer data.John Smith has a score of {5 1 1}.This means that John ________.

A)has ordered recently,and orders a lot when he orders
B)hasn't ordered recently,but orders a lot when he orders
C)has ordered recently,but doesn't order a lot when he orders
D)hasn't ordered recently,and doesn't order a lot when he orders

Question 79

The "R" in RFM analysis stands for ________.

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

Question 80

Snowflake schemas have normalized ________.

A)fact tables
B)dimension tables
C)map tables
D)reduce tables