Requirements, admin portal, gateways in Microsoft Fabric | DP-600 EXAM PREP (2 of 12)

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

[@LearnMicrosoftFabric]

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

[@Pepyrss]

That's the most real-life examples I have seen! Thanks for putting this course together! Best one so far :)

[@LearnMicrosoftFabric]

No problem, glad you like it ☺️

[@luizfernandosp]

Awesome approach simulating this client and her problems!

[@LearnMicrosoftFabric]

Thanks! glad you’re enjoying the approach. 🙌🏽

[@iamjameson]

Get hyped!!! Thanks for all the effort making these Will.

[@LearnMicrosoftFabric]

No worries, hope you find it useful!

[@vt1454]

Awesome content!! Thanks for all the efforts

[@anderswold123]

These videos are incredible! I’m learning so much. Keep it up!

[@LearnMicrosoftFabric]

Great to hear you’re finding them useful, thanks!

[@amira_369]

Great effort!! Very helpful.

[@LearnMicrosoftFabric]

Thanks for watching! Glad you found it helpful 👍

[@RosarioGamarra-qp4zt]

Excellent work Will👌🏼 very well explained! Thank you!

[@LearnMicrosoftFabric]

Thanks for watching!!

[@VinayakKommana]

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!❤❤

[@LearnMicrosoftFabric]

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 🙌

[@scottpowell408]

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

[@LearnMicrosoftFabric]

That’s a great clarification, thanks Scott 👍

[@moeeljawad5361]

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?

[@scottpowell408]

@@moeeljawad5361 yep that’s right. Works on prem for SQL server but nothing else yet. Hopefully they add others soon. Thanks, Scott

[@LearnMicrosoftFabric]

@@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

[@scottpowell408]

Just as a follow up, this now works for Oracle also. Make sure to install the oracle tools for Microsoft clients drivers

[@oumouratouannasow6190]

Waaaw really interesting and original. Cannot wait to see the following videos. Thanks !!!🔥🔥

[@LearnMicrosoftFabric]

Thanks, glad you’re enjoying so far! I better get working on the next ones then 🤓😂

[@crixcel8388]

I am amazed to see how this is planned and designed, great work brother

[@LearnMicrosoftFabric]

Thanks for watching, and for the feedback 🙌🏽

[@yogeendravarma4104]

Thank You Will for Great video, Great explanation as always.

[@LearnMicrosoftFabric]

Thanks for watching! Glad you enjoyed this one 🙌🏽

[@AdrianMcGavock]

cheers for another great vid sir, listening to you while I'm making my dinner! 👍

[@LearnMicrosoftFabric]

🤣🤣 that’s great multitasking! Thanks for watching 🙌🏽

[@juanc.alcazar7507]

Great video

[@mattroberts9665]

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.

[@LearnMicrosoftFabric]

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!).

[@mattroberts9665]

@@LearnMicrosoftFabric Great! Thanks Will. Keep up the brilliant work.

[@leankassio671]

Thanks!

[@LearnMicrosoftFabric]

Thank you very much!!

[@moeeljawad5361]

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

[@LearnMicrosoftFabric]

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: kzbin.info/www/bejne/qmbQhn6Xgbyjfqc

[@moeeljawad5361]

@@LearnMicrosoftFabric Thanks for your quick reply. Great content and design. Keep it going please.

[@Azureandfabricmastery]

Dear will, Nice presentation and great content. Curious to know more about tools used to generate presentation and recording 🙂

[@LearnMicrosoftFabric]

Hey thanks! I used PowerPoint for the slides and Camtasia to record 👍

[@user-bg4wu1gs6i]

Hi,loved the session.Can you please share the links you promised for gateways

[@LearnMicrosoftFabric]

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

[@bijalpatel5164]

Amazing content!! When are the rest coming?

[@LearnMicrosoftFabric]

Thanks, glad you're enjoying! Next one in 4 hours 👀

[@bijalpatel5164]

@@LearnMicrosoftFabric By when would the whole series be out? Am preparing to give the exam..

[@LearnMicrosoftFabric]

@@bijalpatel5164 Not sure exactly, but aiming for the end of May 👍

[@michaelobuma]

Been trying to get in, but it keeps rejecting my card(master card) tried quite a few, still same result (for both free and pay as you go) have no idea what to do again. Need help please

[@LearnMicrosoftFabric]

Please raise this with Microsoft 👍

[@moeeljawad5361]

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, .....)

[@LearnMicrosoftFabric]

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 👍

[@sanishthomas2858]

nice Effort..is it enough to complete the course and pass the Exam?

[@LearnMicrosoftFabric]

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

[@sanishthomas2858]

@@LearnMicrosoftFabric I am DP-203 Certified so will this videos help to clear?

[@LearnMicrosoftFabric]

@@sanishthomas2858 no guarantees, but DP-203 definitely help! Good luck 👍

[@ranjithv3307]

After signing up for the portal, it is asking to upload a picture. After uploading it keeps on loading and never goes to next step

[@LearnMicrosoftFabric]

I believe you have now entered, correct?

[@ranjithv3307]

@@LearnMicrosoftFabric yes I do thanks

[@nguyenminhthu7064]

Please upload moreeeeeeee

[@LearnMicrosoftFabric]

Haha I'm going as quickly as I can! 8 out of 12 now uploaded 👍

[@shivanityagi3868]

In one of your other video you said that "Cannot connect to on premise gateways using Data Pipelines" at kzbin.info/www/bejne/qmbQhn6Xgbyjfqc (time Stamp : 16:10) BUT In this video at 8:36 you connected with both Data Pipeline and Dataflow. Can you please clarify ?

[@LearnMicrosoftFabric]

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 👍

[@shivanityagi3868]

​@@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.

[@Rohan_Bagde]

First of all Amazing video series! After completing this cource what type of job opportunity availablre in industry?

[@LearnMicrosoftFabric]

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)