exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 17 discussion

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

HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Yes -
Like IaaS, PaaS includes infrastructure ג€" servers, storage, and networking ג€" but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources

Box 2: No -
You manage the applications and services you develop, and the cloud service provider typically manages everything else.


Box 3: No -
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB."
Reference:
https://azure.microsoft.com/en-us/overview/what-is-paas

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
sakanan
Highly Voted 3 years, 3 months ago
correct
upvoted 38 times
...
Edriv
Highly Voted 3 years ago
YES, NO, YES
upvoted 16 times
Jezza8024
1 year ago
Yeah dont be an idiota
upvoted 1 times
...
HananS
3 years ago
Don't be an IDIO.
upvoted 18 times
...
...
razit
Most Recent 3 months, 1 week ago
I think the correct answers should be YES, NO, NO. The third one is NO because of the keyword 'paused'. Auto-pause is available in Azure SQL Database ServerLess, but not in other databases. Azure SQL DB Provisioned Tier don't have option "stop" or "pause"
upvoted 1 times
...
dhruvstar
5 months ago
Final Answers: ✅ Yes ❌ No ❌ No
upvoted 2 times
...
man5484
8 months, 3 weeks ago
Yes: PaaS (Platform as a Service) database offerings handle much of the setup, maintenance, and scaling automatically, reducing the configuration effort compared to IaaS (Infrastructure as a Service), where the user must manage more aspects of the environment. No: In PaaS offerings, the underlying OS is managed by Azure, and users do not have control over OS updates or versions. This is handled by the cloud provider to ensure consistent maintenance and security. No: Not all PaaS database offerings in Azure support pausing to reduce costs. Some offerings, like Azure SQL Database serverless, allow pausing, but many others do not provide this feature, meaning charges continue to accrue even if the database is idle.
upvoted 2 times
...
the_jigglypuff
9 months, 3 weeks ago
Y N N Yes NO NO
upvoted 1 times
...
Jeevi0905
1 year ago
Yes,NO,Yes
upvoted 1 times
...
jerrybin30731
1 year, 1 month ago
what is the "end users" mean? developer? or is like player or something like that?
upvoted 1 times
...
Ruesam
1 year, 2 months ago
Yes, No, No. I see there are a lot of questions about the last one. The answer is no because it’s true that at the moment, you cannot pause Azure SQL DB: https://techcommunity.microsoft.com/t5/azure-database-support-blog/stop-azure-sql-database/ba-p/3890369#:~:text=Stopping%20an%20Azure%20SQL%20Database,SQL%20Database%20serverless%20compute%20tier.
upvoted 3 times
...
AGTraining
1 year, 5 months ago
YES, NO, NO
upvoted 1 times
...
Cabusas
1 year, 5 months ago
For me it is YES, NO, YES. Because in an Azure SQL Managed Instance you can pause it. Refer: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql&tabs=azure-powershell-prep%2Cazure-portal
upvoted 1 times
...
trashbox
1 year, 9 months ago
Yes, No, No. Appeared on 2023-11-05.
upvoted 2 times
...
DonDemik
1 year, 10 months ago
Last question is tricky : not all databases can be paused. f.x. Cosmos DB. However, some services such as Azure SQL database provides an auto-pause feature that user can configure. https://learn.microsoft.com/en-us/answers/questions/707576/how-do-i-pause-an-azure-sql-database-(serverless)
upvoted 3 times
...
FedeMI
1 year, 11 months ago
Corret way is: YES, NO, NO
upvoted 3 times
...
MannyJZ
1 year, 11 months ago
On exam today 08/08/23
upvoted 1 times
...
akhil5432
1 year, 12 months ago
YES NO NO
upvoted 2 times
...
VNR25
2 years ago
This question appeared in the 07/07/23 exam and the answer is correct.
upvoted 5 times
...
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
Loading ...