1z1-908試験無料問題集（142題）「Oracle MySQL 8.0 Database Administrator 認定」

出題：1

You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

A. Run MySQL Server docker containers.

B. Use system tools to lock each instance to its own CPU.

C. Start mysqld or mysqld_safe using different option files for each instance.

D. Run mysqld with --datadir defined for each instance.

E. Use systemd with different settings for each instance.

F. Use resource groups to lock different instances on separate CPUs.

正解：C,D,E 解答を投票する

出題：2

Examine this command and output:

Which statement is true?

A. Firewall_access_granted is the number of connections granted from whitelisted hosts.

B. Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C. Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

D. Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

正解：D 解答を投票する

出題：3

Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?

A. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

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 is restarted.

正解：C 解答を投票する

出題：4

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?

A. Replication will work.

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

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

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

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

正解：B 解答を投票する

出題：5

Examine this query:

What information does this query provide?

A. total memory used by connection number 10

B. total memory used across all connections associated with the user on connection number 10

C. total memory used by the first 10 threads

D. total memory used by the first 10 connections

E. total memory used across all connections associated with the user on thread number 10

F. total memory used by thread number 10

正解：A 解答を投票する

出題：6

Which two statements are true about raw binary backups? (Choose two.)

A. They are converted to a highly compressible binary format.

B. They are required to obtain FIPS security compliance.

C. The data format is identical to how MySQL stores the data on disk.

D. They are faster than logical backups because the process is a simple file or file system copy.

E. The resulting files are easily human readable.

正解：C,E 解答を投票する

出題：7

Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

A. Each slave thread is responsible for updating a specific database.

B. Setting transaction_allow_batching to on will improve data consistency.

C. Increasing slave_parallel_workers will improve high availability.

D. Setting slave_preserve_commit_order to on will improve data consistency.

E. Cross-database constraints can cause database inconsistency.

F. Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.

正解：D 解答を投票する

出題：8

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

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

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

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

E. 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 解答を投票する

出題：9

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

正解：C,D,F 解答を投票する

出題：10

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup
--optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?

A. The redo logs are not backed up at all.

B. The redo logs are backed up only if there are changes showing for the transactions tables.

C. The redo logs are backed up first, then the transaction and archive tables.

D. The archive tables are backed up first, then the transaction tables and redo logs.

E. The transaction tables are backed up first, then the archive tables and redo logs.

正解：B 解答を投票する

1z1-908試験無料問題集「Oracle MySQL 8.0 Database Administrator 認定」