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

質問 1

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?

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

（B）It is not necessary because innodb_data_home_dir is already defined.

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

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

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

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

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）The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.

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

（D）Failure of the instance deployed on host1 provokes an outage.

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

（F）The instance deployed on host2 is elected as the new primary instance.

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

質問 3

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

（A）They allow direct copying of table rows with operating system copy commands.

（B）They take roughly twice as long as logical backups.

（C）There is a slight performance cost while the snapshot is active.

（D）The backup window is almost zero from the perspective of the application.

（E）They work best for transaction storage engines that can perform their own recovery when restored.

（F）They do not use additional disk space.

（G）They do not back up views, stored procedures, or configuration files.

正解：E、F、G 解答を投票する

質問 4

Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

（A）named pipes

（B）TCP/IP

（C）UDP

（D）X Protocol

（E）SOCKET

（F）shared memory

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

質問 5

Which three are requirements for a secure MySQL Server environment? (Choose three.)

（A）Encrypt the file system to avoid needing exact file-system permissions.

（B）Keep the entire software stack on one OS host.

（C）Ensure appropriate file system privileges for OS users and groups.

（D）Restrict the number of OS users that have access at the OS level.

（E）Minimize the number of non-MySQL Server-related processes running on the server host.

（F）Run MySQL server as the root user to prevent incorrect sudo settings.

正解：A、B、C 解答を投票する

質問 6

Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

（A）It is not mandatory that all instances are running and reachable before running the command.

（B）It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

（C）It reconfigures InnoDB Cluster if the cluster was stopped.

（D）It only starts all InnoDB Cluster instances.

（E）It performs InnoDB Cluster instances rolling restart.

（F）It only stops and restarts all InnoDB Cluster instances.

（G）It stops and restarts all InnoDB Cluster instances and initializes the metadata.

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

質問 7

Which two statements are true about MySQL server multi-source replication? (Choose two.)

（A）It is not compatible with auto-positioning.

（B）It relies on relay_log_recovery for resilient operations.

（C）It does not attempt to detect or resolve replication conflicts.

（D）It uses only time-based replication conflict resolution.

（E）It needs to be re-instanced after a crash to maintain consistency.

（F）It must use GTID replication.

正解：D、F 解答を投票する

質問 8

You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

（A）MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

（B）The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

（C）MySQL writes SDI to the binary log for distributed backups.

（D）MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

（E）MySQL keeps InnoDB metadata changes in .sdi files in datadir.

正解：A、B 解答を投票する

質問 9

Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)

（A）Connections driven by MySQL Router are not affected by the command.

（B）The command drops the mysql_innodb_cluster_metadata schema and re-creates it.

（C）Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.

（D）The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

（E）The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

（F）Group Replication will be dissolved and all metadata purged.

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

質問 10

Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

（A）The copy-back process makes inconsistent backups.

（B）It restores files from the data directory to their original MySQL server locations.

（C）The copy-back process is used to overwrite a new backup over an existing backup.

（D）It restores files from the backup directory to their original MySQL server locations.

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

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

弊社を連絡する

関連リンク

トップ試験