Which Azure Storage service implements the key/value model?
A. Azure Queue
B. Azure Files
C. Azure Table
D. Azure Blob
Show Answer
Correct Answer: C
Explanation: Azure Table Storage implements a NoSQL key/attribute (key/value) store with a schemaless design, using partition and row keys to organize entities. The other services provide queues, file shares, or object/blob storage rather than a key/value data model.
Question 92
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: Durability is the ACID property that guarantees once a transaction has been committed, its changes are permanently stored and will survive system crashes or operating system restarts. Atomicity ensures all-or-nothing execution, consistency preserves valid database states, and isolation prevents interference between concurrent transactions.
Question 93
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 format is JSON, which represents data using key/value pairs enclosed in braces, with field names in double quotes. XML uses tags, HTML is markup for web pages, and YAML uses indentation rather than JSON syntax.
Question 94
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 that enables users to query, analyze, and visualize data through a web-based notebook interface. pgAdmin is a PostgreSQL administration tool, and Power BI is primarily a business intelligence and reporting platform rather than a native notebook environment.
Question 95
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 is designed to support both batch and near real-time/streaming data ingestion and processing in addition to traditional analytical workloads. Batch-only is characteristic of older architectures, and a warehouse does not store only raw data. While analytical processing is a core purpose, built-in/native OLAP is not a defining function of all modern data warehouses because many modern platforms use SQL engines, semantic models, or external BI tools rather than native OLAP cubes.
Question 96
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 described data format is XML, which is identified by its angle-bracket tags with opening and closing elements (for example, <tag>...</tag>). JSON uses braces, YAML uses indentation and key-value pairs without tags, and HTML is a markup language for web documents rather than a general data serialization format.
Question 97
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 graphical administration tool. Azure Data Studio is the lightweight query editor that can export results to text, JSON, and Excel. SSDT is the development tool for SQL databases, SSAS, SSIS, and SSRS projects.
Question 98
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: A data analyst
Explanation: Business rules are typically identified from business requirements by a data analyst. Data engineers generally implement data pipelines and technical processing, while data scientists focus on advanced analysis and modeling.
Question 99
Which type of database contains nodes and edges?
A. graph
B. key/value
C. columnar
D. time series
Show Answer
Correct Answer: A
Explanation: A graph database models data as nodes (entities) and edges (relationships) connecting those nodes. Key/value, columnar, and time series databases use different data models and do not fundamentally organize data as nodes and edges.
Question 100
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: virtual machine
Explanation: An IaaS deployment provides the infrastructure, but you are responsible for managing the virtual machine (including the OS and SQL Server installation).
$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.
