Azure Solutions Architect Expert (AZ-305) Cert Prep: Design Data Storage Solutions

Course details

Are you preparing for the Azure Solutions Architect AZ-305 examination? In this course, instructor Nicole Stevens helps you master the skills and knowledge you need to pass the exam domain focused on designing data storage solutions. Nicole goes over data storage in Azure, then dives into what you need to know to make effective recommendations on data storage solutions. She steps you through designing for unstructured data in Azure and deep dives into everything you need to know about designing for structured relational data and semistructured data in Azure. Nicole covers design considerations for data integration, orchestration, warehousing, and more. Plus, she points you toward additional learning resources on Azure data storage, including tutorials and documentation.

Concepts

0. Introduction

01 - Data storage in Azure
02 - What you should know

1. Recommend a Data Storage Solution

03 - Understanding types of data
04 - Features of relational data
05 - Solutions for relational data on Azure
06 - Features of semistructured data
07 - Solutions for semistructured data on Azure
08 - Features of unstructured data
09 - Solutions for unstructured data on Azure

2. Designing for Unstructured Data in Azure

10 - Unstructured data and Azure Storage
11 - Considerations for data redundancy and Azure Storage
12 - Authorizing access to data in Azure Storage
13 - Network security options for Azure Storage
14 - Encryption and secure data transfer for Azure Storage
15 - Access tiers and rehydration for Blobs in Azure Storage
16 - Lifecycle management for Blobs in Azure Storage
17 - Data protection for Blobs in Azure Storage
18 - Immutable storage for Blobs in Azure Storage
19 - Considerations for Azure Files

3. Designing for Structured Relational Data in Azure

20 - Introduction to Azure SQL DB and Azure SQL Managed Instance (MI)
21 - Purchasing models for Azure SQL DB and SQL MI
22 - Azure SQL DB and SQL MI service tiers
23 - Managing pre-provisioned compute for Azure SQL DB and SQL MI
24 - Serverless and Hyperscale compute tier for Azure SQL DB
25 - Scaling options for Azure SQL DB and SQL MI
26 - Encryption at rest and in transit on Azure SQL DB and SQL MI
27 - Always Encrypted for Azure SQL DB and SQL MI
28 - Dynamic data masking for Azure SQL DB and SQL MI
29 - Data discovery, classification, and audit for Azure SQL DB and SQL MI
30 - High availability and business continuity for Azure SQL DB and SQL MI
31 - Performance monitoring and tuning for Azure SQL DB and SQL MI
32 - IaaS for relational data with Azure SQL VM
33 - Azure SQL VM Agent for SQL on Azure VMs
34 - Azure SQL at the edge

4. Designing for Semistructured Data in Azure

35 - Introduction to Cosmos DB and Azure Tables
36 - The elements of Azure Cosmos DB and choosing an API
37 - Understanding options for Azure Cosmos DB consistency model
38 - Capacity management for Azure Cosmos DB
39 - Partitioning data in Azure Cosmos DB

5. Designing for Data Integration in Azure

40 - Considerations for data integration
41 - Design storage for big data analytics
42 - Design for ETL ELT and data orchestration
43 - Design for SQL Analysis, data warehousing, and integrated BI
44 - Design for stream processing, data science, and ML

Conclusion

45 - Learning more about Azure data storage