Q&A Hero

Q: ________ is a DBMS that provides a full set of object-relational features. A) Oracle Database B) Microsoft Access C) Microsoft SQL Server 2014 D) MySQL

Q: 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

Q: Hadoop is a(n) ________. A) RDMBS B) OODBMS C) distributed file system (DFS) D) Web server

Q: In the MapReduce process, the first step is the ________ step. A) column B) reduce C) column family D) map

Q: The structured storage equivalent of an RDBMS table is a ________. A) column B) super column C) column family D) map

Q: DBMSs associated with the NoSQL movement are often known as ________. A) RDBMSs B) OODBMSs C) SSDBMSs D) structured storage

Q: 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

Q: 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

Q: To format a PivotTable in Microsoft 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

Q: To arrange the PivotTable columns and rows in Microsoft Excel 2013, we use the ________. A) PivotTable Control B) PivotTable dialog box C) PivotTable Field List D) Pivot Table Wizard

Q: To use an SQL Server 2014 database in an Microsoft Excel 2013 PivotTable, it is generally useful to ________. A) create a view in SQL Server 2014 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

Q: To create an OLAP report for an SQL Server 2014 database, we can build a PivotTable in ________. A) Microsoft Access 2013 B) Microsoft Word 2013 C) Microsoft Visio 2013 D) Microsoft Excel 2013

Q: The term drill down means the user wants to ________. A) summarize data B) get older data C) sort data D) get more details

Q: An OLAP cube is called that because some products show OLAP displays on ________ axes. A) one B) two C) three D) four

Q: In OLAP, the characteristic of a measure is called a ________. A) level B) dimension C) slice D) member

Q: In OLAP, the data item of interest is called a ________. A) level B) dimension C) measure D) member

Q: OLAP stands for ________. A) OnLine Analytical Processing B) OffLine Analytical Processing C) OnLine Analysis Process D) Old, Lazy And Particular

Q: 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

Q: The "M" in RFM analysis stands for ________. A) money B) mostly C) modest D) modern

Q: 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

Q: 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

Q: Snowflake schemas have normalized ________. A) fact tables B) dimension tables C) map tables D) reduce tables

Q: Star schemas have a ________ at the center of the star. A) fact table B) dimension table C) map table D) reduce table

Q: 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

Q: Slowly changing dimensions are handled by a(n) ________. A) operational database B) dimensional database C) structured storage D) object-relational data model

Q: Data warehouses use a(n) ________. A) operational database B) dimensional database C) structured storage D) object-relational data model

Q: 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

Q: 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

Q: 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

Q: 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

Q: 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

Q: 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

Q: 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

Q: 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

Q: 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

Q: 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

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

Q: Structured storage column families are indistinguishable from relational database tables.

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

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

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

Q: NoSQL really stands of "Not only SQL."

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

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

Q: 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.

Q: 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.

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

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

Q: 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.

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

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

Q: An OLAP cube is limited to three axes.

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

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

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

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

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

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

Q: 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.

Q: In a snowflake table, each dimension table is normalized.

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

Q: Operational databases contain a fact table.

Q: Dimensional databases use the star schema.

Q: Dimensional databases are used for analytical data processing.

Q: Operational databases store historical data.

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

Q: Problematic data are called dirty data.

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

Q: Data warehouses often include data purchased from outside vendors.

Q: Data warehouses also store the data warehouse metadata.

Q: Data warehouse data are frequently denormalized.

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

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

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

Q: 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.

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

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

Q: The coding for Java Server Pages must be written in ________. A) Java B) JavaScript C) C++ D) Both A and B are correct

Q: The first step in using a JDBC driver is to ________. A) establish a connection to the database B) load the driver C) create a statement D) call the DriverManager object

Q: In a three-tier or n-tier architecture, which type of JDBC driver can be used if the DBMS and the Web server are running on the same computer? A) Only Type 1 and Type 2 B) All four Types C) Only Type 3 and Type 4 D) Only Type 2 and Type 3