DRAG DROP
-
Match the cloud service model to the appropriate Azure relational database service.
To answer, drag the appropriate cloud service model from the column on the left to its service on the right. Each model may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Show Answer
Correct Answer: Azure SQL Database: Platform as a Service
Azure SQL Managed Instance: Platform as a Service
SQL Server on Azure Virtual Machines: Infrastructure as a Service
Explanation: Azure SQL Database and Azure SQL Managed Instance are fully managed database platforms (PaaS). SQL Server on Azure Virtual Machines requires managing the OS and SQL Server, which is IaaS.
Question 60
Which statement is an example of Data Manipulation Language (DML)?
A. INSERT
B. ALTER
C. DROP
D. CREATE
Show Answer
Correct Answer: A
Explanation: Data Manipulation Language (DML) includes commands that add, modify, or remove data within existing database tables. INSERT is a core DML command. ALTER, DROP, and CREATE are Data Definition Language (DDL) statements because they define or change database structures.
Question 61
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: JSON
Explanation: JSON supports a hierarchical, nested document structure, allowing entities to have multiple attributes and sub-attributes, unlike flat formats such as CSV or TSV.
Question 62
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: CSV
Explanation: CSV (Comma-Separated Values) stores delimited data, uses commas to separate fields, and ends rows with a carriage return/newline.
Question 63
What is a difference between structured data and semi-structured data?
A. Structured data has a fixed schema and semi-structured data has a flexible schema.
B. Only Structured data supports entities.
C. Structured data has a flexible schema and semi-structured data has a fixed schema.
D. Only Structured data supports attributes.
Show Answer
Correct Answer: A
Explanation: Structured data relies on a predefined, rigid schema where fields and data types are fixed in advance (e.g., relational tables). Semi-structured data does not require a strict prior schema; its structure is flexible and can evolve over time (e.g., JSON or XML), allowing new attributes to be added as needed.
Question 64
A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable.
Of which ACID semantic is this an example?
A. durability
B. isolation
C. atomicity
D. consistency
Show Answer
Correct Answer: A
Explanation: This scenario describes durability. Durability guarantees that once a transaction has successfully committed, its effects (such as updated account balances) will persist permanently, even if the database system crashes or becomes temporarily unavailable afterward.
Question 65
Which Azure Cosmos DB API should you use for a graph database?
A. Azure Cosmos DB for Table
B. Azure Cosmos DB for Apache Cassandra
C. Azure Cosmos DB for NoSQL
D. Azure Cosmos DB for Apache Gremlin
Show Answer
Correct Answer: D
Explanation: Azure Cosmos DB supports graph data models through the Apache Gremlin API, which is specifically designed for graph databases and graph traversal queries. The other APIs target table, wide-column, or document/key-value workloads, not graph workloads.
Question 66
DRAG DROP
-
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Show Answer
Correct Answer: Graph data → Azure Cosmos DB for Apache Gremlin API
JSON documents → Azure Cosmos DB for NoSQL API
Key/value data → Azure Cosmos DB for Table API
Explanation: Gremlin API is designed for graph (vertices and edges). The NoSQL API stores JSON documents. The Table API supports key/value-style data similar to Azure Table Storage.
Question 67
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Azure SQL Edge
Explanation: Azure SQL Edge is specifically optimized for IoT and IoT Edge scenarios, providing a lightweight relational database engine designed for edge devices.
Question 68
Which language is used to define queries in Azure Synapse Data Explorer?
A. Bash
B. PowerShell
C. KQL
D. SQL
Show Answer
Correct Answer: C
Explanation: Azure Synapse Data Explorer uses Kusto Query Language (KQL) to define and run queries. KQL is specifically designed for fast, interactive analysis of large volumes of telemetry, log, and time-series data, which is the core purpose of Data Explorer.
$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.
