HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: simple analytics with short latency
Explanation: Stream processing handles data as it arrives to enable real-time or near-real-time insights, typically using lightweight operations such as filtering and aggregation, which require low latency.
Question 20
You need to accept and store large quantities of IoT streaming data.
Which database solution should you use?
A. Azure Database for PostgreSQL
B. Azure Database for MariaDB
C. Azure Cache for Redis
D. Azure Cosmos DB
Show Answer
Correct Answer: D
Explanation: Azure Cosmos DB is designed to handle massive volumes of globally distributed, high-throughput, low-latency data, making it well suited for ingesting and storing large quantities of IoT streaming data. The other options are relational databases or in-memory cache services that are not optimized for large-scale IoT data ingestion.
Question 22
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.
Show Answer
Correct Answer: Yes
No
No
Explanation: Batch processing excels at processing very large volumes of data. Stream processing focuses on low-latency, near-real-time handling rather than complex, long-running analytics. Batch processing latency is typically minutes to hours, not seconds or milliseconds.
Question 24
Which two features distinguish Delta Lake from Azure Data Lake Storage? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. support for batch data
B. schema enforcement
C. support for an Apache Spark runtime
D. transactional consistency
E. support for streaming data
Show Answer
Correct Answer: B, D
Explanation: Delta Lake adds a transactional storage layer on top of data lake storage. Unlike Azure Data Lake Storage, Delta Lake provides schema enforcement to prevent incompatible writes and supports ACID transactional consistency to ensure reliable reads and writes. Both batch and streaming data, as well as Apache Spark support, are available in both technologies and therefore are not distinguishing features.
Question 25
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Power BI Desktop
Explanation: An analytics solution workflow typically starts in Power BI Desktop, where data is connected, transformed, modeled, and reports are created before being published to the Power BI service.
Question 27
DRAG DROP -
Match the database normalization terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Show Answer
Correct Answer: Attributes → Get separated into individual columns
Entities → Get separated into individual tables
Foreign keys → Link two related entities
Explanation: Attributes represent columns, entities are modeled as tables, and foreign keys create relationships between tables by referencing primary keys.
Question 28
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: random read and write operations.
Explanation: Azure Page Blobs are designed for frequent, random read/write access to fixed-size pages, making them suitable for scenarios like virtual hard disks where small segments are updated at known offsets.
Question 32
DRAG DROP -
Match the ACID terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once or not at all.
NOTE: Each correct match is worth one point.
Explanation: Isolation: concurrent transactions do not interfere.
Atomicity: transaction succeeds or fails as a whole.
Consistency: database moves between valid states.
Durability: committed changes persist.
Question 34
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: only the Microsoft Power BI service
Explanation: Dashboards are created only in the Power BI service. Power BI Desktop is used to build reports, and the mobile app is for viewing, not creating dashboards.
Question 35
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Azure Synapse Analytics
Explanation: Azure Synapse Analytics integrates a SQL Server–based relational data warehouse with big data analytics, combining scalable MPP SQL, data lake storage, and native Apache Spark support.
$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.
