[Aug-2021] 1z1-908 Pre-Exam Practice Tests | Exam Questions and Answers for MySQL Database Administration Study Guide
MySQL 8.0 Database Administrator Certification Sample Questions
NEW QUESTION 38
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?
- A. user_variables_by_thread
- B. global_variables
- C. variables_by_thread
- D. session_variables
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/worklog/task/?id=6629
NEW QUESTION 39
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Remove world read privileges from the public_key.pemfile.
- B. Change the parent directory owner and group to mysql.
- C. Remove world read privileges from the server-cert.pemcertificate file.
- D. Remove group read/write privileges from the private_key.pemfile.
- E. Change the group ownership of the mysqldirectory to the mysqluser group.
- F. Remove the world read/execute privilege from the accountingdirectory.
Answer: B,E
NEW QUESTION 40
Examine these commands and output:
Which connection ID is holding the metadata lock?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
- F. 5
Answer: B
NEW QUESTION 41
Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
- A. All databases are backed up to the output file.
- B. All non-active binary logs are removed from the master.
- C. All databases, excluding master metadata, are backed up to the output file.
- D. All binary logs are deleted from the master.
- E. All binary logs are backed up and then deleted.
- F. All details regarding deleted logs and master metadata are captured in the output file.
Answer: C,D
NEW QUESTION 42
Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?
- A. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
- B. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
- C. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
- D. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
Answer: D
NEW QUESTION 43
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your dat
a. Examine your backup requirement:
The MySQL system being backed up can never be unavailable or locked to the client applications.
The recovery from the backup must work on any system.
Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?
- A. Take your backup from a slave of the MySQL system.
- B. Use the Clone Plugin to copy the data to another MySQL system.
- C. Take a logical backup of the MySQL system.
- D. Take a physical backup of the MySQL system.
Answer: C
NEW QUESTION 44
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. using stored procedures for any database access
- B. installing and configuring the Connection Control plugin
- C. using PREPARED STATEMENTS
- D. avoiding concatenation of SQL statements and user-supplied values in an application
Answer: A
NEW QUESTION 45
You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:
You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?
- A. It allows scanning of other locations to discover more innodb tablespaces.
- B. It adds more temporary workspace in addition to the innodb_tmpdir location.
- C. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
- D. It is not necessary because innodb_data_home_dir is already defined.
- E. It defines all innodb tablespace options relative to a starting parent directory.
Answer: D
NEW QUESTION 46
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:
You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?
- A. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- C. RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - D. RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - E. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;
Answer: D
NEW QUESTION 47
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. MySQL Enterprise Backup will automatically back up from an available slave.
- B. It guarantees near real-time replication between a master and a slave.
- C. You can scale writes by creating a replicated mesh.
- D. It allows backup to be done on the slave without impacting the master.
- E. You can scale reads by adding multiple slaves.
Answer: D,E
NEW QUESTION 48
Examine these commands and output:
Which connection ID is holding the metadata lock?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
- F. 5
Answer: B
NEW QUESTION 49
Examine this command, which executes successfully:
mysqlpump --user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
- A. information_schema
- B. employee
- C. mysql
- D. world
- E. sys
Answer: A,E
NEW QUESTION 50
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
- A. MySQL Router is restarted.
- B. MySQL Router is configured based on the information in files in directory_path.
- C. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- D. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
Answer: C
NEW QUESTION 51
Which two statements are true about MySQL server multi-source replication? (Choose two.)
- A. It is not compatible with auto-positioning.
- B. It relies on relay_log_recovery for resilient operations.
- C. It does not attempt to detect or resolve replication conflicts.
- D. It must use GTID replication.
- E. It uses only time-based replication conflict resolution.
- F. It needs to be re-instanced after a crash to maintain consistency.
Answer: D,E
NEW QUESTION 52
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:
What is the reason for the error?
- A. The DBA needs to execute FLUSH PRIVILEGES.
- B. The statement was blocked by MySQL Firewall.
- C. John needs to reconnect to the database.
- D. John has not activated the role.
Answer: D
NEW QUESTION 53
What does the binlog dump thread do?
- A. It connects to the master and asks it to send updates recorded in its binary logs.
- B. It monitors and schedules the rotation/deletion of the binary logs.
- C. It reads the relay log and executes the events contained in them.
- D. It acquires a lock on the binary log for reading each event to be sent to the slave.
Answer: A
NEW QUESTION 54
......
Oracle Exam Practice Test To Gain Brilliante Result: https://www.testkingfree.com/Oracle/1z1-908-practice-exam-dumps.html
Tested Material Used To 1z1-908: https://drive.google.com/open?id=1uQlQqFkD6KpnleohgvR3o-8qeZEYJVZP