nerdexam
Microsoft

AI-102 · Question #128

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection

The correct answer is A. reduced administrative effort for managing the server infrastructure D. access to the latest features. Azure PaaS relational databases like Azure SQL Database offer significant benefits including reduced administrative overhead for server infrastructure and automatic access to the latest features.

Submitted by packet_pusher· Mar 30, 2026

Question

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection Is worth one point.

Options

  • Areduced administrative effort for managing the server infrastructure
  • Bcomplete control over backup and restore processes
  • Cin-database machine learning services S3
  • Daccess to the latest features

How the community answered

(36 responses)
  • A
    92% (33)
  • B
    3% (1)
  • C
    6% (2)

Why each option

Azure PaaS relational databases like Azure SQL Database offer significant benefits including reduced administrative overhead for server infrastructure and automatic access to the latest features.

Areduced administrative effort for managing the server infrastructureCorrect

PaaS offerings abstract away the underlying server infrastructure, meaning Microsoft manages tasks like operating system patching, hardware maintenance, and database engine updates, which significantly reduces the administrative effort for the customer.

Bcomplete control over backup and restore processes

While PaaS relational databases offer robust backup and restore capabilities, the customer typically has managed control (e.g., configuring retention) rather than complete control over the underlying backup processes and infrastructure, which are handled by the platform.

Cin-database machine learning services S3

In-database machine learning services are specific features that might be available in some database editions or configurations, but they are not a universal core benefit of all PaaS relational database offerings themselves, nor a primary differentiator of PaaS as a whole.

Daccess to the latest featuresCorrect

PaaS services are continuously updated and managed by the cloud provider, ensuring that customers automatically receive the latest features, security patches, and performance improvements without manual intervention or upgrade cycles.

Concept tested: PaaS relational database benefits

Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Topics

#PaaS benefits#Azure SQL Database

Community Discussion

No community discussion yet for this question.

Full AI-102 Practice