{"id":1232,"date":"2022-04-01T14:05:00","date_gmt":"2022-04-01T14:05:00","guid":{"rendered":"https:\/\/thecloudmarathoner.com\/?p=1232"},"modified":"2022-04-25T13:45:28","modified_gmt":"2022-04-25T13:45:28","slug":"study-guide-az-305-part-9-design-a-data-storage-solution-for-relational-data","status":"publish","type":"post","link":"https:\/\/thecloudmarathoner.com\/index.php\/2022\/04\/01\/study-guide-az-305-part-9-design-a-data-storage-solution-for-relational-data\/","title":{"rendered":"Study Guide AZ-305: Part 9 &#8211; Design a data storage solution for relational data"},"content":{"rendered":"\n<p>Hi Cloud Marathoners!<\/p>\n\n\n\n<p>Welcome to the next blog post (Part 9\/12) from the Az-305 series to help you get ready for the <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/az-305\" target=\"_blank\">AZ-305 exam<\/a>. <br><br>Please, check the previous blog posts listed below, if you landed on this page for the first time&nbsp;\ud83d\ude42<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"table-of-content-blog-series\">Table of content (blog series)<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>*** Design Identity, Governance, and Monitoring Solutions ***<\/strong><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/02\/11\/study-guide-for-az-305-designing-microsoft-azure-infrastructure-solutions-part-1-design-a-governance-solution\/\" target=\"_blank\">Part 1: Design a governance solution<\/a><\/li><li><a href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/02\/12\/study-guide-for-az-305-part-2-design-authentication-and-authorization-solutions\/\">Part 2:\u00a0Design Authentication and Authorization Solutions<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/02\/19\/study-guide-for-az-305-part-3-design-a-solution-to-log-and-monitor-azure-resources\/\" target=\"_blank\">Part 3:\u00a0Design a solution to log and monitor Azure resources<\/a><\/li><li><strong>*** Design Infrastructure Solutions ***<\/strong><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/02\/24\/study-guide-for-az-305-part-4-design-a-compute-solution\/\" target=\"_blank\">Part 4: Design a compute solution<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/03\/07\/study-guide-for-az-305-part-5-design-an-application-architecture-solution\/\" target=\"_blank\">Part 5:\u00a0Design an application architecture solution<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/03\/11\/study-guide-for-az-305-part-6-design-a-network-infrastructure-solution\/\" target=\"_blank\">Part 6:\u00a0Design a network infrastructure solution<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/03\/19\/study-guide-for-az-305-part-7-design-a-migration-solution\/\" target=\"_blank\">Part 7:\u00a0Design a migration solution<\/a><\/li><li><strong>*** Design Data Storage Solutions ****<\/strong><\/li><li><a href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/03\/25\/study-guide-az-305-part-8-design-a-non-relational-storage-solution\/\">Part 8:\u00a0Design a non-relational data storage solution<\/a><\/li><li><a href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/04\/01\/study-guide-az-305-part-9-design-a-data-storage-solution-for-relational-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">Part 9:\u00a0Design a data storage solution for relational data<\/a><\/li><li><a href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/04\/10\/study-guide-az-305-part-10-design-a-data-integration-solution\/\">Part 10:\u00a0Design a data integration solution<\/a><\/li><li><strong>*** Design Business Continuity Solutions ***<\/strong><\/li><li><a href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/04\/16\/study-guide-az-305-part-11-design-for-business-continuity-backup-and-disaster-recovery\/\">Part 11:\u00a0Design a solution for Business Continuity, backup and disaster recovery<\/a>\u00a0<\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/04\/22\/study-guide-for-az-305-part-12-design-for-high-availability\/\" target=\"_blank\">Part 12: Design for high availability<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what-is-the-compute-service\">What is a relational data?<\/h3>\n\n\n\n<p>A relational data is a set of data that have a certain pre-defined structure. Once this data structure (aka, data schema) is enforced on data then we can start talking about a relational database.<\/p>\n\n\n\n<p>Thus, a relational database (DB) is a collection of data items with some pre-defined relationships. These data items are organized as a set of tables with columns and rows. The tables are used to hold a similar type of information object to be represented in the database.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/learn\/achievements\/explore-relational-data-offerings-azure-social.png\" alt=\"Explore fundamental relational data concepts - Learn | Microsoft Docs\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">WHAT is relational data storage in azure?<\/h4>\n\n\n\n<p>In Microsoft Azure, relational data could be stored in different forms and shapes. The early approach of storing and running relational databases has been accomplished through Virtual Machine (VM) instances.  However, this approach brought a certain operational overhead and required specialized skills within the team to manage those VMs properly.<\/p>\n\n\n\n<p>Nowadays, we could run the relational databases as a managed service (aka, PAAS) in the cloud. In other words, Microsoft Azure helped to offload operational overhead associated with the management of VMs that are assigned to run your database services. All this became possible by the introduction of managed relational Azure Database services like SQL, MySQL, PostgreSQL, and MariaDB.<\/p>\n\n\n\n<p>In this study guide, you will learn about these managed, relational DB services in depth.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/mspoweruser.com\/wp-content\/uploads\/2016\/12\/azure-sql-database-pools.png\" alt=\"Microsoft's Azure SQL Database named among the top 3 databases of 2020 -  MSPoweruser\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"part-3-design-a-solution-to-log-and-monitor-azure-resources\">Part 9:&nbsp;Design a data storage solution for relational data<\/h4>\n\n\n\n<p>The references below are taken from official Microsoft docs and focused on designing Data Storage solutions for Relational data in Azure. You could also find it helpful to check the Microsoft docs and learning paths with [Tutorials] below \ud83d\ude09.<\/p>\n\n\n\n<p>This collection of links is gathered with a focus on the exam objectives of the AZ-305 certification exam. <\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/elastic-pool-overview\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">Elastic pools help you manage and scale multiple databases in Azure SQL Database<\/a> <br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/service-tiers-dtu?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">DTU-based purchasing model overview<\/a> <br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/elastic-pool-scale?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">Scale elastic pool resources in Azure SQL Database<\/a> <br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/windows\/availability-group-overview?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">Always On availability group on SQL Server on Azure VMs<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/encryption\/transparent-data-encryption?view=sql-server-ver15&amp;WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">Transparent data encryption (TDE) <\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/dynamic-data-masking?view=sql-server-ver15&amp;WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">Dynamic Data Masking<\/a> <br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/auditing-overview?view=sql-server-ver15&amp;WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">Auditing for Azure SQL Database and Azure Synapse Analytics<\/a> <br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/sql-vulnerability-assessment?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">SQL vulnerability assessment helps you identify database vulnerabilities<\/a><\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/paths\/azure-data-fundamentals-explore-relational-data\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial] Explore relational data in Azure<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-provision-deploy-relational-database-offerings-azure\/4-exercise-provision-relational-azure-data-services?pivots=azuresql&amp;WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial] Provision Azure relational database services<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/query-relational-data\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial] Query relational data in Azure<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/design-data-storage-solution-for-relational-data\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial] Design a data storage solution for relational data<\/a><br><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/provision-azure-sql-db\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\" rel=\"noreferrer noopener\">[Tutorial] Provision an Azure SQL database to store application data<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/windows\/availability-group-manually-configure-tutorial-single-subnet?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial]: Manually configure an availability group (SQL Server on Azure VMs)<\/a><\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/paths\/work-with-relational-data-in-azure\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial] Work with relational data in Azure<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/intro-to-azure-database-for-mysql\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial] Introduction to Azure Database for MySQL<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/intro-to-azure-database-for-mariadb\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial] Introduction to Azure Database for MariaDB<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-connect-to-postgres\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial] Create and connect to an Azure Database for PostgreSQL<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/migrate-sql-server-relational-data\/?WT.mc_id=AZ-MVP-5004750\" target=\"_blank\">[Tutorial] Migrate your relational data stored in SQL Server to Azure SQL Database<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"summary\">SUMMARY<\/h4>\n\n\n\n<p>Thank you for visiting the AZ-305 Study Guide and checking the <em><a rel=\"noreferrer noopener\" href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/04\/02\/study-guide-az-305-part-9-design-a-data-storage-solution-for-relational-data\/\" target=\"_blank\">Part 9: Design a data storage solution for relational data<\/a>.<\/em><br><br>The next blog post will be continuation with <em><a href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/04\/10\/study-guide-az-305-part-10-design-a-data-integration-solution\/\" target=\"_blank\" rel=\"noreferrer noopener\">Part 10: <em>Design a data integration solution<\/em><\/a><\/em>.<\/p>\n<div class=\"pvc_clear\"><\/div><p id=\"pvc_stats_1232\" class=\"pvc_stats all  \" data-element-id=\"1232\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p><div class=\"pvc_clear\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Hi Cloud Marathoners! Welcome to the next blog post (Part 9\/12) from the Az-305 series to help you get ready for the AZ-305 exam. Please, check the previous blog posts listed below, if you landed on this page for the first time&nbsp;\ud83d\ude42 Table of content (blog series) *** Design Identity, Governance, and Monitoring Solutions *** &hellip; <a href=\"https:\/\/thecloudmarathoner.com\/index.php\/2022\/04\/01\/study-guide-az-305-part-9-design-a-data-storage-solution-for-relational-data\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Study Guide AZ-305: Part 9 &#8211; Design a data storage solution for relational data&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,18,29],"tags":[],"class_list":["post-1232","post","type-post","status-publish","format-standard","hentry","category-azure-sql","category-azure","category-study-guides"],"_links":{"self":[{"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/posts\/1232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/comments?post=1232"}],"version-history":[{"count":24,"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/posts\/1232\/revisions"}],"predecessor-version":[{"id":1411,"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/posts\/1232\/revisions\/1411"}],"wp:attachment":[{"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/media?parent=1232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/categories?post=1232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thecloudmarathoner.com\/index.php\/wp-json\/wp\/v2\/tags?post=1232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}