Free Preparation Discussions
MENU
Microsoft DP-300 Exam
- Topic 1: Configure database authentication by using platform and database tools/ Deploy resources by using manual methods
- Topic 2: Plan and Implement a High Availability and Disaster Recovery (HADR) Environment/ Apply patches and updates for hybrid and IaaS deployment
- Topic 3: Evaluate the security aspects of the possible database offering/ Prepare an operational performance baseline
- Topic 4: Recommend an appropriate database offering based on specific requirements/ Identify and implement index changes for queries
- Topic 5: Recommend an HADR strategy for a data platform solution/ Evaluate the functional benefits/impact of possible database offerings
- Topic 6: Manage schedules for regular maintenance jobs/ Deploy database offerings on selected platforms/ Plan and Implement Data Platform Resources
- Topic 7: Configure database and object-level permissions using graphical tools/ Apply principle of least privilege for all securables
- Topic 8: Determine the appropriate Dynamic Management Views (DMVs) to gather query performance information/ Evaluate the HA/DR of the possible database offering
- Topic 9: Configure multi-server automation/ Configure customized deployment templates/ Evaluate the scalability of the possible database offering
- Topic 10: Automate database maintenance tasks/ Configure database authorization by using platform and database tools
- Topic 11: Extract query plans from the Query StoreEvaluate performance improvements/ Assess database performance by using Azure SQL Database Intelligent Performance
- Topic 12: Recommend query construct modifications based on resource usage/ determine sources for performance metrics
Free Microsoft DP-300 Exam Actual Questions
The questions for DP-300 were last updated On May. 27, 2023
You have an Azure subscription.
Vou need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:
* Minimize how long it takes to fail over.
* Maintain existing connections to the primary replica during a failover.
What should you do?
You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements:
* Support real-time data replication to a different geographic region.
* Use Azure as a disaster recovery target.
* Minimize costs and administrative effort.
What should you include in the recommendation?
You have an Azure subscription.
You need to deploy an Azure SQL database. The solution must meet the following requirements:
* Dynamically scale CPU resources.
* Ensure that the database can be paused to reduce costs.
What should you use?
You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements:
* Support real-time data replication to a different geographic region.
* Use Azure as a disaster recovery target.
* Minimize costs and administrative effort.
What should you include in the recommendation?
You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1 and an Azure Storage account named storage1.
You need to ensure that you can back up db1 to storage1. The solution must meet the following requirements:
* Use block blob storage.
* Maximize security.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Submit Cancel