4-Describe an analytics workload on Azure (25-30%).md

DP-900: Describe an analytics workload on Azure (25-30%)

Describe analytics workloads

• Describe transactional workloads
• Describe the difference between:
  • transactional workload
  • analytics workload
• Describe the difference between:
  • batch
    • Azure Synapse Analytics
    • Azure Data Lake Analytics Gen2
    • HDInsight
      • Spark
      • Hive
      • Hive Low Latency Analytical Processing (LLAP)
      • MapReduce
    • Azure Databricks
    • Azure Distributed Data Engineering Toolkit
  • real time
    • Azure Event Hubs
    • Azure IoT Hub
    • Kafka on HDInsight
• Describe data warehousing workloads
• Determine when a data warehouse solution is needed
  • Enterprise Data Warehouse Architecture
  • Data warehousing and analytics

Describe the components of a modern data warehouse

• Describe Azure data services for modern data warehousing such as:
  • Azure Data Lake
  • Azure Synapse Analytics
  • Azure Databricks
  • Azure HDInsight
• Describe modern data warehousing architecture and workload

Describe data ingestion and processing on Azure

• Describe common practices for data loading

  • PolyBase
  • AzCopy
  • CREATE TABLE AS SELECT
  • BCP
  • SqlBulkCopy

• Describe the components of Azure Data Factory such as:

  • Pipeline
    • a logical grouping of activities that together perform a task
  • Activities
    • define actions to perform on your data

• Describe data processing options such as:

  • Azure HDInsight
  • Azure Databricks
  • Azure Synapse Analytics
  • Azure Data Factory

Describe data visualization in Microsoft Power BI

• Describe the role of paginated reporting
• Describe the role of interactive reports
• Describe the role of dashboards
• Describe the workflow in Power BI
  • Get Data
  • Clean data
  • Model the data
  • Visualize your data
  • Share the data, report

Return to Table of Contents