Certification     Microsoft     Microsoft Certified: Azure Solutions Architect Expert     AZ-305: Designing Microsoft Azure Infrastructure Solutions

---

Designing data storage solutions is a primary focus for Azure solutions architects. This course will help you confidently analyze your organization’s data storage needs and select the appropriate solutions.
Begin by exploring NoSQL and SQL Azure database services and deploying a SQL database. Next, discover how to manage settings related to cloud SQL deployments and how to use Microsoft Visual Studio on-premises to connect to cloud SQL instances. Learn how to resize a database and configure database high availability. Finally, discover data analysis services such as Azure Synapse Analytics and Azure HDInsight.
This course can be used to prepare for Exam AZ-305: Designing Microsoft Azure Infrastructure Solutions.

---

---

Objectives

AZ-305 - Microsoft Azure Infrastructure Solutions: Data Solutions discover the key concepts covered in this course describe various Azure cloud database options use the Azure portal to deploy Azure SQL demonstrate how to manage Azure SQL configuration settings use Microsoft SQL Server Management Studio to connect to Azure SQL demonstrate how to enable high availability for Azure SQL use Microsoft SQL Server Management Studio to publish an on-premises database to Azure configure database sizing and scalability settings outline various Azure data management and analysis solutions determine when Azure Synapse Analytics should be used determine when Azure HDInsight should be used summarize the key concepts covered in this course