DAC Fundamentals of Data Analytics 2 — Questions and Answers
Question 1: Which type of analytics answers the question 'What happened?'
- Descriptive analytics (Correct answer)
- Predictive analytics
- Prescriptive analytics
- Diagnostic analytics
Correct answer: Descriptive analytics
Descriptive analytics summarizes historical data to describe what happened.
Question 2: A data analyst wants to understand WHY sales dropped last quarter. Which analytics type applies?
- Descriptive analytics
- Diagnostic analytics (Correct answer)
- Predictive analytics
- Prescriptive analytics
Correct answer: Diagnostic analytics
Diagnostic analytics investigates the causes behind an observed outcome.
Question 3: What is the primary purpose of data cleaning?
- To visualize trends
- To remove errors, duplicates, and inconsistencies (Correct answer)
- To increase dataset size
- To encrypt sensitive fields
Correct answer: To remove errors, duplicates, and inconsistencies
Data cleaning improves quality by fixing errors, duplicates, and inconsistencies.
Question 4: Which measure of central tendency is most affected by outliers?
- Median
- Mode
- Mean (Correct answer)
- Range
Correct answer: Mean
The mean shifts significantly when extreme values are present.
Question 5: In a dataset, 'structured data' refers to information that is:
- Stored in emails and documents
- Organized in rows and columns (Correct answer)
- Only images and video
- Never queryable
Correct answer: Organized in rows and columns
Structured data fits neatly into rows and columns, like a database table.
Question 6: What does the acronym KPI stand for in analytics?
- Key Process Indicator
- Key Performance Indicator (Correct answer)
- Known Priority Item
- Key Product Index
Correct answer: Key Performance Indicator
A KPI is a Key Performance Indicator used to measure progress toward goals.
Question 7: Which chart type is best for showing the composition of a whole at a single point in time?
- Line chart
- Pie chart (Correct answer)
- Scatter plot
- Histogram
Correct answer: Pie chart
A pie chart displays parts of a whole as proportional slices.
DAC Fundamentals of Data Analytics 2
Which type of analytics answers the question 'What happened?'