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: Normalized OLTP databases are generally optimized to reduce redundancy and support efficient writes, analytics systems are typically less normalized (often star schemas), and normalization increases the need for joins.
Question 132
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's Gremlin API is the graph database model. Graph data is represented as vertices (nodes) and edges and queried using the Gremlin query language.
Question 133
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 is the managed PaaS offering that provides near-full SQL Server instance compatibility, including support for Service Broker and Database Mail, while minimizing maintenance effort compared to running SQL Server on Azure virtual machines. Azure SQL Database (single database and elastic pool) does not support these features.
Question 134
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: Two customer tables with rows, columns, and a defined schema represent structured data. Relational tables with keys are a classic example of structured data, not semi-structured, unstructured, or merely 'non-relational'.
Question 135
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: Hierarchical namespace
Explanation: Azure Data Lake Storage Gen2 requires a storage account with the hierarchical namespace feature enabled to provide a file system-like directory structure and Data Lake capabilities.
Question 136
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A clustered index
Explanation: A clustered index stores and sorts the table's data rows by the index key values. The other options do not define the physical sort order of table data.
Question 137
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: Atomicity ensures that a transaction is treated as a single indivisible unit: either all of its operations complete successfully and commit, or none of them do and the transaction is rolled back. Durability ensures committed data persists, isolation prevents interference between concurrent transactions, and consistency ensures the database moves between valid states.
Question 138
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: database administrator
Explanation: Database administrators are responsible for managing databases, including backups and restoring data after failures.
Question 139
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 format is comma-delimited with rows separated by newlines, which is the standard format for Comma-Separated Values (CSV). YAML uses indentation and key-value structures, JSON uses braces/brackets, and HTML uses markup tags.
Question 140
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 all operations in a transaction succeed or the transaction rolls back. Consistency means transactions preserve valid database rules, not specifically that all changes are logged (logging is associated with durability/recovery). Isolation ensures transactions do not observe intermediate states from other transactions, so they see only consistent states.
$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.
