Requirements, admin portal, gateways in Microsoft Fabric | DP-600 EXAM PREP (2 of 12)
Vložit
- čas přidán 17. 04. 2024
- Free DP-600 study notes inside community: www.skool.com/microsoft-fabri...
In this video we cover the first section of the DP-600 study guide: Plan your data analytics environment. We cover each of the four subsections:
- Identify requirements for a solution, including components, features, performance, and capacity stock-keeping units (SKUs)
- Recommend settings in the Fabric admin portal
- Choose a data gateway type
- Create a custom Power BI report theme
This video is part of the DP-600 Exam Preparation series: • DP-600 Exam Preparation
Timeline
0:00
1:14 Identify requirements
2:36 Capacity requirements
6:55 Data ingestion requirements
11:22 Data gateways
13:52 Data storage requirements
15:44 Admin portal settings
18:45 Custom Power BI report themes
21:35 Practice Question 1
23:00 Practice Question 2
24:35 Practice Question 3
25:45 Practice Question 4
27:35 Practice Question 5
28:36 Next steps
#microsoftfabric #dp600 #powerbi
Here we go Fabricators! The first section of the exam - let me know what you think, and if you have any questions! If you found it useful, please LIKE, SUBSCRIBE and SHARE with colleagues who are also studying for the exam 🙌🙌
Free access to the DP-600 study notes inside the community: www.skool.com/microsoft-fabric/classroom/6e52cd48?md=9065a30b5ef647aeaf7986bd62aad840
That's the most real-life examples I have seen! Thanks for putting this course together!
Best one so far :)
No problem, glad you like it ☺️
Awesome content!! Thanks for all the efforts
Awesome approach simulating this client and her problems!
Thanks! glad you’re enjoying the approach. 🙌🏽
Hi Will, just wanted to add on piece about getting on prem data. The copy activity does work but only for SQL Server. If data is in another database like Oracle you’re still limited to Gen2 dataflows
That’s a great clarification, thanks Scott 👍
Thanks for the clarification @scottpowell, i remember that one of the limitation of Data Pipelines was its inability to connect to on premise DB, that caused a bit of confusion with what Will has mentioned in his video. Just to double check, so the copy activity works for on premise SQL Server but not for other servers, right?
@@moeeljawad5361 yep that’s right. Works on prem for SQL server but nothing else yet. Hopefully they add others soon.
Thanks,
Scott
@@moeeljawad5361 Hi Moe, ability for data pipeline to connect to OPDG was recently made available (preview), you can read more here: learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data#using-on-premises-data-in-a-pipeline-preview
Get hyped!!! Thanks for all the effort making these Will.
No worries, hope you find it useful!
Fantastic video❤🔥Pure high quality content, editing, visuals, storytelling and insane amount of research and hard work. This feels like a crime to watch it for free. Amazing job Will!❤❤
Thanks a lot for the kind words Vinayak 😂 Glad you are finding the videos useful. You can pay with a like and a share, that's all I ask, thanks 🙌
I am amazed to see how this is planned and designed, great work brother
Thanks for watching, and for the feedback 🙌🏽
Great effort!! Very helpful.
Thanks for watching! Glad you found it helpful 👍
Brilliant. Thanks Will. Your channel is by far the best when it comes to learning the concepts of Fabric. How you distil subjects down into manageable learning chunks is so impressive.
Also, i cheekily put a comment on SKOOL......a video on Deployment Pipelines and GIT would be really really useful.
Thanks Matt, glad you're enjoying the content!
And it's not cheeky, that's what the Skool is there for! We'll be covering Git and deployment pipelines very soon (video 4 in this DP-600 series!).
@@LearnMicrosoftFabric Great! Thanks Will. Keep up the brilliant work.
cheers for another great vid sir, listening to you while I'm making my dinner! 👍
🤣🤣 that’s great multitasking! Thanks for watching 🙌🏽
Excellent work Will👌🏼 very well explained! Thank you!
Thanks for watching!!
These videos are incredible! I’m learning so much. Keep it up!
Great to hear you’re finding them useful, thanks!
Thank You Will for Great video, Great explanation as always.
Thanks for watching! Glad you enjoyed this one 🙌🏽
Waaaw really interesting and original. Cannot wait to see the following videos. Thanks !!!🔥🔥
Thanks, glad you’re enjoying so far! I better get working on the next ones then 🤓😂
Thanks Will for this playlist. Keep it going. you mentioned that you have a video that specify when each of the three ETL options (DataFlow, Data pipeline and notebook), that we will find it in the description or showing as a link in the video, but not of them were found. Can the link to that video be added. Thanks in advance
I will be covering this topic again in the next video (due shortly), but here is a link to the video I mentioned in the video: czcams.com/video/t5mUKaLWpHE/video.html
@@LearnMicrosoftFabric Thanks for your quick reply. Great content and design. Keep it going please.
Dear will,
Nice presentation and great content.
Curious to know more about tools used to generate presentation and recording 🙂
Hey thanks! I used PowerPoint for the slides and Camtasia to record 👍
Hi,loved the session.Can you please share the links you promised for gateways
Thanks, yes all the supporting material (including lots of links to further learning) is in the Skool community here (it's free!): www.skool.com/microsoft-fabric/classroom/6e52cd48?md=9065a30b5ef647aeaf7986bd62aad840
Why are you restricting the On-premise Data gateway to on - premise SQL servers? In power bi we have used on-premise data gateway with other kinds of servers (Oracle, SAP BW, .....)
Hi Moe, just FYI, I don't work for Microsoft, so I'm not restricting anything! The Data Pipeline OPDG connection is in preview currently, I'm sure the will add more functionality in the future 👍
nice Effort..is it enough to complete the course and pass the Exam?
That depends on your level of experience! If you have working experience with a lot of the topics covered, then yes. If you’re completely new to a lot of these topics then I think it will be difficult
@@LearnMicrosoftFabric I am DP-203 Certified so will this videos help to clear?
@@sanishthomas2858 no guarantees, but DP-203 definitely help! Good luck 👍
Amazing content!! When are the rest coming?
Thanks, glad you're enjoying! Next one in 4 hours 👀
@@LearnMicrosoftFabric By when would the whole series be out? Am preparing to give the exam..
@@bijalpatel5164 Not sure exactly, but aiming for the end of May 👍
Please upload moreeeeeeee
Haha I'm going as quickly as I can! 8 out of 12 now uploaded 👍
In one of your other video you said that "Cannot connect to on premise gateways using Data Pipelines" at czcams.com/video/t5mUKaLWpHE/video.html (time Stamp : 16:10)
BUT In this video at 8:36 you connected with both Data Pipeline and Dataflow. Can you please clarify ?
Yes this feature became available after the first video, and before the second video. Read more here: learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data#using-on-premises-data-in-a-pipeline-preview
BUT be careful because the exam questions were written many months ago, and I don't think they have been updated yet. So it's likely if you receive a question about on-premise data, the answer will include a Dataflow, rather than a Data Pipeline 👍
@@LearnMicrosoftFabric Thank you so much for the clarification. I just wanted to take a moment to express my appreciation for your content. It's amazing, well-thought-out, and exactly what people like me need. Thank you for making these videos.
First of all Amazing video series! After completing this cource what type of job opportunity availablre in industry?
Thanks! Funnily enough we discussed this this week in the Skool community!
There is a big demand for analytics engineering skill sets generally (at least where I am in the UK).
There aren’t any Fabric-specific jobs yet in my country, think companies are still figuring it out, but I’m sure they will come 👍
Many of the skills you learn for this exam are transferable to generic analytics engineering roles (git/ version control, sql, python, data modelling)