Latest [Jul 27, 2025] 100% Passing Guarantee – Brilliant 1Z0-908 Exam Questions PDF [Q20-Q37]

4/5 - (1 vote)

Latest [Jul 27, 2025] 100% Passing Guarantee – Brilliant 1Z0-908 Exam Questions PDF

1Z0-908 Certification – Valid Exam Dumps Questions Study Guide! (Updated 142 Questions)

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

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

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

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

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

QUESTION 21
Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.

Executing ALTER TABLE transactions will enable you to free up disk space.

Truncating the sales and leads table will free up disk space.

Truncating the transactions table will free up the most disk space.

The transactions table was created with innodb_file_per_table=OFF.

QUESTION 22
You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

–shared-memory-base-name=world

–protocol=UDP

–protocol=pipe

–password

–user=admin

–host=192.0.2.1

–socket=/tmp/mysql.sock

–port=3306

–database=world

QUESTION 23
Examine these commands and output:

Which connection ID is holding the metadata lock?

QUESTION 24
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

QUESTION 25
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

table data

primary indexes

user privileges

InnoDB Data Dictionary

change buffer

doublewrite buffer

Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html

QUESTION 26
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

MyISAM

NDB

MEMORY

ARCHIVE

InnoDB

QUESTION 27
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?

Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.

Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.

Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.

Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.

Replication will work.

QUESTION 28
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?

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.

QUESTION 29
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?

RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

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;

RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

QUESTION 30
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?

RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

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;

RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

QUESTION 31
Which statement is true about InnoDB persistent index statistics?

Updating index statistics is an I/O expensive operation.

Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Tables are scanned and index statistics recalculated when an instance is restarted.

QUESTION 32
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck.
Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

innodb_flush_log_at_trx_commit=1

buffer_pool_size=24G

innodb_log_file_size=1G

sync_binlog=0

innodb_doublewrite=0

max_connections=10000

innodb_undo_directory=/dev/shm

Explanation/Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/

QUESTION 33
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

QUESTION 34
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?

kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.

kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.

mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

QUESTION 35
Examine this statement, which executes successfully:

Now examine this query:

Which two statements can do this? (Choose two.)

ALTER TABLE employees –
ADD INDEX (birth_date DESC);

ALTER TABLE employees –
ADD INDEX ((MONTH(birth_date)));

ALTER TABLE employees –
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);

ALTER TABLE employees –
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>’$.month’) VIRTUAL NOT NULL, ADD INDEX (birth_month);

ALTER TABLE employees –
ADD INDEX ((CAST(birth_date->>’$.month’ AS unsigned)));

ALTER TABLE employees –
ADD INDEX (birth_date);

QUESTION 36
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

table data

primary indexes

user privileges

InnoDB Data Dictionary

change buffer

doublewrite buffer

QUESTION 37
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?

It defines all innodb tablespace options relative to a starting parent directory.

It is not necessary because innodb_data_home_dir is already defined.

It allows scanning of other locations to discover more innodb tablespaces.

It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

It adds more temporary workspace in addition to the innodb_tmpdir location.

Loading …

As a certified MySQL 8.0 Database Administrator, you will be able to efficiently manage and maintain databases, thereby ensuring the smooth running of businesses. MySQL 8.0 Database Administrator certification also opens up various career opportunities, including database administrator roles in companies dealing with big data, e-commerce, finance, and more. With Oracle 1Z0-908 certification, you can showcase your proficiency in MySQL database administration and take your career to new heights.

Oracle 1Z0-908 certification exam is a highly sought-after certification in the information technology industry. MySQL 8.0 Database Administrator certification is globally recognized, making it a valuable asset for individuals who want to work in any part of the world. 1Z0-908 exam is designed to evaluate a candidate’s skills in database administration, security, backup and recovery, high availability, and performance tuning. Passing 1Z0-908 exam is a must for individuals who want to work as a MySQL database administrator, database developer, or in any other related field.

1Z0-908 are Available for Instant Access: https://www.testkingfree.com/Oracle/1Z0-908-practice-exam-dumps.html