Question 1

What are the similarities and differences between a data warehouse and a data mart?

Accepted Answer

The answer of What are the similarities and differences between...

Question 2

An information policy specifies the procedures and rules for defining the structure and content of corporate databases.

Accepted Answer

An information policy primarily outlines the organization's rules regarding the creation, distribution, and use of information, rather than specifically detailing procedures for defining the structure and content of corporate databases.

Question 3

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

The answer of List and describe three main capabilities or...

Question 4

Redundant data often stems from the use of different codes to identify the same data in a firm's various information systems.

Accepted Answer

Redundant data can occur when the same information is stored multiple times or when different codes are used to represent the same data in different systems. This can lead to inconsistencies and inaccuracies in data analysis and reporting.

Question 5

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Accepted Answer

The answer of What are the differences between data mining...

Question 6

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Accepted Answer

The answer of Explain what big data refers to. What...

Question 7

Rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is referred to as:
A) data cleansing.
B) data mining.
C) an information policy.
D) logical database design.
E) a data quality audit.

Accepted Answer

Rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information are all part of an organization's information policy. Data cleansing refers to the process of identifying and correcting or removing errors or inconsistencies in data. Data mining is the process of analyzing large datasets to uncover patterns or relationships. Logical database design refers to the process of creating a database schema that reflects an organization's requirements. A data quality audit is an assessment of the accuracy, completeness, and consistency of data.

Question 8

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Accepted Answer

The answer of Imagine you are running a growing business...

Question 9

Data cleansing is the same process as data scrubbing.

Accepted Answer

Data cleansing and data scrubbing are interchangeable terms used to describe the process of identifying and correcting or removing inaccurate or incomplete data in a database or dataset.

Question 10

In linking databases to the web, the role of the application server is to host the DBMS.

Accepted Answer

The role of the application server is to run the web application's logic and facilitate the interaction between the user's requests from the web interface and the database, not to host the DBMS itself. The DBMS is typically hosted on a database server.

Question 11

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

Accepted Answer

The answer of Describe the ways in which database technologies...

Question 12

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:
A) data auditing.
B) defragmentation.
C) data scrubbing.
D) data optimization.
E) data repair.

Accepted Answer

Data scrubbing involves identifying and correcting any errors or inconsistencies in a database or file. This includes incorrect data, incomplete entries, improperly formatted fields, and redundant or duplicate entries. The goal is to ensure that the data is as accurate and reliable as possible for analysis and decision-making. Data auditing and optimization are related concepts, but they primarily focus on analyzing and improving the performance and security of a database rather than correcting errors. Defragmentation and data repair are not related to correcting errors in a database.

Question 13

Within a corporate information services department, the task of establishing the physical database and its logical relations are responsibilities of the ________ function.
A) data management
B) data administration
C) server administration
D) data modeling
E) database administration

Accepted Answer

The database administration function is responsible for establishing the physical database and its logical relations. This includes tasks such as designing, implementing, and maintaining the database structure and access permissions.

Question 14

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

Accepted Answer

A firm's information policy is responsible for setting out the roles and responsibilities of those responsible for updating and maintaining the information in a database system. Therefore, the statement is true.

Question 15

Why might you receive multiple pieces of the same piece of mail, or multiple emails featuring the same promotion?

Accepted Answer

The answer of Why might you receive multiple pieces of...

Question 16

Common data quality problems include all of the following except:
A) misspelled names.
B) transposed numbers.
C) incorrect codes.
D) missing codes.
E) Internet connectivity problems.

Accepted Answer

Internet connectivity problems do not directly affect data quality, as they are typically an issue with accessing the data rather than the data itself. The other options listed all directly impact the quality and accuracy of the data.

Question 17

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

Accepted Answer

Data administration is indeed a specialized function that deals with managing the policies and procedures related to data as an organizational resource. It is responsible for ensuring the accuracy, integrity, confidentiality, and availability of data, as well as creating and enforcing data-related standards and guidelines.

Question 18

A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.
A) data quality audit
B) systems analysis
C) systems audit
D) data analysis
E) data overview

Accepted Answer

A data quality audit is specifically designed to evaluate the accuracy and completeness of data in an information system. Systems analysis and systems audit focus more broadly on evaluating the performance and functionality of an entire system, while data analysis and data overview are general terms that do not necessarily connote a structured survey or evaluation process.

Question 19

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

Accepted Answer

The answer of What makes data mining an important business...

Question 20

List at least two ways that a business's data can become redundant or inconsistent.

Accepted Answer

The answer of List at least two ways that a...

Quiz 6: Foundations of Business Intelligence: Databases and Information Management