Microsoft Practice Test DP-300: Administering Microsoft Azure SQL Solutions
The DP-300 practice test trains you in administering Microsoft A zure SQL solutions.
Why should I take the DP-300 exam?
The DP- 300 certification offers database administrators the perfect opportunity to validate their skills in managing on-premises and cloud databases built with SQL Server and SQL database services. On passing the DP-300, you will achieve the Microsoft Certified: Azure Database Administrator Associate certification, demonstrating your knowledge of , and experience , with Azure SQL Edge, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
The DP-300 practice test includes two different modes: certification and practice mode. Certification mode allows you to assess your knowledge and discover your weak areas, with practice mode allowing you to focus on the areas that need development.
Regular Price
$99.00
As low as
$59.40
https://www.measureup.com/microsoft-practice-test-dp-300-administering-relational-databases-on-microsoft-azure.html
7606
Microsoft Practice Test DP-300: Administering Microsoft Azure SQL Solutions
<b>Questions:</b> 160 <br><b>Release Date:</b> 10/2021 (Last Update: 12/2022) <br><b>Job Role:</b> Database Administrator <br><b>Language:</b> English <br><br><p>The DP-300 practice test contains 160 questions and covers the following objectives:</p>
<h3><span class="TextRun SCXW201985463 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW201985463 BCX8" data-ccp-parastyle="heading 3">Plan and implement data platform resources – 34 questions</span></span><span class="EOP SCXW201985463 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":120,"335559739":0,"335559740":240}"> </span></h3>
<h4><span style="color: #0780c2; line-height: 10px;"><span class="TextRun SCXW214354834 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW214354834 BCX8" data-ccp-parastyle="heading 2">Plan and deploy Azure SQL Database solutions</span></span><span class="EOP SCXW214354834 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto"><span class="TextRun SCXW47696188 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW47696188 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Deploy database offerings on selected platforms</span></span><span class="EOP SCXW47696188 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></span><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW134302033 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW134302033 BCX8"><span class="TextRun SCXW31905946 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW31905946 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Understand automated deployment</span></span><span class="EOP SCXW31905946 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></span></span></span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW124783170 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW124783170 BCX8"><span class="TextRun SCXW68403130 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW68403130 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Apply patches and updates for hybrid and infrastructure as a service (IaaS) deployment</span></span></span></span></span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW111631536 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW111631536 BCX8"><span class="TextRun SCXW117113427 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW117113427 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Deploy hybrid SQL Server database solutions</span></span><span class="EOP SCXW117113427 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></span></span></span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW179632151 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW179632151 BCX8"><span class="TextRun SCXW244641383 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW244641383 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Recommend </span><span class="NormalTextRun SCXW244641383 BCX8" data-ccp-parastyle="Bullet level 1">an appropriate database</span><span class="NormalTextRun SCXW244641383 BCX8" data-ccp-parastyle="Bullet level 1"> offering based on specific requirements</span></span><span class="EOP SCXW244641383 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></span></span></span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW179632151 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="TextRun SCXW259837455 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW259837455 BCX8"><span class="TextRun SCXW151249815 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW151249815 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Evaluate the security aspects of the possible database offering</span></span></span></span></span></span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW179632151 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="TextRun SCXW259837455 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW259837455 BCX8"><span class="EOP SCXW151249815 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"><span class="TextRun SCXW70333713 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW70333713 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Recommend a table partitioning solution</span></span></span></span></span></span></span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW179632151 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="TextRun SCXW259837455 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW259837455 BCX8"><span class="EOP SCXW151249815 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"><span class="TextRun SCXW70333713 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="TextRun SCXW226011671 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW226011671 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Recommend a database </span><span class="NormalTextRun SpellingErrorV2Themed SCXW226011671 BCX8" data-ccp-parastyle="Bullet level 1">sharding</span><span class="NormalTextRun SCXW226011671 BCX8" data-ccp-parastyle="Bullet level 1"> solution</span></span><span class="EOP SCXW226011671 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></span></span></span></span></span></span></li>
</ul>
<p> </p>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW115790326 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW115790326 BCX8" data-ccp-parastyle="heading 2">Configure resources for scale and performance</span></span><span class="EOP SCXW115790326 BCX8" data-ccp-props="{"134233117":false,"134233118":false,"134245418":true,"134245529":true,"201341983":0,"335551550":1,"335551620":1,"335559685":0,"335559737":0,"335559738":40,"335559739":0,"335559740":259}"> </span> </span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto"><span class="TextRun SCXW87478839 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW87478839 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Configure Azure SQL Database for scale and performance</span></span><span class="EOP SCXW87478839 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></span><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto"><span class="TextRun SCXW84226783 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW84226783 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Configure Azure SQL Managed Instance for scale and performance</span></span></span><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto"><span class="TextRun SCXW177366994 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW177366994 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Configure SQL Server on Azure Virtual Machines for scale and performance</span></span><span class="EOP SCXW177366994 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></span><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto"><span class="TextRun SCXW219938013 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW219938013 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Configure table partitioning</span></span></span></li>
<li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto"><span class="EOP SCXW219938013 BCX8" data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"><span class="TextRun SCXW26313931 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW26313931 BCX8" data-ccp-parastyle="Bullet level 1" data-ccp-parastyle-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|110","ClassId":1073872969,"Properties":[469775450,"Bullet level 1",201340122,"2",134234082,"true",134233614,"true",469778129,"Bulletlevel1",335572020,"1",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",335559685,"720",335559991,"360",469777462,"1080",469777927,"0",469777928,"8",335559740,"259",201341983,"0",335559739,"40",469777929,"Bullet level 1 Char",469778324,"Normal"]}" data-ccp-parastyle-linked-defn="{"ObjectId":"e52b992c-f7c9-4a3c-ae67-e4452d3c4eef|114","ClassId":1073872969,"Properties":[469775450,"Bullet level 1 Char",201340122,"1",134233614,"true",469778129,"Bulletlevel1Char",335572020,"1",134231262,"true",201342447,"5",201342448,"1",469777841,"Segoe UI",469777842,"",469777843,"Calibri",469777844,"Segoe UI",469769226,"Segoe UI,Calibri",335551500,"0",469777929,"Bullet level 1",469778324,"Default Paragraph Font"]}">Configure data compression</span></span></span></span></li>
</ul>
<p> </p>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW64743200 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW64743200 BCX8" data-ccp-parastyle="heading 2">Plan and implement a migration strategy</span></span><span class="EOP SCXW64743200 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span> </span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="132" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Evaluate requirements for the migration</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="132" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Evaluate offline or online migration strategies</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="132" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Implement an online migration strategy</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="132" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Implement an offline migration strategy</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="132" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Perform post migration validations</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="132" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span data-contrast="none">Troubleshoot a migration</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="132" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Set up SQL Data Sync for Azure</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="132" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Implement a migration to Azure</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="132" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Implement a migration between Azure SQL services</span></li>
</ul>
<h3> </h3>
<h3><span class="TextRun SCXW70995127 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW70995127 BCX8" data-ccp-parastyle="heading 3">Implement a secure environment – 34 questions</span></span><span class="EOP SCXW70995127 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":120,"335559739":0,"335559740":240}"> </span></h3>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW93414897 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW93414897 BCX8" data-ccp-parastyle="heading 2">Configure database authentication and authorization</span></span><span class="EOP SCXW93414897 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span> </span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="133" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Configure Azure Active Directory (Azure AD) authentication and Active Directory authentication</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="133" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Create users from Azure AD identities</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="133" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Configure security principals</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="133" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Configure database and object-level permissions using graphical tools</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="133" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span data-contrast="none">Apply principle of least privilege for all securables</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="133" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Troubleshoot authentication and authorization issues</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="133" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Manage authentication and authorization by using T-SQL</span></li>
</ul>
<h4 aria-level="3"> </h4>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW189045301 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW189045301 BCX8" data-ccp-parastyle="heading 2">Implement security for data at rest and data in transit</span></span><span class="EOP SCXW189045301 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="134" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Implement transparent data encryption (TDE)</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="134" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Implement object-level encryption</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="134" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Configure server- and database-level firewall rules</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="134" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Implement Always Encrypted</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="134" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Configure secure access</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="134" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Configure Transport Layer Security (TLS)</span></li>
</ul>
<h4 aria-level="3"> </h4>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW237200081 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW237200081 BCX8" data-ccp-parastyle="heading 2">Implement compliance controls for sensitive data</span></span><span class="EOP SCXW237200081 BCX8" data-ccp-props="{"134233117":false,"134233118":false,"134245418":true,"134245529":true,"201341983":0,"335551550":1,"335551620":1,"335559685":0,"335559737":0,"335559738":40,"335559739":0,"335559740":259}"> </span> </span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="135" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Apply a data classification strategy</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="135" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Configure server and database audits</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="135" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Implement data change tracking</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="135" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Implement dynamic data masking</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="135" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span data-contrast="none">Manage database resources by using Azure Purview</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="135" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Implement Azure SQL Database ledger</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="135" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Implement row-level security</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="135" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Configure Advanced Threat Protection</span></li>
</ul>
<h3> </h3>
<h3><span class="TextRun SCXW186109269 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW186109269 BCX8" data-ccp-parastyle="heading 3">Monitor, configure, and </span><span class="NormalTextRun SCXW186109269 BCX8" data-ccp-parastyle="heading 3">optimize</span><span class="NormalTextRun SCXW186109269 BCX8" data-ccp-parastyle="heading 3"> database resources</span><span class="NormalTextRun SCXW186109269 BCX8" data-ccp-parastyle="heading 3"> – 38 questions</span></span><span class="EOP SCXW186109269 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":120,"335559739":0,"335559740":240}"> </span></h3>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW7101842 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW7101842 BCX8" data-ccp-parastyle="heading 2">Monitor resource activity and performance</span></span><span class="EOP SCXW7101842 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span> </span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="136" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Prepare an operational performance baseline</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="136" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Determine sources for performance metrics</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="136" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Interpret performance metrics</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="136" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Configure and monitor activity and performance</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="136" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span data-contrast="none">Monitor by using SQL Insights</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="136" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Monitor by using Extended Events</span></li>
</ul>
<h4 aria-level="3"> </h4>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW66684424 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW66684424 BCX8" data-ccp-parastyle="heading 2">Monitor and </span><span class="NormalTextRun SCXW66684424 BCX8" data-ccp-parastyle="heading 2">optimize</span><span class="NormalTextRun SCXW66684424 BCX8" data-ccp-parastyle="heading 2"> query performance</span></span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="137" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Configure Query Store </span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="137" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Monitor by using Query Store</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="137" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Identify sessions that cause blocking</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="137" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Identify performance issues using dynamic management views (DMVs)</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="137" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Identify and implement index changes for queries</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="137" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Recommend query construct modifications based on resource usage</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="137" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Assess the use of query hints for query performance</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="137" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span data-contrast="none">Review execution plans</span><span data-ccp-props="{"201341983":0,"335559739":40,"335559740":240,"469777462":[1080],"469777927":[0],"469777928":[8]}"> </span></li>
</ul>
<h4 aria-level="3"> </h4>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW266423351 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW266423351 BCX8" data-ccp-parastyle="heading 2">Configure database solutions for </span><span class="NormalTextRun SCXW266423351 BCX8" data-ccp-parastyle="heading 2">optimal</span><span class="NormalTextRun SCXW266423351 BCX8" data-ccp-parastyle="heading 2"> performance</span></span><span class="EOP SCXW266423351 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span> </span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="138" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Implement index maintenance tasks</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="138" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Implement statistics maintenance tasks</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="138" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Implement database integrity checks</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="138" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Configure database automatic tuning</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="138" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Configure server settings for performance</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="138" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Configure Resource Governor for performance</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="138" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Implement database-scoped configuration</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="138" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Configure compute and storage resources for scaling</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="138" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span data-contrast="none">Configure intelligent query processing (IQP)</span></li>
</ul>
<h3> </h3>
<h3><span class="TextRun SCXW186109269 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW186109269 BCX8" data-ccp-parastyle="heading 3"><span class="TextRun SCXW20218770 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW20218770 BCX8" data-ccp-parastyle="heading 3">C</span></span></span></span><span class="TextRun SCXW186109269 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW186109269 BCX8" data-ccp-parastyle="heading 3"><span class="TextRun SCXW20218770 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW20218770 BCX8" data-ccp-parastyle="heading 3">onfigure and manage automation of tasks</span><span class="NormalTextRun SCXW20218770 BCX8" data-ccp-parastyle="heading 3"> – 23 questions</span></span><span class="EOP SCXW20218770 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":120,"335559739":0,"335559740":240}"> </span></span></span></h3>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW153783307 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW153783307 BCX8" data-ccp-parastyle="heading 2">Create and manage SQL Server Agent jobs</span></span><span class="EOP SCXW153783307 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Describe the purpose of Azure Advisor</span><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Describe Azure Service Health</span><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Describe Azure Monitor, including Log Analytics, Azure Monitor alerts, and Application</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Manage schedules for regular maintenance jobs</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="139" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Configure job alerts and notifications</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="139" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Troubleshoot SQL Server Agent jobs</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="139" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Automate deployment of database resources</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="139" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Automate deployment by using Azure Resource Manager templates (ARM templates) and Bicep</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="139" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Automate deployment by using PowerShell</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="139" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Automate deployment by using Azure CLI</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="139" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span data-contrast="none">Monitor and troubleshoot deployments</span></li>
</ul>
<p> </p>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW153783307 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW153783307 BCX8" data-ccp-parastyle="heading 2"><span class="TextRun SCXW219682234 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW219682234 BCX8" data-ccp-parastyle="heading 2">Create and manage database tasks in Azure</span></span></span></span><span class="EOP SCXW153783307 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="140" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Create and configure elastic jobs</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="140" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Create and configure database tasks by using automation</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="140" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Automate database workflows by using Azure Logic Apps</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="140" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Configure alerts and notifications on database tasks</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="140" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Troubleshoot automated database tasks</span></li>
</ul>
<h3> </h3>
<h3><span class="TextRun SCXW186109269 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW186109269 BCX8" data-ccp-parastyle="heading 3"><span class="TextRun SCXW20218770 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW20218770 BCX8" data-ccp-parastyle="heading 3"><span class="TextRun SCXW239071492 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW239071492 BCX8" data-ccp-parastyle="heading 3">Plan and configure a high availability and disaster recovery (HA/DR) environment</span><span class="NormalTextRun SCXW239071492 BCX8" data-ccp-parastyle="heading 3"> – 31 questions</span></span><span class="EOP SCXW239071492 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":120,"335559739":0,"335559740":240}"> </span></span></span><span class="EOP SCXW20218770 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":120,"335559739":0,"335559740":240}"> </span></span></span></h3>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW153783307 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW153783307 BCX8" data-ccp-parastyle="heading 2"><span class="TextRun SCXW219682234 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW219682234 BCX8" data-ccp-parastyle="heading 2"><span class="TextRun SCXW9223579 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW9223579 BCX8" data-ccp-parastyle="heading 2">Recommend an HA/DR strategy for database solutions</span></span><span class="EOP SCXW9223579 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></span></span></span><span class="EOP SCXW153783307 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="141" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Recommend HA/DR strategy based on Recovery Point Objective/Recovery Time Objective (RPO/RTO) requirements</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="141" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Evaluate HA/DR for hybrid deployments</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="141" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Evaluate Azure-specific HA/DR solutions</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="141" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Recommend a testing procedure for an HA/DR solution</span></li>
</ul>
<h4 aria-level="3"> </h4>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW153783307 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW153783307 BCX8" data-ccp-parastyle="heading 2"><span class="TextRun SCXW219682234 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW219682234 BCX8" data-ccp-parastyle="heading 2"><span class="TextRun SCXW9223579 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW9223579 BCX8" data-ccp-parastyle="heading 2"><span class="TextRun SCXW151966918 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW151966918 BCX8" data-ccp-parastyle="heading 2">Plan and perform backup and restore of a database</span></span><span class="EOP SCXW151966918 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></span></span></span></span></span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="142" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Recommend a database backup and restore strategy</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="142" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Perform a database backup by using database tools</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="142" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Perform a database restore by using database tools</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="142" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Perform a database restore to a point in time</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="142" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Configure long-term backup retention</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="142" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Backup and restore a database by using T-SQL</span></li>
</ul>
<h4 aria-level="3"> </h4>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW153783307 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW153783307 BCX8" data-ccp-parastyle="heading 2"><span class="TextRun SCXW219682234 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW219682234 BCX8" data-ccp-parastyle="heading 2"><span class="TextRun SCXW9223579 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW9223579 BCX8" data-ccp-parastyle="heading 2"><span class="TextRun SCXW34804834 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW34804834 BCX8" data-ccp-parastyle="heading 2">Configure HA/DR for database solutions</span></span><span class="EOP SCXW34804834 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></span></span></span></span></span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="143" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Configure active geo-replication</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="143" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Configure an Always On availability group</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="143" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Configure auto-failover groups</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="143" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="none">Configure quorum options for a Windows Server Failover Cluster</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="143" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span data-contrast="none">Configure failover cluster instances on Azure Virtual Machines</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="143" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="none">Configure log shipping</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="143" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="none">Monitor an HA/DR solution</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="143" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="none">Troubleshoot an HA/DR solution</span></li>
</ul>
<p> </p>
<p><strong>Notes:</strong></p>
<ul style="font-weight: 400;">
<li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":360,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.</span><span data-ccp-props="{"201341983":0,"335559685":720,"335559739":0,"335559740":240}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":360,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.</span><span data-ccp-props="{"201341983":0,"335559685":720,"335559739":0,"335559740":240}"> </span></li>
</ul>
<p> </p>
<p> </p> <u><a target="_blank" href="https://docs.measureup.com/knowledgebase/system-requirements/">System Requirements</a></u>
https://www.measureup.com/media/catalog/product/m/i/microsoft_dp-300_pt_1.png
59.4
instock
99
59.4
40
39.6
Microsoft
1
5
1
https://www.measureup.com/media/catalog/product/m/i/microsoft_dp-300_pt_1.png
7617
/measureup
/measureup/Microsoft
/measureup/Microsoft/Microsoft Technical
/measureup/Microsoft/Microsoft Technical/Microsoft Practice Tests
2021-03-31T07:46:11+0000