A. Correct.
OLTP systems support high-volume transactional operations such as orders, payments, and account updates.

B. Incorrect.
OLAP is optimized for analytical queries over historical data, not frequent operational transactions.

C. Incorrect.
Batch analytics processes accumulated data in groups and is not the best description for live order transactions.

D. Incorrect.
Archiving stores data for retention and does not describe transactional order processing.

A. Incorrect.
A key-value cache is used for fast lookups and temporary data, not long-term business analysis.

B. Incorrect.
File synchronization is about keeping files available across locations, not analytical reporting.

C. Correct.
OLAP workloads aggregate and analyze large volumes of historical data for reporting and decision making.

D. Incorrect.
Device identity workloads manage authentication or enrollment and are unrelated to sales analytics.

A. Incorrect.
Stream processing handles events continuously as they arrive rather than waiting for a nightly run.

B. Correct.
Batch processing works on stored data in scheduled groups, such as files processed overnight.

C. Incorrect.
OLTP handles live operational transactions and is not the pattern for scheduled file processing.

D. Incorrect.
Point-to-site VPN is a networking feature and is unrelated to data processing.

A. Incorrect.
Archive-only processing stores data but does not analyze events immediately.

B. Incorrect.
Nightly batch processing would delay alerts until the batch run.

C. Incorrect.
Manual spreadsheets are not suitable for continuous sensor alerting.

D. Correct.
Stream processing analyzes event data continuously as it is received.

A. Incorrect.
Fixed rows and columns are typical of structured relational data, not semi-structured data.

B. Correct.
Semi-structured data, such as JSON, has organization but does not require a rigid table schema.

C. Incorrect.
Semi-structured data can be queried by services such as Azure Cosmos DB, Synapse, and Spark engines.

D. Incorrect.
Storage media does not define whether data is semi-structured.

A. Incorrect.
Key Vault stores secrets, keys, and certificates; it does not orchestrate ETL pipelines.

B. Incorrect.
Azure Bastion provides secure VM access and is unrelated to ETL orchestration.

C. Correct.
Azure Data Factory orchestrates data movement and transformation pipelines for ETL and ELT workloads.

D. Incorrect.
Azure DNS hosts DNS zones and does not copy or transform data.

A. Incorrect.
KQL is used for services such as Azure Monitor Logs and Azure Data Explorer, not as the primary Azure SQL table query language.

B. Incorrect.
YAML is commonly used for configuration files and pipelines, not relational table queries.

C. Incorrect.
Bicep is an infrastructure-as-code language and not a data query language.

D. Correct.
SQL is used to query and manipulate relational data in Azure SQL Database.

A. Correct.
ACID properties help ensure transactions are atomic, consistent, isolated, and durable.

B. Incorrect.
DNS delegation controls name resolution and does not protect database transaction consistency.

C. Incorrect.
Caching improves content delivery performance but does not guarantee financial transaction integrity.

D. Incorrect.
Image tagging is a classification concept and is unrelated to database transaction guarantees.

A. Incorrect.
A virtual network provides network isolation and connectivity, not a database service.

B. Correct.
Azure SQL Database is a managed relational PaaS offering with built-in patching, backups, and availability features.

C. Incorrect.
Queue Storage stores messages and is not a relational database platform.

D. Incorrect.
Container Registry stores container images and is not a relational database.

A. Incorrect.
Public anonymous access is a security setting and is not required for Data Lake Storage Gen2.

B. Incorrect.
Soft delete can help recovery, but it does not create Data Lake Storage Gen2 capabilities.

C. Correct.
Hierarchical namespace enables Azure Data Lake Storage Gen2 features such as directories and file-system semantics.

D. Incorrect.
A CDN endpoint can improve content delivery but does not enable data lake capabilities.