48) 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
49) Problematic data are called ________.
50) A(n) ________ is a collection of data that addresses a particular component or functional
area of a business.
51) What is a data warehouse?
52) What is a conformed dimension?
53) What is a distributed database?
54) What are objects, and how are they related to the object-oriented DBMS (OODBMS)?
55) What is a Microsoft Excel PivotTable?
56) Describe how to create an OLAP report for a Microsoft Access 2016 database in Microsoft
Excel 2016.
57) Operational databases store historical data.
58) Dimensional databases are used for analytical data processing.
59) Dimensional databases use the star schema.
60) Operational databases contain a fact table.
61) A star schema resembles a star, with a dimension table at the center and fact tables radiating
out from the center.
62) In a snowflake schema, each dimension table is normalized.
63) Data warehouses use a(n) ________.
A) operational database
B) dimensional database
C) structured storage
D) either A or B
E) distributed database
64) 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
65) 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
66) 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
67) Snowflake schemas have normalized ________.
A) fact tables
B) dimension tables
C) map tables
D) reduce tables
E) None of the above
68) Data warehouse data is often stored in a(n) ________.
69) Data warehouses are populated with data prepared by ________ programs.
70) A dimensional database uses a(n) ________.
71) A variant of the star schema is the ________.
72) In the snowflake schema, the ________ tables are normalized.
73) To deal with data values that change over time, dimensional databases use a(n) ________.
74) To deal with historical data values, dimensional databases use a(n) ________.
75) Compare the characteristics of an operational database and a dimensional database.
76) What is a slowly changing dimension?
77) What is a star schema?
78) OLAP provides the ability to sum, count, average and perform other simple arithmetic
operations on groups of data.
79) The term drill down refers to the capability of seeing the data in smaller and smaller units.
80) To create an OLAP report for an Access 2016 database, use the PivotTable tool in Access
2016.
81) When creating an OLAP report based on Access 2016 data, it is often a good idea to create a
view equivalent query to organize the data needed for the OLAP report.
82) Excel 2016 allows us to connect directly to an Access 2016 database when building a
PivotTable.
83) Excel 2016 cannot import Access 2016 data directly into a PivotTable report, but must first
place the data into a worksheet.
84) Although Excel 2016 will create a PivotTable report using Access 2016 data, it does not
have formatting tools that can be used with the report.
85) OLAP stands for ________.
A) Online Analytical Processing
B) Offline Analytical Processing
C) Online Analysis Process
D) Offline Analysis Process
E) Old, Lazy And Particular
86) The term drill down means the user wants to ________.
A) summarize data
B) get older data
C) sort data
D) get more details
E) aggregate data
87) To create an OLAP report for an Access 2016 database, we can build a PivotTable in
________.
A) Microsoft Access 2016
B) Microsoft Word 2016
C) Microsoft Visio 2016
D) Microsoft Excel 2016
E) Microsoft PowerPoint 2016
88) To use the Access 2016 database in an Excel 2016 PivotTable, it is generally useful to
________.
A) create a view-equivalent query in Access 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 PowerPoint slide show
E) store the needed data in a Visio diagram
89) To use Access 2016 data in an Excel 2016 PivotTable, we use the ________.
A) “To Excel” command on the Access Data command tab
B) “To Excel” command on the Excel Data command tab
C) “From Access” command on the Access Data command tab
D) “From Access” command on the Excel Data command tab
E) “Get Data” command on the Excel Data command tab
90) To arrange the PivotTable columns and rows in Excel 2016, we use the ________.
A) PivotTable Control
B) PivotTable dialog box
C) PivotTable Field List
D) PivotTable Wizard
E) PivotTable command tab
91) To format a PivotTable in 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
E) Report Tools command tab
92) ________ provides the ability to sum, count, average and perform other simple arithmetic
operations on groups of data.
93) The term ________ refers to the capability of seeing the data in smaller and smaller units.
94) OLAP reports can be created using the Excel 2016 ________ tool.
95) To create an OLAP report for an Access 2016 database, use the ________ tool in Excel
2016.
96) When creating an OLAP report based on Access 2016 data, it is often a good idea to create
a(n) ________ query to organize the data needed for the OLAP report.
97) Excel 2016 allows us to ________ to an Access 2016 database when building a PivotTable.
98) To control the placement of columns and rows in an Excel 2016 PivotTable, we use the
________.
99) To format an Excel 2016 PivotTable report, we use the ________ command tab.
100) Virtualization is using hardware and software to simulate another software application.