Which two features distinguish Delta Lake from Azure Data Lake Storage? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. support for batch data
B. schema enforcement
C. support for an Apache Spark runtime
D. transactional consistency
E. support for streaming data
Show Answer
Correct Answer: B, D
Explanation: Delta Lake extends data lakes with ACID transactional consistency and schema enforcement/evolution, whereas Azure Data Lake Storage is a storage service that does not itself provide these table-level guarantees. Both batch and streaming workloads can use ADLS and Delta Lake, and Spark support is not a distinguishing feature because Spark can read/write ADLS directly.
Question 12
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Power BI Desktop
Explanation: A typical Power BI analytics workflow starts in Power BI Desktop, where you connect to data, transform it, build the data model, and create reports before publishing to the Power BI service.
Question 13
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: Non-relational (NoSQL) databases are not inherently table-based, typically do not require a fixed schema, and document collections can contain records with different fields.
Question 14
DRAG DROP -
Match the database normalization terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Show Answer
Correct Answer: Attributes → Get separated into individual columns
Entities → Get separated into individual tables
Foreign keys → Link two related entities
Explanation: Attributes map to columns, entities are represented as tables, and foreign keys create relationships between tables/entities.
Question 15
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: random read and write operations.
Explanation: Azure Page Blobs are designed for frequent random read/write access, making them suitable for virtual hard disks (VHDs). Append blobs are for append operations, block blobs for large binary objects, and table storage is for key/value data.
Question 16
You have the following data.
Which type of data is this?
A. unstructured
B. semi-structured
C. structured
Show Answer
Correct Answer: B
Explanation: The described data is JSON, which is a standard example of semi-structured data. It does not conform to a fixed relational schema like structured data, but it uses keys and hierarchical organization that provide structure unlike unstructured data.
Question 17
Structured data where each row represents a single data entity uses which type of schema?
A. XML
B. tabular
C. blob
D. JSON
Show Answer
Correct Answer: B
Explanation: A tabular schema organizes structured data into rows and columns, where each row represents a single entity (record) and each column represents an attribute. XML and JSON are hierarchical data formats, and a blob is unstructured binary data.
Question 18
DRAG DROP -
Match the ACID terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once or not at all.
NOTE: Each correct match is worth one point.
Explanation: Isolation prevents concurrent transactions from interfering. Atomicity ensures all-or-nothing execution. Consistency moves the database between valid states. Durability guarantees committed changes persist.
Question 19
GRANT, REVOKE, and DENY are examples of which type of SQL statement?
A. Data Definition language (DDL)
B. Data Control Language (DCL)
C. Data Manipulation Language (DML)
Show Answer
Correct Answer: B
Explanation: GRANT, REVOKE, and DENY are Data Control Language (DCL) statements because they manage permissions and access rights to database objects. DDL defines database structures (e.g., CREATE, ALTER, DROP), while DML manipulates data (e.g., SELECT, INSERT, UPDATE, DELETE).
Question 20
You need to implement an Azure platform as a service (PaaS) service that will host a relational database. The solution must support built-in autoscaling.
Which service should you implement?
A. Azure SQL Database
B. SQL Server on Azure Virtual Machines
C. Azure SQL Managed Instance
D. Azure SQL Edge
Show Answer
Correct Answer: A
Explanation: Azure SQL Database is the fully managed PaaS relational database service that supports built-in autoscaling capabilities (such as serverless compute with automatic scaling). SQL Server on Azure Virtual Machines is IaaS, Azure SQL Managed Instance is PaaS but does not provide the same built-in autoscaling capability expected by this question, and Azure SQL Edge is intended for edge/IoT scenarios.
$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.
