Identify common structured query language (SQL) statements
Describe Azure services for data warehousing, including Azure Synapse Analytics, Azure Databricks, Azure HDInsight, and Azure Data Factory
Describe Azure Cosmos DB APIs
Identify appropriate visualizations for data
Describe features of data models in Power BI
Identify capabilities of Power BI
Identify common database objects
Describe features of analytical workloads
Identify use cases for Azure Cosmos DB
Describe technologies for real-time analytics including Azure Stream Analytics, Azure Synapse Data Explorer, and Spark Structured Streaming
Describe features of transactional workloads
Describe Azure Table storage
Describe types of databases
Describe the difference between batch and streaming data
Describe normalization and why it is used
Describe Azure File storage