You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?
A. Synapse pipelines
B. a Synapse SQL pool
C. Synapse Link
D. Synapse Studio
Show Answer
Correct Answer: C
Explanation: Hybrid Transactional and Analytical Processing (HTAP) for Azure Cosmos DB with Azure Synapse Analytics is enabled through Azure Synapse Link. Synapse Link creates a near real-time analytical replica of Cosmos DB data that can be queried without ETL, which is the core requirement for HTAP. The other options are components of Synapse but do not by themselves enable HTAP on Cosmos DB data.
Question 160
You need to create a visualization of running sales totals per quarter as shown in the following exhibit.
What should you create in Power BI Desktop?
A. a waterfall chart
B. a ribbon chart
C. a bar chart
D. a decomposition tree
Show Answer
Correct Answer: A
Explanation: A waterfall chart is designed to show running totals over time, illustrating how sequential values (such as quarterly sales) cumulatively increase or decrease to reach a final total. This matches the requirement to visualize running sales totals per quarter.
Question 161
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Show Answer
Correct Answer: Yes
No
Yes
Explanation: Stream processing typically works on the most recent events or a rolling time window. Batch processing does not need to run immediately and usually has higher latency. Stream processing is commonly used for simple responses, aggregations, and calculations such as rolling averages.
Question 162
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Show Answer
Correct Answer: Azure Databricks is an Apache Spark-based analytics platform: Yes
Azure Analysis Services is used for transactional workloads: No
Azure Data Factory orchestrates data integration workflows: Yes
Explanation: Azure Databricks is built on Apache Spark for big data analytics. Azure Analysis Services supports analytical (OLAP) workloads, not transactional (OLTP) workloads. Azure Data Factory is designed to orchestrate and automate data integration and ETL/ELT workflows.
Question 163
DRAG DROP -
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Show Answer
Correct Answer: Analyzing historical web traffic from the previous year: Batch
Classifying images uploaded last month: Batch
Tracking real-time website users: Streaming
Explanation: Batch workloads process large, accumulated datasets at rest (historical analysis and past uploads). Streaming workloads process data continuously in real time (live user tracking).
Question 164
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema defined in a database
E. schema defined when reading unstructured data from a database
F. normalized data
Show Answer
Correct Answer: B, D, F
Explanation: OLTP systems are designed to support many concurrent, short-lived transactions that modify data. They typically involve frequent inserts, updates, and deletes (heavy writes with moderate reads), use a predefined schema enforced by the database, and store data in a normalized form to reduce redundancy and maintain transactional integrity. Denormalized data and read-heavy patterns are more characteristic of OLAP workloads, while schema-on-read applies to unstructured or analytical data stores rather than OLTP.
Question 165
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Show Answer
Correct Answer: No
No
Yes
Explanation: Dashboards can only be copied within the same workspace, not between workspaces.
A Power BI dashboard can include tiles from multiple datasets.
Dashboards can pin visuals from Excel workbooks (e.g., tables/charts) stored in OneDrive or SharePoint.
Question 166
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. a report page
B. a Microsoft PowerPoint slide
C. a visualization from a report
D. a dataflow
E. a text box
Show Answer
Correct Answer: A, C, E
Explanation: A Power BI dashboard can contain tiles pinned from report content and built-in widgets. You can pin an entire report page as a live tile, pin individual visualizations from a report, and add widgets such as a text box. PowerPoint slides and dataflows cannot be added to dashboards.
Question 167
You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?
A. a view
B. a report
C. a dataflow
D. Microsoft Power Apps
Show Answer
Correct Answer: B
Explanation: In Power BI, reports provide an interactive graphical interface with multiple visuals, support key performance indicators (KPIs), and allow users to explore data through features such as drill-down, drill-through, and filtering. Views and dataflows do not provide interactive visualization, and Power Apps is a separate application platform rather than a BI reporting tool.
Question 168
Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. report and dashboard creation
B. report sharing and distribution
C. data modeling
D. data acquisition and preparation
Show Answer
Correct Answer: A, B
Explanation: Power BI Service can be used to create reports (with web authoring) and to create dashboards, and it is the primary platform for sharing and distributing content. Data modeling and data acquisition/preparation are primarily performed in Power BI Desktop; while dataflows exist in the service, they do not fully replace Desktop for end‑to‑end modeling and preparation.
$19
Get all 282 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
