Operational Procedures practice questions

A business analyst is asked to distinguish between KPIs and metrics for a new dashboard. According to CompTIA Data+, which TWO statements correctly differentiate KPIs from metrics? (Choose two.)

Trap 1: KPIs and metrics are interchangeable terms

They are distinct; KPIs are a subset of metrics tied to strategy.

Trap 2: Metrics are always more important than KPIs

KPIs are typically more important at a strategic level.

Trap 3: KPIs are always lagging indicators

KPIs can be leading or lagging.

A
KPIs and metrics are interchangeable terms
Why wrong: They are distinct; KPIs are a subset of metrics tied to strategy.
B
Metrics are always more important than KPIs
Why wrong: KPIs are typically more important at a strategic level.
C
KPIs are directly tied to strategic business objectives
Correct. KPIs measure progress toward strategic goals.
D
Metrics are operational measurements that may not be strategic
Correct. Metrics are detailed operational data.
E
KPIs are always lagging indicators
Why wrong: KPIs can be leading or lagging.

Question 2mediummultiple choice

A data engineer is designing an ETL pipeline to extract sales data from a legacy on-premise database and load it into a cloud data warehouse. The database is slow and queries during business hours affect performance. Which extraction strategy minimizes impact?

Trap 1: Query the database with SELECT * every hour

Frequent full queries overload the database and worsen performance impact.

Trap 2: Full table extraction nightly

Nightly full extraction still consumes significant resources and may not be incremental enough.

Trap 3: Use a database log shipping

Log shipping is for replication, not typically for ETL extraction, and may not be suitable for incremental loading.

A
Query the database with SELECT * every hour
Why wrong: Frequent full queries overload the database and worsen performance impact.
B
Incremental extraction using Change Data Capture (CDC)
CDC minimizes database load by extracting only changed data, reducing performance impact.
C
Full table extraction nightly
Why wrong: Nightly full extraction still consumes significant resources and may not be incremental enough.
D
Use a database log shipping
Why wrong: Log shipping is for replication, not typically for ETL extraction, and may not be suitable for incremental loading.

Question 3easymultiple choice

Which of the following is a key performance indicator (KPI) tied to a strategic objective, as opposed to a metric?

Trap 1: Average handle time

This is an operational metric.

Trap 2: Number of daily logins

This is an operational metric, not a strategic KPI.

Trap 3: Server uptime percentage

This is an operational metric.

A
Average handle time
Why wrong: This is an operational metric.
B
Customer satisfaction score (CSAT) as a strategic goal
CSAT can be a KPI if tied to strategic objective of improving customer experience.
C
Number of daily logins
Why wrong: This is an operational metric, not a strategic KPI.
D
Server uptime percentage
Why wrong: This is an operational metric.

Question 4easymultiple choice

A dashboard should be designed so that the most important metric is prominently displayed. This is an example of which design principle?

Trap 1: Data-ink ratio

Data-ink ratio is about minimizing non-data ink.

Trap 2: Consistent color coding

Color coding is about using colors consistently, not about prominence.

Trap 3: Appropriate precision

Precision is about avoiding unnecessary decimal places.

A
Data-ink ratio
Why wrong: Data-ink ratio is about minimizing non-data ink.
B
Consistent color coding
Why wrong: Color coding is about using colors consistently, not about prominence.
C
Appropriate precision
Why wrong: Precision is about avoiding unnecessary decimal places.
D
Visual hierarchy
Visual hierarchy arranges elements by importance.

Question 5mediummultiple choice

A manager in operations needs a real-time dashboard showing production line status, including machine uptime and error counts. Which type of report is most appropriate?

Trap 1: Analytical report

Analytical reports are exploratory and not real-time.

Trap 2: Ad hoc report

Ad hoc reports are on-demand, but not necessarily real-time.

Trap 3: Scheduled report

Scheduled reports are periodic, not real-time.

A
Analytical report
Why wrong: Analytical reports are exploratory and not real-time.
B
Ad hoc report
Why wrong: Ad hoc reports are on-demand, but not necessarily real-time.
C
Scheduled report
Why wrong: Scheduled reports are periodic, not real-time.
D
Operational report
Operational reports deliver real-time status for operations.

Question 6easymultiple choice

Which of the following is a key difference between a Key Performance Indicator (KPI) and a metric?

Trap 1: Metrics are always quantitative, while KPIs can be qualitative

Both are typically quantitative.

Trap 2: There is no difference; the terms are interchangeable

They are not interchangeable; KPIs are specifically linked to strategic goals.

Trap 3: KPIs are always lagging indicators, while metrics are leading…

Both can be leading or lagging; the distinction is not about leading vs lagging.

A
Metrics are always quantitative, while KPIs can be qualitative
Why wrong: Both are typically quantitative.
B
There is no difference; the terms are interchangeable
Why wrong: They are not interchangeable; KPIs are specifically linked to strategic goals.
C
KPIs are tied to strategic objectives, while metrics are broader operational measurements
Correct. KPIs are a subset of metrics that are critical to strategic success.
D
KPIs are always lagging indicators, while metrics are leading indicators
Why wrong: Both can be leading or lagging; the distinction is not about leading vs lagging.

Question 7hardmulti select

Which TWO of the following are primary benefits of implementing a data governance program?

Trap 1: Faster data processing speed

Processing speed is more related to infrastructure than governance.

Trap 2: Increased data volume

Governance does not aim to increase volume; it manages existing data.

Trap 3: Lower storage costs

