Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Microsoft Discussions

Exam DP-900 topic 1 question 99 discussion

Actual exam question from Microsoft's DP-900
Question #: 99
Topic #: 1
[All DP-900 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
brainiacATH
Highly Voted 1 year, 7 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 16 times
okayhey
2 months, 1 week 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
1 year, 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
1 year, 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
1 year, 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 1 year, 8 months ago
Shouldn't it be Elastic Pool, MI then Single Db?
upvoted 8 times
Sr18
2 weeks 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
2 weeks ago
My Bad Typo!!!, Correct Ans: Single, MI, Single
upvoted 1 times
...
...
virtualcharm
1 year, 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
1 year, 7 months ago
Not a pro, but I had the same idea.
upvoted 1 times
...
JA2018
1 year, 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
...
...
AGTraining
Most Recent 2 months, 2 weeks ago
EP, MI single
upvoted 1 times
...
m0j7zdgm
3 months, 1 week 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
6 months, 1 week 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 3 times
...
Pixan
6 months, 2 weeks 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
1 year, 1 month 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
6 months, 2 weeks 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
1 year, 2 months ago
Correct Answer
upvoted 2 times
...
ravick4u
1 year, 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
1 year, 5 months ago
correct: Single, Managed, Elastic
upvoted 2 times
...
Maddhy
1 year, 6 months ago
Single,MI,Single
upvoted 2 times
...
OldSchool
1 year, 6 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
1 year, 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
...
fusioner
1 year, 8 months ago
Correct Answer
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel