Question 1

Which of the following companies is an emerging vendor in the BI market?
A) SAS
B) MicroStrategy
C) Information Builder
D) PivotLink

Accepted Answer

PivotLink is an emerging vendor in the BI market, while SAS, MicroStrategy, and Information Builders are established vendors with a long history in the industry.

Question 2

Which of the following is an example of supervised data mining?
A) regression analysis
B) cluster analysis
C) decision trees
D) market basket analysis

Accepted Answer

Regression analysis is a supervised data mining technique that uses a set of input variables to predict a continuous output variable.

Question 3

Which of the following refers to a mashup of the real world, supplemented by computer-based data about the objects in that world?
A) real-time computing
B) visualization
C) clickstream data
D) augmented reality

Accepted Answer

Augmented reality combines real-world objects with computer-generated information to enhance the user's experience by providing additional information about the objects in the real world. Real-time computing refers to the processing of data as it is generated, visualization is a general term for creating visual representations of data, and clickstream data refers to the trails of clicks and page views that users leave behind as they navigate through a website.

Question 4

Max visits a local electronics store to buy a new laptop. After deciding on a certain brand and model, the sales assistant also convinces him to buy a wireless router and a thumb drive. This situation is an example of ________.
A) hard-selling
B) down-selling
C) cross-selling
D) up-selling

Accepted Answer

Cross-selling is the practice of suggesting additional complementary products to a customer who is already interested in a particular product. In this scenario, the sales assistant convinces Max to buy a wireless router and a thumb drive along with the laptop he intends to purchase, which is a classic example of cross-selling.

Question 5

An organization uses SAP financial management software to store accounting details and Microsoft CRM software to record customer transactions. Managers face problems when they have to make decisions based on both sets of data, as the data are stored on two different platforms. Such data are referred to as ________ data.
A) nonintegrated
B) coarse
C) granular
D) inconsistent

Accepted Answer

Nonintegrated data refers to sets of data that are stored on multiple platforms or systems that are not connected or integrated with each other. In this case, the financial data is stored on SAP software, and customer transaction data is stored on Microsoft CRM software. Managers face difficulties when making decisions based on both sets of data due to lack of integration.

Question 6

Which of the following BI-related problems is commonly associated with organizational leaders?
A) mistaking data for information
B) resisting BI use because the system may change their jobs
C) underestimating the cost of producing a BI report
D) overselling the potential of a BI system

Accepted Answer

Overselling the potential of a BI system is a common problem among organizational leaders. They may have unrealistic expectations of what a BI system can do or how quickly it can provide valuable insights.

Question 7

Decision tree analysis is also called ________ because at each step the analysis divides itself into groups.
A) cluster analysis
B) transactional processing
C) recursive partitioning
D) data-driven analysis

Accepted Answer

Decision tree analysis is also called recursive partitioning because it involves recursively partitioning the data into smaller and smaller subgroups based on the chosen decision criteria. This results in a tree-like structure where each node represents a decision point that splits the data into two or more subgroups.

Question 8

A ________ is a hierarchical arrangement of criteria that predict a classification or a value.
A) decision tree
B) taxonomy
C) cluster
D) dashboard

Accepted Answer

A decision tree is a hierarchical arrangement of criteria that predicts a classification or a value. It is a popular machine learning algorithm used for both classification and regression tasks. A taxonomy is a system of classification used to organize concepts and objects. A cluster is a group of objects that are similar to each other while being different from objects in other groups. A dashboard is a visual representation of key performance indicators and other important data used by businesses to make decisions. While all of these options involve some form of organization, a decision tree is the most appropriate choice based on the given definition.

Question 9

What is a business intelligence system?

Accepted Answer

The answer of What is a business intelligence system?...

Question 10

With ________, analysts do not create a model or hypothesis before running the analysis.
A) interactive analytical processing
B) unsupervised data mining
C) supervised data mining
D) noninteractive analytical processing

Accepted Answer

Unsupervised data mining refers to the process of analyzing data without any prior hypothesis or model. It relies on algorithms to identify patterns and relationships in the data, clustering similar observations and detecting anomalies. Interactive analytical processing, supervised data mining, and noninteractive analytical processing all involve some level of preconceived model or hypothesis.

Question 11

________ is the creation of images or diagrams that communicate a message.
A) Dashboarding
B) Simulation
C) Visualization
D) Augmented reality

Accepted Answer

Visualization is the creation of images or diagrams that communicate a message. Dashboarding refers to the creation of dashboards that show key performance indicators (KPIs) and data visualizations. Simulation refers to the imitation of the operation of a real-world process or system over time. Augmented reality involves overlaying digital information onto the physical world.

Question 12

Which of the following is a pure-play BI company?
A) SAP
B) Oracle
C) IBM
D) SAS

Accepted Answer

SAS is a pure-play BI company specializing in analytics, business intelligence, and data management. SAP, Oracle, and IBM are diversified companies that offer a range of technology solutions beyond BI.

Question 13

________ data include everything a customer does at a Web site.
A) Real-time
B) Clickstream
C) Keystroke
D) Digital

Accepted Answer