Governance may lead to better storage utilization but cost reduction is not a primary benefit.

A
Faster data processing speed
Why wrong: Processing speed is more related to infrastructure than governance.
B
Increased data volume
Why wrong: Governance does not aim to increase volume; it manages existing data.
C
Improved data quality and consistency
Governance establishes standards that enhance quality and consistency.
D
Lower storage costs
Why wrong: Governance may lead to better storage utilization but cost reduction is not a primary benefit.
E
Reduced data redundancy
Governance helps eliminate duplicate data across systems.

Question 8hardmultiple choice

A data analyst is building a dashboard that will be used by both executives and operational managers. The executives need high-level summaries, while managers need granular details. Which dashboard design principle should the analyst apply?

Trap 1: Use a single chart that shows both summary and detail…

Combining both in one chart often results in clutter.

Trap 2: Display all available data on one page for transparency.

Information overload reduces usability.

Trap 3: Create two separate dashboards for each audience.

Separate dashboards may lead to data inconsistency and duplication.

A
Use a single chart that shows both summary and detail simultaneously.
Why wrong: Combining both in one chart often results in clutter.
B
Display all available data on one page for transparency.
Why wrong: Information overload reduces usability.
C
Design the dashboard with drill-down capabilities from summary to detail.
Drill-down allows executives to see overview and managers to access details on demand.
D
Create two separate dashboards for each audience.
Why wrong: Separate dashboards may lead to data inconsistency and duplication.

Question 9easymultiple choice

Which report type is best suited for monitoring the real-time status of manufacturing equipment on the factory floor?

Trap 1: Scheduled report

Scheduled reports are not real-time.

Trap 2: Self-service report

Self-service reports are user-generated, not automatically updated in real-time.

Trap 3: Analytical report

Analytical reports are for deep exploration, not real-time monitoring.

A
Scheduled report
Why wrong: Scheduled reports are not real-time.
B
Self-service report
Why wrong: Self-service reports are user-generated, not automatically updated in real-time.
C
Analytical report
Why wrong: Analytical reports are for deep exploration, not real-time monitoring.
D
Operational report
Operational reports deliver real-time status for day-to-day operations.

Question 10mediummultiple choice

A data team is designing an ETL process to extract data from an operational database daily. The database experiences heavy write loads during business hours. What is the best practice to minimize impact on operations?

Trap 1: Extract directly from the primary database with high priority

High priority extraction can still degrade performance.

Trap 2: Run the extraction during peak hours to ensure data freshness

Running during peak hours maximizes impact on operations.

Trap 3: Schedule extraction at midnight when load is low

Even at low load, extracting from primary can still cause contention.

A
Extract directly from the primary database with high priority
Why wrong: High priority extraction can still degrade performance.
B
Run the extraction during peak hours to ensure data freshness
Why wrong: Running during peak hours maximizes impact on operations.
C
Schedule extraction at midnight when load is low
Why wrong: Even at low load, extracting from primary can still cause contention.
D
Use replication or a read replica to extract data
Read replicas are designed for such purposes and do not affect the primary.

Question 11hardmultiple choice

A data analyst needs to design a report for two audiences: executives want a high-level trend, and operational managers need current inventory levels. Which approach best satisfies both?

Trap 1: Include all details in one report so everyone sees the same…

Executives may be overwhelmed with detail, and operational managers may not find the trend useful.

Trap 2: Send only the operational dashboard and let executives derive…

Executives need summarized trends, not raw data.

Trap 3: Ask the stakeholders to agree on a single view.

May not satisfy either audience fully; best practice is to tailor.

A
Include all details in one report so everyone sees the same information.
Why wrong: Executives may be overwhelmed with detail, and operational managers may not find the trend useful.
B
Send only the operational dashboard and let executives derive trends.
Why wrong: Executives need summarized trends, not raw data.
C
Ask the stakeholders to agree on a single view.
Why wrong: May not satisfy either audience fully; best practice is to tailor.
D
Create two separate reports: an executive summary with trends and an operational dashboard with real-time inventory.
Tailors content to each audience's needs.

Question 12hardmultiple choice

A large financial institution is implementing a data governance framework to comply with new regulations requiring strict control over sensitive customer data. The data governance committee has identified several domains, including customer master data, transaction data, and risk assessment data. They need to decide on a master data management (MDM) approach that ensures a single, authoritative source of customer information across all systems. However, the current environment has multiple legacy systems with conflicting customer records. The committee is concerned about downtime and business disruption during the transition. Which MDM approach best balances data consistency with minimal operational impact?

Trap 1: Centralized MDM, which replaces all systems with one central master…

Incorrect: Centralized MDM is highly disruptive and requires full migration.

Trap 2: Consolidation MDM, which merges all customer data into a single…

Incorrect: Consolidation requires data migration and can cause downtime.

Trap 3: Coexistence MDM, which maintains multiple masters with…

Incorrect: Coexistence does not enforce a single source of truth.

A
Registry MDM, which creates a virtual view by linking records without moving data.
Correct: Registry avoids disruption by leaving data in place and creating a unified index.
B
Centralized MDM, which replaces all systems with one central master system.
Why wrong: Incorrect: Centralized MDM is highly disruptive and requires full migration.
C
Consolidation MDM, which merges all customer data into a single physical hub.
Why wrong: Incorrect: Consolidation requires data migration and can cause downtime.
D
Coexistence MDM, which maintains multiple masters with synchronization.
Why wrong: Incorrect: Coexistence does not enforce a single source of truth.