65) Data warehouses use a(n) ________.
A) operational database
B) dimensional database
C) structured storage
D) object-relational data model
66) Slowly changing dimensions are handled by a(n) ________.
A) operational database
B) dimensional database
C) structured storage
D) object-relational data model
67) 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
68) Star schemas have a ________ at the center of the star.
A) fact table
B) dimension table
C) map table
D) reduce table
69) Snowflake schemas have normalized ________.
A) fact tables
B) dimension tables
C) map tables
D) reduce tables
70) 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
71) 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
72) The “R” in RFM analysis stands for ________.
A) rank
B) recent
C) relationship
D) readiness
73) The “M” in RFM analysis stands for ________.
A) money
B) mostly
C) modest
D) modern
74) 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
75) 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
76) OLAP stands for ________.
A) OnLine Analytical Processing
B) OffLine Analytical Processing
C) OnLine Analysis Process
D) Old, Lazy and Particular
77) In OLAP, the data item of interest is called a ________.
A) level
B) dimension
C) measure
D) member
78) In OLAP, the characteristic of a measure is called a ________.
A) level
B) dimension
C) slice
D) member
79) An OLAP cube is called that because some products show OLAP displays on ________
axes.
A) one
B) two
C) three
D) four
80) The term drill down means the user wants to ________.
A) summarize data
B) get older data
C) sort data
D) get more details
81) To create an OLAP report for an SQL Server 2017 database, we can build a PivotTable in
________.
A) Microsoft Access 2016
B) Microsoft Word 2016
C) Microsoft Visio 2016
D) Microsoft Excel 2016
82) To use an SQL Server 2017 database in an Microsoft Excel 2016 PivotTable, it is generally
useful to ________.
A) create a view in SQL Server 2017 to organize the data
B) store the needed data in an Excel worksheet
C) store the needed data in a Word document
D) store the needed data in a Visio diagram
83) To arrange the PivotTable columns and rows in Microsoft Excel 2016, we use the ________.
A) PivotTable Control
B) PivotTable dialog box
C) PivotTable Field List
D) Pivot Table Wizard
84) To format a PivotTable in Microsoft Excel 2016, we use the ________.
A) Design command tab in the PivotTable Tools contextual command tab
B) Format command tab in the PivotTable Tools contextual command tab
C) Design command tab in the Report Tools contextual command tab
D) Format command tab in the Report Tools contextual command tab
85) 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
86) 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
87) DBMSs associated with the NoSQL movement are often known as ________.
A) RDBMSs
B) OODBMSs
C) SSDBMSs
D) structured storage
88) The structured storage equivalent of an RDBMS table is a ________.
A) column
B) super column
C) column family
D) map
89) In the MapReduce process, the first step is the ________ step.
A) column
B) reduce
C) column family
D) map
90) Hadoop is a(n) ________.
A) RDMBS
B) OODBMS
C) distributed file system (DFS)
D) Web server
91) One of the goals of an object-relational database is to allow ________ to persist in the
database.
A) data structures
B) objects
C) methods
D) Java variables
92) ________ is a DBMS that provides a full set of object-relational features.
A) Oracle Database
B) Microsoft Access
C) Microsoft SQL Server 2017
D) MySQL
93) Virtualization is an attempt to do a better job of using which hardware resources in a
computer?
A) Memory and monitors
B) CPU and memory
C) Operating system
D) Database tables
94) The program that manages the various virtual machines (which can of course be running
their own DBMS installation) running on a physical machine is called a ________.
A) supervisor
B) hypervisor
C) virtual operating system
D) virtual DBMS
95) Computing and storage services offered by various companies over the internet, with either
storage or processing performed remotely, are collectively known as ________.
A) NoSQL databases
B) remote databases
C) cloud computing
D) distributed computing
96) Each of the following is an example of a cloud computing platform except ________.
A) SQL Server 2017 Express
B) Amazon Web Services
C) Google Business Solutions
D) Windows Azure
97) What are Business Intelligence (BI) systems?
98) Why is operational data sometimes unusable for Business Intelligence (BI) use? Include at
least two examples.
99) What is a data warehouse?
100) Compare the characteristics of an operational database and a dimensional database.
101) What is a slowly changing dimension? Include an example.
102) What is a star schema?
103) What is a conformed dimension?
104) What is a reporting system?
105) What is a Microsoft Excel PivotTable?
106) What is a distributed database?
107) What are objects, and how are they related to the object-oriented DBMS (OODBMS)?
108) What is the NoSQL movement?