AZ-900 Exam - Question 42

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

Your company plans to migrate all its data and resources to Azure.

The company's migration plan states that only Platform as a Service (PaaS) solutions must be used in Azure.

You need to deploy an Azure environment that meets the company migration plan.

Solution: You create an Azure App Service and Azure virtual machines that have Microsoft SQL Server installed.

Does this meet the goal?

Examice · Accepted Answer

The Azure App Service is indeed a Platform as a Service (PaaS). However, Azure virtual machines (VMs) with Microsoft SQL Server installed are classified as Infrastructure as a Service (IaaS). In a PaaS model, the user does not manage the underlying infrastructure or the operating system, while in an IaaS model, the user is responsible for managing these components. Since the company's migration plan specifies the use of only PaaS solutions, deploying Azure VMs does not meet the requirement. Therefore, this solution does not meet the goal.

CJWit · Answer

The question says "YOU create an Azure App Service and Azure VMs with SQL installed"

We are getting stuck on the tech terms and not reading the question.  Is this a PaaS solution, if YOU create it? I don't think so, guys. I think the answer here is NO

even the solution text says so lol:
Azure App Service is a PaaS (Platform as a Service) service. Azure virtual machines are an IaaS (Infrastructure as a Service) service, and a Paas service.
Therefore, this solution does meet the goal.

Answer = NO

52592b8 · Answer

Looks like i made a wrong decision buying this subscription. too many wrong answers that are basic knowledge!

kedamni · Answer

the answer is NO , 
a VM is IaaS

Robdebert · Answer

An Azure VM with SQL server installed in it falls under IaaS. So the answer is No.
See https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview

m_i_e_k_e_ · Answer

Azure App Service is a PaaS (Platform as a Service) service. However, Azure virtual machines are an IaaS (Infrastructure as a Service) service. Therefore, this solution does not meet the goal.

Feraso · Answer

VM is IaaS so the answer is no.

Jila · Answer

The answer is YES....Azure V.M + Azure SQL Server = PaaS take example of Myslq + PC resulting to a hosting capabilities we call localhost.

ReeTech · Answer

Ans should be: No, Install DB in VM is IaaS.

Mophase · Answer

it is B

Yoryos · Answer

https://azure.microsoft.com/en-gb/services/virtual-machines/sql-server/#faq
IaaS (SQL Server on Azure Virtual Machines) is generally seen as the fastest and most straightforward migration option, but it requires a more hands-on approach to database administration. You’ll continue to purchase, install, configure and manage your own software, including operating systems, middleware and applications.

Fully managed PaaS (Azure SQL Managed Instance, Azure SQL Database ) reduces or eliminates day-to-day administration but may require changes to the application code. Automated and intelligent features boost performance and data protection on your behalf, while cloud-native technologies such as serverless and Hyperscale automatically scale compute and storage resources based on workload demands.

alexandre1979 · Answer

IAAS ==> Azure virtual machines

Tito93 · Answer

VM ==> IaaS

sriram72 · Answer

List most have said, Azure VMs are not PAAS.  That is why, B

YuvaRajaVignesh · Answer

Key word: Azure virtual machines that have Microsoft SQL Server installed.

VM is IaaS, however VM that have MS SQL server falls under PaaS.
hence the answer is Yes!

Burken · Answer

No no no. B

ssssss78 · Answer

ANS: B

NKG123 · Answer

155 answers for this simple question. Go back to study. 
It’s definitely No.

Annaisathya · Answer

The answers given and the discussion makes really confusing to decide the correct Answer!

Driyan · Answer

Azure App Service is a PaaS (Platform as a Service) service. However, Azure virtual machines are an IaaS (Infrastructure as a Service) service. Therefore, this solution does not meet the goal.

robson_barbosa · Answer

virtual machines are an IaaS (Infrastructure as a Service) service

Emmysoft · Answer

Azure App Service is a PaaS offering that enables you to build and deploy web applications and APIs. However, deploying Azure virtual machines with Microsoft SQL Server installed is an example of Infrastructure as a Service (IaaS) since you are managing the virtual machines and the SQL Server installation. SO THE ANSWER IS NO.

VinnyMacD · Answer

The company's migration plan states that only "Platform as a Service (PaaS) solutions must be used in Azure."
Solution: You create an Azure App Service and 
"Azure virtual machines that have Microsoft SQL Server installed." is not PaaS. So the answer is NO.

Nico1996 · Answer