Clickstream data includes every action a customer takes at a website, such as clicking links, browsing pages, and making purchases. Real-time data refers to information that is transmitted immediately, keystroke data refers specifically to the keys pressed on a keyboard, and digital data is a broad term that can refer to any type of electronic information.

Question 14

Which of the following systems is considered a subset of BI?
A) RSS
B) CIS
C) AI
D) DSS

Accepted Answer

DSS (Decision Support Systems) is considered a subset of BI (Business Intelligence) as it helps in making data-driven decisions by providing interactive reports and data analysis tools. The other options, RSS (Really Simple Syndication), CIS (Customer Information System), and AI (Artificial Intelligence), though related to data and information technology, are not considered subsets of BI.

Question 15

Data that are problematic for business intelligence are termed ________.
A) clustered data
B) intrinsic data
C) dirty data
D) granular data

Accepted Answer

Dirty data refers to data that contains errors, inconsistencies, duplicates, or is incomplete. It can cause problems for business intelligence because it can lead to inaccurate analysis and decision-making. Clustered data (A) refers to data that is grouped together based on similarities, intrinsic data (B) refers to data that is inherent to a particular entity or system, and granular data (D) refers to data that is highly detailed or specific. While these types of data may present their own challenges for business intelligence, they are not inherently problematic in the same way that dirty data is.

Question 16

With ________, analysts develop a model prior to the analysis and apply statistical analyses to the data to estimate parameters of the model.
A) interactive analytical processing
B) unsupervised data mining
C) supervised data mining
D) noninteractive analytical processing

Accepted Answer

The description fits with the process of supervised data mining, where analysts have a preconceived model and use statistical techniques to estimate its parameters. The other options (A, B, and D) do not accurately describe this process.

Question 17

Which of the following statements is true of a BI system?
A) A BI server is capable of delivering output in a variety of formats.
B) Operational databases are not typically used by BI systems.
C) Data collected for BI systems are not stored in data warehouses.
D) General-purpose BI software is used irrespective of the analysis method employed.

Accepted Answer

A BI system typically involves a BI server that is capable of delivering output in a variety of formats, such as reports, dashboards, and visualizations.

Option B is incorrect because BI systems can use operational databases in addition to data warehouses.

Option C is incorrect because data collected for BI systems are typically stored in data warehouses, which are designed for querying and analysis.

Option D is incorrect because different analysis methods may require different types of BI software. For example, predictive modeling may require specialized software that is not needed for basic reporting.

Question 18

A sales manager uses a bar chart to describe sales projections to his associates. This chart is an example of ________.
A) dashboarding
B) visualization
C) simulation
D) augmented reality

Accepted Answer

The bar chart is an example of visualization, which refers to the use of graphical representations to present complex data in an easily understandable manner. Dashboarding refers to the use of a visual display of key performance indicators to monitor business performance. Simulation involves creating a virtual model of a real-world situation to test various scenarios. Augmented reality involves enhancing the real world with computer-generated sensory input, such as images or sounds.

Question 19

The collection of operational process data that SAP uses is referred to as ________.
A) online analytical processing
B) Business Objects
C) Crystal Reports
D) online transactional processing

Accepted Answer

Online transactional processing (OLTP) is the collection of data that SAP uses to support its day-to-day operations. This data includes transactional and process data that is used to drive operational efficiency and effectiveness. OLTP is focused on processing transactions as quickly and efficiently as possible, which includes capturing and storing data in real-time. OLTP data is often used to support decision-making through reporting and analysis tools like Business Objects and Crystal Reports, but OLTP itself is distinct from these tools. Online analytical processing (OLAP) is another term used for reporting and analysis tools that use data from OLTP systems, but OLAP is not the collection of data itself.

Question 20

Granularity refers to the ________.
A) problems that persist within data
B) level of detail of the data
C) inconsistencies within data
D) patterns derived from operational data

Accepted Answer

Granularity refers to the level of detail or the amount of data available. It refers to how finely data is divided or how specific the data elements are.

Quiz 11: Business Intelligence

Which of the following companies is an emerging vendor in the BI market?

Which of the following is an example of supervised data mining?

Which of the following refers to a mashup of the real world, supplemented by computer-based data about the objects in that world?

Max visits a local electronics store to buy a new laptop. After deciding on a certain brand and model, the sales assistant also convinces him to buy a wireless router and a thumb drive. This situation is an example of ________.

Which of the following BI-related problems is commonly associated with organizational leaders?

Decision tree analysis is also called ________ because at each step the analysis divides itself into groups.

A ________ is a hierarchical arrangement of criteria that predict a classification or a value.

What is a business intelligence system?

With ________, analysts do not create a model or hypothesis before running the analysis.

________ is the creation of images or diagrams that communicate a message.

Which of the following is a pure-play BI company?

________ data include everything a customer does at a Web site.

Which of the following systems is considered a subset of BI?

Data that are problematic for business intelligence are termed ________.

With ________, analysts develop a model prior to the analysis and apply statistical analyses to the data to estimate parameters of the model.

Which of the following statements is true of a BI system?

A sales manager uses a bar chart to describe sales projections to his associates. This chart is an example of ________.

The collection of operational process data that SAP uses is referred to as ________.

Granularity refers to the ________.