MySQL 8.0 Database Administrator

1Z0-071 Oracle Database Administration - MySQL Operations

This exam assesses a candidate"s skills in designing, building, maintain and optimize the MySQL databases, also covering data protection, security and fine-grained controls.

Focus

The MySQL 8.0 Database Administrator certification focuses on MySQL Database Administration

Exam Duration

The MySQL 8.0 Database Administrator exam duration is 120 minutes

Num of Question

The exam contains a total of 44

Exam Fee

The exam fee is $245 USD (Discounted rate $145 for Oracle Certified Professionals).

Exam Validity

The CCRN-Pediatric certification is valid for 3 years.

Prior Certification

• No specific prior certification is required

Exam Format

The MySQL 8.0 Database Administrator exam is a Multiple-choice questions

Passing Conditions

To pass MySQL 8.0 Database Administrator exam, applicants must achieve a minimum score of Pass the exam by scoring 62%, you will get 27/44 questions correct.

Who Should Take

Database Administrators, System Administrators, and Data Analysts working with MySQL database.

• MySQL Database Administrator
• System Administrator
• Data Analyst

Prerequisites

No specific work experience is required for taking this exam.

Or can substitute with certifications:

• 1Z0-007: Oracle Systems Technical Associate, Java programming - Associate
• 1Z0-076: Oracle Database 19c, MySQL Development and Administration Associate

Certification Process

• Step 1: Prepare for the exam, by using Oracle University course materials, online tutorials, or training provided by Oracle-approved partners.
• Step 2: Schedule the exam.

Domains with Weights

• Domain 3: Security (14%): Implement data protection, manage fine-grained controls. covers Data encryption, Access control, Auditing and compliance (14%).
• Domain 2: Data Protection and Recovery (14%): Manage and recover data, covers backups and recovery, data import/export and encryption (14%).
• Domain 1: MySQL Operations (35%): Administer database, covers database instance configuration, Manage database performance, Troubleshoot issues (35%).
• Domain 4: Performance, Scalability, and Extensibility (PSE) (37%): Optimize database performance, covers query tuning, indexing, and partitioning, (37%).