SKILL BENCHMARK

Microsoft Azure Data Fundamentals: Azure Data Analytics Competency (Intermediate Level)

  • 19m
  • 19 questions
Explore all Skills Benchmarks
The Microsoft Azure Data Fundamentals: Azure Data Analytics Competency (Intermediate Level) benchmark measures your ability to identify, recognize, and apply concepts of data analytics, the Azure Synapse Analytics architecture, and transactional and analytical workloads. You will be evaluated on your ability to recognize concepts about Synapse Analytics, Synapse SQL pool, batch and real-time data processing, and using the Azure portal, Azure PowerShell, Azure Data Lake Analytics, and Azure Data Factory. A learner who scores high on this benchmark demonstrates that they have the necessary Azure data analytics skills to perform analytics on the Azure platform with minimal supervision.

Topics covered

  • applying best practices for Synapse SQL pool
  • compare batch and real time data processing
  • compare transactional and analytic workloads
  • create an Azure data factory
  • describe Azure data factory pipelines and activities
  • describe Data Warehouse Units (DWU)
  • describe Data warehousing workloads
  • identify loading strategies for Synapse SQL pools
  • recognize when to use a data warehouse solution
  • use Azure Databricks to ingest data
  • use Azure Data Lake Analytics
  • use Azure Data Lake to load data
  • use Azure Portal to create a Synapse SQL pool
  • use Azure PowerShell to create a Synapse SQL pool
  • use Azure Synapse Analytics PolyBase to ingest data
  • use Azure Synapse Analytics service
  • use Azure Synapse Analytics to load data
  • use SQL Server Integration Services (SSIS) to ingest data
  • use the Azure data factory copy data tool to copy data