DP-900 decision sheets

• Which Cosmos DB API to choose: NoSQL vs MongoDB vs Cassandra vs Gremlin vs Table
• Which data file format fits (CSV/JSON/XML vs Avro vs Parquet)
• Which data role owns a task: data engineer vs database administrator vs data analyst
• Which data store type fits the workload (relational vs document vs key-value vs graph vs time-series)
• OneLake vs Lakehouse vs Warehouse vs Shortcut: which Fabric analytics piece fits
• Line vs column vs pie vs scatter vs map: which Power BI visual fits the goal
• Power BI Desktop vs Power BI service (author vs publish and share)
• Which relational database object fits: index vs view vs stored procedure
• Primary key vs foreign key in a relational table
• Azure SQL Database compute choice: single database vs elastic pool vs serverless
• SQL Server on Azure VM vs Azure SQL Managed Instance vs Azure SQL Database vs Azure Database for MySQL/PostgreSQL
• Which category of SQL statement (DDL vs DML vs DCL)
• Blob vs Files vs Table vs Queue: which Azure Storage service fits the workload
• Dedicated SQL pool vs serverless SQL pool vs Apache Spark pool