Data Analysis
A report summarizes what happened last quarter, showing total sales, average order value, and month-over-month change. Which type of analytics is this?
- APrescriptive analytics
- BPredictive analytics
- CDescriptive analyticsCorrect
- DDiagnostic analytics
Why: Descriptive analytics summarizes what has already happened using measures such as totals and averages. Diagnostic analytics explains why it happened, predictive forecasts what will happen, and prescriptive recommends what action to take.
Data Mining
During data preparation, an analyst finds the same customer recorded three times with identical details. Which data-cleansing task removes these repeats?
- ANormalization of numeric ranges
- BImputation
- CAggregation
- DDeduplicationCorrect
Why: Deduplication removes duplicate records so each entity appears once, preventing inflated counts and skewed analysis. Imputation fills in missing values, normalization rescales numeric ranges, and aggregation summarizes groups; none of those address duplicate rows.