2023年最新のの検証済み1z1-908問題と解答で合格保証 もしくは全額返金
[2023年11月]更新の1z1-908認証と実際の解答はここにあるJPNTest
質問 # 18
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage...
The instance 'host1:3377'' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y The instance 'host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadat a. Please use the most up to date instance: 'host1:3377'. (RuntimeError) Which statement is true?
- A. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
- B. The cluster is running and there is at least one ONLINE instance.
- C. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
- D. The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').
- E. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').
正解：E
質問 # 19
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)
- A. It enforces consistent backups for all storage engines.
- B. This option uses the READ COMMITTED transaction isolation mode.
- C. The backup created is a consistent data dump.
- D. It executes flush tables with read lock.
- E. It is a cold backup.
正解：B、D
質問 # 20
Examine this statement, which executes successfully:
You want to improve the performance of this query:
Which change enables the query to succeed while accessing fewer rows?
- A. ALTER TABLE world.city ADD INDEX (Name);
- B. ALTER TABLE world.city ADD INDEX (Population);
- C. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- D. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- E. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- F. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
正解：D
解説：
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
質問 # 21
Examine these statements and output:
Which statement is true?
- A. The user is logged in with --user=accountingas an option.
- B. The user is authorized as the rsmith@localhostuser.
- C. The user is authenticated as the anonymous proxy user ‘’@’%’.
- D. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
- E. The user is authorized as the accounting@localhostuser.
正解：B
質問 # 22
Examine these commands and output:
Which connection ID is holding the metadata lock?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
- F. 5
正解：A
質問 # 23
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Remove world read privileges from the server-cert.pem certificate file.
- B. Remove the world read/execute privilege from the accounting directory.
- C. Remove group read/write privileges from the private_key.pem file.
- D. Change the parent directory owner and group to mysql.
- E. Remove world read privileges from the public_key.pem file.
- F. Change the group ownership of the mysql directory to the mysql user group.
正解：D、F
質問 # 24
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:
What statement is true about the start attempt?
- A. MySQL server was not started due to a problem while executing process 2732.
- B. MySQL server continued to start up even though another process existed.
- C. systemd waited for 30 seconds before timing out and start up failed.
- D. systemd found the mysqld service disabled and failed to start it.
- E. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
正解：E
質問 # 25
You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.
Using Query Analyzer, where do you begin to look for problem queries?
- A. Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.
- B. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.
- C. Look for queries with low total latency times in the Latency section in the times series graph.
- D. Look for queries with big prolonged spikes in row activity/access graph in the times series graph.
正解：D
質問 # 26
Which three sets of item information are visible in the mysql system database? (Choose three.)
- A. audit log events
- B. help topics
- C. information about table structures
- D. rollback segments
- E. performance monitoring information
- F. plugins
- G. time zone information and definitions
正解：B、D、F
質問 # 27
Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?
- A. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
- B. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
- C. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
- D. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
正解：C
質問 # 28
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?
- A. VERIFY_IDENTITY
- B. REQUIRED
- C. PREFERRED
- D. DISABLED
- E. VERIFY_CA
正解：A、E
解説：
Explanation
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
質問 # 29
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)
- A. $HOME/.my.cnf file
- B. $HOME/.mysql/auth/login file
- C. $HOME/.mysqlrc file
- D. /etc/my.cnf file
- E. $MYSQL_HOME/my.cnf file
- F. DATADIR/mysqld-auto.cnf file
- G. $HOME/.mylogin.cnf file
正解：D、E、F
質問 # 30
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?
- A. Change the default database and re-execute the failed statement in your transaction.
- B. Roll back the transaction and start the transaction again in the same session.
- C. Re-execute the failed statement in your transaction.
- D. Close the connection, reconnect, and start the transaction again.
正解：C
質問 # 31
Examine the modified output:
Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
- A. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- B. One or more large tables do not have primary keys.
- C. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- D. The master is producing a large volume of events in parallel but the slave is processing them serially.
- E. The parallel slave threads are experiencing lock contention.
正解：A、D
質問 # 32
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
- A. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
- B. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation - C. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
- D. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
- E. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
正解：B、D
質問 # 33
Examine this output:
Which change should optimize the number of buffer pool instances for this workload?
- A. Increase the number of buffer pool instances to 32.
- B. Increase the number of buffer pool instances to 12.
- C. Increase the number of buffer pool instances to 16.
- D. Decrease the number of buffer pool instances to 4.
- E. Decrease the number of buffer pool instances to 1.
正解：A
質問 # 34
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your dat
a. Examine your backup requirement:
The MySQL system being backed up can never be unavailable or locked to the client applications.
The recovery from the backup must work on any system.
Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?
- A. Take your backup from a slave of the MySQL system.
- B. Take a physical backup of the MySQL system.
- C. Use the Clone Plugin to copy the data to another MySQL system.
- D. Take a logical backup of the MySQL system.
正解：D
質問 # 35
Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)
- A. read_buffer_size
- B. innodb_buffer_pool_size
- C. tmp_table_size
- D. sort_buffer_size
- E. key_buffer_size
- F. table_open_cache
正解：C、D、E
質問 # 36
Examine this command and output:
Which statement is true?
- A. Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
- B. Firewall_access_granted is the number of connections granted from whitelisted hosts.
- 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
質問 # 37
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.)
- A. max_connections=10000
- B. sync_binlog=0
- C. innodb_undo_directory=/dev/shm
- D. buffer_pool_size=24G
- E. innodb_flush_log_at_trx_commit=1
- F. innodb_doublewrite=0
- G. innodb_log_file_size=1G
正解：A、E、G
質問 # 38
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 host2 is elected as the new primary instance.
- B. The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.
- C. The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')
- D. The primary instance can be specified by using the command
cluster.setPrimaryInstance(<host>:<port>). - E. Failure of the instance deployed on host1 provokes an outage.
- F. The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.
正解：B、D
質問 # 39
Examine this command, which executes successfully:
Which statement is true?
- A. Only tables stored in their own tablespaces are backed up.
- B. The backup includes only data files and their metadata.
- C. Only non-encrypted files are backed up.
- D. Only InnoDB data and log files are backed up.
- E. Only files for MySQL or Its built-in storage engines are backed
正解：D
質問 # 40
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?
- A. REQUIRED
- B. VERIFY_IDENTITY
- C. VERIFY_CA
- D. PREFERRED
- E. DISABLED
正解：A
質問 # 41
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It creates a logical backup of all metadata, but contains no table data.
- B. It creates a logical backup of all MySQL user accounts.
- C. It creates a logical backup of only the usersdatabase.
- D. It returns an error because the mysqldumpcommand should have been used.
正解：A
解説：
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html
質問 # 42
......
1z1-908リアル有効で正確な問題集142問題と解答が待ってます：https://www.jpntest.com/shiken/1z1-908-mondaishu
最新の1z1-908問題集でPDF：https://drive.google.com/open?id=1u37BfQA1GnUbcAV83x2NPVzPFlH5IgwP