HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: as nodes and edges by using the Gremlin language
Explanation: Azure Cosmos DB provides a Graph API that models data as vertices (nodes) and edges and is queried using the Apache Gremlin query language. The other options relate to different Cosmos DB APIs, not graph queries.
Question 150
You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
* Minimize maintenance effort.
* Support the Database Mail and Service Broker features.
What should you include in the solution?
A. Azure SQL Database single database
B. an Azure SQL Database elastic pool
C. Azure SQL Managed instance
D. SQL Server on Azure virtual machines
Show Answer
Correct Answer: C
Explanation: Azure SQL Managed Instance provides near 100% SQL Server engine compatibility with minimal maintenance overhead. It supports SQL Server features such as Database Mail and Service Broker, which are not supported in Azure SQL Database single databases or elastic pools. Compared to SQL Server on Azure VMs, Managed Instance significantly reduces administrative and maintenance effort while still meeting the feature requirements.
Question 151
You have the following two tables of customer data.
Which type of data do the tables contain?
A. structured
B. non-relational
C. semi-structured
D. unstructured
Show Answer
Correct Answer: A
Explanation: The data is organized into tables with defined columns, rows, and keys (e.g., primary/foreign keys) that enable joins. This is the definition of structured data, as opposed to semi-structured (JSON/XML), non-relational, or unstructured data (text, images, audio).
Question 152
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: Hierarchical namespace
Explanation: Azure Data Lake Storage Gen2 requires the hierarchical namespace feature to enable directory and file semantics on an Azure Storage account.
Question 153
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A clustered index
Explanation: A clustered index is an object associated with a table that physically sorts and stores the table’s data rows based on the index key values.
Question 154
Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?
A. atomicity
B. durability
C. isolation
D. consistency
Show Answer
Correct Answer: A
Explanation: The property described—transactions executing as a single, indivisible unit that either fully succeed or are completely rolled back—is atomicity. Atomicity guarantees that partial effects of a transaction are never visible; it is all-or-nothing. Durability concerns persistence after commit, isolation concerns concurrent visibility, and consistency concerns moving the database from one valid state to another.
Question 155
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: database administrator
Explanation: Backing up and restoring data, along with managing security and availability of databases, are core responsibilities of a database administrator (DBA).
Question 156
You have data saved in the following format.
Which format was used?
A. YAML
B. CSV
C. JSON
D. HTML
Show Answer
Correct Answer: B
Explanation: The described data is comma-delimited with rows terminated by newlines, which is the defining characteristic of CSV (Comma-Separated Values). YAML, JSON, and HTML use structured syntax with indentation, braces, or tags rather than simple comma-separated rows.
Question 157
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
Yes
Explanation: Atomicity means a transaction is all-or-nothing: either all statements succeed or the transaction rolls back.
Consistency refers to moving between valid states, not to logging; logging is associated with durability.
Isolation prevents transactions from seeing intermediate results, so only consistent states are visible.
Question 158
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A data analyst
Explanation: Creating visuals and charts to support informed business decisions is a core responsibility of a data analyst. Data engineers focus on building data pipelines, not visualization.
$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.
