WGU D659 Objective Assessment 2025 – 96
QUESTIONS AND ANSWERS || COMPLETE
SOLUTIONS 100% GUARANTEED PASS
Description: The WGU D659 OA (96 questions, 2025 update) includes all verified
answers and rationale explanations. Covers data analytics fundamentals,
visualization, and statistical interpretation for business intelligence applications.
Keywords: WGU D659 Objective Assessment Data Analytics Business
Intelligence Statistical Analysis Verified Answers
1. What is the primary goal of Business Intelligence (BI)?
A) To perform advanced statistical modeling.
B) To support better business decision-making through data-driven insights.
C) To replace human decision-makers with automated systems.
D) To store large volumes of historical data.
2. Which data analytics type is focused on "what happened"?
A) Prescriptive Analytics
B) Predictive Analytics
C) Descriptive Analytics
D) Diagnostic Analytics
3. A dashboard showing monthly sales trends is an example of:
A) Predictive Analytics
B) Descriptive Analytics
C) Prescriptive Analytics
D) Cognitive Analytics
4. What is the term for data that has meaning and context?
A) Information
B) Knowledge
C) Wisdom
D) A datum
,5. In the data lifecycle, which phase involves removing inconsistencies and
errors?
A) Data Sourcing
B) Data Storage
C) Data Cleansing
D) Data Analysis
6. A dataset containing customer reviews in text form is an example of:
A) Structured Data
B) Semi-structured Data
C) Unstructured Data
D) Quantitative Data
7. Which of the following is a characteristic of a relational database?
A) It stores data in a network model.
B) It uses tables with rows and columns and enforces data integrity.
C) It is schema-less and highly flexible.
D) It is only suitable for small datasets.
8. What does SQL stand for?
A) Structured Question Language
B) Standard Query Logic
C) Structured Query Language
D) Sequential Query Listing
9. In a SQL query, which clause is used to filter rows?
A) SELECT
B) FROM
C) WHERE
D) GROUP BY
10. The SQL clause ORDER BY Last_Name DESC will sort the data:
A) Alphabetically from A to Z.
B) Alphabetically from Z to A.
C) By the most recent entry.
D) In a random order.
, 11. What is the primary purpose of data visualization?
A) To make reports look more colorful.
B) To communicate information clearly and efficiently through graphical means.
C) To replace all textual reporting.
D) To store data in a compressed format.
12. Which chart type is most effective for comparing parts of a whole?
A) Line Chart
B) Bar Chart
C) Scatter Plot
D) Pie Chart
13. A line chart is most appropriate for visualizing:
A) The distribution of a single variable.
B) The relationship between two categorical variables.
C) Trends over a continuous period, like time.
D) The correlation between two quantitative variables.
14. Which principle of good visualization advises against using 3D effects in a
simple bar chart?
A) Data-Ink Ratio
B) Chartjunk
C) Gestalt Principles
D) Pre-attentive Processing
15. What does ETL stand for in the context of data warehousing?
A) Extract, Transfer, Load
B) Extract, Transform, Load
C) Enter, Translate, Leave
D) Encode, Tag, Locate
16. The "Transform" step in ETL primarily involves:
A) Moving data from source to target.
B) Cleaning, standardizing, and integrating data.
QUESTIONS AND ANSWERS || COMPLETE
SOLUTIONS 100% GUARANTEED PASS
Description: The WGU D659 OA (96 questions, 2025 update) includes all verified
answers and rationale explanations. Covers data analytics fundamentals,
visualization, and statistical interpretation for business intelligence applications.
Keywords: WGU D659 Objective Assessment Data Analytics Business
Intelligence Statistical Analysis Verified Answers
1. What is the primary goal of Business Intelligence (BI)?
A) To perform advanced statistical modeling.
B) To support better business decision-making through data-driven insights.
C) To replace human decision-makers with automated systems.
D) To store large volumes of historical data.
2. Which data analytics type is focused on "what happened"?
A) Prescriptive Analytics
B) Predictive Analytics
C) Descriptive Analytics
D) Diagnostic Analytics
3. A dashboard showing monthly sales trends is an example of:
A) Predictive Analytics
B) Descriptive Analytics
C) Prescriptive Analytics
D) Cognitive Analytics
4. What is the term for data that has meaning and context?
A) Information
B) Knowledge
C) Wisdom
D) A datum
,5. In the data lifecycle, which phase involves removing inconsistencies and
errors?
A) Data Sourcing
B) Data Storage
C) Data Cleansing
D) Data Analysis
6. A dataset containing customer reviews in text form is an example of:
A) Structured Data
B) Semi-structured Data
C) Unstructured Data
D) Quantitative Data
7. Which of the following is a characteristic of a relational database?
A) It stores data in a network model.
B) It uses tables with rows and columns and enforces data integrity.
C) It is schema-less and highly flexible.
D) It is only suitable for small datasets.
8. What does SQL stand for?
A) Structured Question Language
B) Standard Query Logic
C) Structured Query Language
D) Sequential Query Listing
9. In a SQL query, which clause is used to filter rows?
A) SELECT
B) FROM
C) WHERE
D) GROUP BY
10. The SQL clause ORDER BY Last_Name DESC will sort the data:
A) Alphabetically from A to Z.
B) Alphabetically from Z to A.
C) By the most recent entry.
D) In a random order.
, 11. What is the primary purpose of data visualization?
A) To make reports look more colorful.
B) To communicate information clearly and efficiently through graphical means.
C) To replace all textual reporting.
D) To store data in a compressed format.
12. Which chart type is most effective for comparing parts of a whole?
A) Line Chart
B) Bar Chart
C) Scatter Plot
D) Pie Chart
13. A line chart is most appropriate for visualizing:
A) The distribution of a single variable.
B) The relationship between two categorical variables.
C) Trends over a continuous period, like time.
D) The correlation between two quantitative variables.
14. Which principle of good visualization advises against using 3D effects in a
simple bar chart?
A) Data-Ink Ratio
B) Chartjunk
C) Gestalt Principles
D) Pre-attentive Processing
15. What does ETL stand for in the context of data warehousing?
A) Extract, Transfer, Load
B) Extract, Transform, Load
C) Enter, Translate, Leave
D) Encode, Tag, Locate
16. The "Transform" step in ETL primarily involves:
A) Moving data from source to target.
B) Cleaning, standardizing, and integrating data.
