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 Apr. 18, 2024
You have an instance of SQL Server on Azure Virtual Machines named VM1.
You need to implement a disaster recovery solution that meets the following requirements:
* Returns the solution to an operational state within 15 minutes of a failure
* Can perform disaster recovery testing in an isolated environment
* Minimizes administrative effort
What should you include in the solution?
You have an Azure subscription.
You create a logical SQL server that hosts four databases Each database will be used by a separate customer.
You need to ensure that each customer can access only its own database. The solution must minimize administrative effort
Which two actions should you perform? Each correct answer presents part of the solution
NOTE: Each correct selection is worth one point.
You Save an Azure SCX database named DB1.
You need to query the fragmentation information of data and indexes for the tables in D61.
Which command should you run?
A.
B.
C.
D.
You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication. You need to migrate SQL1 to Azure. Which service should you use?
You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL database named SQLDB1.
You need to replicate DB1 to SQlDC1.
Which type of replication should you use?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Currently there are no comments in this discussion, be the first to comment!