The company's migration plan requires that only Platform as a Service (PaaS) solutions must be used in Azure.

Azure App Service is a PaaS solution, which is suitable for hosting web apps, RESTful APIs, and mobile backends.
However, Azure virtual machines (VMs) with Microsoft SQL Server installed are considered Infrastructure as a Service (IaaS), not PaaS. VMs provide infrastructure-level resources rather than platform-level services.
To meet the goal of using only PaaS solutions, you should use Azure SQL Database instead of deploying SQL Server on virtual machines. Azure SQL Database is a fully managed PaaS database engine that handles most of the database management functions, such as upgrading, patching, backups, and monitoring without user involvement.

Therefore, the solution should be:

Azure App Service for hosting web applications.
Azure SQL Database for database services.
This ensures that the environment consists entirely of PaaS solutions, in line with the company's migration plan.

Rinesh25 · Answer

No.,B is correct

Alsari · Answer

Azure virtual machine is an IaaS

VPoo · Answer

Wouldn't VMs be included in PaaS? Answer should be "Yes"

PaaS
Platform-as-a-Service
This cloud service model is a managed hosting environment. The cloud provider manages the virtual machines and networking resources, and the cloud tenant deploys their applications into the managed hosting environment. For example, Azure App Services provides a managed hosting environment where developers can upload their web applications, without having to worry about the physical hardware and software requirements.

raulek · Answer

VM's are IaaS plus while installing SQL server on it, it will be considered as a Hybrid Benefits solution as you need to own license for it.

tarmah · Answer

Anyone who already gave exam within these days can help me in answering this question? Is it Yes or No

tonyrz · Answer

The Answer is No. Check out this documentation: https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview
"SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure."

krisca · Answer

answer should be NO,
 vm is IaaS
https://azure.microsoft.com/zh-tw/services/virtual-machines/#overview

Bigtee70 · Answer

Look back to the statement that says:
"The companyג€™s migration plan states that only Platform as a Service (PaaS) solutions must be used in Azure"
Then the answer has to be NO because AzureVM is IaaS. This straight forward.

FinOps · Answer

VM needs to create + MS SQL needs to be installed on it = IAAS
so answer is big "NO"

thegreatnivram · Answer

The answer is NO. Azure virtual machines that have Microsoft SQL Server installed are Infrastructure as a Service.

AidenYoukhana · Answer

The answer should be NO. VM is considered to be IaaS and NOT PaaS.

DGeorgieva · Answer

Question 73 is evidence, that the correct answer here is NO. VM + MS SQL server is not PaaS.

glhs · Answer

B is correct answer

sugarfrosted · Answer

The explanation says it's B, but the answer here is A

Vishnuhup · Answer

It should be B

Frank_Rivera · Answer

A: is wrong, Azure App Service is correct but Azure VMs are an IaaS ...Answer is B:

skimpidoodles · Answer

VM itself is IaaS.

cdiazal · Answer

VM is IAAS it does not matters what do you install after, VM is IAAS so answer is B

Darkeh · Answer

A VM IS NOT PAAS

tcuroso · Answer

Adding my vote to the pile. As stated by many others, Azure VM is IaaS. This is pretty unambiguous in the literature. Answer should be B.

hashtagbigbang · Answer

VM is a IaaS service no matter what is installed in it.

maruf1126user · Answer

IaaS is under PaaS

Rawatvs · Answer

Should be B

mmmmmnm · Answer

The correct answer is NO.
You do not install/create VMs when you use PaaS.

ars25 · Answer

It should be NO. VM itself a IAAS service.

RajeshA · Answer

SQL Server installed on a VM is falls in the category of IaaS hence the answer should be No

Vennydev · Answer

when creating a VM you have to manage the underlying infrastructure, but with the App service and SQL data base you go straight ahead to use them for the purpose you have created them for while Azure is concerned about managing the underlying infrastructure...
creating PaaS services costs more when making Azure Pricing Estimates and far less when you have to create your own VM to host these services

adolsworld · Answer

Virtual machines are IaaS

SatenderRathee · Answer

Answer = B

fuchsm999 · Answer

B is correct

pc131 · Answer

Azure virtual machines that have Microsoft SQL Server is still IAAS - you still have to manage Azure  Virtual Machines, so this does not meet PAAS requirements asked in question.

RKDON · Answer

Answer : B

yogec17918 · Answer

B is correct

zokzz · Answer

