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: The requirement is a relational database hosted as a Platform as a Service (PaaS) with built-in autoscaling. Azure SQL Database is a fully managed PaaS relational database that supports automatic scaling of compute resources (for example, through DTU/vCore models and serverless autoscaling). SQL Server on Azure VMs is IaaS, Managed Instance does not provide native autoscaling in the same way, and Azure SQL Edge targets IoT/edge scenarios.
Question 38
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: an attribute hierarchy
Explanation: Attribute hierarchies in Power BI organize dimension data into levels, enabling quick drill-up and drill-down to view aggregated values at different granularities.
Question 39
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: an aggregated measure.
Explanation: In an analytical (OLAP) model, the intersection of dimension members defines a cell, and that cell stores aggregated measure values (e.g., sum, count) for that combination of dimensions.
Question 40
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Azure Synapse Analytics
Explanation: Azure Synapse Analytics includes the same pipeline engine as Azure Data Factory, allowing you to create and run data integration pipelines directly within Synapse.
Question 43
In a fully denormalized database, how is data read and written for a single entity?
A. Data is read from a single table and written to a single table.
B. Data is read from multiple tables and written to a single table.
C. Data is read from a single table and written to multiple tables.
D. Data is read from multiple tables and written to multiple tables.
Show Answer
Correct Answer: A
Explanation: In a fully denormalized database, all attributes related to a single entity are consolidated into one table. Therefore, accessing or updating that entity does not require joins or multiple tables: the data is read from one table and written back to the same table. Denormalization trades redundancy for simpler and faster reads and writes for a single entity.
Question 44
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: aggregated
Explanation: OLAP systems store pre-aggregated, multidimensional data to optimize fast analytical queries such as roll-up, drill-down, and slice-and-dice.
Question 45
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: KQL
Explanation: Azure Data Explorer is queried using Kusto Query Language (KQL), which is optimized for fast exploration, filtering, and aggregation of large datasets.
Question 46
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: pgAdmin is a standard PostgreSQL management tool and can connect to Azure Database for PostgreSQL.
Azure Database for MariaDB supports point-in-time restore only up to about 35 days, not 365 days.
Azure Database for MySQL supports SSL, but it is not always mandatory and can be configured.
Question 47
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: UPDATE
Explanation: DML statements modify data within existing tables. UPDATE changes existing records, while CREATE, DROP, and RENAME are Data Definition Language (DDL) statements.
Question 48
SELECT, INSERT, and UPDATE 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: C
Explanation: SELECT, INSERT, and UPDATE are categorized under Data Manipulation Language (DML) because they are used to retrieve and modify data stored in database tables. While SELECT is sometimes informally referred to as data retrieval, in standard SQL classification it is included within DML.
$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.
