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: Yes
No
No
Explanation: Azure Files is created within an Azure storage account. Premium Azure Files uses SSD-backed storage, while Standard Azure Files uses HDD-backed storage.
Question 62
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 tabular structured data, each row represents a single record, which is one individual instance of the entity. Columns represent attributes (fields), cells hold individual values, and the table contains the collection of entity instances.
Question 63
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 is designed to provide near-100% compatibility with on-premises SQL Server while offering a fully managed platform with automated patching, backups, updates, and maintenance. SQL Server on Azure VMs offers full compatibility but remains infrastructure-as-a-service, leaving most maintenance to the customer. Azure SQL Database has lower compatibility with SQL Server than Managed Instance, and Azure SQL Edge is intended for edge scenarios.
Question 64
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: Azure Data Explorer — KQL
Azure Stream Analytics — SQL
Azure Synapse Analytics — SQL
Explanation: Azure Data Explorer uses Kusto Query Language (KQL). Azure Stream Analytics uses a SQL-like query language for streaming queries. Azure Synapse Analytics primarily uses SQL for analytics workloads; although it also supports Python in notebooks, the matching language for the service is SQL.
Question 65
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: Default storage account access tier is Hot, not Cool. Append blobs are optimized for append (sequential write) operations, not random read/write. Archive tier data must be rehydrated before access, which typically takes hours.
Question 66
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: vertexes
Explanation: In a graph database, edges represent relationships between vertices (nodes).
Question 67
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. The MongoDB, Gremlin, and Table APIs use their own query models.
Question 68
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 files such as audio. Azure Cosmos DB for NoSQL is designed for JSON documents. Azure SQL Database is a relational database suited for tabular data. Azure Data Factory is an integration/orchestration service, not a data storage option.
Question 69
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 supported for single databases in Azure SQL Database. It provides automatic compute scaling and auto-pause/auto-resume based on workload. It is not available for SQL Server on Azure VMs, elastic pools, or Azure SQL Managed Instance.
Question 70
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 extracted and loaded first, then transformed within the target data store. Therefore, the target system must have sufficient processing capability to perform the transformations.
$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.