answer is B

jybong · Answer

Azure SQL Database is a relational database-as-a-service (DBaaS) hosted in Azure that falls into the industry category of Platform-as-a-Service (PaaS).

https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview

vinkals · Answer

VM with SQL Server is IAAS , so answer is NO: Reference https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview

Monster5566 · Answer

Azure App Service and Azure SQL databases are examples of Azure PaaS solutions.

kapy024 · Answer

VM with SQL Database is IaaS not PaaS
So answer is NO

Pa1theAchiever · Answer

B is correct

_your__fear_ · Answer

B is correct

IssaZeidan · Answer

Azure storage account is a paas which is meet the goal as well as the App Service

MarCro · Answer

B is correct answer.
Azure Virtual machines are IaaS.

Mushfig · Answer

which one is correct

Sandyonweb · Answer

B, An Azure VM with SQL server installed in it falls under IaaS. So the answer is No.
Please refer the MS Doc- https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview

Driyan · Answer

Correct Answer should be B

Driyan · Answer

Correct Answer should be B

Allen2020 · Answer

Answer is No, It has VM and it is IaaS.

kirshoff · Answer

Are "App Service" and "Virtual Machine" together PaaS? What is your comment on this?

wyabcp · Answer

Answer should be No

buiducvu · Answer

Azure virtual machines are an IaaS

BrkyUlukn · Answer

Answer is No

The question say you create a virtual machine as a part of the solution. However, you cannot create a vm in PaaS...Vm runs underneath of PaaS solution...user can only use Paas to create the application not infrastructure such as vm. An Azure VM with SQL server installed in it falls under IaaS. So the answer is No.

KIMJG · Answer

sql server installed <- Iaas

LPaul · Answer

When you said "Create Virtual machine", it already out of scope . PaaS in not include create VM .

ier94 · Answer

Answer is no, because Microsoft SQL Server running on Azure VM is an example of IaaS, and the question states that only PaaS solutions must be used.

ZionKofi · Answer

No, the solution does not fully meet the goal because the company's migration plan states that only Platform as a Service (PaaS) solutions must be used in Azure. Azure App Service is a PaaS offering that allows developers to build, deploy, and scale web apps, mobile app backends, and RESTful APIs, but the use of Azure virtual machines with Microsoft SQL Server installed represents an Infrastructure as a Service (IaaS) solution.

To fully meet the goal, you could use Azure SQL Database, which is a PaaS offering that provides a managed SQL Server database service, eliminating the need for managing underlying infrastructure. This would be a PaaS solution that meets the company's migration plan.

bqre · Answer

It should be B. VMs are IaaS

Vismuth · Answer

No. Az VM is IaaS, not a PaaS service.

MSStudent · Answer

Answer should be no since virtual machine is in the list and VMs are IaaS and not PaaS

KittieHearts · Answer

Azure VM is IAAS

Eugene13 · Answer

SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS)

amoln · Answer

Ans is Yes, Azure VM with SQL installed in it is PaaS service, as user don't need to manage SQL software, backup, patching even not OS etc.

oopspruu · Answer

A VM with SQL Server installed is IaaS. Hence answer should be NO (B)

OlaAZ · Answer

The answer is No, you will be using VM which consider IaaS

Ani69 · Answer

B is the right answer

yaz083 · Answer

"only Platform as a Service (PaaS) solutions must be used"

therefore, NO because VM is IaaS

AkshayTadla · Answer

Correct answer is NO

TrainingCA06 · Answer

Answer is NO:
SQL Server on Azure VMs falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure.
https://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

LaReis · Answer

A criação de máquinas virtuais do Azure com o Microsoft SQL Server instalado se enquadra na categoria de Infraestrutura como Serviço (IaaS), não em Plataforma como Serviço (PaaS)12. Para atender ao plano de migração da empresa que especifica o uso de soluções PaaS, você deve utilizar serviços como o Azure App Service para aplicativos web e Azure SQL Database para bancos de dados SQL

arjunyv2022 · Answer

Azure App Service is a PaaS solution that allows you to host web applications without managing the underlying infrastructure. ✅
Azure Virtual Machines (VMs) with SQL Server is an Infrastructure as a Service (IaaS) solution, not PaaS ❌.
Since the company's migration plan requires only PaaS solutions, and the provided solution includes IaaS (Azure VM with SQL Server), this does not meet the goal.

AZ-900 Exam - Question 42

Discussion