Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
MySQL Database Administration
1z0-908
MySQL 8.0 Database Administrator Questions and Answers

Pass the Oracle MySQL Database Administration 1z0-908 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-908 Premium Access

View all detail and faqs for the 1z0-908 exam

Go to Exam

679 Students Passed

96% Average Score

97% Same Questions

Viewing page 4 out of 5 pages

Viewing questions 31-40 out of questions

Questions # 31:

Which three sets of item information are visible in the mysql system database? (Choose three.)

Options:

help topics

performance monitoring information

plugins

information about table structures

audit log events

rollback segments

time zone information and definitions

Answer

A, C, G

Explanation

Help topics: The mysql.help_topic and mysql.help_category tables store the help information that can be accessed by the HELP statement or the mysql --help command1.

Plugins: The mysql.plugins table stores information about the server plugins that are installed and active2.

Time zone information and definitions: The mysql.time_zone, mysql.time_zone_name, mysql.time_zone_leap_second, mysql.time_zone_transition, and mysql.time_zone_transition_type tables store the time zone information that can be used by the server and the clients3.

Questions # 32:

MySQL is installed on a Linux server with this configuration:

Question # 32

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

Options:

Set validate-user-plugins=caching_sha2_password in the configuration file.

Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.

Add default_authentication_plugin=mysql_native_password in the configuration file.

Add default_authentication_plugin=sha256_password in the configuration file.

Answer

Questions # 33:

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:

Question # 33

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

Options:

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

Answer

D, E, G

Explanation

D. sync_binlog=0: This disables the synchronizing of the binary log to disk after every commit. This can reduce disk I/O, but it comes with a risk of losing transactions in case of a crash. Since your data is transient, this might be an acceptable risk. E. innodb_doublewrite=0: Disabling innodb_doublewrite can reduce disk I/O, but it comes with a risk of data corruption in the event of a crash. Since your data is transient and doesn’t require backup or replication, this might be an acceptable risk. G. innodb_undo_directory=/dev/shm: Moving the innodb_undo_directory to a memory-based filesystem like /dev/shm can reduce disk I/O and improve performance. However, this comes with a risk of running out of space for undo logs if the system has a high rate of updates/deletes/inserts.

Questions # 34:

Examine this command, which executes successfully:

Question # 34

Which statement is true?

Options:

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.

Answer

Explanation

https://dev.mysql.com/doc/mysql-enterprise-backup/8.0/en/backup-partial-options.html

Questions # 35:

Which two statements are true about MySQL Enterprise Backup? (Choose two.)

Options:

It supports backing up only table structures.

It can perform hot or warm backups.

It creates logical backups.

It supports the creation of incremental backups.

It supports backup of a remote MySQL system.

It supports restoring to a remote MySQL system.

Answer

B, D

Questions # 36:

Which statement is true about InnoDB persistent index statistics?

Options:

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.

Answer

Explanation

[Reference: https://mariadb.com/kb/en/innodb-persistent-statistics/, ]

Questions # 37:

Four nodes are configured to use circular replication.

Examine these configuration parameters for each node:

Question # 37

Which statement is true?

Options:

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.

Answer

Questions # 38:

Examine Joe's account:

CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'

GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'

All existing connections for joe are killed.

Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

Options:

ALTER USER 'joe'@'%' ACCOUNT LOCK

ALTER USER 'joe'@'%' SET password='*invalid*'

REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'

ALTER USER 'joe'@'%' PASSWORD HISTORY 0

ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

REVOKE USAGE ON *.* FROM 'joe'@'%'

Answer

C, E

Questions # 39:

Examine this command, which executes successfully:

Question # 39

Which two statements are true? (Choose two.)

Options:

A single-file backup is created.

The backup operation will finish only when backup-and-apply-log is executed.

The --backup-dir option holds temporary output, status, and metadata files.

The backup operation will finish only when apply-log is executed.

A raw backup is created.

Answer

C, D

Questions # 40:

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

Options:

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.

Answer

C, E

Viewing page 4 out of 5 pages

Viewing questions 31-40 out of questions

Modal title

Registered Required

In order to participate in the comments you need to be logged-in.
You can sign-up or login (it's free).

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25

ADM-201

Agentforce-Specialist

CMMC-CCP

Data-Cloud-Consultant

PDI

PSE-Strata-Pro-24

Secure-Software-Design

Sharing-and-Visibility-Architect

Workday-Pro-Integrations

ZDTA