Monitoring and Optimizing Operational Resources

• Implementation of maintenance tasks that are performance-related
  • Implementing index maintenance and statistics maintenance tasks
  • Database auto-tuning configuration
  • Storage capacity management
  • Performing automation for database maintenance tasks
• Identifying performance-related issues
  • Configuration of Query Store
  • Identifying sessions that can lead to blocking
  • Assessing fragmentation of logs and databases
  • Assessing configuration parameters related to database performance
• Monitoring performance and activity
  • Preparation of a working performance baseline
  • Determining performance metrics' sources
  • Interpretation of performance metrics
  • Assessing database performance using Intelligent Insights for Managed Instances and Azure SQL Database
  • Monitoring and configuring performance and activity at the server, infrastructure, service and database levels
• Configuring a user database
  • Implementation of database-scoped configuration
  • Configuring compute resources
  • Intelligent Query Processing (IQP) configuration
• Resource configuration for optimal performance
  • Infrastructure and storage resources
  • Server and service account settings
  • Configuration of Resource Governance for performance

Reference: https://learn.microsoft.com/en-us/credentials/certifications/azure-database-administrator-associate/?practice-assessment-type=certification

Secure Environment Implementation: 15-20%

• Implement Compliance Controls for Sensitive Data: This subject area will measure your competence in applying data classification strategies, configuring database & server audits, performing vulnerability assessments, and implementing data change tracking.
• Use Database Tools and Platform to Customize Database Authorization: The examinees need to demonstrate the ability to apply the principles of the least privilege of available securable and configure object-level permissions and database with the use of graphical tools.
• Apply Data at Rest Security: This domain covers one’s skills in implementing Dynamic Data Masking, object-level encryption, Transparent Data Encryption, and disk encryption for the Azure Virtual Machines & Azure Key Vault.
• Use Database Tools and Platform to Customize Database Authentication: This topic requires that the candidates demonstrate the ability to construct the users using Azure Active Directory identities as well as customize Azure Active Directory authentication and security principles.

Microsoft DP-300 Practice Test Questions, Microsoft DP-300 Exam Practice Test Questions

The Microsoft DP-300: Administering Relational Databases on Microsoft Azure exam is intended for the data management specialists and database administrators who want to validate their professional expertise. This test is a prerequisite option for the Microsoft Certified: Azure Database Administrator Associate certification.

Exam Details

Microsoft DP-300 may contain 40-60 questions and last for 180 minutes. This test evaluates the ability of the candidates to perform different technical tasks covering the exam topics. It includes the skills in planning and implementing resources for data platforms, implementing secure environments, and performing automation tasks, among others. The students can take the test in English, Korean, Japanese, or Simplified Chinese. To register, they must go through the Pearson VUE website and pay the fee of $165. The sum is for a single delivery of the exam. This means that those who do not pass the test will need to pay a new fee to retake the exam.

Microsoft DP-300日本語 Exam Syllabus Topics: