Question 1

Report modes include dynamic and static.

Accepted Answer

False

Question 2

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.

Accepted Answer

BI reporting systems are specifically designed to collect data from multiple sources, transform it into meaningful insights and dashboards, and present it to the right users at the right time, helping organizations make informed decisions.

Question 3

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

Accepted Answer

Reporting systems are specifically designed for the purpose of generating and delivering reports to end-users, making report delivery a fundamental aspect of their functionality. Data mining focuses on discovering patterns and knowledge from large datasets, where the emphasis is more on the analysis and extraction of data rather than the delivery of reports.

Question 4

Problematic data include so-called "dirty data."

Accepted Answer

Problematic data can refer to data that is inaccurate, incomplete, irrelevant, or inconsistent, which can be classified as "dirty data."

Question 5

Business Intelligence (BI)systems support operational activities.

Accepted Answer

Business Intelligence (BI) systems support strategic and analytical activities, not operational activities. They are used to transform data into actionable insights that drive decision-making at different levels of an organization. Operational activities usually rely on transactional systems such as Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) systems.

Question 6

A digital dashboard is an electronic display customized for an individual user.

Accepted Answer

A digital dashboard is designed to display personalized information and data relevant to a specific user, hence it is customized for individual use.

Question 7

A data warehouse is a database system that has data and programs for,as well as personnel specialized in,BI processing.

Accepted Answer

A data warehouse is specifically designed for BI (Business Intelligence) processing, with specialized personnel and tools for extracting insights and trends from large amounts of data.

Question 8

In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" or "bad."

Accepted Answer

The answer of In a common form of RFM analysis,a...

Question 9

Data warehouses are populated with data prepared by Extract,Transform,and Load (ETL)systems.

Accepted Answer

Data warehouses are indeed populated with data prepared by ETL systems, which extract data from various sources, transform it to fit the data warehouse schema, and load it into the data warehouse.

Question 10

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

Accepted Answer

A data mart is a subset of a larger data warehouse that is designed to serve a specific business function or department. It contains a specific set of data that is relevant to the needs of that particular area of the business.

Question 11

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

Accepted Answer

RFM analysis ranks customers based on their purchasing behavior by analyzing Recency, Frequency, and Monetary value of their transactions, not on-line survey data.

Question 12

Business Intelligence (BI)reporting systems are used to filter data,sort data,group data and make simple calculations based on the data.

Accepted Answer

BI reporting systems are specifically designed to perform data filtering, sorting, grouping, and basic calculations to provide insights into business performance.

Question 13

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

Accepted Answer

Business Intelligence (BI) reporting systems use standard SQL to analyze data and generate reports. SQL is a powerful language that can be used to query databases, manipulate data, and create customized reports. By using SQL, BI reporting systems can access data from a variety of sources, including data warehouses, data marts, and operational databases, and generate real-time or scheduled reports that provide insights into business performance and trends.

Question 14

Data Mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

Accepted Answer

Data Mining does indeed use sophisticated statistical and mathematical techniques to perform what-if analyses, make predictions, and facilitate decision making.

Question 15

BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

Accepted Answer

BI reporting systems not only summarize current status and compare it with past events, but they can also include predictive analytics to forecast future trends based on historical data.

Question 16

Business Intelligence (BI)systems are information systems that help users analyze and use data.

Accepted Answer

Business Intelligence (BI) systems are specifically designed to help users analyze and use data in a more effective way, providing insights that can inform decision-making processes.

Question 17

In a common form of RFM analysis,an RFM score of 5 1 1 means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

Accepted Answer

In RFM analysis, the first number (5 in this case) represents recency (how recently a customer has made a purchase), the second number (1) represents frequency (how often a customer makes a purchase), and the third number (1) also represents monetary value (the amount of money a customer spends). A score of 5 1 1 indicates a customer who hasn't purchased recently (5 being the lowest score for recency), but when they do purchase, they do so frequently and spend a lot (both scored as 1, with 1 being the highest score for frequency and monetary value).

Question 18

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Accepted Answer

The answer of In a common form of RFM analysis,customers...

Question 19

A reporting system does not maintain a database of metadata.

Accepted Answer

A reporting system typically does maintain a database of metadata, which includes information about the data being analyzed, such as its source, structure, and relationships with other data. This metadata is used to enable querying, filtering, and reporting on the data in meaningful ways.

Question 20

In RFM analysis,R stands for "how recently",F stands for "how frequently" and M stands for "how many months."

Accepted Answer

In RFM analysis, M stands for "how much money" a customer has spent.

Quiz 17: Getting Started With Web Servers, php, and the Netbeans IDE