There is one assessment set and two practice exams to test your knowledge.
There are two types of questions on the examination:
Multiple choice: Has one correct response and three incorrect responses (distractors).
Multiple response: Has two or more correct responses out of five or more options. Select one or more responses that best complete the statement or answer the question. Distractors, or incorrect answers, are response options that an examinee with incomplete knowledge or skill would likely choose. However, they are generally plausible responses that fit in the content area defined by the test objective.
Unanswered questions are scored as incorrect; there is no penalty for guessing.
There are 5 domains being covered in this preparation kit and in the certification exam.
Domain 1: Workload-Specific Database Design
1.1 Select appropriate database services for specific types of data and workloads
1.2 Determine strategies for disaster recovery and high availability
1.3 Design database solutions for performance, compliance, and scalability
1.4 Compare the costs of database solutions
Domain 2: Deployment and Migration
2.1 Automate database solution deployments
2.2 Determine data preparation and migration strategies
2.3 Execute and validate data migration
Domain 3: Management and Operations
3.1 Determine maintenance tasks and processes
3.2 Determine backup and restore strategies
3.3 Manage the operational environment of a database solution
Domain 4: Monitoring and Troubleshooting
4.1 Determine monitoring and alerting strategies
4.2 Troubleshoot and resolve common database issues
4.3 Optimize database performance
Domain 5: Database Security
5.1 Encrypt data at rest and in transit
5.2 Evaluate auditing solutions
5.3 Determine access control and authentication mechanisms
5.4 Recognize potential security vulnerabilities within database solutions