Question 1

A data mart is the process of analysing data to extract information not offered by the raw data alone.

Accepted Answer

False

Question 2

Which of the following represents the different information levels?
A) Detail,summary,aggregate
B) Document,presentation,spreadsheet,database
C) Individual,department,enterprise
D) None of the answers is correct

Accepted Answer

C

Question 3

Relational integrity constraints enforce business rules vital to an organisation's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

Relational integrity constraints are rules that ensure data accuracy and consistency within a relational database, but they do not encompass broader business rules which may require additional insight and knowledge beyond data constraints.

Question 4

Redundancy is the duplication of data,or storing the same data in multiple places.

Accepted Answer

Redundancy involves storing the same data in multiple places or duplicating data.

Question 5

Within the data warehouse model,the external databases are competitor information,industry information,mailing lists and stock market analysis.

Accepted Answer

External databases are sources of various types of information that can be added to the data warehouse model, such as competitor information, industry information, mailing lists and stock market analysis.

Question 6

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

While the financial industry may use business intelligence for various purposes such as risk analysis, fraud detection, customer insights, etc., predicting hardware failures is not a common use case in this industry. This type of prediction is more related to the field of IT operations and is usually addressed using specific tools and techniques such as predictive maintenance, machine learning algorithms, etc.

Question 7

Which of the following represents the different information granularities?
A) Detail,summary,aggregate
B) Document,presentation,spreadsheet,database
C) Individual,department,enterprise
D) None of the answers is correct

Accepted Answer

Option A represents the hierarchy of different levels of detail in data: detail refers to a transactional level of data, summary represents an overview of a set of data, and aggregate summarizes large sets of data.

B represents different types of data storage and analysis tools, and C represents different organizational levels in a business hierarchy, but neither of them is related to information granularities.

Question 8

Databases offer many security features including passwords to provide authentication,access levels to determine who can access the data,and access controls to determine what type of access they have to the information.

Accepted Answer

Databases do indeed offer security features such as passwords, access levels, and access controls to protect the information stored within them.

Question 9

Information can tell an organisation how it is currently performing and help it estimate and strategise for future plans and performance.

Accepted Answer

Information provides insights into an organization's current performance, allowing it to make informed decisions regarding future strategies and plans.

Question 10

Which of the following is not a primary trait of information?
A) Transactional
B) Analytical
C) Timeliness
D) Quantity

Accepted Answer

Quantity is not a primary trait of information as it does not determine the quality or usefulness of the information. The other three options - transactional, analytical, and timeliness - are primary traits of information as they all contribute to the usefulness and relevance of the information.

Question 11

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Accepted Answer

A data-driven website can analyze customer data and behavior to personalize the information displayed, which can limit unnecessary information and help customers find what they are looking for more efficiently.

Question 12

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behaviour and guide decision making.

Accepted Answer

Data-mining tools are indeed designed to analyze vast amounts of data and identify patterns and trends that can be used to make informed decisions and predictions about future behavior.

Question 13

Zappos is an online shoe retailer that built its data-driven website catering to a specific niche market-consumers who were tired of finding that their most-desired items were always out of stock at traditional retailers.

Accepted Answer

Zappos is indeed an online shoe retailer that built its data-driven website to target a specific niche market of consumers who were frustrated with out-of-stock items at traditional retailers.

Question 14

If a manager identifies numerous data integrity issues he should consider the reports generated from that data as invalid and not use them when making decisions.

Accepted Answer

If there are data integrity issues, the accuracy and reliability of the reports cannot be guaranteed, and therefore they should not be relied upon for decision-making.

Question 15

The core components of any system,regardless of size,are a database and a database management system.

Accepted Answer

The answer of The core components of any system,regardless of...

Question 16

Many organisations find themselves in the position of being data rich and information poor.Even in today's electronic world,managers struggle with the challenge of turning their business data into business intelligence.

Accepted Answer

This statement is true. Many organizations have a vast amount of data but struggle with turning it into meaningful insights and intelligence that help to guide their business decisions.

Question 17

There are two main primary traits that help you determine the value of information including timeliness and quality.

Accepted Answer

There are four main primary traits that help you determine the value of information including timeliness,quality,type,and governance.

Question 18

A foreign key provides details about data.

Accepted Answer

A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table, primarily used to establish and enforce a link between the data in two tables, not to provide details about the data itself.

Question 19

Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Accepted Answer

Business intelligence software is becoming increasingly important for companies to analyze data and make informed decisions. While it may require a financial investment, it can ultimately lead to cost savings and improved efficiency.

Question 20

A data warehouse is a logical collection of information,gathered from many different operational databases,that supports business analysis activities and decision-making tasks.

Accepted Answer

This statement accurately describes what a data warehouse is.

Quiz 8: Databases-Business Intelligence