DP-600 Exam Full Course (6+ hours) | Microsoft Fabric Analytics Engineer
HTML-код
- Опубликовано: 24 июл 2024
- Free study notes for this course and links to further learning resources: www.skool.com/microsoft-fabri...
If you want to become a Microsoft Certified: Fabric Analytics Engineer Associate, you will need to pass the DP-600 exam.
In this 6 hour course, we cover each of the elements of the study guide.
You will learn through a combination of theory, practical examples, case studies and practice questions.
Timeline
00:00:00 Course Introduction
00:10:47 Plan a data analytics environment
00:40:07 Implement and manage a data analytics environment
01:12:01 Manage the analytics development lifecycle
01:59:48 Getting data into Fabric
02:20:10 SQL, Data Warehouse and scheduling
02:46:41 Transforming data with Dataflows, PySpark, T-SQL
03:30:48 Optimizing performance
04:05:19 Design and build semantic models
04:33:20 Secure and optimize semantic models
04:54:44 Perform exploratory analytics
05:23:17 Query data using T-SQL
05:56:00 TOP TIPS for the exam
#microsoftfabric #dp600 #powerbi
Thanks for watching everyone, and good luck for your exam!! If you found this course helpful, please do like, subscribe, share - all that good stuff!! Happy to answer any questions you have about the exam in the comments 👇
Thank you Will for this amazing course. I passed my DP 600 today with a score of 826. Your videos are my main preparation material. I have shared your videos to everyone I know, preparing for the exam.
That's amazing - well done!! Thank you for sharing the videos also 🙂
Congrats on passing the exam. Is this course alone is enough to pass the exam ?
@@BasitAIi Some people have, yes, but I always recommend using a variety of materials to prepare, all of which I link to throughout the study notes in Skool
Will, you are a diamond! I did all the Microsoft Learn modules and watched their DP-600 videos and yours were way better
Man, this is quality tutorials. I'm currently helping my company shift into Fabric and I've been trying to figure out everything myself which is sometimes a bit confusing but now that I'm preparing for the DP-600 I want some formal education on Fabric. Thank you for providing it and for free! After this one I'll jump into the Spark tutorial since it's a main piece of my data science work and then Power BI for all BI and visualizations. Thanks again!
Got my DP-600! Thank you for such valuable content 😊
This is sweet, FREE, Concise and Valuable information jampacked into one full length end-to-end course delivered in a relatable way. I'm not even halfway yet and I've already nodded my head 300+ times 🤣.
Thank you, Will, for these wonderful resources you put out here on RUclips and your community. You are almost single handedly democratizing Fabric. Everyone I know that has taken and passed the DP-600 has referenced your content and that says a lot! Kudos to you!💪🏾
Congratulations for your incredible work! clean, clear, complete!
Thanks for watching, glad you enjoyed 🙂
This content is literally gold. The way you have explained it is so crystal clear.I have always hated permission and access control setting ,But you have helped me understand it so clearly.
Thanks. Looking to participate in the community
Actively
Thanks for this course. Passed the DP-600 exam using your course as main preparation and review material.
Thank you for all the effort put into creating this course. It is truly incredible. The material is presented very clearly and is straight to the point, making it easy to understand and follow.Also
having the main character scenario makes it very engaging , camilla's problems helped a lot in understanding fabric :)
Gracias por todos tus videos ,me ayudaron bastante para poder pasar examen DP 600 a la primera 😁
Thanks for the videos Will. I passed my DP-600 today with a score of 900. Almost 60-65% of the questions came from your videos and the rest from free exam dumps I found on google as well as Microsoft's training path for this certification. Its not super tough but questions can be tricky sometimes, 70% of the questions I had encountered before , so kindly prepare and give it a go. Thanks again for the great content ✅😊
Hi Dennies, well done on passing the exam. Please delete mention of Exam Dumps, they are against Microsoft policy and should not be used/ promoted
Amazing course! Thanks a lot for sharing it! ❤
Thanks for watching!
Wow.Massive.Great compilation...
Thanks for watching Nalaka, and congratulations on passing the exam!!
Just passed my exam. It's a pity that I watched this video late. This video is GOLD. Thank you man.
thank you so much for your support!
Thanks for watching!!
Very excited, I'm going to prepare my coffee and start this course, thank you very much
Haha you might need a few cups 😂 good luck. Let me know if you have any questions 👍
Thank you Will! I only had enough time to go thru the ms learn course and your video due to time constraints, but i was able to barely pass at 755! You covered around 80 to 90% of the non DAX questions. I got a lot those and came up blank lol. No visualization type question. Time is really tight. I had 25 minutes to answer the last 30 questions. And the questions was like really long. I think this series +dax and sql dive will give a taker a very high chance to pass.
Well done Bryan!
Superb content Will.
Absolute Excellent course
Thanks for watching!
3:21:54
Data aggregation means collecting data and presenting it in a summarized form to facilitate in statistical analysis. There are several types of it like roll-up, drill-down, Pivot and slice & dice
Thanks for your comment, yes my point was that the term data aggregation is ambiguous, it can mean many different things in analytics engineering, and it isn't clear what exactly Microsoft expect. Especially when it is combined with 'disaggregation'. But yes, I believe they are looking for a Power BI view on data aggregation 👍
Thank you Will for the video, this helped very much in clearing my DP-600 Exam. I just passed it!
great job - well done!
Hi Will, I just passed DP-600 today, thanks a lot for your series !
Amazing, well done!!
You are the best.
Thanks for watching!!
Thank you very much, Will, for this video series. Today, I passed my DP-600 exam with a score of 763 marks. I prepared for this exam in a short period, and your videos were my main learning material.
I highly recommend these videos to everyone preparing for the DP-600 exam. Watch the series without skipping a single second. Will teaches everything in a simple and very clear manner. Once you complete this series, you'll have almost everything you need to learn, not just for the DP-600, but also for working with Microsoft Fabric, especially if you are new to it.
After finishing the video series, I suggest doing as many practice questions as possible to easily pass the exam. A huge shoutout and thank you to Will for preparing such invaluable videos. All other videos available on this channel are also very useful. 💪🖤
Amazing - well done!
Great course so far! I have some doubts regarding the practice questions:
1) 01:09:00 - I tested this case by creating a separate workspace as a Fabric admin. Inside the workspace I added a Lakehouse 1 with sample Covid data loaded and Notebook 1 that simply imports the table as a dataframe, adds a column and overwrites the original table. Then I shared the items with another user who has no access to the workspace. I gave him ReadAll for Lakehouse 1 and Edit permission for Notebook 1. Now there's a message that you have to grant the Run permission to the user with Edit permission, but it was still possible to grant the Edit permission only. Not surprisingly, this user was able to open Notebook 1, but couldn't run it. Granting the Run permission fixed this issue, so I think it should be mentioned in the answer to the questions as well. But there's more - I thought that ReadAll permission grants READ permission to Spark data only, but apparently this user was able to run the notebook from start to end, overwriting the table (or even creating a new one after code updates) without the Write permission to the lakehouse. Is that the intended behaviour? What's more, the user could even create shortcuts and delete tables from the Lakehouse explorer, so what's the point of Write permission granted with the Contributor role? Funny enough, the user couldn't see the contents of the lakehouse from the notebook level (with the message that permission was denied), but could see everything from the lakehouse explorer.
2) 2:18:00 - I also tested this and in my case I needed the Contributor access to both Workspaces. With the Viewer in Workspace B I was able to see the lakehouse, but not the tables, thus I was unable to create a shortcut.
I'd be grateful for help!
Hey, thanks for your comment! I will go through them and respond shortly 👍
Tack!
Thank you so much - very kind!!
Thank you will!!!
I just passed the exam!!!!
Great job - well done!
Thanks Will! Please let us know if you will do a course on the Machine Learning Applied Skill Cert for Fabric.
I upvote!
Yeh that would be cool actually!
Thank you for this one and pls create a Microsoft Fabric Course Especially for Data Engineering
Thanks for watching! Which area of data engineering in Fabric are you interested in learning more about?
@@LearnMicrosoftFabric I'm interested in learning about the traditional process and what Fabric brings to the table that changes it. I need the context so that I can understand what power i'm leveraging.
Why is Apache Spark the chosen vs the alternatives (Kafka etc.)
Since the SQL Endpoint is both read and write, should the whole OLTP layer just move into directly into Fabric? (Power Apps etc.). Can that be configured?
@@LearnMicrosoftFabric pipelines in a real project, with some sources, not one.
Will thanks for this wonderful learning stuffs can you bring some real life end to end project with fabric which will help to gain more practical understanding
Absolutely, yes I'm planning more hands-on learning in the future 🙌
Thank you Will for this master piece!
I tried to connect azure devops from a different tenant/subscription in another fabrics workspace and there's no way to that. Is there a work-around?
Your content is amazing, precise and well explained. Today cleared DP600 with score of 913 .Thank you 😊
Amazing - well done!
Hello and thank you for your efforts. I want to ask if this full course the same previous series of 12 vids combined in one video?
Yes, it combines all previous videos into one 👍
thanks, G I got my certificate
Amazing - well done!
Hi, great content!
Do you know how similar the practice exam is to the real exam?
As in are they very watered down or quite similar to what we should expect?
The content is fairly similar, but normally the exam questions are longer/ with more context. I definitely recommend going through the Microsoft Practice Assessment DP-600 a few times to understand the types of questions you can expect 👍
Hello, great course, I signed up and I am unable to access the study notes , will it be available once membership is approved? Thanks
Hi , since the syllabus is going to change by the end of this month July 2024.. what changes will be there in the course content here and expected questions post July 22 2024 ?
Great work 👏👏
Kindly what tool you are using for this presentation?
Thanks for watching! PowerPoint for the slides and Camtasia for recording/ editing mainly 👍
@@LearnMicrosoftFabric impressive
If I have watched the initial series of 12 videos, is this different content or basically the same? Do I have to go through this video for the course as well?
It's the same content, just combined into one long video 👍
@@LearnMicrosoftFabric okay thank you very much Will. You’ve been a great help, the community appreciates you!
Thanks for watching!!
Thanks for the help, just finished with 739. That was horrendous, time is not on your side, or Microsoft learn, not sure why that thing has a search bar
microsoft learn content while available at exam time ?
@@vajeebchemmala yes it’s available, but ctrl + f doesn’t work. Don’t know if you’ve used MS learn on the fly, but it’s search is worse than bing. I wasted far too much time in it looking for a few answers that I couldn’t find, and had to rush the rest.
@@vajeebchemmalayeah, use it sparingly. You will run out of time if you depend on it
I have one doubt in fabric data pipelines and dataflow present in both data factory and data engineering and they look same what is the difference between them,what is the need of presenting in two like in data factory and data engineering,can anyone explain
Yes they will be the same. Some items appear in more than one 'experience' because they are useful to different personas (also the notebook is available in Data Engineering and Data Science experiences)
@@LearnMicrosoftFabric thanks man
Just asking I'm not willing to take the exam
Will this course be helpful!!
Hello sir,
Thank you so much providing these productive videos.
Today, I faced a challenge, and the solution I couldn't find elsewhere.
That is
How to Extract data from SAP Hana Cloud to Microsoft Fabric (cloud to cloud connectivity). Could you please help me here?
Hi there, thanks! I think SAP Hana connectivity is supported, read more here: blog.fabric.microsoft.com/en-us/blog/integrate-your-sap-data-into-microsoft-fabric/
I have tried, that only supports SAP Hana Database but not SAP Hana Cloud as of now.
Could you please at your end once, please
After completing this course will i be able to clear dp-600 or I need to know more
Hey, that depends on your current level of skills and experience. If you are a complete beginner, probably not, but if you have existing skills and experience in SQL, PySpark, Power BI, it's possible. GO through the course and then try the Microsoft Practice Exam to gauge your current level 👍
@@LearnMicrosoftFabric I'm preparing for dp-203 now once done will start to preparing for this one. Just for small doubt if you could clarify I asked a few about taking fabric they said it's still too early and still being developed is it right time to go for the certificate or wait some more time.
Please share the link of practice test? Great work
@@sanishthomas2858 Does anyone know if Microsoft has or is planning to release an official practice test? They helped a ton when I did PL-300
@keithfjord Microsoft already has a practice exam for the Fabric exam and you can take the practice tests as much as you can. Simply go to getting certified under DP600 to take practice exam. You may need to sign in with your MS learn credentials to have an assessment result tailored to your achievements achievements
Is there any option that we can take exam with free voucher?
participate in microsoft challenges
I don't think you will get 100% off, that was only available around April time. Check out the Microsoft Challenges for 50% off though. The most recent one was the AI Skills Challenge (50% off), not sure if that's still avaiable
@@BasitAIi may I get more details on it please?