Exam AZ-900 topic 1 question 324 discussion

I am not a robot

And Thats my Last Question for today Tomorrow Exam , Wish me luck

YNN 1. yes the price can be different between regions 2. no you can reserve capacity in specific region or availability zone but you never know in which datacentre is it. 3. no you can not stop Azure SQL Database instance, only scale down the tier.

Box 1: YES - This global distribution comes with regional pricing differences. The cost of power, labor, taxes, and other fees can vary significantly Box 2: NO - Azure reservations are used to reserve resources in Microsoft Azure, which is a cloud computing service by Microsoft. These reservations can include virtual machines, storage, databases, etc. When you reserve resources in Azure, you are not reserving server capacity at a specific data center Box 3: NO -You cannot stop an Azure SQL Database instance to decrease costs in the same way you might stop a virtual machine. Azure SQL Database is a managed service, and you are billed for the database based on the provisioned compute resources and storage, regardless of whether the database is actively in use or not.

The answer is YNY - 1. The cost of resources can vary between regions, 2. Copilot:Azure Reservations allow you to reserve compute resources for your virtual machines (VMs) in a specific region or availability zone, but not for a specific data center . By using Azure Capacity Reservations, you can ensure that your VMs have guaranteed access to the resources they need, even during periods of high demand or unexpected events. 3. Yes, you can stop an Azure SQL Database or SQL Managed Instance to reduce costs . When you stop these services, you're no longer billed for compute and licensing costs, but you'll still be charged for storage and backup storage . This can be a great way to save on costs when the database is not in use

Copilot: Yes, you can stop an Azure SQL Database or SQL Managed Instance to reduce costs1 . When you stop these services, you're no longer billed for compute and licensing costs, but you'll still be charged for storage and backup storage2 . This can be a great way to save on costs when the database is not in use

To save on billing costs, you can stop your General Purpose managed instance when you're not using it. Stopping an instance is similar to deallocating a virtual machine. When an instance is in a stopped state, you're no longer billed for compute and licensing costs but still billed for data and backup storage. - https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql&tabs=azure-powershell-prep%2Cazure-portal - what should I believe ? -

To save on billing costs, you can stop your General Purpose managed instance when you're not using it. Stopping an instance is similar to deallocating a virtual machine. When an instance is in a stopped state, you're no longer billed for compute and licensing costs but still billed for data and backup storage. - https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql&tabs=azure-powershell-prep%2Cazure-portal - what should I believe ? -

Yes you can stop SQL Instance to decrease costs. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql&tabs=azure-powershell-prep%2Cazure-portal

The correct answer is YNN. 1st one is obvious 2nd one is in the comments 3rd one is; You cannot stop an Azure SQL Database instance to decrease costs in the same way you might stop a virtual machine. Azure SQL Database is a managed service, and you are billed for the database based on the provisioned compute resources and storage, regardless of whether the database is actively in use or not.

2) no. Azure Reservations are used to reserve resources such as virtual machines, databases, or other services in Azure, but they do not reserve server capacity at specific data centers. When you purchase an Azure Reservation, you are committing to pay for a specific instance type within a region for a one- or three-year term. This commitment provides you with significant cost savings compared to pay-as-you-go pricing. However, Azure Reservations do not guarantee or reserve physical server capacity at specific data centers. Azure manages its infrastructure dynamically, and the physical location of your resources may vary based on Azure's load balancing and resource allocation algorithms.

Second Q? is Yes. You can use Azure reservation to reserve server capacity. to Lower your cost you can pay upfront or pay on a monthly basis at no additional cost. https://azure.microsoft.com/en-gb/pricing/reserved-capacity/

Third question should be Y It is possible to stop a Azure SQL Instance https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql&tabs=azure-powershell-prep%2Cazure-portal

There is no way to stop the server/database, however, what you could do instead is switch to a lower-cost tier or switch to serverless tier with auto-pause enabled. With auto-pause enabled the server will pause if there is no activity during the time period you set (minimum of 1 hour). https://learn.microsoft.com/en-us/answers/questions/1351021/how-to-stop-azure-sql-database

Q3 - should be Y per this link: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/pause-and-resume-compute-portal#pause-compute "To reduce costs, you can pause and resume compute resources on-demand. For example, if you won't be using the database during the night and on weekends, you can pause it during those times, and resume it during the day. You won't be charged for compute resources while the database is paused. However, you will continue to be charged for storage." Only a concern is "STOP in Q" vs "Pause in the MS doc", I believe we should treat them as synonyms in current context, since the focus of the Q is on "reducing costs".

Ans - YNN. 2nd - Azure Reservations are used to reserve capacity for specific Azure services and resources, but they do not reserve physical server capacity at a specified datacenter. Instead, they allow you to prepay for and reserve virtual machine (VM) instances or other Azure resources within a particular Azure region.

You can stop an Azure SQL Database instance to decrease cost - Yes source: https://azure.microsoft.com/en-us/updates/stopstart-functionality-for-azure-database-for-mysql/