Overview

Skills at a glanceDescribe core data concepts (25-30%)Identify considerations for relational data on Azure (20-25%)Describe considerations for working with non-relational data on Azure (15-20%)Describe an analytics workload on Azure (25-30%)Describe core data concepts (25-30%)Describe ways to represent dataDescribe features of structured dataDescribe features of semi-structuredDescribe features of unstructured dataIdentify options for data storageDescribe common formats for data filesDescribe types of databasesDescribe common data workloadsDescribe features of transactional workloadsDescribe features of analytical workloadsIdentify roles and responsibilities for data workloadsDescribe responsibilities for database administratorsDescribe responsibilities for data engineersDescribe responsibilities for data analystsIdentify considerations for relational data on Azure (20-25%)Describe relational conceptsIdentify features of relational dataDescribe normalization and why it is usedIdentify common structured query language (SQL) statementsIdentify common database objectsDescribe relational Azure data servicesDescribe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual MachinesIdentify Azure database services for open-source database systemsDescribe considerations for working with non-relational data on Azure (15-20%)Describe capabilities of Azure storageDescribe Azure Blob storageDescribe Azure File storageDescribe Azure Table storageDescribe capabilities and features of Azure Cosmos DBIdentify use cases for Azure Cosmos DBDescribe Azure Cosmos DB APIsDescribe an analytics workload (25-30%)Describe common elements of large-scale analyticsDescribe considerations for data ingestion and processingDescribe options for analytical data storesDescribe Microsoft cloud services for large-scale analytics, including Azure Databricks and Microsoft FabricDescribe consideration for real-time data analyticsDescribe the difference between batch and streaming dataIdentify Microsoft cloud services for real-time analyticsDescribe data visualization in Microsoft Power BIIdentify capabilities of Power BIDescribe features of data models in Power BIIdentify appropriate visualizations for data

Skills

Reviews