Exam DP-300: Administering Relational Databases on Microsoft Azure
| Exam Number: DP-300 | Length of test: 120 mins |
| Exam Name: Administering Relational Databases on Microsoft Azure | Number of questions in the actual exam: 40-60 |
| Format: PDF, VPLUS | Passing Score: 700/1000 |
|
Total Questions: 342 $30 Premium PDF file 2 months updates Last updated: November-2024 |
Total Questions: 342 FREE Premium VPLUS file Last updated: November-2024 |
Download practice test questions
| Title | Size | Hits | Download |
|---|---|---|---|
| Microsoft.DP-300.vSep-2024.by.Oshinomo.144q | 4.88 MB | 32 | Download |
| Microsoft.DP-300.vSep-2024.by.Oshinomo.144q | 6.75 MB | 23 | Download |
| Microsoft.DP-300.vJul-2024.by.Odin.189q | 7.21 MB | 54 | Download |
| Microsoft.DP-300.vJul-2024.by.Odin.189q | 13.53 MB | 47 | Download |
| Microsoft.DP-300.vJan-2024.by.Ricky.112q | 6.11 MB | 60 | Download |
Study guide for Exam DP-300: Administering Microsoft Azure SQL Solutions
Audience profile
As a candidate for this exam, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with:
- SQL Server on-premises
- Azure SQL services
You’re a database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services.
As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes.
You’re responsible for the following concerning database solutions:
- Management
- Availability
- Security
- Performance monitoring and optimization
You evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions.
As a candidate for this exam, you should have knowledge of and experience with:
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure Virtual Machines (Windows and Linux)
Skills at a glance
Plan and implement data platform resources (20–25%)
- Plan and deploy Azure SQL solutions
- Configure resources for scale and performance
- Plan and implement a migration strategy
Implement a secure environment (15–20%)
- Implement security for data at rest and data in transit
- Implement compliance controls for sensitive data
Monitor, configure, and optimize database resources (20–25%)
- Monitor resource activity and performance
- Monitor and optimize query performance
- Configure database solutions for optimal performance
Configure and manage automation of tasks (15–20%)
- Create and manage SQL Server Agent jobs
- Automate deployment of database resources
- Create and manage database tasks in Azure
Plan and configure a high availability and disaster recovery (HA/DR) environment (20–25%)
- Recommend an HA/DR strategy for database solutions
- Plan and perform backup and restore of a database
- Configure HA/DR for database solutions
Some new questions:
Q
You have 25 Azure SQL databases.
You need to implement a centralized database management solution that uses Transact-SQL What should you include in the solution?
A. elastic jobs
B. an Azure Automation runbook
C. Azure Functions
D. Azure Logic Apps
Q
HOTSPOT
You have an Azure virtual machine named Server1 that has Microsoft SQL Server installed. Server1 contains a database named DB1.
You have a logical SQL server named ASVR1 that contains an Azure SQL database named ADB1.
You plan to use SQL Data Sync to migrate DB1 from Server! to ASVR1.
You need to prepare the environment for the migration. The solution must ensure that the connection from Server1 to ADB1 does NOT use a public endpoint.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
…….
Some new questions:
Q
You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1.
You need to configure SQL1 to use mixed mode authentication.
Which procedure should you run?
A. sp_eddremotelogin
B. xp_grant_login
C. sp_change_users_login
D. xp_instance_regwrite
Q
You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines.
You plan to implement a disaster recovery solution.
You need to be able to perform disaster recovery drills regularly. The solution must meet the following requirements:
* Minimize administrative effort for the recovery drills.
* Isolate the recovery environment from the production environment.
What should you use?
A. Recovery Services vaults
B. Azure Site Recovery
C. Azure Backup
D. native Microsoft SQL Server backup
Q
You have an Azure subscription that contains an Azure SQL database named db1.
You need to implement SQL insights for db1.
Which two resources should you create first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
A. an Azure logic app
B. a virtual machine
C. an Azure function
D. a Log Analytics workspace
E. a storage account
Q
You need to recommend a process to automate the management of DB3. The solution must meet the management requirements. What should be the first step of the process?
A. Configure Microsoft Entra authentication for the logical server that hosts DB3.
B. Create a database that has database-scoped credentials.
C. Configure a private endpoint for connectivity to DB3.
D. Create data base-scoped credentials in DB3.
………