Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 99 discussion

Actual exam question from Microsoft's DP-900

Question #: 99
Topic #: 1

DRAG DROP -
Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match its worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

Box 1: Azure SQL Database single database
Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.
Scenarios well suited for serverless compute
Single databases with intermittent, unpredictable usage patterns interspersed with periods of inactivity, and lower average compute utilization over time.
Single databases in the provisioned compute tier that are frequently rescaled and customers who prefer to delegate compute rescaling to the service.
New single databases without usage history where compute sizing is difficult or not possible to estimate prior to deployment in SQL Database.
Box 2: Azure SQL Managed Instance
Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service.
Box 3: Azure SQL Database elastic pool
Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. Elastic pools in SQL Database enable software as a service (SaaS) developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

by fusioner at Sept. 1, 2022, 10:31 a.m.

Comments

Submit Cancel

brainiacATH

Highly Voted 2 years, 8 months ago

Correct answer should be single, MI, single. Elastic Pool uses a server, and is thus not serverless, and the third point refers to 'a database' while Elastic Pool is for scaling multiple databases.

upvoted 19 times

okayhey

1 year, 2 months ago

All azure services use a server... Lol it just depends on the type of cloud model what your responsibilities are. Elastic pool uses shared resources on a server, but you don't manage the server itself, nor the OS. You do manage scaling, which makes it PaaS and not Serverless. Single database can dynamically scale up and down, making it a Serverless solution. Single, MI, single use correct, but not for the reasons you gave

upvoted 1 times

...

AnonymousJhb

2 years, 7 months ago

Single, MI, single. First option is single because MS: Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.

upvoted 3 times

j888

2 years, 6 months ago

You can choose serverless or provisioned resources when creating the single database in Azure SQL. https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?view=azuresql&tabs=azure-portal. "ach has its own service tier within the DTU-based purchasing model or vCore-based purchasing model and a compute size defining the resources allocated to the database engine." https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-overview?view=azuresql So I doubt this fall under serverless. Elastic on the other hand is pure serverless, and the main purpose of Elastic pool is the ability to scale when needed which in turn will save cost. So I will choose Elastic, MI, Elastic.

upvoted 3 times

j888

2 years, 6 months ago

Actually, the given answer is correct. This statement did say single database as serverless. https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql

upvoted 1 times

...

SwissAir

Highly Voted 2 years, 8 months ago

Shouldn't it be Elastic Pool, MI then Single Db?

upvoted 9 times

Sr18

1 year ago

No, Elastic Pool is not serverless. So for first one it will be Single. Second one is MI. Where as 3rd one should be MI because we are talking about single database not databases. If you will have multiple databases then mostly Elastic Pool will be cheaper as all will share same resources.

upvoted 1 times

Sr18

1 year ago

My Bad Typo!!!, Correct Ans: Single, MI, Single

upvoted 1 times

...

virtualcharm

2 years, 1 month ago

Yes, EP, MI and single. The last two options want a database answer. The first options wants a configuration answer, elastic pool is a config.

upvoted 4 times

...

just_karlijn

2 years, 8 months ago

Not a pro, but I had the same idea.

upvoted 1 times

...

JA2018

2 years, 7 months ago

For Elastic pool, all the databases are hosted on a single server to allow sharing of system resources (e.g. CPU, RAM, disk, etc)

upvoted 1 times

...

ROCTW

Most Recent 1 month, 1 week ago

single, MI, elastic pool

upvoted 1 times

...

Jxx80i

7 months, 2 weeks ago

Azure SQL Database elastic pool ↔ A low-cost, low-maintenance database Azure SQL Database single database ↔ A serverless configuration Azure SQL Managed instance ↔ A database that has the highest compatibility with on-premises Microsoft SQL Server

upvoted 1 times

...

AGTraining

1 year, 3 months ago

EP, MI single

upvoted 1 times

...

m0j7zdgm

1 year, 3 months ago

Azure SQL DB Single Instance - serverless https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. Azure SQL Managed Instance - highest compatible with on-premise SQL server (Actually it's SQL server on VM but that's not an option here) https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql https://azure.microsoft.com/en-us/products/virtual-machines/sql-server#:~:text=SQL%20Server%20on%20Azure%20Virtual%20Machines%20is%20100%20percent%20compatible,Pro%20Linux%2C%20and%20Windows%20Server. low cost low maint DB - Azure SQL DB Elastic Pool

upvoted 2 times

...

Kemsmems

1 year, 6 months ago

"Serverless is a compute tier for single databases in Azure SQL Database" https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose.

upvoted 4 times

...

Pixan

1 year, 6 months ago

Hi Everyone!! Join ET and get actual and valid study material: https://examstopics.quora.com/ and pass your exam in first attempt. Study Smart Not Hard

upvoted 1 times

...

aadil111

2 years, 2 months ago

1. Azure SQL Database Elastic Pool: C. A low-cost, low-maintenance database. • An Azure SQL Database Elastic Pool allows you to manage and scale multiple databases with a shared set of resources. It is a cost-effective option for managing databases with varying and unpredictable usage patterns. 2. Azure SQL Database Single Database: B. A database that has the highest compatibility with on-premises Microsoft SQL Server. • Azure SQL Database Single Database is a fully managed, highly available, and scalable relational database service. It provides the highest compatibility with on-premises Microsoft SQL Server and supports most of the features available in SQL Server. 3. Azure SQL Managed Instance: A. A serverless config. • Azure SQL Managed Instance is a fully managed platform-as-a-service (PaaS) solution that provides SQL Server compatibility. It offers a serverless configuration that automatically scales compute and storage resources based on the workload demands.

upvoted 5 times

barcodepiglet

1 year, 6 months ago

I don't think is correct. Azure SQL Managed Instance has the highest compability with on-premises MSFT SQL Server.

upvoted 4 times

...

chiiiweiii

2 years, 2 months ago

Correct Answer

upvoted 3 times

...

ravick4u

2 years, 3 months ago

The answer is correct (Key point is "serverless" which is for Azure SQL Database single database and "low cost" which is for elastic pool). I can not update the image here but when you try to create new Azure SQL database read the description on the portal. https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql

upvoted 3 times

...

Dusica

2 years, 6 months ago

correct: Single, Managed, Elastic

upvoted 2 times

...

Maddhy

2 years, 6 months ago

Single,MI,Single

upvoted 2 times

...

OldSchool

2 years, 7 months ago

1. Single Instance "Serverless is a compute tier for single databases in Azure SQL Database..." https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql 2. Managed Instance 3. Elastic Pool "Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands." https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql

upvoted 5 times

...

PatYeo

2 years, 7 months ago

The model answer appears to be correct based on the supporting statements and links : 1) Single Instance 2) Managed Instance 3) Elastic Pool

upvoted 7 times

...