Course Details
Course Details
What You'll Learn
This course prepares you for the DP-700 certification exam, covering all official exam domains and their approximate weightings:
Domain 1 Implement and manage an analytics solution (32.5%)
- Configure Microsoft Fabric workspace settings (Spark, domain, OneLake, Apache Airflow)
- Implement lifecycle management in Fabric: version control, database projects, deployment pipelines
- Configure security and governance: workspace/item-level access, row/column/object/folder-file-level access, dynamic data masking, sensitivity labels, item endorsement, audit logs, OneLake security
- Orchestrate processes: choose between Dataflow Gen2, pipeline and notebook; design schedules and event-based triggers; implement orchestration patterns with notebooks and pipelines (parameters, dynamic expressions)
Domain 2 Ingest and transform data (32.5%)
- Design and implement full and incremental data loads; prepare data for a dimensional model; design a loading pattern for streaming data
- Ingest and transform batch data: choose data store and transformation tool (Dataflows Gen2, notebooks, KQL, T-SQL), create OneLake shortcuts, implement mirroring, ingest via pipelines
- Transform data using PySpark, SQL, and KQL; denormalize, group/aggregate data; handle duplicate, missing, and late-arriving data
- Ingest and transform streaming data: choose streaming engine, use Eventstreams/Spark structured streaming/KQL, choose native tables vs OneLake shortcuts, create windowing functions
Domain 3 Monitor and optimize an analytics solution (32.5%)
- Monitor Fabric items: data ingestion, data transformation, semantic model refresh, configure alerts
- Identify and resolve errors in pipelines, Dataflow Gen2, notebooks, Eventhouse, Eventstream, T-SQL, and OneLake shortcuts
- Optimize performance of Lakehouse tables, pipelines, data warehouse, Eventstreams/Eventhouses, Spark, and query performance
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
free Microsoft Azure account (https://azure.microsoft.com/en-us/) hereHardware: Window or Mac Laptops
Job Roles
Job Roles
- Microsoft Fabric Data Engineer
- Data Ingestion Specialist
- Real-Time Analytics Engineer
- Lakehouse Developer
- Apache Spark Engineer (Fabric)
- Eventstream Data Engineer
- Delta Lake Engineer
- Fabric Lakehouse Architect
- Data Platform Engineer
- Data Pipeline Developer
- Data Warehouse Developer
- Fabric Eventhouse Engineer
- Cloud Data Engineer
- Analytics Operations Engineer
- Data Transformation Engineer
- Business Intelligence Data Engineer
- CI/CD Data Platform Engineer
- Fabric Environment Administrator
- Enterprise Data Engineer
- Data Automation Specialist
Trainers
Trainers
Saeid is co-founder of Skymics Sdn Bhd. He has 8 years of experience in the field of IoT (Internet of Things) and Information Technology. He is a certified IBM IoT Practitioner and instructor, and a Certified Citizen Data Scientist Train-The-Trainer. He has been co-inventor of 3 inventions during the last 4 years.
Review
Customer Reviews (9)
- Good course materials Review by Course Participant/Trainee
-
The training was very practical and hands-on. I could apply what I learned to my work immediately. (Posted on 11/01/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Very informative Review by Course Participant/Trainee
-
The course content was comprehensive and up to date. The practical exercises were the best part. (Posted on 08/01/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Would attend again Review by Course Participant/Trainee
-
Very engaging session. The trainer patiently answered all our questions and gave useful tips. (Posted on 17/09/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Very useful course Review by Course Participant/Trainee
-
Great course materials and well-paced lessons. The exercises really helped me understand the topic. (Posted on 15/01/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses