Applied Skills

Implement a data warehouse in Microsoft Fabric

Validate your technical skills and open doors to new possibilities of advancement with Microsoft Applied Skills.

Overview

To earn this Microsoft Applied Skills credential, learners demonstrate the ability to implement a data warehouse in Microsoft Fabric, including:

  • Creating a data warehouse
  • Loading, transforming, and querying data
  • Modeling a star schema
  • Managing security

Candidates for this credential should be familiar with data modeling, data transformation, and exploratory data analytics. They should also be able to query and change data by using T-SQL.

Tasks performed

  • Create a data warehouse
  • Load data
  • Transform data
  • Model a star schema
  • Query and modify data
  • Manage security

Prepare for the assessment

Take the assessment

English

This assessment will use an interactive lab to evaluate your performance. It will take a few minutes to load the lab, and you may do other activities while it loads. After you launch the lab, you will need to wait 72 hours to launch it again. Your mouse movements and text entered during the lab will be recorded for quality purposes. Learn more

Need accommodations?

We offer a variety of accommodations to support you. Learn more

Applied Skills Resources

Study guide for Applied Skills

This study guide provides a summary of the topics covered in the assessment lab, along with additional resources to help you prepare.

Choose your Microsoft Credential

Microsoft Applied Skills or Microsoft Certifications? Choose the path that fits your career goals, desired skillset, and schedule.

Support for credentials

Get help through Microsoft Credentials support forums. A forum moderator will respond in one business day, Monday–Friday.