DP 900

[wagners32]

Relational Data - Azure Data Workloads

• [x] Online transaction processing

• [x] Online analytical processing

• [x] Azure relational data services

• [x] MSSQL data offerings in Azure

• [x] PostgreSQL, MariaDB, and MySQL

  Relational Data - Management Tasks

• [x] Provision relational data service in Azure

• [x] Common connectivity issues

• [x] Azure Data Studio

Relational Data - Query Techniques Using SQL

• [x] Data definition vs data manipulation
• [x] Query Azure SQL database

Non-Relational Data - Workloads and offerings

• [ ] Non relational data workloads
• [ ] JSON and CSV files for data solutions
• [ ] Time series data
• [ ] Cosmos DB API
• [ ] Query Azure Cosmos DB using SQL API
• [ ] Azure storage for non-relational database

Non-Relational Data - Azure Modern data Warehouse

• [ ] Data warehousing in Azure
• [ ] Modern data warehousing
• [ ] Azure synapse analytics
• [ ] Azure databricks

Non-Relational Data - Ingestion, processing and visualization

• [ ] Azure data factory
• [ ] Paginated reporting
• [ ] Reporting in Power BI
• [ ] Create HDInsight cluster

Reference Documents

• [ ] Microsoft references
• [ ] Exam tips
• [ ] Course conclusion