Azure Data Engineer Associate (DP-203) Cert Prep: 1 Design and Implement Data Storage

Introduction

• Design and implement data storage on Microsoft Azure
• Quick prerequisite technology overview

1. Design a Data Storage Structure

• Design an Azure Data Lake solution
• Recommend file types for storage
• Recommend file types for analytical queries
• Design for efficient querying
• Design for data pruning
• Design a folder structure
• Design a distribution strategy
• Design a data archiving solution

2. Design a Partition Strategy

• Overview of data partitioning
• Partition strategy

3. Design the Serving Layer

• Design analytical stores
• Design metastores

4. Implement Physical Data Storage Structures

• Implement different table geometries
• Implement data storage structures

5. Implement Data Architectures

• Implement data architectures, structures, and serving

Conclusion

• Summary and next steps