{"id":222,"date":"2026-04-03T22:47:54","date_gmt":"2026-04-04T01:47:54","guid":{"rendered":"https:\/\/proglab.com.br\/?page_id=222"},"modified":"2026-04-10T21:30:39","modified_gmt":"2026-04-11T00:30:39","slug":"recommend-a-database-service-tier-and-compute-tier","status":"publish","type":"page","link":"https:\/\/proglab.com.br\/?page_id=222","title":{"rendered":"Recommend a database service tier and compute tier"},"content":{"rendered":"\n<p>When studying Azure SQL purchasing models, make sure you understand the difference between the DTU and the vCore models. <\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"737\" height=\"723\" data-id=\"443\" src=\"https:\/\/proglab.com.br\/wp-content\/uploads\/2026\/04\/image-18.png\" alt=\"\" class=\"wp-image-443\" srcset=\"https:\/\/proglab.com.br\/wp-content\/uploads\/2026\/04\/image-18.png 737w, https:\/\/proglab.com.br\/wp-content\/uploads\/2026\/04\/image-18-300x294.png 300w\" sizes=\"auto, (max-width: 737px) 100vw, 737px\" \/><\/figure>\n<\/figure>\n\n\n\n<p>The DTU model, short for Data-base Transaction Unit, is a simplified bundled option. It combines things like your compute, storage and I\/O into a single package which makes it easier to choose that service. Remember, there are three tiers; those are Basic, Standard, and Premium, and as you move up the tiers, both performance and storage capacity increases. Remember, you&#8217;re going to see a lot of scenario-based questions, so these are the type of things that you&#8217;ll need to know. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"731\" height=\"725\" src=\"https:\/\/proglab.com.br\/wp-content\/uploads\/2026\/04\/image-19.png\" alt=\"\" class=\"wp-image-444\" srcset=\"https:\/\/proglab.com.br\/wp-content\/uploads\/2026\/04\/image-19.png 731w, https:\/\/proglab.com.br\/wp-content\/uploads\/2026\/04\/image-19-300x298.png 300w, https:\/\/proglab.com.br\/wp-content\/uploads\/2026\/04\/image-19-150x150.png 150w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/figure>\n\n\n\n<p>And then we have the vCore model, which gives you a lot more flexibility and greater control. It lets you control scale, compute, and storage independently; you&#8217;ll need to know that. And you want to know that the two provisioning types that you have are provisioned compute, where resources are always allocated and serverless compute, which automatically scales based on usage and pauses during inactivity which saves you costs. <\/p>\n\n\n\n<p>For your exam, focus on when to use each model. Now, keep in mind, DTU is great for predictable workloads and simplicity, while vCore is better for customization, transparency and aligning with your on-prem type specifications. Also, be familiar with how each model impacts performance, pricing, and scalability. These distinctions are likely to show up in scenario-based questions.<\/p>\n\n\n\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/training\/modules\/design-data-storage-solution-for-relational-data\/5-recommend-database-scalability\/?ns-enrollment-type=learningpath&amp;ns-enrollment-id=learn.wwl.design-data-storage-solutions\">Recommend a solution for database scalability<\/a><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When studying Azure SQL purchasing models, make sure you understand the difference between the DTU and the vCore models. The DTU model, short for Data-base Transaction Unit, is a simplified bundled option. It combines things like your compute, storage and I\/O into a single package which makes it easier to choose that service. Remember, there &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/proglab.com.br\/?page_id=222\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Recommend a database service tier and compute tier&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":175,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-222","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/proglab.com.br\/index.php?rest_route=\/wp\/v2\/pages\/222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/proglab.com.br\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/proglab.com.br\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/proglab.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/proglab.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=222"}],"version-history":[{"count":3,"href":"https:\/\/proglab.com.br\/index.php?rest_route=\/wp\/v2\/pages\/222\/revisions"}],"predecessor-version":[{"id":461,"href":"https:\/\/proglab.com.br\/index.php?rest_route=\/wp\/v2\/pages\/222\/revisions\/461"}],"up":[{"embeddable":true,"href":"https:\/\/proglab.com.br\/index.php?rest_route=\/wp\/v2\/pages\/175"}],"wp:attachment":[{"href":"https:\/\/proglab.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}