Question 1

In terms of the major functions performed by a DBMS, data synchronization refers to which of the following?
A) Correcting, standardizing, and verifying the integrity of the data.
B) Integrating, matching, or linking data from disparate sources.
C) Enhancing data using information from internal and external data sources.
D) Checking and controlling data integrity over time.

Accepted Answer

Data synchronization refers to the process of integrating, matching, or linking data from disparate sources into a single consistent view. This involves ensuring that duplicate data is identified and eliminated, and that any inconsistencies or conflicts between different data sources are resolved. Data synchronization is a key function of a DBMS, as it allows users to access and query data from multiple sources as if it were all stored in a single location.

Question 2

According to your text, which of the following is not a major data function performed by a DBMS?
A) Data filtering and profiling
B) Data integrity
C) Data synchronization
D) Data analysis

Accepted Answer

The three major data functions performed by a DBMS are data filtering and profiling, data integrity, and data synchronization. While data analysis is an important function for utilizing the data stored in the DBMS, it is not considered a major data function performed by the DBMS itself.

Question 3

In terms of the major functions performed by a DBMS, "data filtering and profiling" refers to which of the following?
A) Inspecting the data for errors, inconsistencies, redundancies, and incomplete information.
B) Correcting, standardizing, and verifying the integrity of the data.
C) Integrating, matching, or linking data from disparate sources.
D) Checking and controlling data integrity over time.

Accepted Answer

Data filtering and profiling involves inspecting the data for errors, inconsistencies, redundancies, and incomplete information. This helps to identify and clean up any problematic data before it is stored in the database.

Question 4

MDM consolidates data from various data sources into a ___________________, which then feeds data back to the applications, thereby creating accurate and consistent data across the enterprise. This helps eliminate redundancies, inaccuracies and omissions that might otherwise hinder business processes.
A) Multi-source data file
B) Master reference file
C) Maximized data file
D) Mission central directory

Accepted Answer

MDM typically creates a Master Reference File, which serves as the authoritative source of data for the enterprise. This file consolidates data from various sources and provides a unified view of data that can be used by different applications across the organization. This helps to ensure data consistency and accuracy, which in turn improves business operations and decision making. The other options presented (A, C, and D) do not accurately describe the data consolidation process that takes place in MDM.

Question 5

There are three kinds of enterprise data. Which of the following is not one of the types of enterprise data identified in your text?
A) Transactional data
B) Master data
C) Functional data
D) Analytical data

Accepted Answer

The three kinds of enterprise data identified in the text are transactional data, master data, and analytical data. There is no mention of functional data as one of the types of enterprise data.

Question 6

According to your text, ___________________ are responsible for increasing the cost of health care by billions of dollars, not to mention, putting lives at risk.
A) Data errors
B) Physicians who refuse to convert paper files to digital files
C) Outdated computers
D) Untrained or under-trained medical staff

Accepted Answer

The text mentions that data errors are responsible for increasing the cost of health care by billions of dollars and putting lives at risk. The other options, such as physicians who refuse to convert paper files to digital and outdated computers, may contribute to inefficiencies in the healthcare system but are not explicitly mentioned as responsible for increasing costs and putting lives at risk. Untrained or under-trained medical staff may also contribute to errors but are not the only cause mentioned in the text.

Question 7

In terms of the major functions performed by a DBMS, data enrichment refers to which of the following?
A) Correcting, standardizing, and verifying the integrity of the data.
B) Integrating, matching, or linking data from disparate sources.
C) Enhancing data using information from internal and external data sources.
D) Checking and controlling data integrity over time.

Accepted Answer

Data enrichment refers to the process of enhancing data using information from internal and external data sources. This involves supplementing existing data with additional data to provide a more complete picture of the data being analyzed. This can help improve data quality and provide more valuable insights for decision-making. Options A, B, and D refer to other functions of a DBMS such as data cleaning, data integration, and data maintenance.

Question 8

In terms of the major functions performed by a DBMS, "maintaining data integrity" refers to which of the following?
A) Inspecting the data for errors, inconsistencies, redundancies, and incomplete information.
B) Integrating, matching, or linking data from disparate sources.
C) Correcting, standardizing, and verifying the integrity of the data.
D) Checking and controlling data integrity over time.

Accepted Answer

Correcting, standardizing, and verifying the integrity of the data.

Question 9

A majority of data is seldom accessed after a 3 month period. Which of the following principles is based on this observation?
A) Principle of data in context
B) Principle of 90/90 data use
C) Principle of diminishing data value
D) Principle of data quality

Accepted Answer

The principle of 90/90 data use suggests that 90% of data is rarely accessed after the first 90 days of its creation, aligning with the observation that a majority of data is seldom accessed after a 3-month period.

Question 10

Sometimes organizations place too much emphasis on the costs associated with acquiring high levels of data quality and ignore the costs of "dirty" or poor quality data. According to your text, what three factors make up the total costs associated with poor quality data?
A) Technology costs + Training costs + Marketing costs
B) Value of lost business + Cost to prevent errors + Cost to correct errors
C) Cost of repeating analyses + Lost opportunity costs + Cost of unrealized threats
D) Value of lost business + Cost to correct errors + Cost of repeating analyses on corrected data)

Accepted Answer

The three factors that make up the total costs associated with poor quality data are: Value of lost business, Cost to prevent errors, and Cost to correct errors.

Question 11

Data in databases are said to be volatile because ____________________.
A) Faulty data storage technology sometimes overwrites or deletes data accidently.
B) Of issues related primarily to "human error".
C) Of rounding errors or software apps that lack the appropriate precision when making calculations.
D) Data is constantly being added or updated by new transactions.

