HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: Graph databases
Explanation: Graph databases are designed to model and analyze relationships between entities using nodes and edges, making them the native choice for relationship analysis.
Question 102
Which Azure Cosmos DB API should you use for a graph database?
A. Table
B. Cassandra
C. Core (SQL)
D. Gremlin
Show Answer
Correct Answer: D
Explanation: Azure Cosmos DB provides multiple APIs for different data models. The Gremlin API is specifically designed for graph databases and supports the Apache TinkerPop Gremlin graph traversal language.
Question 103
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: Semi-structured data
Explanation: Graph databases store data as nodes and relationships with flexible schemas. This provides organization without the fixed tabular schema of relational databases, so it is classified as semi-structured data.
Question 104
Which Azure Blob Storage feature enables you to sync a Blob Storage account to an external cache?
A. the Hot access tier
B. change feed
C. snapshots
D. versioning
Show Answer
Correct Answer: B
Explanation: Azure Blob Storage change feed records changes to blobs and is intended for downstream processing scenarios such as synchronizing with an external cache, updating search indexes, and reacting to object changes. The Hot access tier is a storage tier, while snapshots and versioning provide data protection and recovery rather than cache synchronization.
Question 105
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: stores data without a fixed schema
Explanation: Non-relational (NoSQL) databases are schema-flexible and do not require a fixed table structure, unlike relational databases.
Question 106
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A view
Explanation: A view is a virtual table whose contents are defined by a SQL query. A stored procedure contains executable code, an index improves query performance, and a heap is a table without a clustered index.
Question 107
Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
A. Azure SQL Database
B. Azure Database for MySQL
C. Azure SQL Managed Instance
D. an Azure SQL Database elastic pool
Show Answer
Correct Answer: C
Explanation: Azure SQL Managed Instance provides the highest compatibility with on-premises Microsoft SQL Server Enterprise workloads, supporting near full SQL Server instance compatibility, making it the preferred PaaS target for lift-and-shift migrations from SQL Server 2019 Enterprise edition.
Question 108
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: primary key
Explanation: A primary key uniquely identifies each row in a relational database table. Foreign keys reference rows in another table, a WHERE clause filters results, and a nonclustered index improves lookup performance but does not uniquely identify every row.
Question 109
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A clustered index
Explanation: A clustered index determines the physical order of rows in a table based on the indexed key values. A nonclustered index stores a separate index structure, while a view and a stored procedure do not physically sort table data.
Question 110
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: Azure Synapse Analytics
Explanation: Azure Synapse Analytics is the Azure PaaS analytics service that provides a massively parallel processing (MPP) SQL engine (formerly SQL Data Warehouse). The other options are not MPP PaaS relational data services.
$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.
