SKILL BENCHMARK

Microsoft Azure Data Fundamentals: Azure Relational Data Workloads Competency (Intermediate Level)

  • 20m
  • 20 questions
Explore all Skills Benchmarks
The Microsoft Azure Data Fundamentals: Azure Relational Data Workloads Competency (Intermediate Level) benchmark measures your ability to identify, recognize, and apply the concepts of relational data workloads in Azure. You will be evaluated on your ability to recognize concepts such as relational data stores and delivery models, SQL relational databases, SaaS in Azure, OLAP and OLTP, Azure SQL security features, and more. A learner who scores high on this benchmark demonstrates that they have the necessary Azure relational data skills to perform relational data workloads on the Azure platform with minimal supervision.

Topics covered

  • describe Azure Infrastructure as a Service
  • describe Azure Managed Instance features
  • describe Azure Platform as a Service
  • describe Azure Software as a Service
  • describe Azure SQL Database uses and features
  • describe Azure Synapse Analytics components and features
  • describe online analytical processing (OLAP)
  • describe online transaction processing (OLTP)
  • describe SQL Server on Azure Virtual Machine
  • identify different Azure SQL connectivity errors
  • identify the different data store models
  • identify the different delivery models for Azure relational data
  • recognize Azure SQL Database security features
  • use Azure AD authentication for security
  • use Azure Data Studio as a query tool
  • use different methods for deploying relational data
  • use indexes in an Azure SQL relational database
  • use SQL Server Management Studio as a query tool
  • use the sqlcmd utility as a query tool
  • use views in an Azure SQL relational database