HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Database administrators
Explanation: Database administrators (DBAs) are responsible for ensuring the availability, performance, security, and optimization of databases.
Question 42
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 (PaaS)
Azure SQL Managed Instance — Platform as a Service (PaaS)
SQL Server on Azure Virtual Machines — Infrastructure as a Service (IaaS)
Explanation: Azure SQL Database and Azure SQL Managed Instance are fully managed database platform offerings (PaaS). SQL Server on Azure Virtual Machines runs on customer-managed VMs, making it an IaaS solution.
Question 43
Which statement is an example of Data Manipulation Language (DML)?
A. INSERT
B. ALTER
C. DROP
D. CREATE
Show Answer
Correct Answer: A
Explanation: INSERT is a Data Manipulation Language (DML) statement because it adds rows to a table. ALTER, DROP, and CREATE are Data Definition Language (DDL) statements used to define or modify database schema.
Question 44
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: JSON
Explanation: JSON uses a hierarchical document structure with nested objects and arrays, allowing entities to have multiple attributes. CSV and TSV are flat text formats, and ORC is a columnar storage format rather than a hierarchical document schema.
Question 45
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: CSV
Explanation: CSV (Comma-Separated Values) stores delimited data with fields separated by commas and records typically terminated by a newline/carriage return.
Question 46
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 uses a predefined, fixed schema (such as relational database tables), while semi-structured data uses a flexible or self-describing schema (such as JSON or XML), allowing attributes to vary between records.
Question 47
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: Durability means that once a transaction has been successfully committed, its changes are permanently persisted and will survive system failures or database restarts. The scenario describes committed account balances remaining intact even if the database becomes temporarily unavailable.
Sources:
https://learn.microsoft.com/en-us/training/modules/explore-core-data-concepts/5-transactional-data-processing
Question 48
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 multiple APIs. The API designed for graph databases is the Apache Gremlin API, which implements the Gremlin graph traversal language and property graph model. The Table API is for key-value/table storage, Cassandra API is for wide-column workloads, and NoSQL API is for document-oriented data.
Question 49
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 is the graph API, NoSQL stores JSON documents, and Table API provides key/value-style table storage.
Question 50
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 deployments, unlike the other Azure SQL offerings.
$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.
