comptia data+ practice test Intermediate Practice Exam: Medium Difficulty 2025

A retail company wants analysts to run consistent revenue queries across web orders and in-store POS data. Source systems use different column names and data types for the same concepts (e.g., store_id as INT vs STRING). Which approach best supports consistent analytics while minimizing disruption to source systems?

A data engineer is designing a pipeline that ingests raw clickstream JSON files daily and also serves curated datasets to BI dashboards. Analysts need reproducible reporting, while data scientists want access to raw data for exploration. Which architecture best satisfies both needs?

A telecom company wants to identify customers likely to churn in the next 60 days. The target variable is churned (yes/no). The dataset includes tenure, billing amount, number of support tickets, and contract type. Which technique is most appropriate as a first model?

A dataset of online orders has 0.8% fraudulent transactions. A model achieves 99% accuracy but misses most fraud cases. Which metric should the analyst prioritize to better evaluate fraud detection performance?

A marketing team wants to discover which products are frequently purchased together to improve cross-sell recommendations. They have transaction-level basket data (each order contains multiple items). Which technique is the best fit?

An analyst is building a regression model to predict delivery time. They find that distance and fuel cost are highly correlated, making coefficients unstable across retrains. Which action best addresses this issue while keeping the model interpretable?

A product manager asks whether a new checkout flow improved conversion. The analyst has conversion rates from 50,000 users in the control group and 50,000 in the variant group. Which approach best determines whether the observed difference is statistically significant?

A dashboard shows monthly revenue by region using a stacked bar chart with 12 months and 8 regions. Users complain it is hard to compare regions across months. Which visualization change best improves comparability while keeping the same information?

An analyst is creating a heatmap of customer satisfaction by store and month. Some stores have very few survey responses, causing extreme values that dominate the color scale and mislead viewers. What is the best adjustment?

A healthcare analytics team is granted access to a dataset containing patient visits. They need to share trend reports with external partners while reducing privacy risk. Which control best supports sharing while aligning with data governance practices?