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: version control, database projects, deployment pipelines
- Configure security and governance: workspace/item-level access controls, row/column/object/file-level security, 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 parameters and dynamic expressions
Domain 2 Ingest and transform data (32.5%)
- Design and implement full and incremental data loading patterns, including for dimensional models and streaming data
- Ingest and transform batch data: choose appropriate 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, process data via Eventstreams, Spark structured streaming, and KQL; create windowing functions
Domain 3 Monitor and optimize an analytics solution (32.5%)
- Monitor Fabric items: data ingestion, data transformation, semantic model refresh, and 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 warehouses, Eventstreams/Eventhouses, Spark jobs, and queries
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:
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Data Engineer
- Azure Data Engineer
- Cloud Data Engineer
- Business Intelligence Developer
- Data Architect
- Data Scientist
- Machine Learning Engineer
- Big Data Engineer
- Data Analyst
- Database Administrator
- Cloud Solutions Architect
- DevOps Engineer
- Software Developer
- IT Professional
- Systems Analyst
Trainers
Trainers
Dr Alvin Ang is a ACTA certified trainer. Dr. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally.
Review
Write Your Own Review
- Recommended Courses