Fundamental
Prepare and test your skills
Fundamental
Prepare and test your skills
Managed Web and Database Hosting with PaaS
Free sample question, answered and explained below. The AZ-900 Microsoft Azure Fundamentals Exam practice bank has 688 more like it. Try 10 free: instant score, no account.
A development team is designing a new customer-facing web application with a relational database backend. The team needs a managed hosting environment that allows them to deploy application code and store relational data without provisioning, patching, or managing underlying virtual machines or operating systems.
Which combination of Azure Platform as a Service (PaaS) solutions should the team implement?
Explanations
Azure Virtual Machines and Azure SQL Database
Azure Virtual Machines and Azure SQL Database
What This Combination Is
This option combines an Infrastructure as a Service (IaaS) compute layer (Azure Virtual Machines) with a Platform as a Service (PaaS) data storage layer (Azure SQL Database). While Azure SQL Database provides a managed database solution, Azure Virtual Machines requires users to provision and manage virtual compute instances.
Why It Does Not Meet the Requirement
- Compute Layer Is IaaS: Using Azure Virtual Machines to host the web front-end requires the team to configure web server software (like IIS or Nginx), apply OS security patches, and manage virtual network infrastructure.
- Conflicts with Requirements: The scenario specifically requires the hosting environment to abstract virtual machine management across both the application and database tiers.
Key Characteristics and Limitations
- Hybrid Service Model: Blends IaaS compute management with PaaS database management.
- Inconsistent Management Overhead: The team would still need dedicated system administration resources to maintain the web server VMs even while the database is fully managed.
- Complex Scaling: Scaling virtual machines often requires managing Virtual Machine Scale Sets and custom load balancers rather than utilizing native PaaS autoscaling.
This Answer Would Be Correct If
This architecture would be suitable if the web application relied on specialized Windows background services, legacy COM components, or custom software dependencies that cannot run in a managed environment like Azure App Service, but the database could still leverage a managed cloud database.
Azure Virtual Machines and SQL Server on Azure VMs
Azure Virtual Machines and SQL Server on Azure VMs
What Azure Virtual Machines and SQL Server on Azure VMs Are
Azure Virtual Machines and SQL Server on Azure VMs represent Infrastructure as a Service (IaaS) offerings in Microsoft Azure. They provide on-demand, scalable computing resources where users deploy and manage dedicated virtual machine instances running either Windows Server or Linux operating systems.
Why They Do Not Meet the Requirement
- Infrastructure Overhead: In an IaaS model, the customer is responsible for configuring, updating, and patching the operating system, as well as managing installed software components like SQL Server.
- Administrative Burden: Tasks such as scheduling database backups, configuring high-availability clusters, and managing OS security updates fall directly on the organization's IT staff.
- Fails PaaS Criteria: The scenario explicitly requests a managed PaaS solution that avoids virtual machine and operating system management.
Key Characteristics and Limitations
- Complete Administrative Control: Provides full administrative (root/administrator) access to the guest OS and database engine.
- Shared Responsibility: Microsoft manages the physical hardware, but the user manages the VM operating system, middleware, and applications.
- Higher Maintenance: Requires continuous maintenance, monitoring, and operational overhead compared to managed PaaS alternatives.
This Answer Would Be Correct If
This combination would be appropriate if an organization needed full administrative access to the underlying operating system, required custom OS-level third-party software, or planned a direct lift-and-shift migration of legacy applications requiring specific SQL Server configurations.
Azure Batch and Azure Files
Azure Batch and Azure Files
What Azure Batch and Azure Files Are
Azure Batch is a specialized cloud service used to run large-scale parallel and high-performance computing (HPC) batch jobs across compute nodes. Azure Files is a fully managed cloud file share service accessible via the standard Server Message Block (SMB) and Network File System (NFS) protocols.
Why They Do Not Meet the Requirement
- Incorrect Workload Focus: Azure Batch is designed for scheduled, compute-intensive background jobs (such as video rendering, simulations, and data transformation), not for hosting continuous, interactive web applications.
- Unsuitable Data Storage: Azure Files provides file shares for unstructured file data and shared storage; it is not a relational database management system (RDBMS) and cannot process SQL queries or manage structured relational tables.
Key Characteristics and Limitations
- Job-Oriented Compute: Azure Batch provisions compute pools dynamically to execute command-line tasks and scripts rather than listening for real-time HTTP web traffic.
- File Storage System: Azure Files serves as cloud shared storage for VMs and applications rather than providing transaction-oriented relational data querying.
- Mismatched Architecture: Does not provide native web hosting runtime environments or relational schema management.
This Answer Would Be Correct If
This combination would be appropriate if an enterprise needed to process thousands of raw data files or media assets concurrently using parallel compute algorithms and store the processed output files in a shared network drive.
Azure App Service and Azure SQL Database
Azure App Service and Azure SQL Database
What Azure App Service and Azure SQL Database Are
Azure App Service and Azure SQL Database are core Platform as a Service (PaaS) offerings in Azure. Azure App Service provides a fully managed hosting platform for web applications, RESTful APIs, and mobile backends. Azure SQL Database is a fully managed relational database-as-a-service built on the Microsoft SQL Server database engine that automates infrastructure management, software patching, and high availability.
How They Meet the Requirements
- Managed Application Hosting: Azure App Service allows developers to deploy code directly (e.g., .NET, Java, Node.js, Python) without having to configure, maintain, or update underlying virtual machines or web server software.
- Managed Relational Storage: Azure SQL Database manages relational tables and schemas while completely abstracting the underlying operating system and physical storage.
- Automated Operations: Both services handle routine administrative tasks automatically, including automated backups, OS patching, scaling, and monitoring.
Key Advantages and Capabilities
- Built-in High Availability: Azure SQL Database and App Service include built-in redundancy and high-availability guarantees without requiring complex cluster setup.
- Productivity Focus: Developers can focus entirely on writing business logic and database queries rather than infrastructure configuration.
- Flexible Scaling: Both services support rapid scaling up or scaling out to handle variable user workloads seamlessly.
- Integrated Security: Provides native support for features such as TLS encryption, Azure Active Directory authentication, and private endpoints.
Why This Is Optimal
Choosing Azure App Service together with Azure SQL Database delivers a pure PaaS architecture. This eliminates operational overhead related to server maintenance, allowing development teams to deploy modern web applications quickly with minimal administration costs.
Try 10 interactive questions like this one, free
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
- 688 practice questions across all 3 exam domains
- Every answer explained: why it is right, and why the others are not
- Scout, an AI tutor that answers your follow-up questions
- Readiness tracking by domain, so you know when to book the exam
Related questions
Keep the momentum going with these hand-picked practice scenarios
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Platform as a Service (PaaS)
Describe platform as a service (PaaS)
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Azure Key Vault HSM Keys
Describe platform as a service (PaaS)
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Platform as a Service (PaaS)
Describe platform as a service (PaaS)
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Virtual Machine Scale Sets
Describe the benefits of high availability and scalability in the cloud
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Azure Region Pairs
Describe Azure regions, region pairs, and sovereign regions
ExpertAZ-500 Microsoft Azure Security Technologies Exam
Application Permissions vs Delegated Permissions
Configure app registration permission scopes
Last updated Validated