DP-900 practice question 3 of 35
A bar chart showing year-to date sales by region is an example of which type of analytics?
Full set: 303 questionsDomain Describe an analytics workload on Azure
A bar chart showing year-to-date sales by region is an example of descriptive analytics. This type of analytics focuses on summarizing historical data to provide a clear view of what has happened. The chart describes the past performance of sales across different regions without explaining the cause or predicting future outcomes. It answers the fundamental question, "What happened?". This is a common use case for business intelligence reports and dashboards, which are primary tools for descriptive analysis.
B. diagnostic: This is incorrect because the chart shows what happened, not why it happened. Diagnostic analytics would involve investigating the reasons behind the sales figures.
C. predictive: This is incorrect because the chart displays historical data. Predictive analytics uses this data to forecast what is likely to happen in the future.
D. prescriptive: This is incorrect because the chart does not recommend any actions. Prescriptive analytics suggests specific actions to achieve a desired outcome. ---
1. Microsoft Learn. (2024). Describe types of core data workloads - DP-900. Microsoft.
Section: Types of data analytics
Details: The documentation explicitly defines descriptive analytics as the process that answers the question, "What happened?". It states, "This is the most common type of data analytics... Business reports with visualizations such as pie charts, bar charts, line charts, tables, or generated narratives are all examples of descriptive analytics." This directly maps the question's scenario (a bar chart of sales) to the definition of descriptive analytics. The same document defines diagnostic, predictive, and prescriptive analytics in ways that exclude them as the correct answer.
Keep practicing
Take the free DP-900 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DP-900 practice questions
- Question 5You have a transactional application that stem data in an Azure SQL managed instance. Whe…
- Question 8Which Azure SQL offering supports automatic database scaling and automatic pausing of the…
- Question 10What is used to define a query in a stream processing jobs in Azure Stream Analytics?
- Question 12Which Azure storage solution provides native support for POSIX-compliant access control l…
- Question 15You have an e-commerce application that reads and writes data to an Azure SQL database. W…
- Question 19Your company needs to design a database that illustrates the relationships between utiliz…
