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. 25, 2024
You have two Azure virtual machines named Server 1 and Server2 that run Windows Server 2022 and are joined to an Active Directory Domain Services (AD DS) domain named contoso.com.
Both virtual machines have a default instance of Microsoft SQL Server 2019 installed. Server1 is configured as a master server, and Server2 is configured as a target server.
On Server1, you create a proxy account named contoso\sqlproxy.
You need to ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
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 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.
- 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!