Final exam ch 8 – Flashcards
80 test answers
Unlock all answers in this set
Unlock answers 80question
5) Business Intelligence (BI) reporting systems are used to filter data, sort data, group data and make simple calculations based on the data.
answer
TRUE
Unlock the answer
question
6) Business Intelligence (BI) reporting systems can analyze data using standard SQL.
answer
TRUE
Unlock the answer
question
7) BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.
answer
FALSE
Unlock the answer
question
8) Data Mining uses sophisticated statistical and mathematical techniques to perform what-if analyses, to make predictions, and to facilitate decision making.
answer
TRUE
Unlock the answer
question
9) Report delivery is more difficult for data mining than it is for reporting systems.
answer
FALSE
Unlock the answer
question
10) Problematic data include so-called "dirty data."
answer
TRUE
Unlock the answer
question
11) A data warehouse is a database system that has data and programs for, as well as personnel specialized in, BI processing.
answer
TRUE
Unlock the answer
question
12) Data warehouses are populated with data prepared by Extract, Transform, and Load (ETL) systems.
answer
TRUE
Unlock the answer
question
13) A data mart is a collection of data that addresses a particular component or functional area of a business.
answer
TRUE
Unlock the answer
question
14) Operational databases store historical data.
answer
FALSE
Unlock the answer
question
15) Dimensional databases are used for analytical data processing.
answer
TRUE
Unlock the answer
question
16) Dimensional databases use the star schema.
answer
TRUE
Unlock the answer
question
17) Operational databases contain a fact table.
answer
FALSE
Unlock the answer
question
18) A star schema resembles a star, with a dimension table at the center and fact tables radiating out from the center.
answer
FALSE
Unlock the answer
question
19) In a snowflake table, each dimension table is normalized.
answer
TRUE
Unlock the answer
question
20) OLAP provides the ability to sum, count, average and perform other simple arithmetic operations on groups of data.
answer
TRUE
Unlock the answer
question
21) The term drill down refers to the capability of seeing the data in smaller and smaller units.
answer
TRUE
Unlock the answer
question
22) NoSQL really stands for "Not only SQL."
answer
TRUE
Unlock the answer
question
23) Apache Cassandra is an example of a column family database.
answer
TRUE
Unlock the answer
question
24) Column family databases are indistinguishable from relational database tables.
answer
FALSE
Unlock the answer
question
25) In the MapReduce process, the Reduce step is followed by the Map step.
answer
FALSE
Unlock the answer
question
26) To create an OLAP report for an Access 2013 database, use the PivotTable tool in Access 2013.
answer
FALSE
Unlock the answer
question
27) When creating an OLAP report based on Access 2013 data, it is often a good idea to create a view equivalent query to organize the data needed for the OLAP report.
answer
TRUE
Unlock the answer
question
28) Excel 2013 allows us to connect directly to an Access 2013 database when building a PivotTable.
answer
TRUE
Unlock the answer
question
29) Excel 2013 cannot import Access 2013 data directly into a PivotTable report, but must first place the data into a worksheet.
answer
FALSE
Unlock the answer
question
30) Although Excel 2013 will create a PivotTable report using Access 2013 data, it does not have formatting tools that can be used with the report.
answer
FALSE
Unlock the answer
question
31) 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) All of the above
answer
D
Unlock the answer
question
32) 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
E
Unlock the answer
question
33) Business Intelligence (BI) systems obtain their data by which of the following means? A) Read and process data from an operational database B) Process extracts from operational databases C) Process data purchased from data vendors D) Both A and B E) All of the above
answer
E
Unlock the answer
question
34) 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) All of the above
answer
D
Unlock the answer
question
35) A Business Intelligence (BI) reporting system that uses extensions to SQL is: A) cluster analysis. B) OLAP. C) regression analysis. D) RFM analysis. E) All of the above
answer
B
Unlock the answer
question
36) Data mining applications are used to accomplish which of the following tasks? A) Perform what-if analysis B) Make predications C) Facilitate decision making D) Both A and B E) All of the above
answer
E
Unlock the answer
question
37) 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 of the above
answer
D
Unlock the answer
question
38) Which of the following is a reason that operational data are difficult to read? A) Dirty data B) Missing values C) Non-integrated data D) Both A and B E) All of the above
answer
E
Unlock the answer
question
39) 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.
answer
A
Unlock the answer
question
40) 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.
answer
B
Unlock the answer
question
41) 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) All of the above
answer
C
Unlock the answer
question
42) A data mart differs from a data warehouse in that: 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) Both A and B E) All of the above
answer
E
Unlock the answer
question
43) Data warehouses use a(n): A) operational database. B) dimensional database. C) structured storage. D) Either A or B E) All of the above
answer
B
Unlock the answer
question
44) Slowly changing dimensions are handled by a(n): A) operational database. B) dimensional database. C) structured storage. D) Either A or B E) All of the above
answer
B
Unlock the answer
question
45) 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
answer
A
Unlock the answer
question
46) 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
answer
A
Unlock the answer
question
47) Snowflake schemas have normalized: A) fact tables. B) dimension tables. C) map tables. D) reduce tables. E) None of the above
answer
B
Unlock the answer
question
48) OLAP stands for: A) Online Analytical Processing. B) Offline Analytical Processing. C) Online Analysis Process. D) Offline Analysis Process. E) Old, Lazy And Particular.
answer
A
Unlock the answer
question
49) 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.
answer
D
Unlock the answer
question
50) 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
answer
B
Unlock the answer
question
51) 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) None of the above
answer
A
Unlock the answer
question
52) Non-relational DBMSs associated with the NoSQL movement include: A) Key-Value. B) Document. C) Column Family. D) Graph. E) All of the above
answer
E
Unlock the answer
question
53) Apache Cassandra is an example of a(n) ________ non-relational DBMS. A) Key-Value B) Document C) Column Family D) Graph E) Object-Oriented
answer
C
Unlock the answer
question
54) In the MapReduce process, the first step is the ________ step. A) column B) super column C) column family D) map E) reduce
answer
D
Unlock the answer
question
55) Hadoop is a(n): A) RDMBS. B) OODBMS. C) distributed file system (DFS). D) print system. E) Web server.
answer
C
Unlock the answer
question
56) To create an OLAP report for an Access 2013 database, we can build a PivotTable in: A) Microsoft Access 2013. B) Microsoft Word 2013. C) Microsoft Visio 2013. D) Microsoft Excel 2013. E) Microsoft PowerPoint 2013.
answer
D
Unlock the answer
question
57) To use the Access 2013 database in an Excel 2013 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.
answer
A
Unlock the answer
question
58) To use Access 2013 data in an Excel 2013 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.
answer
D
Unlock the answer
question
59) To arrange the PivotTable columns and rows in Excel 2013, we use the: A) PivotTable Control. B) PivotTable dialog box. C) PivotTable Field List. D) PivotTable Wizard. E) PivotTable command tab.
answer
C
Unlock the answer
question
60) To format a PivotTable in Excel 2013, 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.
answer
A
Unlock the answer
question
61) The term for the enormous datasets generated by Web 2.0 applications is ________.
answer
Big Data
Unlock the answer
question
62) A(n) ________ is an information system that helps users analyze and use data.
answer
Business Intelligence (BI) system
Unlock the answer
question
63) Business Intelligence (BI) systems fall into two broad categories: ________ and ________.
answer
reporting and data mining
Unlock the answer
question
64) Business Intelligence (BI) systems obtain data in ________ different ways.
answer
three
Unlock the answer
question
65) Business Intelligence (BI) ________ are used to filter data, sort data, group data and make simple calculations based on the data.
answer
reporting systems
Unlock the answer
question
66) Business Intelligence (BI) ________ uses sophisticated statistical and mathematical techniques to perform what-if analyses, to make predictions, and to facilitate decision making.
answer
data mining
Unlock the answer
question
67) Problematic data are called ________.
answer
dirty data
Unlock the answer
question
68) Data warehouse data is often stored in a(n) ________.
answer
dimensional database
Unlock the answer
question
69) Data warehouses are populated with data prepared by ________ programs.
answer
Extract, Transform and Load (ETL)
Unlock the answer
question
70) A(n) ________ is a collection of data that addresses a particular component or functional area of a business.
answer
data mart
Unlock the answer
question
71) A dimensional database uses a(n) ________.
answer
star schema
Unlock the answer
question
72) A variant of the star schema is the ________.
answer
snowflake schema
Unlock the answer
question
73) In the snowflake schema, the ________ tables are normalized.
answer
dimension
Unlock the answer
question
74) To deal with data values that change over time, dimensional databases use a(n) ________.
answer
slowly changing dimension
Unlock the answer
question
75) To deal with historical data values, dimensional databases use a(n) ________.
answer
time dimension
Unlock the answer
question
76) ________ provides the ability to sum, count, average and perform other simple arithmetic operations on groups of data.
answer
OLAP
Unlock the answer
question
77) The term ________ refers to the capability of seeing the data in smaller and smaller units.
answer
drill down
Unlock the answer
question
78) OLAP reports can be created using the Excel 2013 ________ tool.
answer
PivotTable
Unlock the answer
question
79) Distributed databases can be distributed by partitioning and ________.
answer
replication
Unlock the answer
question
80) Objects have ________, which are computer programs that perform some task.
answer
methods
Unlock the answer
