CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

1z0-908 Exam Questions Tutorials

Page: 5 / 5
Total 140 questions
Get 1z0-908 Full Access Download 1z0-908 PDF

MySQL 8.0 Database Administrator Questions and Answers

Question 17

A colleague complains about slow response time on your website.

Examine this query and output:

What is the most likely cause for the high number of lock waits?

Options:

A.

You use the MyISAM storage engine for most common tables.

B.

You use the InnoDB storage engine and statements wait while data is inserted.

C.

The Innodb Buffer pool is full.

D.

Your table accesses wait for the operating system level flush.

Question 18

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

Options:

A.

innodb_flush_log_at_trx_commit=1

B.

buffer_pool_size=24G

C.

innodb_log_file_size=1G

D.

sync_binlog=0

E.

innodb_doublewrite=0

F.

max_connections=10000

G.

innodb_undo_directory=/dev/shm

Question 19

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?

Options:

A.

Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa

transactions than the master.

B.

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

C.

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

D.

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

GTIDs.

E.

Replication will work.

Question 20

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

Options:

A.

It installs most Oracle MySQL products.

B.

It performs product upgrades.

C.

It provides only GUI-driven, interactive installations.

D.

Manual download of separate product packages is required before installing them through MySQL Installer.

E.

It provides a uniform installation wizard across multiple platforms.

Page: 5 / 5
Total 140 questions
Get 1z0-908 Full Access Download 1z0-908 PDF