Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
A. consistency
B. atomicity
C. durability
D. isolation
Show Answer
Correct Answer: C
Explanation: The property that guarantees committed transaction changes will survive system crashes or operating system restarts is durability. Durability ensures that once a transaction is committed, its effects are permanently stored (e.g., on disk or through logging mechanisms) and will not be lost even in the event of failures.
Question 110
You have data saved in the following format.
Which format was used?
A. XML
B. HTML
C. YAML
D. JSON
Show Answer
Correct Answer: D
Explanation: The described data uses key/value pairs with names in double quotes separated by colons, which is characteristic of JSON. XML and HTML use tagged markup, and YAML uses indentation rather than braces and quoted keys.
Question 111
What can be used with native notebook support to query and visualize data by using a web-based interface?
A. Azure Databricks
B. pgAdmin
C. Microsoft Power BI
Show Answer
Correct Answer: A
Explanation: Azure Databricks provides native notebook support with a web-based interface that allows users to query data, run code, and create visualizations directly within notebooks. It is specifically designed for data engineering, data science, and analytics workflows, unlike pgAdmin (database administration) or Power BI (reporting without native notebooks).
Question 112
What is a function of a modern data warehouse?
A. supports batch processing only
B. supports real-time and batch processing
C. provides built-in or native online analytical processing
D. stores raw data only
Show Answer
Correct Answer: B
Explanation: A modern data warehouse extends traditional warehousing by supporting both batch and real-time (streaming) data ingestion and processing. Built-in or native OLAP is a hallmark of traditional/conventional data warehouses and is not the distinguishing function emphasized for *modern* data warehouses in Microsoft Learn materials. Therefore, the correct answer is B.
Question 113
You have data saved in the following format.
Which format was used?
A. JSON
B. YAML
C. HTML
D. XML
Show Answer
Correct Answer: D
Explanation: The data format uses angle-bracket tags with explicit opening and closing elements (<tag>...</tag>), which is characteristic of XML. JSON uses braces and key–value pairs, YAML relies on indentation, and HTML is a specific markup language built on XML-like syntax but intended for web pages, not generic data storage.
Question 114
DRAG DROP -
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
Select and Place:
Show Answer
Correct Answer: Microsoft SQL Server Management Studio (SSMS)
Azure Data Studio
Microsoft SQL Server Data Tools (SSDT)
Explanation: SSMS is the primary graphical administration tool for managing SQL Server and Azure SQL. Azure Data Studio is a lightweight query editor for running SQL and exporting results. SSDT is a development tool for building and deploying SQL databases, SSAS models, SSIS packages, and SSRS reports.
Question 115
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A data analyst
Explanation: A data analyst works with business stakeholders to understand requirements and identify which business rules should be applied to company data. Data engineers implement pipelines and infrastructure, while data scientists focus on advanced analytics and modeling rather than defining business rules.
Question 116
Which type of database contains nodes and edges?
A. graph
B. key/value
C. columnar
D. time series
Show Answer
Correct Answer: A
Explanation: Graph databases model data as nodes (entities) and edges (relationships) connecting those nodes, often with properties on both. The other options use different data models (key/value pairs, columns, or time-indexed records) and do not use nodes and edges.
Question 117
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: virtual machine
Explanation: In an IaaS deployment of SQL Server on Azure, SQL Server runs on an Azure Virtual Machine, and you are responsible for managing the VM and operating system.
Question 118
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: Graph databases
Explanation: Graph databases are designed to model and analyze relationships between entities using nodes and edges, making relationship analysis a native capability.
$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.
