Question 1

Business intelligence (BI)systems have only four of the five components of an information system: hardware, software, data, and people.

Accepted Answer

Business intelligence systems have all five components of an information system, including hardware, software, data, people, and processes. The processes component is essential for integrating the other four components and making the BI system effective in providing insights and decision support.

Question 2

A data mart is a data collection that addresses a particular functional area of the business.

Accepted Answer

This statement accurately defines what a data mart is. It is a subset of a larger data warehouse that is focused on a specific business function or department, such as sales or marketing.

Question 3

The software component of a BI system is called a BI application.

Accepted Answer

The software component of a BI system does indeed go by the name of a BI application.

Question 4

It is possible to capture the customers' clicking behavior using clickstream data.

Accepted Answer

Clickstream data refers to the record of a user's activity on a website or application, including the pages visited and the links clicked. By analyzing clickstream data, businesses can gain insights into their customers' clicking behavior and use this information to improve the user experience and optimize their marketing efforts.

Question 5

The three primary activities in the BI process are to acquire data, perform analysis, and publish results.

Accepted Answer

This statement is true. The BI process involves acquiring data from various sources, analyzing the data to extract valuable insights, and then publishing the results in a format that is useful for decision-making.

Question 6

The three fundamental categories of BI analysis are reporting, data mining, Big data and knowledge management.

Accepted Answer

The answer of The three fundamental categories of BI analysis...

Question 7

Granularity is a term that refers to the level of detail represented by the data.

Accepted Answer

Granularity refers to the level of detail in data which could be high or low.

Question 8

Data acquisition is the process of creating business intelligence.

Accepted Answer

Data acquisition is only one part of the process of creating business intelligence. Other parts include data cleansing, transformation, integration, analysis, and visualization.

Question 9

Problematic data are termed dirty data.

Accepted Answer

Dirty data refers to data that is inaccurate, incomplete, or inconsistent, and can cause problems in analysis and decision-making.

Question 10

A value of 999-999-9999 for a U.S.phone number is an example of dirty data for BI purpose.

Accepted Answer

999-999-9999 does not follow the standard format of a valid U.S. phone number, which should have ten digits (area code + local number) and cannot start with a 0 or 1 in the area code. Therefore, it is considered dirty data for BI purpose.

Question 11

A reporting application is a BI application that inputs data from one or more sources and applies reporting operations to that data to produce business intelligence.

Accepted Answer

A reporting application takes in data and generates reports to produce business intelligence.

Question 12

It is better to have data with too coarse a granularity, than data with too fine a granularity.

Accepted Answer

Data with too fine a granularity can lead to inaccuracies and noise, as well as being difficult to manage and analyze. Data with a slightly coarser granularity may still provide useful insights without being overwhelming.

Question 13

Operational data is structured for fast and reliable transaction processing.

Accepted Answer

Operational data is optimized for transactional processing, which requires fast and reliable processing of individual transactions. This typically involves structured data that is highly organized and indexed for quick access and retrieval.

Question 14

Push publishing requires the user to request BI results.

Accepted Answer

Push publishing is the opposite of the traditional pull approach. In push publishing, BI results are automatically and continuously distributed to users without their having to request them.

Question 15

The five basic reporting operations that produce business intelligence can all be accomplished using SQL and basic HTML or a simple report writing tool.

Accepted Answer

SQL and basic HTML or a simple report writing tool can be used to perform the five basic reporting operations that produce business intelligence, which are filtering, grouping, calculating, formatting, and visualizing.

Question 16

Data warehouses do not include data that are purchased from outside sources.

Accepted Answer

Data warehouses may include data that are purchased from outside sources to supplement the internal data of the organization.

Question 17

Report servers are specialized Web servers.

Accepted Answer

Report servers are specialized Web servers designed to store, manage, and deliver reports. They are used for generating dynamic reports that can be based on a variety of data sources, such as databases or other repositories. These servers are specifically designed for managing, processing, and distributing reports, and can handle large volumes of data with greater efficiency and speed than traditional Web servers.

Question 18

Data mart is another term used for a data warehouse.

Accepted Answer

A data mart is a subset of a data warehouse, designed to serve a specific purpose or department within an organization, whereas a data warehouse is a large-scale repository that aggregates data from multiple sources for analysis and reporting across the entire organization.

Question 19

Placing BI applications on operational servers can dramatically increase system performance.

Accepted Answer

Placing BI applications on operational servers can cause a decrease in system performance, as it can put additional strain on the servers and potentially cause conflicts with other processes. It is generally recommended to have separate servers dedicated to BI applications.

Question 20

A data mart is a lot larger than a data warehouse.

Accepted Answer

A data mart is a subset of a data warehouse that is designed for a specific business unit or department, while a data warehouse is a larger, centralized repository of data from various sources that serves the entire organization.

Quiz 9: Business Intelligence Systems