MySQL 8.0 Database Administrator (1z1-908) Free Practice Test

Question 1

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

A. ALTER USER baduser@hostname PASSWORD DISABLED;

B. ALTER USER baduser@hostname ACCOUNT LOCK;

C. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

D. ALTER USER baduser@hostname DEFAULT ROLE NONE;

E. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

Correct Answer: B,C

Question 2

Which three requirements must be enabled for group replication? (Choose three.)

A. primary key or primary key equivalent on every table

B. semi-sync replication plugin

C. replication filters

D. binary log MIXED format

E. binary log ROW format

F. binary log checksum

G. slave updates logging

Correct Answer: A,B,D

Question 3

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

C. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Correct Answer: B

Question 4

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.)

A. ibdata1

B. ibtmp1

C. ib_buffer_pool

D. mysql.ibd

E. undo_001

F. ib_logfile0

Correct Answer: C,D

Question 5

You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:

Which action would allow the server to start?

A. Execute mysqladmin flush-logs.

B. First run mysqld --initialize to refresh the Size of ib_logfile.

C. Create a new ib_logfile0 file of size 26214400.

D. Remove ib_logfile0 and ib_logfile1 files from the file system.

Correct Answer: B

Question 6

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)

A. MySQL Replication monitoring

B. security-related advisor warnings

C. disk usage and disk characteristics including disk advisors warnings

D. network-related information and network characteristics

E. CPU utilization

F. operating system memory utilization

G. MySQL Query Analysis data

Correct Answer: B,C,G

Question 7

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

A. They work best for transaction storage engines that can perform their own recovery when restored.

B. They take roughly twice as long as logical backups.

C. The backup window is almost zero from the perspective of the application.

D. There is a slight performance cost while the snapshot is active.

E. They do not back up views, stored procedures, or configuration files.

F. They allow direct copying of table rows with operating system copy commands.

G. They do not use additional disk space.

Correct Answer: A,E,G

Welcome to TestSimulate

Oracle MySQL 8.0 Database Administrator (1z1-908) Free Practice Test