DP-900 Exam - Question 17

correct

YES, NO, YES

Yes No No

Y,N,N - you can't pause a managed instance

It depends on time. Past versions of service wouldn't allow to pause no sql, unless if it was a serveless slq. Nowadays, its permited to pause and to reduce compute costs. So, for nowadays, the answer would be Y, N, Y

YES, NO, NO

In exam 21 April 2022

I disagree: you can pause your PaaS resources to save money, you are still billed but less than if the resource is running.

Third answer should be YES. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/pause-and-resume-compute-portal As for my understanding, you can pause compute. You will still pay for storage, but this will *reduce* your costs, and that's what's stated in the question. In order to incur Zero costs the work around is to 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.

the tricky part here is that it says ALL and not all PaaS services can be paused

This question appeared in the 07/07/23 exam and the answer is correct.

YES, NO, NO (seems correct)

Corret way is: YES, NO, NO

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)

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.

ignore this, it asks for all relational and non-relational PaaS offerings

Correct Answer.

YES NO NO

Yes, No, No. Appeared on 2023-11-05.

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.

Final Answers: ✅ Yes ❌ No ❌ No

export/import DB is not considered as pausing in my humble opinion. It is considered as deleting and recreating. Should be Yes, No, No.

the compute can be paused in a pool https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/pause-and-resume-compute-portal

On exam today 08/08/23

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

YES, NO, NO

what is the "end users" mean? developer? or is like player or something like that?

Yes,NO,Yes

Y N N Yes NO NO

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"