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 is designed for large-volume datasets. Stream processing is optimized for low-latency continuous data rather than complex batch analytics. Batch processing typically has higher latency (minutes to hours), not seconds or milliseconds.
Question 22
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: an attribute hierarchy
Explanation: Attribute hierarchies let users drill down and roll up through different levels of a dimension to view aggregated values.
Question 23
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: an aggregated measure.
Explanation: In a multidimensional analytical model, the intersection of dimension members corresponds to a cell that contains the aggregated value of a measure. Among the provided options, this is best matched by 'an aggregated measure.'
Question 24
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Azure Synapse Analytics.
Explanation: Azure Synapse Analytics includes the same pipeline engine as Azure Data Factory, enabling similar data integration and orchestration capabilities.
Question 25
HOTSPOT -
Select the answer that correctly completed the sentence.
Show Answer
Correct Answer: Azure Synapse Analytics.
Explanation: Azure Synapse Analytics includes the same pipeline orchestration engine as Azure Data Factory, allowing creation and execution of ADF-style pipelines within Synapse.
Question 26
In a fully denormalized database, how is data read and written for a single entity?
A. Data is read from a single table and written to a single table.
B. Data is read from multiple tables and written to a single table.
C. Data is read from a single table and written to multiple tables.
D. Data is read from multiple tables and written to multiple tables.
Show Answer
Correct Answer: A
Explanation: In a fully denormalized database, data for a single entity is consolidated into a single table to avoid joins. Reading the entity requires only that table, and updates are also made to that same table (though duplicated data elsewhere may exist in a broader schema, the question asks about a single entity).
Question 27
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: aggregated
Explanation: OLAP systems are optimized for analytical queries by storing pre-aggregated, multidimensional data to speed analysis rather than normalized transactional data.
Question 28
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: KQL
Explanation: Azure Data Explorer uses Kusto Query Language (KQL) for fast exploration, filtering, and aggregation of large datasets.
Question 29
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
Yes
Explanation: pgAdmin can manage Azure Database for PostgreSQL. Azure Database for MariaDB backup retention supports point-in-time restore up to 35 days, not 365. Azure Database for MySQL traditionally enforces SSL/TLS connections by default in Azure managed service.
Question 30
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: UPDATE
Explanation: DML (Data Manipulation Language) is used to modify data in tables. UPDATE is a DML statement, while CREATE, DROP, and RENAME are DDL statements.
$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.
