WGU D075 OA 2026/2027 EXAMS TEST PAPER QUESTIONS
AND ANSWERS GRADED A+
✔✔When using extract, transform, and load (ETL), what is done during the "transform"
step?
*The data are normalized and structured.
*The data are given context and relevance.
*The database is queried for relevant data.
*The database schema is designed and created. - ✔✔The data are normalized and
structured.
✔✔What is the key characteristic that differentiates a datamart from a data warehouse?
*A datamart uses centralized data storage while a data warehouse is decentralized.
*A datamart is a cloud-based service while a data warehouse requires a dedicated
server.
*A datamart is smaller and more specialized in its focus than a data warehouse.
*A datamart allows a broader set of data structures than a data warehouse. - ✔✔A
datamart is smaller and more specialized in its focus than a data warehouse.
✔✔A marketing employee is tasked with mailing discount coupons to the company's top
100 customers by sales volume. The marketing employee only has lists of customers'
names, customers' addresses, and the sales generated by each customer. Which
process should this employee use to ensure coupons are mailed to the correct
customers?
*Data structuring
*Data warehousing
*Data mining
*Data intelligence - ✔✔Data mining
✔✔What is the velocity of big data?
*The processing speed of the database servers
*The rate at which the data in a data set become decayed
*The speed of data produced in a given time
*The frequency with which the data set must be updated - ✔✔The speed of data
produced in a given time
✔✔What is it called when an organization implements security procedures to protect the
hardware, network, and software from intrusion?
*System-level security
*Access-level security
*Data-level security
*User-level security - ✔✔System-level security
✔✔Which term is used to refer to data that come from many different sources in various
structures?
, *Unstructured data
*Disparate data
*Semistructured data
*Source data - ✔✔Disparate data
✔✔What are scrubbed data?
*Data that are organized into database tables
*Data that have been validated for accuracy
*Data that have been eliminated because they are inconsistent
*Data that have been deleted for privacy reasons - ✔✔Data that have been validated for
accuracy
✔✔When a company spends money on data management, it uses a metric to measure
the benefit of this spending relative to the cost.
What is this metric called?
*Cost benefit analysis
*Return on investment
*Profit and loss
*Profitability ratio - ✔✔Return on investment
✔✔One perpetual issue with corporate data is ensuring the data are accurate and valid.
Procedures that apply to end users, managers, and IT personnel are often put in place
to ensure good data.
What is the term that describes this effort?
*Master data management
*Schema design
*Data governance
*Database management - ✔✔Data governance
✔✔Which level of management gets the most detailed reports directly from the
transaction processing system?
*Supervisors
*Managers
*Laborers
*Executive - ✔✔Supervisors
✔✔A large online retailer uses a decision support system (DSS) to develop scenarios
for the executive team to evaluate.
What is the primary source of the data used by this DSS?
*The human resource (HR) management system
*The business intelligence (BI) system
*The cloud web hosting (CWH) system
*The transaction processing system (TPS) - ✔✔The transaction processing system
(TPS)
AND ANSWERS GRADED A+
✔✔When using extract, transform, and load (ETL), what is done during the "transform"
step?
*The data are normalized and structured.
*The data are given context and relevance.
*The database is queried for relevant data.
*The database schema is designed and created. - ✔✔The data are normalized and
structured.
✔✔What is the key characteristic that differentiates a datamart from a data warehouse?
*A datamart uses centralized data storage while a data warehouse is decentralized.
*A datamart is a cloud-based service while a data warehouse requires a dedicated
server.
*A datamart is smaller and more specialized in its focus than a data warehouse.
*A datamart allows a broader set of data structures than a data warehouse. - ✔✔A
datamart is smaller and more specialized in its focus than a data warehouse.
✔✔A marketing employee is tasked with mailing discount coupons to the company's top
100 customers by sales volume. The marketing employee only has lists of customers'
names, customers' addresses, and the sales generated by each customer. Which
process should this employee use to ensure coupons are mailed to the correct
customers?
*Data structuring
*Data warehousing
*Data mining
*Data intelligence - ✔✔Data mining
✔✔What is the velocity of big data?
*The processing speed of the database servers
*The rate at which the data in a data set become decayed
*The speed of data produced in a given time
*The frequency with which the data set must be updated - ✔✔The speed of data
produced in a given time
✔✔What is it called when an organization implements security procedures to protect the
hardware, network, and software from intrusion?
*System-level security
*Access-level security
*Data-level security
*User-level security - ✔✔System-level security
✔✔Which term is used to refer to data that come from many different sources in various
structures?
, *Unstructured data
*Disparate data
*Semistructured data
*Source data - ✔✔Disparate data
✔✔What are scrubbed data?
*Data that are organized into database tables
*Data that have been validated for accuracy
*Data that have been eliminated because they are inconsistent
*Data that have been deleted for privacy reasons - ✔✔Data that have been validated for
accuracy
✔✔When a company spends money on data management, it uses a metric to measure
the benefit of this spending relative to the cost.
What is this metric called?
*Cost benefit analysis
*Return on investment
*Profit and loss
*Profitability ratio - ✔✔Return on investment
✔✔One perpetual issue with corporate data is ensuring the data are accurate and valid.
Procedures that apply to end users, managers, and IT personnel are often put in place
to ensure good data.
What is the term that describes this effort?
*Master data management
*Schema design
*Data governance
*Database management - ✔✔Data governance
✔✔Which level of management gets the most detailed reports directly from the
transaction processing system?
*Supervisors
*Managers
*Laborers
*Executive - ✔✔Supervisors
✔✔A large online retailer uses a decision support system (DSS) to develop scenarios
for the executive team to evaluate.
What is the primary source of the data used by this DSS?
*The human resource (HR) management system
*The business intelligence (BI) system
*The cloud web hosting (CWH) system
*The transaction processing system (TPS) - ✔✔The transaction processing system
(TPS)
