You need to store event log data that is semi-structured and received as the logs occur.
What should you use?
A. Azure Table storage
B. Azure Queue storage
C. Azure Files
Show Answer
Correct Answer: A
Explanation: Azure Table storage is the best fit among the given options for storing large volumes of semi-structured event log data. It is a NoSQL key-value store designed for structured and semi-structured data. Azure Queue storage is intended for transient messaging between application components, not long-term log storage, and Azure Files is for managed file shares rather than scalable semi-structured data storage.
Question 82
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 frameworks; tabular OLAP models are provided by Azure Analysis Services/Microsoft Fabric semantic models, not HDInsight.
Question 83
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: semi-structured data
Explanation: JSON allows flexible schemas where different entities can have different fields, making it semi-structured rather than strictly structured, relational, or unstructured.
Question 84
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: semi-structured data
Explanation: JSON stores data as key-value pairs with a flexible schema, making it semi-structured rather than relational, graph, or unstructured.
Question 85
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 scenario describes preventing any transaction from observing a partially completed transfer (seeing the source debited but destination not credited, or vice versa). Isolation ensures concurrent transactions cannot see intermediate states of another transaction and instead see either the state before or after the transfer, but not a mixed view.
Question 86
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: An elastic pool
Explanation: Azure SQL elastic pools allow multiple Azure SQL databases to share compute and storage resources, improving resource utilization and handling varying workloads.
Question 87
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 relational database, information for a conceptual business entity is typically distributed across multiple related tables to eliminate redundancy. Retrieving the complete entity commonly requires joins across those tables, and creating or updating that entity often requires inserting or updating rows in multiple related tables to maintain normalization and referential integrity.
Sources:
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entities
https://learn.microsoft.com/en-us/azure/cosmos-db/modeling-data
Question 88
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: report
Explanation: A Power BI report is a collection of visualizations organized across one or more pages. A dashboard is limited to a single page, a dataset is the data source, and a tile is a single visualization on a dashboard.
Question 89
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 database security, including user access, permissions, and protecting the data. Data analysts, data engineers, and data scientists primarily analyze, build, or model data rather than administer database security.
Question 90
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: Azure Cosmos DB is the Azure nonrelational database service that provides SLA-backed latency guarantees of less than 10 ms for reads and writes (at the 99th percentile for supported configurations). Azure Blob Storage, Azure Files, and Azure Table Storage do not provide the same latency guarantees.
$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.
