Free MySQL 8.0 Database Administrator Exam 1Z0-908 Exam Practice Test

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

• 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

User account baduser@hostname on your MySQL instance has been compromised.Which two commands stop any new connections using the compromised account? (Choose two.)

• ALTER USER baduser@hostname PASSWORD DISABLED;
• ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
• ALTER USER baduser@hostname ACCOUNT LOCK;
• ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
• ALTER USER baduser@hostname DEFAULT ROLE NONE;

You are backing up raw InnoDB files by using mysqlbackup.Which two groups of files will be backed up during a full backup? (Choose two.)

• ibbackup files
• *.CSM files
• *.sdi files
• *.ibd files
• ib_logfile* files

Which three actions are effective in capacity planning? (Choose three.)

• buying more RAM
• monitoring OS resources for patterns
• adding circular replication nodes for increased DML capability
• buying more CPU
• buying more disk
• basing expected growth on an average of the last 3 years
• consulting the application team about any future projects and use
• upgrading to the latest application version

You have an InnoDB Cluster configured with three servers.Examine this command, which executes successfully:mysqldump -uroot -p -d mydatabase > mydatabase_backup.sqlDue to data loss, the cluster is initialized and a restore is attempted resulting in this error:ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin runningWhich two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

• Stop all instances except the primary read/write master instance and run the restore.
• Remove the @@GLOBAL.gtid_purged statement from the dump file.
• Create the backup by using the --set-gtid-purged=OFF option.
• Remove the group replication plugin from each instance before restoring.
• Remove the @@GLOBAL.gtid_executed statement from the dump file.
• Restore using the --set-gtid-purged=OFF option.

You want to check the values of the sort_buffer_size session variables of all existing connections.Which performance_schema table can you query?

• user_variables_by_thread
• global_variables
• variables_by_thread
• session_variables

Your MySQL server is running on the Microsoft Windows platform.Which three local connection protocols are available to you? (Choose three.)

• named pipes
• shared memory
• SOCKET
• X Protocol
• UDP
• TCP/IP

Which command enables rule-based MySQL Auditing capabilities?

• shell> mysql < audit_log_filter_linux_install.sql
• shell> mysqld --initialize --log-raw=audit.log
• mysql> INSTALL PLUGIN audit_log;
• mysql> INSTALL COMPONENT audit_log;

You want to log only the changes made to the database objects and data on the MySQL system.Which log will do this by default?

• general query log
• audit log
• slow query log
• binary log
• error log

Which two are use cases of MySQL asynchronous replication? (Choose two.)

• You can scale writes by creating a replicated mesh.
• It guarantees near real-time replication between a master and a slave.
• You can scale reads by adding multiple slaves.
• MySQL Enterprise Backup will automatically back up from an available slave.
• It allows backup to be done on the slave without impacting the master.