DP-600 EXAM PREPARATION COURSE | Video 1 of 12 (Introduction)

hey everyone and welcome back to the channel and today we've got a very exciting video because we're going to be starting a brand new series here on the channel we're going to be looking at how you can become a Microsoft certified fabric analytics engineer bit of a mouthful you might know it better as the dp600 exam that you need to pass if you want to get this certification now a lot of people have been asking me about dp600 how do I get certified what do I need to learn and so in this course what I'm

going to be doing is bringing together everything that you need to know for this certification so that you can hopefully pass first time so what are we going to be doing in this video well this is a bit of an introduction okay so we're going to be looking at what's in the exam what are some of the details of the exam so how long is it how how can you pass do do it online or in person that kind of thing we're going to look at an overview of this course so specifically what are we

going to learn in this course in YouTube and how are you going to learn as well then we're going to finish by looking at why you might want to take this course and why you might want to get fabric analytics engineering certification in general so what's in the exam so the first section is around planning implementing and managing solutions for data analytics now within that we've got various kind of sub modules okay so you need to understand the requirements how do we identify requirements for Solutions how do we do things like security how do you

know the difference between different data gateways how do you set up access control and workspaces and capacities and how do you modify the settings of all these things as well another important section of the exam and being an analytics engineer in general is Version Control you'll need to understand how to set up Version Control for Azure devops understand some of the settings and the configuration options that that entails as well as some of the deployment pipeline functionality as well now this is not a completely exhaustive list of what's in that section of the exam we'll

go through each of those in a bit more detail it's just the high level kind of areas that are covered in that section and this section is worth 10 to 15% of the exam so it's a small section but it's a very important section I think anyway in terms of becoming an analytics engineer these are really important topics that you need to understand so up next we've got 40 to 45% of the exam so this is really the core of the exam that you need should probably spend most of your time studying okay and it's

a around preparation and serving of data so this is one of the core tasks that you'll be asked to carry out as an analytics engineer and within that we've got quite a lot of really important topics okay so you've got understanding The Lakehouse how do we set one up how do we create tables difference between tables and files the warehouse so the tsql experience creating shortcuts ingesting data from external locations into our warehouse or our lake house what are the different methods that we can choose here and when do we choose specific ones okay then

we've got data transformation so once we've got our data within fabric we might want to do some Transformations on it now you can do that with tsql spark and you will need to know at least the basics of tsql and Spark and also Dax in the next section as well so there's quite a lot of languages that you need to know to kind of an intermediate level I would say for this exam next we've got performance so how do we optimize performance both in terms of the getting data into fabric but also in terms of

the transformation piece so if you've got spark jobs that are running really long or you've got some tsql scripts that are really not very performing very well they're taking a long time to kind of return your data what can you do to monitor performance then optimize it and as I mentioned you will need to know P spark and T SQL to a kind of intermediate level there so that's something to bear in mind for this exam so the next section of the exam is around implementing and managing semantic models and this is worth 20 to

25% of the exam and within this category you've got the different storage modes so direct query import mode and direct late mode and kind of understanding how these things work how to set up direct Lake mode when to use it maybe when not to use it you're going to need to have a good understanding of Dax here there's quite a few questions around Dax and Dax studio and tabul editor 2 as well so these are kind of things that you need to be be aware of because you'll probably get some questions around that as well

also within the section you've got data modeling so things like Star schemas Bridge tables how do we deal with many to many relationships and also we've got things around security how do we set up roow level security within your santic model object level security and how do we validate that that's actually working correctly so in the final section of the exam which is worth around 20 to 25% again is explore and analyze data so here we're really looking at the analysis part of being an analytics engineer because most of your role might be in around

the engineering piece but really you need to know the analytics side of thing as well because that's going to make you a much better analytics engineer so in this section you're going to be asked questions about data analysis specifically you're using tsql okay so analyzing your lake house SQL endpoint analyzing your data warehouse coming up with insights from data using tsql you'll also be asked about data profiling so understanding the pro profile different tables based on some of the profiling metrics that you get and also analyzing data via the xmla endpoint so that's another part

