Please enable JavaScript.
Coggle requires JavaScript to display documents.
DP-900 - Coggle Diagram
DP-900
Data Concepts
Types of Data Workloads
Describe Batch Data
Describe Streaming Data
Characteristics of Relational data
Data Analytics Concepts
Describe Data Visualization
Visualization
Reporting
Business Intelligence (BI)
Describe Basic Chart Types
Bar Charts
Pie Charts
Describe Analytics Techniques
Descriptive
Diagnostic
Predictive
Prescriptive
Cognitive
Describe ETL/ELT Processing
Describe Concepts of Data Processing
Relational Data
Relational Data Workloads
Identify the right data offering for a relational workload
Describe Relational Data Structures
Tables
Index
Views
Relational Azure Data Services
Describe and Compare Solutions
PaaS
IaaS
SaaS
Azure SQL Family of Products
Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure Virtual Machines
Describe Azure Synapse Analytics
Azure Database Family of Products
PostgreeSQL
MariaDB
MySQL
Identify Management Tasks for Relational Data
Describe Provisioning and Deployment of R. Data Services
Method of Deployment
Azure Portal
Azure Resource Manager
Azure PowerShell
Azure Command-Line Interface (CLI)
Data Security Components
Firewall
Authentication
Connectivity Issues
Acessing from on-premises
Access from Azure VNets
Access from Internet
Authentication, firewall
Query Tools
Azure Data Studio
SQL Server Management Studio
sqlcmd utility
Query Techniques Using SQL Language
Compare Data Languages
Data Definition Language (DDL)
Data Manipulation Language (DML)
Query Relational Data in:
Azure SQL Database
Azure Database for PostgreSQL
Azure Database for MySQL
Non-Relational Data
Non-Relational Data Workloads
Characteristics of Non-Relational Data
Types of non-relational data
Recommend the correct data store
When to use non-relational data
Non-Relational Data Offerings on Azure
Azure Data Services for Non-Relational Workloads
Azure CosmosDB APIs
Azure Table Storage
Azure Blob Storage
Azure File Storage
Identify Management Tasks for Non-Relational Data
Describe Provisioning and Deployment of Non-Relational Data Services
Methos for deployment
Azure Portal
Azure Resource Manager
Azure Powershell
Azure Command-Line Interface (CLI)
Data Security Components
Fireawall
Authentication
Encryption
Connectivity Issues
Accessing from on-premises
Access from Azure VNets
Access from Internet
Authentication/Firewall
Identify Management Tools for Non-Relational Data
Analytics Workload
Analytics Workloads
Transactional Workloads
Difference between Transactional and Analytics Workload
Difference between Batch and Real Time
Data Warehousing Workloads
When Data Warehouse solution is needed?
Components of a modern Data Warehouse
Describe Azure Data Services for modern Data Warehousing
Azure Data Lake Storage Gen2
Azure Synapse Analytics
Azure DataBricks
Azure HDInsight
Describe modern data warehousing archtecture and workload
Data Ingestion and Processing on Azure
Common pratices for data loading
Components of Azure Data Factory
Pipeline
Datasets
Activities
Data Processing Options
Azure HDInsights
Azure Databricks
Azure Synapse Analytics
Azure Data Factory
Microsoft Power BI
Role of Paginated Reporting
Role Interatictive Reports
Dashboards
Workflow in Power BI