You have structured data in tabular format.
What represents an individual instance of a data entity?
A. a column
B. a table
C. a cell
D. a row
Show Answer
Correct Answer: D
Explanation: In structured tabular data (such as relational databases), a table represents an entity type, columns represent attributes of that entity, and each row represents a single instance (record) of the entity. A cell is just one attribute value within that instance.
Question 80
Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates. backups, and maintenance tasks?
A. Azure SQL Managed Instance
B. SQL Server on Azure Virtual Machines
C. Azure SQL Database
D. Azure SQL Edge
Show Answer
Correct Answer: A
Explanation: Azure SQL Managed Instance offers near-100% compatibility with the on-premises SQL Server database engine while being a fully managed PaaS service. It provides automated patching, updates, backups, high availability, and maintenance. SQL Server on Azure Virtual Machines offers full compatibility but requires manual management, while Azure SQL Database has more feature differences and Azure SQL Edge targets IoT/edge scenarios.
Question 81
DRAG DROP
-
Match the data processing languages to the appropriate real-time analytics services.
To answer, drag the appropriate language from the column on the left to its service on the right. Each language may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Show Answer
Correct Answer: KQL → Azure Data Explorer
SQL → Azure Stream Analytics
Python → Azure Synapse Analytics
Explanation: Azure Data Explorer is queried with KQL. Azure Stream Analytics uses a SQL-based query language for streaming data. Azure Synapse Analytics supports analytics using languages such as Python (via Spark) in addition to SQL.
Question 82
HOTSPOT
-
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: No
No
Yes
Explanation: Hot is the default access tier, not Cool. Append blobs are optimized for append (sequential write) operations, not random read/write (that applies to page blobs). Rehydrating data from the Archive tier typically takes several hours.
Question 83
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: vertices
Explanation: In a graph database, edges represent relationships that connect nodes, which are also called vertices.
Question 84
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: for NoSQL
Explanation: Azure Cosmos DB API for NoSQL (formerly SQL/Core API) supports SQL-like SELECT statements to query JSON documents. Other APIs use different query languages (MongoDB, Gremlin, Table).
Question 85
DRAG DROP
-
Match the data storage options to the appropriate types of data.
To answer, drag the appropriate data storage option from the column on the left to its data type on the right. Each data storage option may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Explanation: Blob Storage is optimized for unstructured binary data such as audio files. Cosmos DB for NoSQL natively stores and queries JSON documents. Azure SQL Database is designed for structured, relational, tabular data. Azure Data Factory is a data integration service, not a storage option.
Question 86
Which type of Azure resource supports the serverless configuration of an Azure SQL database?
A. SQL Server on Azure Virtual Machines
B. an Azure SQL Database elastic pool
C. a single database in Azure SQL Database
D. Azure SQL Managed Instance
Show Answer
Correct Answer: C
Explanation: The serverless compute tier is available only for **single databases** in Azure SQL Database. It automatically scales compute based on workload demand and can pause during inactivity, billing only for storage. Elastic pools, managed instances, and SQL Server on Azure VMs do not support the serverless compute tier.
Question 87
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: a target data store powerful enough to transform data
Explanation: In ELT, data is loaded first and transformations are performed inside the target system (e.g., data warehouse), so it must be powerful enough to handle transformations. A separate transformation engine is characteristic of ETL, not ELT.
Question 88
HOTSPOT
-
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: No
No
Yes
Explanation: OLTP systems handle frequent transactions and are primarily optimized for write efficiency rather than balanced read/write optimization.
OLAP systems are read-heavy and not optimized for frequent writes.
Data warehouses are designed for analytical queries and are optimized for read operations.
$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.
