Implementing Data Engineering Solutions Using Microsoft Fabric - Course Overview

This course covers methods and practices for implementing and managing data engineering operations using Microsoft Fabric. This course is mainly targeted for Business Analysts, Data Analysts, Data Engineers and Data Scientists. Students will build on existing experience on data engineering and will learn how to use Microsoft Fabric components in-depth for Data Engineering purposes, like workspace settings, lakehouses, data warehouses, spark notebooks, dataflows, data pipelines, event streams, and semantic models to create and deploy data engineering assets. They also learn to implement analytics best practices in Fabric, including identifying and resolving errors, optimization, achieve data security and governance, enable version control and deployment.

Fabric Data Engineers collaborate with other professionals, such as analytics engineers, architects, analysts, and administrators to design and deploy data engineering solutions for analytics.

After Completing the DP-700 course, students will be able to:

  • Ingesting and transforming data.
  • Securing and managing an analytics solution.
  • Monitoring and optimizing an analytics solution.

Upcoming Batches

Enroll Online
Start Date End Date

2024-11-18

2024-11-22

2024-11-25

2024-11-29

2024-12-02

2024-12-06

2024-12-09

2024-12-13

2024-12-16

2024-12-20

Key features of the course Implementing Data Engineering Solutions Using Microsoft Fabric :

  • Our DP-700 exam certification course modules have 50% -60% hands-on lab sessions to encourage Thinking-Based Learning (TBL).
  • The training on exam DP-700: Microsoft Fabric Analytics Engineer is delivered by certified instructor to support Competency-Based Learning (CBL) modules.
  • Integrated teaching assistance and support through expert designed Learning Management System (LMS) and ExamReady platform.
  • Interactive-rich virtual and face-to-face classroom teaching to inculcate Problem-Based Learning (PBL) in this new course by Microsoft.
  • This new Microsoft certifications course consists of well-structured use-cases to simulate challenges encountered in a Real-World environment.
  • Being a Microsoft Learning Partner gives us competitive edge in delivering the best training on this newly announced course from Microsoft.

Who should attend this DP-700 Training Course

  • Data Engineers
  • Analytics Engineers
  • Solutions Architects
  • Administrators
  • Business Analysts
  • Data Analysts

Prerequisites for the course: -

    While there are no official prerequisites for taking this course, it is recommended that:
  • Students have a foundational knowledge of Azure Data Platform (refer DP-900 course) and Azure Data Engineer Associate exam syllabus (DP-203).
  • Awareness of functioning of Azure Synapse Analytics and PowerBI is an added advantage.
  • Learning objective of the course:

    • You can publicize your DP-700 exam credential on social media site such as LinkedIn.
    • You get to incorporate professional values into your organisation.
    • By obtaining the certification, you can advance your career in the Microsoft Cloud’s Data Domain.

    Modules covered in the training program Implementing Data Engineering Solutions Using Microsoft Fabric Download Course Outline

    • Configure Spark workspace settings
    • Configure domain workspace settings
    • Configure OneLake workspace settings
    • Configure data workflow workspace settings

    • Configure version control
    • Implement database projects
    • Create and configure deployment pipelines

    • Implement workspace-level access controls
    • Implement item-level access controls
    • Implement row-level, column-level, object-level, and file-level access controls
    • Implement dynamic data masking
    • Apply sensitivity labels to items
    • Endorse items

    • Choose between a pipeline and a notebook
    • Design and implement schedules and event-based triggers
    • Implement orchestration patterns with notebooks and pipelines, including parameters and dynamic expressions

    • Design and implement full and incremental data loads
    • Prepare data for loading into a dimensional model
    • Design and implement a loading pattern for streaming data

    • Choose an appropriate data store
    • Choose between dataflows, notebooks, and T-SQL for data transformation
    • Create and manage shortcuts to data
    • Implement mirroring
    • Ingest data by using pipelines
    • Transform data by using PySpark, SQL, and KQL
    • Denormalize data
    • Group and aggregate data
    • Handle duplicate, missing, and late-arriving data

    • Choose an appropriate streaming engine
    • Process data by using eventstreams
    • Process data by using Spark structured streaming
    • Process data by using KQL
    • Create windowing functions

    • Monitor data ingestion
    • Monitor data transformation
    • Monitor semantic model refresh
    • Configure alerts

    • Identify and resolve pipeline errors
    • Identify and resolve dataflow errors
    • Identify and resolve notebook errors
    • Identify and resolve eventhouse errors
    • Identify and resolve eventstream errors
    • Identify and resolve T-SQL errors

    • Optimize a lakehouse table
    • Optimize a pipeline
    • Optimize a data warehouse
    • Optimize eventstreams and eventhouses
    • Optimize Spark performance
    • Optimize query performance

    Certification details:

        By earning Microsoft DP-700 certification training, you become Microsoft Certified: Fabric Data Engineer Associate.
        You will prove competency in designing, creating, and deploying end-to-end data engineering and data analytics solutions using Microsoft Fabric, the latest cutting-edge technology offered by Microsoft.
        On successful completion of DP-700 training and certification, aspirants receive a Course Completion Certificate from us.
        By successfully clearing the DP 700 certification, aspirants earn Microsoft Certification of Associate level.

    Course Fee

    Select Course date

    Add to Wishlist

    Course ID: 22683

    Course Price at

    ₹34900 + 18% GST
    Enroll Now

    Frequently Asked Questions

    Duration of DP-700 exam is 1 hour 40 minutes.

    The exam will be available on Beta mode from October 22, 2024. The results will be available once the Beta period is over (approximately 8-12 weeks).

    To register for the DP-700 exam, follow these steps. Firstly, visit the Microsoft Learning website and search for the DP-700 exam. Then, click on the exam link to access the exam details page. On the exam details page, click the "Schedule Exam" or "Register" button. Upon redirection, you will reach the Microsoft Certification dashboard, where you have the option to either sign in using your existing Microsoft account or create a new account. Once signed in, you can select a test center or opt for an online proctored exam, choose a convenient date and time, and proceed with the payment process. After the registration, you will receive a confirmation email with further instructions for the exam day.

    Attaining the DP-700 certification as a Microsoft Fabric Data Engineer can have a substantial impact on career progression and an increase in salary. The certification validates your expertise in understanding the in-depth capabilities of Microsoft Fabric environment. This latest technology, which is also co-pilot enabled, provides as a One-Stop-Shop for handling data coming for various sources such as Microsoft 365, Dynamics 365, Power Platform, Databases, Data storage and compute services from on-prem and multiple cloud services. It serves as a promising platform for handling Machine Learning workloads. One can also integrate Data governance tools such as Microsoft Purview, thus enabling secure handling of the data across multiple platforms that it serves.

    DP-700 certification is valid for one year. Within that period, you may need to renew the certification by passing the renewal assessment, which is free.

    The passing score for the DP-700 exam is 70% (700 marks out of 1000). For the most current information on passing scores, it is advisable to consult the official Microsoft certification website.

    To prepare for the DP-700 certification and pass the exam successfully, candidates need to enroll in CloudThat’s Microsoft Fabric Data Engineer Associate certification training course in Bangalore. Our subject matter experts and Microsoft Certified Trainers offer training through online or instructor-led classes and provide relevant study material necessary to support your exam preparation. At CloudThat, you can strengthen your practical skills through hands-on lab sessions and test your knowledge before the final exam through our test-prep platform. Besides our training and assistance, candidates can also: • Join online forum discussions and study groups to enrich your knowledge. • Have a detailed understanding of the exam structure. • Study Microsoft documentation along with relevant whitepapers and eBooks.

    Enquire Now