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

出題：1

All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)

A. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.

B. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.

C. If only some InnoDB Cluster members are enabled for SSL group communication, and
--ssl-mode=PREFERRED, communication will fall back to unencrypted connection.

D. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).

E. Configuring SSL group communication also configures SSL distributed recovery.

F. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.

正解：B,D 解答を投票する

出題：2

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

A. It performs product upgrades.

B. It provides a uniform installation wizard across multiple platforms.

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

D. It installs most Oracle MySQL products.

E. It provides only GUI-driven, interactive installations.

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

出題：3

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

A. It allows backup to be done on the slave without impacting the master.

B. MySQL Enterprise Backup will automatically back up from an available slave.

C. You can scale writes by creating a replicated mesh.

D. It guarantees near real-time replication between a master and a slave.

E. You can scale reads by adding multiple slaves.

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

出題：4

Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.
Which two statements are true? (Choose two.)

A. The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')

B. Failure of the instance deployed on host1 provokes an outage.

C. The primary instance can be specified by using the command
cluster.setPrimaryInstance(<host>:<port>).

D. The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.

E. The instance deployed on host2 is elected as the new primary instance.

F. The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.

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

出題：5

Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)

A. BLACKHOLE

B. NDB

C. MEMORY

D. InnopB

E. ARCHIVE

F. MyISAM

正解：A,B,F 解答を投票する

出題：6

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

A. information about table structures

B. audit log events

C. help topics

D. rollback segments

E. plugins

F. performance monitoring information

G. time zone information and definitions

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

出題：7

Examine this partial output for InnoDB Cluster status:

Which statement explains the state of the instance deployed on host2?

A. It has been expelled from the cluster because of a transaction error.

B. It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage()

C. It can rejoin the cluster by using the command cluster.addInstance('<user>@host3:3377')

D. It has been removed from the cluster by using the command STOP GROUP_REPLICATION;

E. It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('<user>@host3:3377')

正解：B 解答を投票する

出題：8

Which three actions are effective in capacity planning? (Choose three.)

A. monitoring OS resources for patterns

B. upgrading to the latest application version

C. basing expected growth on an average of the last 3 years

D. adding circular replication nodes for increased DML capability

E. consulting the application team about any future projects and use

F. buying more CPU

G. buying more disk

H. buying more RAM

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

出題：9

Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?

A. mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql

B. mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql

C. mysqlbinlog --stop-position=500324 binlog.000036 | mysql

D. mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql

正解：B 解答を投票する

出題：10

Which two statements are true about the binary log encryption feature? (Choose two.)

A. It can be set at run time.

B. It can be activated per session.

C. When enabled it encrypts existing binary logs.

D. It requires a keyring plugin.

E. It encrypts any connecting slaves connection thread.

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

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