Design a Data Platform Solution (15-20%)
Please read the Azure Application Architecture Guide
Design a Data Management Strategy
Read the Azure Data Architecture Guide
- Choose the right data store
- Criteria for choosing a data store
- Choose between relational and non-relational databases
- Design data auditing and caching strategies
- Identify data attributes (e.g., relevancy, structure, frequency, size, durability, etc.)
- Recommend Database Transaction Unit (DTU) sizing
- Design a data retention policy
- Design for data availability, consistency, and durability
- Design a data warehouse strategy
Design a Data Protection Strategy
Read Define data protection strategy for your hybrid identity solution
- Recommend geographic data storage
- Design an encryption strategy for data at rest, for data in transmission, and for data in use
- Design a data loss prevention (DLP) policy
- Design a scalability strategy for data
- Design secure access to data
Design and Document Data Flows
Review the Azure Data Explorer documentation and Azure Data Factory Mapping Data Flow Select Transformation.
- Identify data flow requirements
- Create a data flow diagram
- Design a data flow to meet business requirements
- Design a data import and export strategy
Design a Monitoring Strategy for the Data Platform
- Design for alert notifications
- Design an alert and metrics strategy
- Monitoring and diagnostics Note this is a long read
- Find and apply performance recommendations