Accepted Answer

Data in databases are said to be volatile because data is constantly being added or updated by new transactions. This means that the data is always changing and can be temporary or constantly updated, making it volatile.

Question 12

In terms of the major functions performed by a DBMS, data maintenance refers to which of the following?
A) Correcting, standardizing, and verifying the integrity of the data.
B) Integrating, matching, or linking data from disparate sources.
C) Enhancing data using information from internal and external data sources.
D) Checking and controlling data integrity over time.

Accepted Answer

The answer of In terms of the major functions performed...

Question 13

The data ____________________ is a model that illustrates the way in which data moves through an organization.
A) Life cycle
B) Pathway
C) Flow chart
D) Flow plan

Accepted Answer

The data life cycle is a model that illustrates the way in which data moves through an organization, detailing the stages from creation and initial storage to the time when it becomes obsolete and is deleted.

Question 14

Which of the following is not one of the costs of "dirty" or poor quality data cited in your text?
A) Value of lost business
B) Cost to prevent errors
C) Cost to correct errors
D) Cost of repeating analyses on corrected data)

Accepted Answer

The answer of Which of the following is not one...

Question 15

Which of the following is not a stage in the data life cycle model?
A) Data sources and data bases
B) Data storage
C) Data cleaning and verification
D) Data analysis

Accepted Answer

The answer of Which of the following is not a...

Question 16

Because of data _______________ in a database that is constantly being updated with real-time transactions, data must be exported to a data warehouse prior to data mining, use by DSS apps and business intelligence analyses.
A) Chaos
B) Errors
C) Volatility
D) Security

Accepted Answer

Volatility refers to the constant changes and updates in a database, which can cause inconsistencies and make it difficult to perform data mining and analysis. Exporting data to a data warehouse before using it for decision-making purposes helps to ensure data accuracy and consistency.

Question 17

__________________________ is a set of processes that aid organizations in integrating data from various sources or enterprise applications to create and maintain a more unified view of a customer, product, or other core data entity that is shared across systems.
A) Universal data management UDM)
B) Unified data management UDM)
C) Master data management MDM)
D) Integrated data management IDM)

Accepted Answer

Master data management (MDM) is the set of processes used to create and maintain a single, accurate, and consistent version of an organization's data assets such as customer, product, or supplier information. MDM helps organizations integrate data from various sources and provides a unified view of critical data entities that can be shared across various systems. Universal data management, unified data management, and integrated data management do not specifically address the need for maintaining a single, accurate version of critical data entities.

Question 18

Most organizations cannot operate at peak performance with blind spots lack of data availability) of 30 days or longer. For instance, many global financial services institutions need near real time data for peak performance. This is due to which of the following principles?
A) Principle of data in context
B) Principle of 90/90 data use
C) Principle of diminishing data value
D) Principle of data quality

Accepted Answer

The principle of diminishing data value explains this situation. As time passes, the value of data decreases, especially in fast-paced environments like global financial services where real-time or near-real-time data is crucial for making timely decisions and maintaining peak performance.

Question 19

Despite the need for high-quality data, _________________ and technical issues often make it a difficult goal to achieve.
A) High costs
B) Untrained or undertrained IT personnel
C) User errors
D) Organizational politics

Accepted Answer

The answer of Despite the need for high-quality data, _________________...

Question 20

The process of moving data from a transactional database to a data warehouse can be complex because of the need to integrate data from multiple sources or enterprise applications. _____________ serves as a layer between transactional data in a database and analytical data in a data warehouse.
A) Transient data
B) Master data
C) Integrated data
D) Unified data

Accepted Answer

The answer of The process of moving data from a...

Quiz 3: Database, Data Warehouse, and Data Mining

In terms of the major functions performed by a DBMS, data synchronization refers to which of the following?

According to your text, which of the following is not a major data function performed by a DBMS?

In terms of the major functions performed by a DBMS, "data filtering and profiling" refers to which of the following?

There are three kinds of enterprise data. Which of the following is not one of the types of enterprise data identified in your text?

According to your text, ___________________ are responsible for increasing the cost of health care by billions of dollars, not to mention, putting lives at risk.

In terms of the major functions performed by a DBMS, data enrichment refers to which of the following?

In terms of the major functions performed by a DBMS, "maintaining data integrity" refers to which of the following?

A majority of data is seldom accessed after a 3 month period. Which of the following principles is based on this observation?

Sometimes organizations place too much emphasis on the costs associated with acquiring high levels of data quality and ignore the costs of "dirty" or poor quality data. According to your text, what three factors make up the total costs associated with poor quality data?

Data in databases are said to be volatile because ____________________.

In terms of the major functions performed by a DBMS, data maintenance refers to which of the following?

The data ____________________ is a model that illustrates the way in which data moves through an organization.

Which of the following is not one of the costs of "dirty" or poor quality data cited in your text?

Which of the following is not a stage in the data life cycle model?

Because of data _______________ in a database that is constantly being updated with real-time transactions, data must be exported to a data warehouse prior to data mining, use by DSS apps and business intelligence analyses.

__________________________ is a set of processes that aid organizations in integrating data from various sources or enterprise applications to create and maintain a more unified view of a customer, product, or other core data entity that is shared across systems.

Most organizations cannot operate at peak performance with blind spots lack of data availability) of 30 days or longer. For instance, many global financial services institutions need near real time data for peak performance. This is due to which of the following principles?

Despite the need for high-quality data, _________________ and technical issues often make it a difficult goal to achieve.

The process of moving data from a transactional database to a data warehouse can be complex because of the need to integrate data from multiple sources or enterprise applications. _____________ serves as a layer between transactional data in a database and analytical data in a data warehouse.