MicrosoftDP 300Exam
EDUSUM.COM GetcompletedetailonDP 300examguidetocrackAdministeringRelationalDatabaseson MicrosoftAzure.YoucancollectallinformationonDP 300tutorial,practicetest,books,study material,examquestions,andsyllabus.FirmyourknowledgeonAdministeringRelational DatabasesonMicrosoftAzureandgetreadytocrackDP 300certification.Exploreallinformation onDP 300examwithnumberofquestions,passingpercentageandtimedurationtocompletetest.
QUESTIONSSAMPLE
MICROSOFT DP-300 CERTIFICATION SYLLABUS AND CERTIFICATION
WWW.EDUSUM.COM PDF DP 300: Administering Relational Databases on Microsoft Azure 1 Introduction to Microsoft CertifiedAzure Database Administrator Associate Exam The Microsoft DP 300 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the Administering Relational Databases on Azure certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. This study guide for the Administering Relational Databases on Microsoft Azure will help guide you through the study process for your certification.
WWW.EDUSUM.COM PDF DP 300: Administering Relational Databases on Microsoft Azure 2 DP-300 Administering Relational Databases on Microsoft Azure Exam Summary ● Exam Name: Administering Relational Databases on Microsoft Azure ● Exam Code: DP 300 ● Exam Price: $165 (USD) ● Duration: 120 mins ● Number of Questions: 40 60 ● Passing Score: 700 / 1000 ● Reference Books: DP-300T00-A: Administering Relational Databases on Microsoft Azure ● Schedule Exam: Pearson VUE ● Sample Questions: Microsoft Administering Relational Databases on Azure Sample Questions ● Recommended Practice: Microsoft DP-300 Certification Practice Exam Exam Syllabus: DP-300 Microsoft CertifiedAzure Database Administrator Associate Topic Details Plan and Implement Data Platform Resources (20-25%) Plan and deploy Azure SQL Database solutions Deploy database offerings on selected platforms Understand automated deployment Apply patches and updates for hybrid and infrastructure as a service (IaaS) deployment Deploy hybrid SQL Server database solutions Recommend an appropriate database offering based on specificEvaluaterequirementsthesecurity aspects of the possible database offeringRecommend a table partitioning solution Recommend a database sharding solution Configure resources for scale and performance Configure Azure SQL Database for scale and -performanceConfigureAzure SQL Managed Instance for scale and performance
WWW.EDUSUM.COM PDF DP 300: Administering Relational Databases on Microsoft Azure 3 Topic Details - Configure SQL Server on Azure Virtual Machines for scale and ConfigureConfigureperformancetablepartitioningdatacompression Plan and implement a migration strategy Evaluate requirements for the migration Evaluate offline or online migration strategies Implement an online migration strategy Implement an offline migration strategy Perform post migration validations Troubleshoot a migration Set up SQL Data Sync for Azure Implement a migration to Azure Implement a migration between Azure SQL services Implement a Secure Environment (15-20%) Configure authorizationauthenticationdatabaseand Configure Azure Active Directory (Azure AD) authentication and Active Directory authentication Create users from Azure AD identities Configure security principals Configure database and object level permissions using graphical tools Apply principle of least privilege for all securables Troubleshoot authentication and authorization issues Manage authentication and authorization by using T SQL Implement security for data at rest and data in transit implement Transparent Data Encryption (TDE) implement object level encryption - Configure server- and database-level firewall rules - Implement Always Encrypted - Configure secure access - Configure Transport Layer Security (TLS) Implement compliance controls for sensitive data - Apply a data classification strategy - Configure server and database audits - Implement data change tracking - Implement dynamic data masking - Manage database resources by using Azure Purview - Implement Azure SQL Database ledger
WWW.EDUSUM.COM PDF DP 300: Administering Relational Databases on Microsoft Azure 4 Topic Details - Implement row-level security Configure Advanced Threat Protection Monitor, configure, and optimize database Resources (20-25%) Monitor resource activity and performance - Prepare an operational performance baseline - Determine sources for performance metrics - Interpret performance metrics - Configure and monitor activity and performance Monitor by using SQL Insights Monitor by using Extended Events Monitor and optimize query performance Configure Query Store Monitor by using Query Store Identify sessions that cause blocking Identify performance issues using dynamic management viewsIdentify(DMVs)andimplement index changes for queries Recommend query construct modifications based on resource usage Assess the use of query hints for query performance Review execution plans Configure database solutions for performanceoptimal Implement index maintenance tasks Implement statistics maintenance tasks Implement database integrity checks Configure database automatic tuning Configure server settings for performance Configure Resource Governor for performance Implement database scoped configuration - Configure compute and storage resources for scaling - Configure intelligent query processing (IQP) Configure and manage automation of tasks (15-20%) Create and manage SQL Server Agent jobs Manage schedules for regular maintenance jobs Configure job alerts and notifications Troubleshoot SQL Server Agent jobs Automate deployment of database resources Automate deployment by using Azure Resource Manager templates (ARM templates) and Bicep Automate deployment by using PowerShell
WWW.EDUSUM.COM PDF DP 300: Administering Relational Databases on Microsoft Azure 5 Topic Details - Automate deployment by using Azure CLI Monitor and troubleshoot deployments Create and manage database tasks in Azure Create and configure elastic jobs Create and configure database tasks by using automationAutomate database workflows by using Azure Logic AppsConfigure alerts and notifications on database tasks Troubleshoot automated database tasks Plan and configure a high availability and disaster recovery (HA/DR) environment (20-25%) Recommend an HA/DR strategy for database solutions - Recommend HA/DR strategy based on Recovery Point Objective/Recovery Time Objective (RPO/RTO) -requirementsEvaluateHA/DR for hybrid deployments - Evaluate Azure-specific HA/DR solutions - Recommend a testing procedure for an HA/DR solution Plan and perform backup and restore of a database - Recommend a database backup and restore strategy Perform a database backup by using database tools Perform a database restore by using database tools Perform a database restore to a point in time Configure long term backup retention Backup and restore a database by using T SQL Configure HA/DR for database solutions Configure active geo replication Configure an Always On availability group Configure auto failover groups Configure quorum options for a Windows Server Failover ClusterConfigure failover cluster instances on Azure Virtual MachinesConfigure log shipping Monitor an HA/DR solution Troubleshoot an HA/DR solution
WWW.EDUSUM.COM PDF DP 300: Administering Relational Databases on Microsoft Azure 6 Microsoft DP-300 Certification Sample Questions and Answers To make you familiar with Administering Relational Databases on Microsoft Azure (DP 300) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for Administering Relational Databases on Azure DP-300 Certification to test your understanding of Microsoft DP 300process with real Microsoft certification exam environment.
DP-300 Administering Relational Databases on Microsoft Azure Sample 01. You are training a new administrator for your company's Azure data services, which includes database deployed on Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure virtual machines (VMs). You need to identify the fixed roles that are supported by Azure SQL Database only. Which two fixed roles are available with Azure SQL Database only? Each correct answer presents a complete solution.
Questions:-
a) locally-redundant storage (LRS) b) read-access geo-redundant storage (RA-GRS) c) zone-redundant storage (ZRS) d) geo-redundant storage 03. You have a new Azure SQL database. The database contains a column that stores confidential information.
a) db_securityadmin b) sysadmin c) dbmanager d) dbcreator e) loginmanager 02. You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine. In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs. Which type of storage accounts should you use for the backups?
Each correct answer presents part of the solution
WWW.EDUSUM.COM PDF DP 300: Administering Relational Databases on Microsoft Azure 7 You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was Whichexecuted.three actions should you perform? Each correct answer presents part of the solution. a) Turn on auditing and write audit logs to an Azure Storage account b) Add extended properties to the column. c) Turn on Advanced Data Security for the Azure SQL server d) Apply sensitivity labels named Highly Confidential to the column. e) Turn on Azure Advanced Threat Protection (ATP). 04. You receive numerous alerts from Azure Monitor for an Azure SQL database. You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period. Which two actions should you perform? Each correct answer presents part of the solution.
a) server audit specification b) SQL Server audit c) database audit specification
options
b)
a) Analyze an actual execution plan. Display an actual execution plan.
a) Set Threshold Sensitivity to High Set the Alert logic threshold to Dynamic c) Set the Alert logic threshold to Static d) Set Threshold Sensitivity to Low e) Set Force Plan to On 05. You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII. You need to record whenever users query the CustomerPII table. Which two should you enable?
b)
d) a server principal 06. MyDB1 is an Azure SQL on Azure virtual machine (VM) database. You identify a long-running query. You want to determine where the operation in the query is causing performance problems. You need to use SQL Server Management Studio (SSMS) to view the execution plan based on runtime information so you can try query variations in real time. What should you use?
c) an Azure SQL Database managed instance
d) Azure SQL databases
09. You have a version-8.0 Azure Database for MySQL database. You need to identify which database queries consume the most resources. Which tool should you use? a) Query Store b) Metrics c) Query Performance Insight d) Alerts
07. You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instance. What should you use to minimize downtime and data loss during the migration?
b) SQL Server on Azure virtual machines
c) Display an estimated execution plan. d) Compare execution plans.
10. You provision an Azure SQL Managed Instance database named MyDevData. The database will be used by in-house development for application development DevSupportprojects. custom database role members will use dynamic management views (DMVs) to retrieve performance and health information about MyDevData. You need to ensure that DevSupport members can view information through DMVs. Which statement should you use? Each correct answer presents part of the solution.
08. You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?
DP 300: Administering Relational Databases on Microsoft Azure 8
c) GRANT VIEW DEFINITION TO DevSupport d) GRANT VIEW REFERENCES TO DevSupport
a) GRANT VIEW DATABASE STATE TO DevSupport b) GRANT VIEW SERVER STATE TO DevSupport
a) An Azure SQL Database elastic pool
WWW.EDUSUM.COM PDF
a) distributed availability groups b) database mirroring c) log shipping d) Database Migration Assistant
WWW.EDUSUM.COM PDF DP 300: Administering Relational Databases on Microsoft Azure 9 Answers:Answer 01:- e Answer 02:- b Answer 03:- a, c, d Answer 04:- b, d Answer 05:- a, c Answer 06:- b Answer 07:- a Answer 08:- a Answer 09:- a Answer 10:- a