HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A data analyst
Explanation: Data analysts explore and analyze data, then create visualizations and charts that help organizations make informed business decisions. Data engineers build data infrastructure, data scientists develop advanced models, and database administrators manage databases.
Question 142
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: Azure Synapse Link is the feature designed to enable hybrid transactional and analytical processing (HTAP) for Azure Cosmos DB by providing a near real-time analytical store that Azure Synapse Analytics can query without ETL. Synapse pipelines orchestrate data movement, SQL pools execute queries but are not the HTAP integration feature, and Synapse Studio is the development interface.
Question 143
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 a running total by displaying how each period's increase or decrease contributes to the cumulative value. This matches a visualization of running sales totals per quarter. Ribbon charts show rank changes, bar charts show simple comparisons, and decomposition trees are for drill-down analysis.
Question 144
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 operates on the latest data or a rolling time window. Batch processing is not immediate and generally has higher latency. Stream processing commonly handles simple responses, aggregations, and rolling calculations such as rolling averages.
Question 145
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: Azure Databricks is an Apache Spark-based analytics platform. Azure Analysis Services is for analytical/semantic modeling, not transactional workloads. Azure Data Factory orchestrates data integration and ETL/ELT workflows.
Question 146
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: Batch
Batch
Streaming
Explanation: Historical and previously uploaded data are processed as batch workloads, while real-time monitoring requires a streaming workload.
Question 147
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 optimized for transactional workloads with frequent inserts, updates, and deletes (heavy writes alongside operational reads), use predefined schemas (schema-on-write) in databases, and typically rely on normalized data models to reduce redundancy and maintain data integrity.
Question 148
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 be copied within the same workspace, not between different workspaces. A dashboard can combine tiles from multiple datasets, and it can include tiles pinned from Excel workbooks.
Question 149
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: Power BI dashboards can include pinned live report pages, individual visualizations pinned from reports, and text boxes added as dashboard tiles. PowerPoint slides and dataflows are not dashboard objects that can be added as tiles.
Question 150
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: A Power BI report provides an interactive graphical interface with multiple visualizations, supports key performance indicators (KPIs), and enables data exploration through features such as drill-down and cross-filtering. Views and dataflows are for data access/preparation, and Power Apps is for building business applications rather than Power BI analytics.
$19
Get all 284 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.
