Question 1

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 2

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

Accepted Answer

Data governance is indeed the set of policies, processes, and standards for ensuring the accuracy, completeness, consistency, availability, and security of data in an organization. It encompasses various activities, such as data quality management, metadata management, data classification, data security and privacy, data usage and access policies, data lifecycle management, and regulatory compliance. The goal of data governance is to maximize the value of data assets while minimizing the risks associated with their use.

Question 3

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 4

Data scrubbing is a more intensive corrective process than data cleansing.

Accepted Answer

The answer of Data scrubbing is a more intensive corrective...

Question 5

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?
A)Data normalization
B)Data accuracy
C)Data redundancy
D)Data inconsistency
E)Data duplication

Accepted Answer

This scenario illustrates the challenge of data inconsistency, as the person's name is not standardized and consistent across the different copies of the catalog.

Question 6

An organization's rules for sharing,disseminating,acquiring,standardizing,classifying,and inventorying information is called a(n):
A)information policy.
B)data definition file.
C)data quality audit.
D)data governance policy.
E)data policy.

Accepted Answer

The answer of An organization's rules for sharing,disseminating,acquiring,standardizing,classifying,and inventorying information...

Question 7

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 normalization.

Accepted Answer

Data scrubbing, also known as data cleansing, is the process of detecting and correcting or removing inaccurate, incomplete, improperly formatted, or duplicated data in a database or file. This process helps ensure data accuracy, consistency, and reliability. Data auditing is a related process of examining data to identify errors or issues, but it does not necessarily involve correcting them. Defragmentation and data optimization typically refer to improving the performance of physical storage devices, such as hard drives, and are not directly related to data integrity. Data normalization is a process of organizing data in a database by eliminating redundant data and ensuring consistency across tables, but it is not specifically focused on identifying and correcting data errors.

Question 8

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 9

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Accepted Answer

High-speed analytic platforms often use a combination of relational and non-relational tools to analyze large datasets, allowing for flexibility and scalability in data analysis.

Question 10

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

Accepted Answer

The answer of Distributors for a furniture manufacturer are complaining...

Question 11

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

Accepted Answer

The answer of Explain what the term big data refers...

Question 12

Which of the following is not a method for performing a data quality audit?
A)Surveying entire data files
B)Surveying samples from data files
C)Surveying data definition and query files
D)Surveying end users about their perceptions of data quality
E)Surveying managers about their perceptions of data quality

Accepted Answer

Surveying data definition and query files is not typically considered a method for performing a data quality audit. Data quality audits usually focus on the actual data content, its accuracy, completeness, and the perceptions of its users, rather than the technical definitions or queries used to manipulate the data.

Question 13

List three ways that a business's data can become redundant or inconsistent.

Accepted Answer

The answer of List three ways that a business's data...

Question 14

You have been hired by a furniture leasing company to implement its first business intelligence systems and infrastructure.To prepare for your initial report,describe the types of data the firm can use to support business intelligence and the systems that you will implement to support both power users and casual users,and explain how these systems or tools work together.

Accepted Answer

The answer of You have been hired by a furniture...

Question 15

In a large organization,which of the following functions would be responsible for physical database design and maintenance?
A)Data administration
B)Database administration
C)Information policy administration
D)Data auditing
E)Database management

Accepted Answer

Database administration is responsible for physical database design and maintenance in a large organization, including tasks such as database backup and recovery, database security, and performance tuning. Data administration is more focused on data governance and ensuring data quality, while information policy administration is responsible for creating and enforcing organizational policies around data management. Data auditing involves reviewing and verifying data for accuracy and completeness, and database management encompasses a broader set of responsibilities including managing database software and applications.

Question 16

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

Accepted Answer

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

Question 17

Data cleansing not only corrects errors but also:
A)establishes logical relationships between data.
B)structures data.
C)normalizes data.
D)removes duplicate data.
E)enforces consistency among different sets of data.

Accepted Answer

The answer of Data cleansing not only corrects errors but...

Question 18

What is an information policy and why is it needed in a firm?

Accepted Answer

The answer of What is an information policy and why...

Question 19

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 20

In a large organization,which of the following functions would be responsible for policies and procedures for managing internal data resources?
A)Data administration
B)Database administration
C)Information policy administration
D)Data auditing
E)Database management

Accepted Answer

The answer of In a large organization,which of the following...

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

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

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

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

Data scrubbing is a more intensive corrective process than data cleansing.

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

An organization's rules for sharing,disseminating,acquiring,standardizing,classifying,and inventorying information is called a(n) :

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called:

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?

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

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

Which of the following is not a method for performing a data quality audit?

List three ways that a business's data can become redundant or inconsistent.

In a large organization,which of the following functions would be responsible for physical database design and maintenance?

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

Data cleansing not only corrects errors but also:

What is an information policy and why is it needed in a firm?

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

In a large organization,which of the following functions would be responsible for policies and procedures for managing internal data resources?