DRAG DROP -
Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match its worth one point.
Select and Place:
Show Answer
Correct Answer: A serverless configuration:
Azure SQL Database single database
A database that has the highest compatibility with on-premises Microsoft SQL Server:
Azure SQL Managed Instance
A low-cost, low-maintenance database:
Azure SQL Database elastic pool
Explanation: Serverless is a compute tier available for Azure SQL single databases. Azure SQL Managed Instance provides the closest compatibility to on‑premises SQL Server. Elastic pools reduce cost and maintenance by sharing resources across multiple databases with variable usage.
Question 130
Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. INSERT
D. GRANT
Show Answer
Correct Answer: C
Explanation: Data Manipulation Language (DML) statements are used to modify the data stored in database tables. INSERT adds new rows to a table, which is a core DML operation. REVOKE and GRANT are Data Control Language (DCL) commands, and DISABLE is an administrative/DDL-related command rather than DML.
Question 131
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: the same set of columns
Explanation: In a relational table, the schema (columns and data types) is fixed. Every row represents a record that conforms to this same structure.
Question 132
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
A. atomicity
B. isolation
C. durability
D. consistency
Show Answer
Correct Answer: A
Explanation: Atomicity is the ACID property that ensures a transaction is treated as a single, indivisible unit of work—either all operations complete successfully, or none are applied if a failure occurs.
Question 133
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: simple lookups.
Explanation: Key/value data stores are designed to retrieve a value directly by its key with very low latency. They are not optimized for enforcing relational constraints or performing joins.
Question 134
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Show Answer
Correct Answer: latency in delivering data processing results is acceptable.
Explanation: Batch processing handles data in groups at scheduled intervals rather than immediately. Because results are not required in real time, delayed (higher) latency is expected and acceptable.
Question 135
What is required to provision Azure Data Lake Storage in an Azure Storage account?
A. Versioning must be disabled.
B. Hierarchical namespace must be disabled.
C. Versioning must be enabled.
D. Hierarchical namespace must be enabled.
Show Answer
Correct Answer: D
Explanation: Azure Data Lake Storage Gen2 requires the storage account to have the hierarchical namespace feature enabled. This namespace provides directory and file system semantics needed for analytics workloads. Versioning settings are unrelated to provisioning ADLS Gen2.
Question 136
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: relational data.
Explanation: SQL Server is a relational database management system, and its tables store data in rows and columns with defined relationships.
Question 137
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: An instance of SQL Server on Azure Virtual Machines
Explanation: SQL Server on Azure Virtual Machines supports lift-and-shift migrations because it closely matches an on-premises SQL Server environment, requiring minimal or no application changes.
Question 138
DRAG DROP -
Match the processes to the appropriate scenarios.
To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Show Answer
Correct Answer: Extract, transform, and load (ETL) processing
Data ingestion
Extract, load, and transform (ELT) processing
Explanation: ETL processes data before loading.
Data ingestion loads data first, then processing can occur.
ELT loads extracted data first and transforms it afterward.
$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.
