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
No
Explanation: Azure Data Lake Storage is commonly used as a staging area for raw ingested data. Azure Data Factory is a data integration/orchestration service, not an MPP analytics engine. Azure HDInsight provides big data processing frameworks, not tabular OLAP models (handled by Azure Analysis Services or Power BI).
Question 100
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: semi-structured data.
Explanation: JSON allows varying fields per entity without a fixed schema, which characterizes semi-structured data.
Question 101
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: semi-structured data
Explanation: JSON has a flexible schema with key–value pairs that can vary between records, so it is not strictly relational or unstructured, making it semi-structured data.
Question 102
A bank has a system that manages financial transactions.
When transferring money between accounts. the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.
Of which ACID semantic is this an example?
A. atomicity
B. durability
C. consistency
D. isolation
Show Answer
Correct Answer: D
Explanation: The requirement prevents other transactions from observing a partial state of the transfer (e.g., seeing the source account before debit while seeing the destination account after credit). This is exactly the isolation property, which ensures concurrent transactions appear to execute as if they were run sequentially, without exposing intermediate states.
Question 103
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: An elastic pool
Explanation: An elastic pool allows multiple Azure SQL databases to share compute, memory, and storage resources dynamically, optimizing resource utilization across databases.
Question 104
In a fully normalized database, how is data read and written for a single entity?
A. Data is read from multiple tables and written to multiple tables.
B. Data is read from a single table 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 a single table.
Show Answer
Correct Answer: A
Explanation: In a fully normalized database, an entity’s data is typically decomposed across multiple related tables to eliminate redundancy (e.g., core entity data, lookup tables, dependent attributes). To reconstruct a complete view of a single entity, data is read using joins across multiple tables. Likewise, creating or updating that entity usually requires inserting or updating rows in several related tables. Therefore, data is read from multiple tables and written to multiple tables.
Question 105
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: report
Explanation: In Power BI, a report is a collection of visualizations that can span one or more pages, whereas a dashboard is limited to a single page.
Question 106
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A database administrator
Explanation: A database administrator (DBA) is responsible for managing and securing database systems, including access control, permissions, backups, and overall data security.
Question 107
You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes.
What should you include in the solution?
A. Azure Blob storage
B. Azure Files
C. Azure Table storage
D. Azure Cosmos DB
Show Answer
Correct Answer: D
Explanation: The requirement is a nonrelational data service with guaranteed read and write latency under 10 ms. Azure Cosmos DB is designed for low-latency, globally distributed NoSQL workloads and provides documented SLA-backed latency guarantees of less than 10 ms at the 99th percentile for both reads and writes. Azure Blob Storage, Azure Files, and Azure Table Storage do not provide comparable low-latency guarantees.
Question 108
Which Azure Storage service implements the key/value model?
A. Azure Queue
B. Azure Files
C. Azure Table
D. Azure Blob
Show Answer
Correct Answer: C
Explanation: Azure Table Storage implements a key/value (key–attribute) NoSQL model, using PartitionKey and RowKey to uniquely identify entities. It is designed for storing large amounts of schemaless, non-relational data, unlike Queues (messaging), Files (file shares), or Blobs (object storage).
$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.
