MySQL 1Z0-908 Sample Questions with Explanations

These original sample questions are designed to help you check how the exam topics appear in decision-style prompts. They are not taken from the live exam.

Use these sample questions as a guided self-assessment for MySQL 8.0 Database Administrator (1Z0-908) topics such as backup choice, binary logs, replication safety, account privileges, configuration, monitoring, and recovery planning. The prompts focus on operational judgment, not memorizing isolated commands.

Where these questions fit in the 1Z0-908 guide

The sample set below is part of the Oracle MySQL 1Z0-908 guide path:

• Oracle certification hub
• Oracle MySQL guides
• 1Z0-908 exam guide
• 1Z0-908 cheat sheet
• 1Z0-908 study plan
• 1Z0-908 FAQ
• 1Z0-908 resources
• 1Z0-908 glossary

1Z0-908 MySQL DBA sample questions

Work through each prompt before opening the explanation. For DBA questions, start with recoverability, safety, and the least risky operational path.

Question 1

Topic: Point-in-time recovery requirement

A database is backed up every night. The business asks whether it can recover to 10:17 a.m. after an accidental data change at 10:20 a.m. What must be available in addition to a usable backup?

• A. The binary logs covering the time after the backup and before the target recovery point.
• B. A larger InnoDB buffer pool at the time of restore.
• C. A user account with only SELECT privileges.
• D. A replica that has already applied the accidental change.

Best answer: A

Explanation: Point-in-time recovery uses a backup plus binary log events replayed up to the target time or position. Without the relevant binary logs, the restore can only reach the backup point.

Why the other choices are weaker:

• B may affect performance but does not provide missing transaction history.
• C is insufficient for restore and recovery operations.
• D may already contain the bad change and does not replace controlled log replay.

What this tests: Backup strategy, binary log purpose, and RPO-aware recovery planning.

Related topics: Backup; Binary logs; Point-in-time recovery; RPO

Question 2

Topic: Least privilege for maintenance

A monitoring tool needs to read server status and performance information but must not modify application data. Which approach best matches the security goal?

• A. Use the administrative account so the tool never fails because of permissions.
• B. Create a dedicated monitoring account with only the privileges needed to read diagnostic information.
• C. Give the application account extra privileges and reuse it for monitoring.
• D. Disable authentication for the monitoring endpoint on the database host.

Best answer: B

Explanation: A dedicated low-privilege account limits blast radius and keeps monitoring separate from application or administrative access.

Why the other choices are weaker:

• A over-privileges an automated tool.
• C mixes operational duties with application access and makes auditing harder.
• D removes an essential access control instead of designing the right one.

What this tests: Least privilege, account separation, and operational security judgment.

Related topics: Privileges; Monitoring; Security; Accounts

Question 3

Topic: Replication lag response

A read replica is lagging during a reporting workload. The application requires fresh reads for payment status but can tolerate stale reads for dashboard charts. What is the safest routing choice?

• A. Route all reads to the lagging replica to protect the primary.
• B. Route payment-status reads to the primary and dashboard reads to the replica while investigating the lag.
• C. Stop binary logging on the primary until the replica catches up.
• D. Promote the replica immediately without checking transaction position.

Best answer: B

Explanation: Freshness requirements should drive read routing. Critical reads that cannot tolerate stale data should use the primary, while tolerant dashboard reads can continue using the replica during investigation.

Why the other choices are weaker:

• A ignores consistency requirements for payment status.
• C breaks replication/recovery assumptions and is not a safe lag fix.
• D risks data loss or inconsistency if promotion is not controlled.

What this tests: Replication lag, read consistency, failover caution, and operational tradeoffs.

Related topics: Replication; Read routing; Consistency; Failover

Independent study note

Tech Exam Lexicon and IT Mastery are independent study tools. They are not affiliated with, endorsed by, or sponsored by Oracle or any certification body.