of this section of the exam so these are the four sections there's quite a lot to go through and it covers quite a broad range of skills that you need to know from ppar tsql Dax data modeling getting data in data modeling serving data in semantic models as well so quite a broad range endtoend exam so in the exam there is between 40 and 60 question and the results are scaled and you get given a result between 0 and 1,000 so the pass Mark here is 700 out of 1,000 and that's the scaled score so

that's something to bear in mind and the questions can be of different types okay so some of them are multiple choice some of them might be a case study and the case studies normally take two three four questions so you really need to understand what's going on and you get multiple questions about the same case study you also have things like drag and drop and ordering lists and for a full list of the question types recommend you go to this resource here it's on the Microsoft learn the exam question section of Microsoft learn I'll leave

a link to that in the description below you can also use the exam sandbox that provides you with a Sandbox experience of the exact question types that you can expect in the exam you'll get given 100 minutes to actually carry out the exam you should set aside at least 2 hours though so 120 minutes for the exam just so that you can kind of get in get settled as I mentioned it's 700 out of 1,000 to pass this exam so 70% you can take the exam either in person in P view sensors or you can

do it online so my personal recommendation would be to take the exam in person if you can um it kind of eliminates a lot of the doubts and the problems around like Wi-Fi and worrying about your desk setup and your room has to be a very specific layout and so if you can visit a center in person I think it's a lot better cuz you can just walk in take the exam and walk out whereas online you have to think about lots of different things for me it's less stressful to do it in person if

you can so there is an exam fee which is $165 for people in the USA it varies for different countries but if you look on the right hand side we got a free exam so if you're very quick and you go to the link in the description and you complete the fabric AI skills challenge training course before the 19th of April so you've only got a few days you can get a voucher to take the DP 600 exam for free so you can do that skills challenge training very quickly get your free voucher and then

watch all of this series on YouTube and as long as you take that exam I think it's before June the 22nd or something so you've got two or three months to kind of go through the material at your own pace and then you get to save yourself $165 or the equivalent in your currency in your country so this is what this series is going to look like here on YouTube we've got the first video which is an introduction to the course then I'm going to be covering all 11 chapters of the exam and the content

is going to be delivered through various real world scenarios cuz I want to make this content interesting for you and also make it relevant for you if you want to be an analytics engineer or if you are an analytics engineer currently in your career and to do this I'm going to be combining Theory so I think there is some theory in some of these modules you do have to understand how things work but then practice as well how to actually implement this stuff in fabric at the same time throughout the course I'm going to be

reinforcing that knowledge as we go through and ask asking rhetorical questions as well as sample questions and at the end I do plan to go through a full video kind of like a practice paper let's say designing and lots of questions that you can expect within the exam as with all of my courses all of the resources and module notes and scripts and notebooks and all this kind of thing I'll be posting that in the school community so if you're not already a member there I'll leave a link in the description below it's completely for

free so make sure you sign up and yeah you'll get access to all of that so there's a few reasons that I just want to cover quickly here around why you might want to take this course and then go on to become a certified analytics engineer well the course gives structure to your learning Microsoft have given us a study guide and they've said these are what we think is important to learn for an analytics engineer so it gives you a really good Pathway to follow might also help you get a new job having that certification

on your CV is definitely not going to hinder your chances it would also be good to go into kind of promotion talks or payiz talks with your boss and say yeah well last year I did the certification and this is especially true if you work in a consultancy right because consultant here they're kind of selling your skills and your experience so if you have certification then that can help them win work in the future so in this lesson we've looked at what's in the exam we've looked at some of the exam details we've also looked

at the overview of this course so what are the different chapters that we're going to be looking through and why I think you should take this course join us in the next lesson where we'll be starting the course properly and we'll be looking at how to plan and Implement a data analytics solution