1z0-908 practice test

1. Question 1 · 1

   Examine this statement, which executes successfully: You want to improve the performance of this query: Which change enables the query to succeed while accessing fewer rows?

   Choose one answer.

   

   

   • ALTER TABLE world.city ADD SPATIAL INDEX (Name);
   • ALTER TABLE world.city ADD SPATIAL INDEX (Population);
   • ALTER TABLE world.city ADD INDEX (Population);
   • ALTER TABLE world.city ADD INDEX (Name);
   • ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
   • ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

2. Question 2 · 1

   You wish to protect your MySQL database against SQL injection attacks. Which method would fail to do this?

   Choose one answer.

   • installing and configuring the Connection Control plugin
   • avoiding concatenation of SQL statements and user-supplied values in an application
   • using stored procedures for any database access
   • using PREPARED STATEMENTS

3. Question 3 · 1

   The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000 The minimum and maximum delays need to be increased to 3000 and 5000, respectively. A command is executed: mysql> SET GLOBAL connection_control_min_connection_delay=3000; What is the result?

   Choose one answer.

   • The minimum value increases to 3000 and the maximum value increases to 4000.
   • Only the minimum connection value is increased to 3000.
   • The minimum connection value is changed to 2000.
   • An error is returned.

4. Question 4 · 1

   Four nodes are configured to use circular replication. Examine these configuration parameters for each node: Which statement is true?

   Choose one answer.

   

   • Each slave thread is responsible for updating a specific database.
   • Cross-database constraints can cause database inconsistency.
   • Increasing slave_parallel_workers will improve high availability.
   • Setting slave_preserve_commit_order to on will improve data consistency.
   • Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
   • Setting transaction_allow_batching to on will improve data consistency.

5. Question 5 · 1

   Examine this command and output: Which statement is true?

   Choose one answer.

   

   • Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.
   • Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
   • Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.
   • Firewall_access_granted is the number of connections granted from whitelisted hosts.

6. Question 6 · 1

   What is the correct syntax for using transparent data encryption with an existing InnoDB table?

   Choose one answer.

   • ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';
   • ALTER TABLE t1 ENCRYPTION='Y';
   • ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;
   • ALTER TABLE t1 SET TDE = 'ON';

7. Question 7 · 1

   Examine this command, which executes successfully: Which statement is true?

   Choose one answer.

   

   • Only files for MySQL or Its built-in storage engines are backed
   • Only non-encrypted files are backed up.
   • The backup includes only data files and their metadata.
   • Only InnoDB data and log files are backed up.
   • Only tables stored in their own tablespaces are backed up.

8. Question 8 · 1

   How can mysql_multi be configured to allow MySQL instances to use the same port number?

   Choose one answer.

   • The instances use different user accounts unique to each instance.
   • The instances listen on different IP addresses.
   • The instances use different socket names.
   • The instances have appropriate net masks set.

9. Question 9 · 1

   What does the slave I/O thread do?

   Choose one answer.

   • connects to the master and requests it to send updates recorded in its binary logs
   • monitors and schedules I/O calls to the subsystem for the relay logs
   • acquires a lock on the binary log for reading each event to be sent to the slave
   • reads the relay log and executes the events contained in them

10. Question 10 · 1

    You have an installation of MySQL 8 on Oracle Linux. Consider the outputs: Which statement is true about disk temporary tables for this installation?

    Choose one answer.

    

    • Only internal temporary tables from the optimizer will be created in tmpdir.
    • Temporary tables will use the InnoDB temporary tablespace located in datadir.
    • Temporary tables are created in tmpdir only if configured to use MyISAM.
    • Temporary tables are created in tmpdir only after they reach tmp_tabie_size.
    • Temporary tables will use the InnoDB temporary tablespace located in /tmp.

11. Question 11 · 1

    Which three are requirements for a secure MySQL Server environment? (Choose three.)

    Choose all answers that apply.

    • Restrict the number of OS users that have access at the OS level.
    • Ensure appropriate file system privileges for OS users and groups.
    • Minimize the number of non-MySQL Server-related processes running on the server host.
    • Encrypt the file system to avoid needing exact file-system permissions.
    • Keep the entire software stack on one OS host.
    • Run MySQL server as the root user to prevent incorrect sudo settings.

12. Question 12 · 1

    Examine this parameter setting: audit_log=FORCE_LOG_PERMANENT What effect does this have on auditing?

    Choose one answer.

    • It will force the load of the audit plugin even in case of errors at server start.
    • It causes the audit log to be created if it does not exist.
    • It prevents the audit plugin from being removed from the running server.
    • It prevents the audit log from being removed or rotated.

13. Question 13 · 1

    Examine this snippet from the binary log file named binlog.000036: The rental table was accidentally dropped, and you must recover the table. You have restored the last backup, which corresponds to the start of the binlog.000036 binary log. Which command will complete the recovery?

    Choose one answer.

    

    • mysqlbinlog --stop-position=500324 binlog.000036 | mysql
    • mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql
    • mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql
    • mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql

14. Question 14 · 1

    Examine these entries from the general query log: All UPDATE statements reference existing rows. Which describes the outcome of the sequence of statements?

    Choose one answer.

    

    • Connection 24 experiences a lock wait timeout.
    • Connection 25 experiences a lock wait timeout.
    • A deadlock occurs immediately.
    • All statements execute without error.
    • A deadlock occurs after innodb_lock_wait_timeout seconds.

15. Question 15 · 1

    A clean shutdown was performed with innodb_fast_shutdown=0. While you were manipulating files, all files were accidentally deleted from the top-level data directory. Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

    Choose all answers that apply.

    • ibtmp1
    • undo_001
    • ib_buffer_pool
    • ibdata1
    • mysql.ibd
    • ib_logfile0

Paid access to all 79 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.