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 supports graph databases through the Gremlin API, which is specifically designed for graph data models and queries. The other APIs (Table, Cassandra, Core SQL) are intended for key-value, wide-column, and document data models respectively.
Question 120
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: structured data
Explanation: In the exam context, relationships between users and followers stored in a graph database are treated as structured data because nodes and edges follow a defined schema and can be queried systematically.
Question 121
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: The Azure Blob Storage feature designed to enable synchronization with external systems such as caches is **change feed**. Change feed provides an ordered, immutable log of all changes (creates, updates, deletes) that occur in a storage account. External services can consume this log to detect changes and keep a cache, index, or secondary system in sync. The Hot access tier only affects performance and cost, while snapshots and versioning retain historical blob states but do not provide a mechanism to propagate changes to external caches.
Question 122
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, unlike relational databases which enforce fixed table schemas.
Question 123
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 stored query, presenting query results without storing the data separately.
Question 124
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 offers the highest compatibility with Microsoft SQL Server 2019 Enterprise because it supports near full SQL Server engine features, including SQL Agent, cross-database queries, CLR, and native VNET integration. It is specifically designed for lift-and-shift migrations with minimal code and configuration changes, unlike Azure SQL Database or elastic pools which have more limitations.
Question 125
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: primary key
Explanation: In a relational database, a primary key uniquely identifies each row in a table, ensuring no duplicate or null values.
Question 126
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A clustered index
Explanation: A clustered index determines the logical order of data rows in a table based on the indexed column values, which is commonly described in exams as physically sorting the data. Only one clustered index can exist per table.
Question 127
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: Azure Synapse Analytics
Explanation: Azure Synapse Analytics is a PaaS relational data warehousing service that uses massively parallel processing (MPP) to scale queries across multiple compute nodes.
Question 128
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
A. SELECT
B. WHERE
C. JOIN
Show Answer
Correct Answer: A
Explanation: The question asks for a T‑SQL *statement* that can instruct the DBMS to use an index. `WHERE` is a clause, not a statement, and it does not instruct the optimizer—it only provides predicates that *may* allow index usage. In T‑SQL, forcing or hinting index usage (e.g., `WITH (INDEX(index_name))`) is done within a `SELECT` statement. Among the given options, only `SELECT` is a statement capable of doing this, so A is correct.
$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.
