Published On May 2, 2024
Free DP-600 study notes inside community: https://www.skool.com/microsoft-fabri...
In this video (6 of 12 in the series), we continue Section 2 of the DP-600 Study Guide: Prepare and Serve Data. We cover the following topics:
- Create views, functions, and stored procedures
- Add stored procedures, notebooks, and dataflows to a data pipeline
- Schedule data pipelines
- Schedule dataflows and notebooks
This video is part of the DP-600 Exam Preparation series: • DP-600 Exam Preparation
Timeline
0:00 Intro
1:13 Connecting to a Data Warehouse using SSMS
2:52 SQL Views
6:15 SQL Functions
10:09 SQL Stored Procedures
13:53 Stored procedure activity in Data Pipeline
16:39 Notebook activity in Data Pipeline
17:55 Dataflow activity in Data Pipeline
18:35 Scheduling Dataflows
19:33 Scheduling Notebooks
20:36 Scheduling Data Pipelines
22:19 Practice Questions
26:14 Outro and next steps
#microsoftfabric #dp600 #powerbi