foreign [Music] good day everyone wherever you are right now I'm Julian Pedro I'm here in this conference to talk a little bit about the p 300xm and the Azure database administrator associate certification I'm a data Nai content developer at Microsoft so super exciting to be here with you all today my background was always in the Microsoft data platform I was a database administrator for many many years then I transitioned to data engineer and then recently about six years ago I transitioned my skill set in SQL products to Azure environment and Cloud so just to talk a little bit about our team our team manages and builds technical learning experiences that help customers worldwide build their own technical skills right in their own technical Journey so from Azure SQL to Azure machine learning power bi and everything in between we are there and it's speaking about a little bit about learning experiences you can sit there you have my LinkedIn profile right there so I'm constantly posting educational materials on my link heading so please stop by and say hi if you want to learn more about Azure SQL Azure machine learn or Azure synapse so just stop by I would love to connect with you today super excited to speak to you about the p300 exam which we all know it started to the Azure database administrator certification so I'm also going to present I'm presenting this session with Sandra Sandra is a senior Business program manager at Microsoft so more towards the end of the presentation Sandra will talk more about the Microsoft exam and share some additional information and resources with you we want to make sure as well that this presentation is enjoyable and information at the same time so please if you have any questions you can ask them along the way or you can wait until the very end of the session to ask them we have some colleagues looking out for questions and we'll be happy to answer them as we go so without even further much talking let's jump right into it today we are gonna review your path to the p300 certification and we're gonna check we're gonna talk a little bit deeper about the technical content that is covering that exam so like our main purpose here is to help you and give all the guidance that we can to help you succeed and then we're gonna also explore the Microsoft exams and share resources to help you prepare so it's in our session but I'm gonna be talking a lot so please um you can post your questions uh in the chat and uh we will be glad to to answer them as we go here we are right we are trying to learn about the exam DP 300 what we need were the technical skills that we need to know uh to succeed in that exam so here we have the XM the official exam name and uh this XM name changed back in August right so before that were administering relation databases in Microsoft Azure and then because of um we switched gears a little bit to remove some of the open source content that we were providing before to now Focus only on Azure SQL Technologies and offerings um and here you're gonna have uh you have the row description and excuse that we are measuring we're gonna talk about them in more details ahead but you also have here the link right in this link will take you to the certification page where you have gonna have a little bit more details about this certification here we are right we are these um pink circle right here we want to know everything we can about the DP 300xm right and we're gonna share everything with you but although not required we do recommend that you take Azure fundamentals and Azure data fundamentals XM if you have done so it's really recommended so uh of course if you were an experienced DBA right in the field and you have some ex some experience already in Azure you can succeed without it but to give a little bit of more understanding about what we're gonna cover in the exam to help you prepare more with some more substantial knowledge it's important to have a little bit um understanding about those baselines right which both exams will give you and Daniel take the exam and finally you become a certified right it's that's um we want you all to succeed so that's why we are here today here we're gonna start talking a little bit about in a high level of the functional groups that are being covered for the p300 and here you see this is the XM objects domain breakdown each one of those is called functional groups right and what they do they basically tell all the topics and all the tasks that you need there are DBA in the field right should know to become an Azure database administrator certified so for example you have here plan and Implement data platform resources you see 20 or 25 percent this means that in the exam there are going to be 20 to 25 percent of questions related to that functional group and so forth so here what I'm gonna do we have those two links here up here one is related to the XM page and the other one is related to the XM guide what I'm gonna do um I have the first link here which is which is actually the XM page you can see here some details about the exam so you can understand what you expect when you want to learn more if you want to learn more about the certification and you hear you can schedule your exam through that button right and here you can see the skills there are measured on that exam and you can even download the outline so you can check later to find gaps in your knowledge things that you need to focus more or less depending on where you were on your journey in a little bit below you can see here there are two ways to prepare so we offer the self -paced training which is on learn it's hosted on learn and you can see here we have all the learning learning paths that support their certification right and right here you have the instructor-led Based training and uh Sandra will talk more about it later um more towards the end of this presentation but knows that there are two types of uh training that we offer right and they're all available to you so coming back to the presentation we also have another link if you click here you're gonna actually see the exam outline and if you can see here there is the audience profile the details all the details about each functional group that we talked about and actually the tasks and the topics that each one has in covers so I'm just going through that a little bit so you'll know how to access that when you need right it's on the certificate is on the exam page and then you can download the skills that we have here to get you prepared and also on the same page right it's really convenient you also have all the learning paths that you need to know to take the exam so coming back to our presentation right we were right here so the next one and now is we're gonna cover each module that the course dp300 um administry Microsoft Azure SQL Solutions all the modules that are being covered but that is supported by that certification I'm not going through a lot but just notice that I put here so you know for example module 5 and module 6 we those are new models that we introduced just really recently so there are a lot of uh asks in the field that you include migration more migration contents and um that that's actually some of the major tasks right especially if you go into the cloud for the first time that you need to know so we we changed a lot of our contents we made a massive without including the name of the certification itself in the course we also change it all the modules some of the modules names and including some topics and we are going to the topics the new topics as well later on and here for example if you see here those three three modules for example are all related to Monitor and optimize operational resources so that is tied back to one of the functional groups that are going to be required in the exam so our certification our modules were everything matching of what is uh required by the object domain so now we are going module by module and uh I'm gonna talk a little bit about the technical part of it and what to consider when taking the exam or what you need to expect in terms of content itself or a skill set that you need to have so the first module is prepare to maintain SQL databases on Azure and what does that mean we kind of create one separate module to set a baseline of understanding right and I know it's sometimes so complicated we have we talk about Azure SQL but what Azure SQL database is and what about SQL management instances um are they the same so this is kind of the initial steps for the further modules that we are going a little bit down and deeper on each one of those products and offerings so you also gonna learn a lot about the Azure database administrator responsibilities right if you're coming from on-premises are there any difference when we are talking about Azure how they relate to other Azure data platform roles right in general and I say that because cloud service can be broken down into two sets of services we have infrastructure as a service IIs and platform as a service which is past right and so we are going to talk about those Concepts as well and all those offerings that we have available in azure on module 2 for example we're going to start going a little bit deep deeper on IAS which is basically Azure a SQL Server running on an Azure VM so we're gonna explore the basics of a SQL Server learn how hybrid scenario works and you can see here um that we included a completely new topic especially now that we are talking a lot about Azure Arc right so companies they are trying to understand what options are available on Azure sometimes implementing a hybrid infrastructure is complicated right so we are trying to cover a lot of the basic understanding when we are talking about databases SQL databases right so for some companies implementing a hybrid infrastructure is also an excellent first step right in evaluating cloud computing um and just to make sure that it will work for them and that will make sense so hybrid hybrid scenario will also cover a lot of those use cases and then we're gonna talk about explore performance and Security Options those will be covered so hadr and performance and Security will also be covered ahead into more details but like other modules this is just set the basic rules for the modules ahead on module 3 for example we are going to talk about past Solutions so here we're gonna most focus on ways to provision deploy Azure SQL database Azure SQL management instance and Azure SQL Edge so all so hyperscale function for example is a completely new topic that we included in the certification that was not there before as long as details completely details the more information about Azure SQL management instance as well and here so when we're talking about Azure SQL we sometimes never heard about it right it's a New Concept and a new product that is out there as well but basically sicko edges the robust database for Edge Computing and it combines capabilities such as data streaming and time series so it's a really great opportunity with beauty machine learning and graph features if you want and if you had that need your own environment depending on your business case right so on module 4 we are gonna start talking a little bit about migrating to seek and more to consider what are the easy cases that we have and how compatibility level affects your query Optimizer and we also is going to understand Azure preview features and describe some options when considering to migrate to Azure SQL and this one here this new one this is a completely new module like we talked before that is focused on how to migrate SQL workloads to Azure SQL databases um in this model we learned to demonstrate the benefits and process for moving a SQL Server database to Azure SQL database you look at how to migrate SQL Server workloads You Begin by exploring the prayer migration considerations right it's like a planning phase that you need to take into account before a migration so what you need to consider when we even talking about migraining our databases in how to even create a SQL database to support our needs all of that is being considered here and it's only focused just uh just to make that clear everyone is just focused on measure SQL databases but on the next model though we do have kind of the same looking and feel that we have in the previous one but just focus on Azure SQL management instance right how to migrate to magazine so and uh just to give a little bit of uh Insight in there this is actually the fastest and least expensive method if you're considered to migrate and migrate an application or workload to the cloud we call that lift and shift migrated migration because it's it's easy right because there is a high comparability compatibility between a single server on premise and a SQL managed instance so if you ever considering this is a good option if you'd prefer to migrate with the little database administrator and developer time as possible to keep your project with a low cost right and here on module 7 we have configure database authentication and authorization so here we're gonna talk a lot about contrast authentication using Azure active directory we intersective directory in SQL Server authentication what are the differences right what are the main things I need to consider if I'm moving to Azure SQL so while the building rows in SQL provide a broad range of security privileges that we all know many applications need more granular Security on database options so we're gonna we're gonna look for those as well and investigate that and then we have a new completely new topic that we now are talking so yeah I have all my security I'm following all the best practices right but if something happens if I have a failure how can I monitor that what are the failures that I should expect and how to solve them so this is kind of the topic a new topic that we included not only in the exam but also in our content on module 8 for example protect dating transit in at rest well this model export encryption options available with the Microsoft SQ courser not only Microsoft SQL server but Azure SQL database and Azure SQL managing instance as well so in here we have a new topic that we also included which we will explain how to enable encrypted connection um basically we're gonna talk about TLS which is transport layer security which is a protocol for encrypting connections you will learn not only how to configure it and how to use it as well so basically when we are talking about um encryption methods there are three scenarios to consider right we have what we call data to rest with which is encrypting the data while it's on a file storage right that's why at rest is important there so dating Transit on the contrary it's encrypting it while it travels through a private or public network and then we also have a third one which is data in use which is encrypted by while it's on cash right it can be a memory cache or a CPU cache so those are the three main components when we are talking about encryption and recover a few of them in that module on module 9 we're gonna talk about Implement compliance control for sensitive data so here we're going to explore data classification capabilities and degrees of confidential confidentiality we're going to implement Security Options to maintain private data safe for example so why serving database audits are important where the difference between those two right how to implement role level security and dynamic data masking and those are new topics as well so we included a new unit only to talk about speaker database Ledger and also Azure purview they're all fresh and new content so make sure you check it out and you can always reach out through our uh social networks and I might link it in profile to give feedback we would love to hear from you on that as well foreign and this is the first module of a set of three that we are going to talk about in in a moment that talks about start talking about monitoring and performance optimization right so here is describe performance monitoring so here we're gonna understand how to monitor your database performance we are going to also compare Azure and on-premise tools for monitoring so when we are talking about uh azure are the same set of rules that I have on premises available in Azure where the differences what they are right how to use each one of those and the main thing is we also going to understand how to create a baseline so coming from a database administrative background as well it's a a baseline is so important right sometimes you have your database there in three in the morning you receive a call in the middle of the night um I believe most of you have been there if not well it's not a good feeling right you receive your application stopped in the mirror of the night no one can do anything you have transactions coming that can complete so when we are talking about Baseline we need to understand and set the ground rule of what is normal right in that environment what we consider normal and everything that deviates from that normality from our Baseline it's actually something that we need to take an action on right so you can start being proactive right although and it's so important especially for that role so this Q Remains the Same in that doesn't change because you move to Azure those are two important skills for a database administrator and also here at the very end um we included a new topic which is it's also covered in the exam which is azure SQL insights so for for those who are not familiarized with that SQL insights is actually in preview and it's a comprehensive solution for monitoring any products in the Azure SQL family so it's really cool it centralized all your performance data in one central place it's really nice and still talking about monitoring and performance so we have the module 11 with configure SQL Server resources for Optimal Performance and uh for folks that attaining this session that is really well familiarized with on-premise SQL Server um it's kind of where we are covering here we are covering a lot of empty bees right tempdb's data files what are those best practices for database files what about transaction logs what about our data files so everything here is more towards on-premise and SQL Server running on a on a on Azure VM and at the very end finally we're gonna understand use cases and scenarios to configure a resource Governor so this is a really cool feature that we have there and so we are going to show some examples as well in the content on module 11 uh we're gonna talk about configure database for Optimal Performance so everything within the database that we can do to improve the performance so we're going to understand database scope configurations what is out there right even if your database is in the cloud ongoing performance related maintenance are critical right so we all know that we need to keep our indexes up to date in our statistics so we also going to learn how features of intelligent query processing we call it iqp um how the how does it relate to Azure and what is this about and we're also going to explore automatic tuning feature on Azure which is super It's A New Concept and well we covered that before but right now we we extended it a little bit to put some more advanced Concepts in the content on module 13 we explore query performance optimization so you will learn how to read and understand various form of execution plans right you're gonna compare estimated versus actual plans and how plans are generated and then you understand the purpose and benefits of the query store right you also it is a new content as well that we are not covering before investigate so there are so many reports available when we're talking about query stores right you have the regressed queries how do you analyze a regressed query that is available there how we can benefit from there and last you're gonna understand how blocking logging affects your database engine and what you need to do to solve those issues so here we're gonna talk more about query performance in this module and on the module 14 we are going to explore performance-based design right this is an is still an important topic for a database administrator um you need to understand normal form and how it affects database performance right investigate the impact of proper data type usage um and I say that because most of the time you may may be working with a third-party vendor application that you don't have control to change the database right most of those 30 party vendors does allow that and you can lose the support if you do that but understanding how things are working on the database design thing it will help you if you have any problems with performance right because you already know how the table structures are you already know the scheme of the database so it is important although most of the time we can change it it is important to understand and the best of the world is if you have in-house developers right we are talking maybe we're talking about an application that was built in-house and now you do have a little bit more control to come back to data engineers and maybe developers and talk to them and propose some changes to improve the performance so on module 15 we are going to start up we're going to talk about evaluate performance improvements so we're gonna talk about weight statistics and what are the possible changes that we need to make when we're talking about index in poor performance in the index what are the what are the type of tuning that we can make on the index is covered index non-cluster indexes column store indexes right we're gonna reveal all of that and I say that one of the challenges um for dbas um is how to evaluate those right sometimes we have a poor performing query online and we cannot sure how to change them to achieve that so all of that is going to be revealed in that module and also we're going to reveal how to make minor tweaks right sometimes there are those little things that we can make that we improve performance considerably so and also last but not least we're gonna understand how query hints work and when to use them should we use them that's a big question mark there um well maybe maybe not or maybe working with a 30-party vendor and database there you don't have control but they implemented a few query hints and that is hurting now that it's in production and you have a massive workload it's kind of hurting your performance so you need to understand them at least and you need to know when and when not you not to use them so you can start having those conversations in your team and in your company on module 6 theme we are going to start uh to talk about automation right and I'm really excited about those modules ahead we have three set of modules that we're gonna Focus strongly on a database automation so I would say those modules was kind of built from scratch from their own content that we used to have with now this new version so super exciting so here we're gonna explore multiple deployment models we're going to talk about Azure resource manager templates arm templates right we're gonna talk about bicep files it's just for deploying Azure SQL resources and on the set second topic this is completely new here we were even and I use Azure CLI a lot in the past on my automation scripts and I was really happy to have to included that a part here so it's completely new how can you take advantage of azure CLI on your information and then like I said as a resource manager templates and bicep and also understand the differences right when we are talking about multiple command line options um what is what are the differences so if I need to run a script I can run it through Powershell and CLI but when should I choose one versus another is that any preferable or recommended approach so this is the module that we are going to cover all of it foreign 17 we're gonna talk specific about SQL agent jobs right it's also a part of the certification because we have SQL server on premise SQL Server running on an Azure VM and we also have SQL management instances which also has SQL agent jobs right you can add them so here we're gonna talk about explore core automation just focus on SQL agent jobs and just to add a little bit here um one of the ways you can benefit from measure is using the butane resource so if you're running although you have different automation mechanisms out there different third-party vendor I was always a strong Advocate to using the native tools right SQL agent right it's easier it's uncomplicated it's everything embedded in just one solution without relying on external resources that sometimes get in the middle and over complicated especially if you have like um a complex right a complex workflow so it's important to to keep that in mind as well on moderating um we're gonna talk about manage Azure past tasks using Automation and here we're gonna focus more about what we have available for paths right for Azure SQL database pads best solution so we are going to explore the capabilities of azure Automation in here we're gonna also run some create right not just configure it we're going to create some around books with a Powershell scripts embedded where you can schedule it you can create a completely set up jobs you can install modules create credential to authenticate so it's a super it's super cool um and those three new topics are really exciting so Alaska jobs is kind of a new uh feature so we are now covering um elastic jobs in the content in index them as well and we also covering logic logic caps for database workflow so these logic apps is mainly used by developers or devops Engineers but now what we did is we can also if you want to write on Azure you can also take um advantage of that functionality of that product to create your own database workflows right why not right it's out there it's available for us and then well you create it right you create your Azure automation account you create your own book or even an elastic jobs no matter each option that you choose how can we monitor that how we can make sure that they are healthy that they weren't in the way they should be running right so we created a new topic only for monitoring automated tasks as well so super super nice the changes we've made here on module 19 and this is the first module that we will start talking about high availability right so for example you're gonna learn how to plan an appropriate habitability and desires to recover strategy based on RTO and RPO where where are those right what are the difference between those two metrics and explore available have availability in disaster recover options not only for infrastructure as a service but all also for past environments right what is available in Azure SQL what is available on Azure Management in SQL management instance what about SQL Server running on a VM and then you're gonna start creating your appropriate High availability and disaster recovered strategy so our plan with that module is that at the end of it you review all the options available and kind of start planning in your own environment what is the best approach based all requirements that you have because there is no one solution that fits all the scenarios right we mostly for costs maybe it's cost related maybe it's a technical component that it's uh it will not allow you to implement one solution versus another so it's important to understand all those differences to understand what you can do in your own environment in your own situation foreign we are going to explore IIs and past solutions for high availability and Disaster Recovery here we're going into each option and go deeper of which one and all those features and how you can configure them so we're going to deploy Windows Server failover cluster we're gonna talk about failover cluster instances for example an availability groups you even going to learn how to configure temporal tables and talking about paths we're gonna learn about Geo replication and how to failover groups and for that we have Labs online for that as well we're gonna talk a little bit about the lab so it's super exciting that you can have the benefit of exploring that through the labs that we also provide provide so I'm talking here but anytime you have a question you can just make sure that you you put it in the chat and we're gonna we're gonna make sure that we answer them um what else let me think let's jump to module 21 and here we're gonna talk about big hap and restore databases right we talk a lot about h a and Dr but if any if none of that works and you're trying to fail over your database and you're receiving failures maybe it's something that was not configured properly or maybe it's something that is not available by the time you try to fail over or something else going on we need to have a good recap strategy right and when we are talking about no matter IIs infrastructure as a service so pass you need to have a good backup strategy and just make sure that you test your backup plan every every I don't know maybe it's three months right maybe six months I work for companies that I had to run a full a full run of a Dr test every six months right and you can use a backup and restore as a as a Dr solution depending on an environment so knowing all the implications of having that and making sure you understand all of those so make sure you test your backups that's my um and as a DBA if you work in the field you probably know but sometimes someone um coming into the SQL Server world will not have that understanding so it's it's it's important to reinforce that so here we're gonna yeah we're gonna plan and Implement policy for recovering your data if you have any failures maybe it's a hardware failure right maybe it's an application failure that will impact your database so we're going to explore various options for how and where to back up and restore your databases and here this was our last module right and we covered a lot of technical content so again any questions just make sure we get to it but I want to I really want to talk about the labs right labs are an important component for what we offer either on self-based Learning Journey or even instructor-led Journey so we offered a hosted virtual machine so in the what is a hosted virtual machine right we provide the lab environment for you you don't need to I mean although you can and we'll talk about it a little bit later but you don't need to spin up any server right or you don't need to have a subscription to run the resources in the lab so we provide all the infrastructure for you so you can do it and try it in your own your own right and we know that we all learn best when we have a chance to implement it right so you're going to have an Azure subscription Resource Group with the permission including the permissions required to complete the lab so it's everything prepared for you there um and what I'm gonna do now I think um I'm gonna do a quick demo for you because it's important that you understand how to find those labs right so um let me just start presenting and then so suppose you're here right in the exam page like we went through a while back so you can see here that we have all the learning paths that we just talked about in those learning paths inside of each learning path so for example planning Implement data platform resources you have all those modules that we just talked about migration the new migration modules you see here they're all here for you so when you go to the learning path page you see the modules and if you expand here in the overview you're gonna see all the units in that module part of that module right and you can see here that you see this one here saying exercise so this means this is actually a lab so when we go here for example let's check another one you have all those topics that are being covered on that module including another one starting with exercise so this is another lab so every time you see that format the first word saying exercise it means that it is actually a lab so when we go here you can click directly through here or we can go through the module itself and you're gonna have the same feel that we just went through and you can click here you or you can just start your your module your module will start and it will go through each topic until you get to the exercise and when you get to the exercise you see here the same here you can access all the topics covered by that module and then their exercise which is where we are right now and then you can launch the lab right and that lab it's actually let me present it again just a second it will pop up a page like that for you which you have you're gonna have a virtual uh a virtual server right for you with in our case for the p300 it has Windows 10 virtual Studio code Azure data studio and SQL Server management studio and also the subscription in the resource Group on Azure Proto available for you so you can try the labs so it it's really cool um if you haven't given that a try I would highly recommend it to you do because our labs are focused on a lot of those Concepts we just talked about we have Labs on performance monitoring we have Labs on the you name it provision a SQL database right or identify blocking and locking just to name a few right every module not every but 90 of the margins you're gonna have a lab Associated to it so please give it a try and here um if you don't so we do recommend your first try beyond the hosted lab that we offer through Microsoft learn or structure lab training but you can only bring your own subscription right if you don't have a subscription you can apply online so you can apply for a free trial but you can also use the subscription that you have to create your own Labs so for that what we can do you can see here this link up here it's important to mention this is our GitHub repo right so that will point you to that page and what it does you're gonna have here if you click on that link here on the repo you're gonna see all the labs that we have so we have that option as well if you uh prefer to bring your own subscription and try all the labs in your own subscription you can do that as well and uh just one comment since we're already here super excited uh but here you have this issue tab here so every time you're trying your lab on your own and you'll find any issue something awkward something weird something that should be that way and it's not the way it's supposed to be you can always create an issue for us we are constantly monitoring all the issues in our repos so you can just come here new issue and we're gonna receive it and we're gonna take care of it okay just so I want to make sure that um I I let you guys know all of you about that as well okay so we talked a lot about it right we covered the topics and the labs um on the next slide though um I wanna personally I wanna talk about tips to prepare those are things that I personally do when I'm trying to learn um about A New Concept or when I'm trying to take a new exam so first thing I make sure that I go through the modules that are certification covers like like we did here right make sure that you understand all the topics being covered by our object domain right um and then try the Hands-On labs this is important because it will bring you some awareness of what we are talking about sometimes you read a lot about a concept but only when you try yourself is that when you fully learn and you fully get what you were referring to right and another tip that I'll give you refer to SQL docs right SQL docs is our source of Truth when we are talking about the latest Future and the latest documents um so if you want to learn about a specific topic so make sure you're checking SQL docs for it and that build your experience with technology so what I'm saying here is try to leverage everything that you learn or everything so you learned about for example temporal tables right it's a cool feature but you're not sure if you should or should not Implement in your own environment maybe bring it on talk to someone in your team share that concept do a demo right someone people don't understand what they don't understand right try to involve folks in the decision making as well so you can Implement and help to implement and give ideas so don't don't keep it the goodness that we will learn about CCO along the way don't keep it to yourself spread the word and talk to other folks in the team and that maybe will make you succeed in implementing those and having the hands-on experience that you may may think you need [Music] um and I think now Sandra it's up to you uh it's your turn how we are on time we are doing great Giuliani this was fantastic all the things that you just shared it's amazing uh um I was so surprised on all this content and and these resources the loves uh thank you for showing all these so I'm gonna spend the last few minutes for our session if you still have questions uh we we will still be around here for a few more minutes so be sure to ask your questions but in the meantime I'm gonna give you some information of what to expect about Microsoft exams so if you haven't taken a Microsoft exam before um just be aware there will be something between 40 and 60 Questions and um this is just a range every exam is different so you may have different questions from one example from the other and if you take the same exam multiple times if you fail and you take it again you will always get the same number of questions but maybe if you take the exam later six months later maybe it will change but we have a large box of questions so if you take the exam again you will not see the same questions um now uh some teams answer all the questions uh even if you are not sure about the answer be sure you give some answer and and you can always Mark a question and come back later and review it maybe you will see the answer later uh some questions one you can skip questions but some questions you cannot Escape so be sure that those you need to answer them now plan for about the three hours at the most and again each exam varies but um some of these um will uh some of this time will be just for you to read the instructions and to comment it's important that you give us feedback on the questions um but at most you should plan for three hours so you are not in a rush um every exam requires 700 points to pass and you saw a how different topics and different questions will have different weight in their in the scoring so be sure to do that now not all the questions are a single choice or multiple choice we have like 10 different type of questions that you will see in the exam and some of those questions are even cases studies uh some questions are some exams include Hands-On Labs so you will actually be presented with a return machine to do some to show us how you do the how you solve a situation if you want to see more information about everything a Microsoft exams go to this webpage and you will see there a lot of information I want to show you a really quick the exam sandbox these are super cool um uh tool that we released recently especially if this is the first time you uh are presenting or taking a Microsoft exam this will give you the full experience and if you want to get familiar with the type of questions you can see here you can see a different type of questions and you can see how it feels in real life so um you can see the type of questions and all this stuff I'm not gonna do all the demo here but be sure you take a look at them at the demo examine this link now another another resource I want to share with you is the exam Readiness Zone this is new on Microsoft learn and you can see here a lot of resources uh from Microsoft experts to help you prepare for different exams so you will find a study guides exam preparation videos and you will find a practice test also not every exam is already included in this exam Readiness sound dp300 is on the way is not there yet but come back every now and then because we are releasing new exams all the time to this exam Readiness on um and you will see all the material here now a compilation of the resources that Giuliani um shared here the exam guide uh you will see all the all the all the all the uh the objective domains and all the topics included and if you want to study all these modules that Julian showed you can access through this uh curated collection or if you want in-depth training you can you can go to Microsoft learning partners and you can ask for instructory training so all this content that Giuliani shared today is what you will get with Proctor instructors that will help you through the labs will answer your questions you will have interactive and you will have peers and colleagues that you can work with or if you want to do your own learning you can go through the sales based learning paths remember to have them and the the the labs that you um that you saw that Giuliani uh share here the links are previously in the deck and the documentation one last thing before we leave um all Microsoft certifications expire if they are associated or or um or expert level they will expire after a year so you need to be sure that you're renewing your certification so once you earn pass your exam dp300 and earn your Azure database and administrator associate certification it will be active for one year and then at the six months Mark you will be eligible to renew this certification so you have six months to renew the certification and once uh you renew it it will be active for another year and so on and so on as long as the certification is available so it's easy to renew your certification uh it's three steps be sure you connect your Microsoft learning certification profiles you can prepare with self-based training that is curated and to renew your certification you only have to pass a free online assessment that is available on Microsoft learn so be sure that you are a renewing your certification before it expires if it expires and you don't renew you will have to take the exam again if you renew it on time is just the the free online certification so these are some resources and you'll get access to this deck to renew your certification and learn more about renewals and we thank you we appreciate your time here we hope this was a good investment of your time and thank you for attending and we hope you keep enjoying your data platform virtual Summit 2022. thank you