ExamDumpster

Free 1Z0-908 sample questions

The free 1Z0-908 sample questions below cover MySQL 8.0 administration, with answers and explanations. They test roles and privileges, backups and replication. Try each one before you read the explanation, then note the topics to revisit.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 10 of 20 free sample questions.

Question 1Choose one

A new DBA is creating their first backup strategy. The requirements are a Recovery Point Objective (RPO) of 15 minutes and a Recovery Time Objective (RTO) of 1 hour. The database is 500GB and moderately busy. Which combination of backup methods best satisfies these requirements?

Question 2Choose one

You are migrating a legacy application from MySQL 5.7 to MySQL 8.0. The application code frequently queries the `information_schema.tables` view to get row counts for MyISAM tables. After the migration, the developers report that these queries are now significantly slower. What is the reason for this performance degradation?

Question 3Choose one

A DBA needs to test the impact of removing an index (`idx_old_filter`) from a large production table without causing downtime or permanently dropping it. The goal is to make the index unusable by the query optimizer for all sessions to evaluate the performance impact on the application's workload. Which command should be used?

Question 4Choose one

A government agency is setting up a MySQL 8.0 server for archival purposes. A strict security policy requires that all administrative actions, connections, and data modifications on a specific sensitive database (`archive_db`) be logged for auditing. However, to save space and reduce noise, read-only queries (`SELECT`) should not be logged. Which MySQL Enterprise feature is best suited for this requirement?

Question 5Choose one

A new MySQL instance is being configured on a host with 128GB of RAM, dedicated solely to the database. The primary workload consists of complex analytical queries on a 100GB InnoDB dataset. Following best practices, what would be an appropriate initial setting for `innodb_buffer_pool_size`?

Question 6Choose 2

You are configuring a new user account for an automated application that only needs to execute stored procedures within a specific database, `app_db`. The application should not have any other privileges. Which TWO grants would achieve this following the principle of least privilege? (Select TWO).

Question 7Choose one

You need to perform an in-place upgrade of a MySQL 5.7 instance to 8.0. Before starting the MySQL 8.0 binary, what is the most critical preparatory step to ensure the upgrade process is as smooth as possible?

Question 8Choose one

An administrator is setting up multisource replication where a single replica server will aggregate data from two different source servers (Source A and Source B). The administrator has successfully configured the channel for Source A. Which command is used to configure the connection details for the second source, Source B?

Question 9Choose one

You are troubleshooting a deadlock issue in a high-concurrency application. You have enabled the `innodb_status_output` and `innodb_status_output_locks` variables to get detailed information in the error log. After capturing a deadlock event, you examine the `LATEST DETECTED DEADLOCK` section. What information is most crucial for identifying the root cause of the deadlock?

Question 10Choose one

A DBA is performing a health check on a production MySQL 8.0 server. They want to identify any indexes that have not been used since the last server restart or statistics reset to reclaim storage space and reduce maintenance overhead. Which `performance_schema` table should be queried to find this information? flowchart TD Start([Start]) --> Query{Query P_S Table} Query --> |Find Unused Indexes| Analyze[Analyze Impact] Analyze --> Drop[Drop Unused Index] Query --> |No Unused Indexes| Monitor[Continue Monitoring] Drop --> Monitor Monitor --> End([End])

10 more free samples are waiting

Create a free account to unlock the whole 1Z0-908 sample bank, or get full access to all 358 practice questions in the simulator.

Create account