1. Recommend an Azure data storage solution based on requirements
- Data Type
- Data Storage Types
- Azure store for application
- Azure Data Platform Architecture
- Design and Troubleshoot Partition Distribution type
3. Design relational cloud data stores
- Purchasing models and Service Tier
- Storage and Sharding patterns
- Data Distribution and Distributing Keys
- Data Types and Table Types
- Partitioning
- Scaling Azure Database
- Scaling Azure Datawarehouse
- Azure SQL Database High Availability and Disaster Recovery options
- Azure SQL Database Backup and Restore
- Azure SQL Datawarehouse Backup and Restore
- Azure SQL Database vs Data Warehouse
- Scenarios – Designing for SQL Database vs Data warehouse
- Learning Outcome and Checklist
5. Design real-time processing solutions
- Real Time Processing
- Azure Streaming Analytics Service
- Streaming Analytics – What is time windowing
- Tumbling Window
- Hopping Window
- Sliding Window
- Session Window
- Design and Provision Compute Resources
- Lambda Architecture
2. Design non-relational cloud data store
- what is partitioning and partition key
- Dedicated vs Shared throughput
- Avoiding hot partition
- Single partition vs Cross partition
- Composite Key
- Partition key best practice
- Globally Distribution
- Multi Master
- Manual vs Automatics Failover
- Throughput and request unit
- Cosmos DB – 5 consistent levels
- Cosmos DB Multi Model 5 APIs
- How Data Lake Gen 2 Evolved?
- Data Lake vs Blob
- High Availability vs Disaster Recovery
- RTO and RPO
- Azure Storage – HA and DR Options
- Cosmos DB – HA and DR Options
- Scenarios – Designing a solution for CosmosDB vs Data Lake vs Blob Storage
4. Design batch processing solutions
- Design Batch Processing Solutions using Data Factory and DataBricks
- Data Ingestion Methods
- Tools to Ingest Data
- Ingest using Portal and SE
- Demo: Ingest Data using azcopy
- Demo: Blob to Gen 2
- Demo: SQL Server to Gen2
- Demo: Amazon S3 to Gen2
6. Design security for source data access
- Plan for Secure Endpoints (Public/Private)
- Access Keys
- Shared Access Signature (SAS)
- Active Directory (Azure AD)
- Role Based Access Control (RBAC)
