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.
Question
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)- A92% (33)
- B3% (1)
- C6% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.