2024年最新の実際に出る1Z0-908問題集テストエンジン試験問題はここにある
更新された公式資料は1Z0-908認証済みの1Z0-908問題集PDF
質問 # 80
A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv='/var/tmp'
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)
- A. shell> cp /backup/customers.frm /var/lib/mysql/shop/
- B. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
- C. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
- D. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- E. mysql> SOURCE '/var/tmp/customers.sdi'
- F. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
- G. shell> cp /backup/customers.sdi /var/tmp
- H. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
正解：C、H
質問 # 81
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. sync_binlog=0
- B. innodb_flush_log_at_trx_commit=1
- C. innodb_doublewrite=0
- D. innodb_log_file_size=1G
- E. innodb_undo_directory=/dev/shm
- F. max_connections=10000
- G. buffer_pool_size=24G
正解：B、D、F
質問 # 82
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. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
- 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. Configuring SSL group communication also configures SSL distributed recovery.
- E. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
- F. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
正解：B、F
質問 # 83
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Start mysqld or mysqld_safe using different option files for each instance.
- B. Use system tools to lock each instance to its own CPU.
- C. Use resource groups to lock different instances on separate CPUs.
- D. Run MySQL Server docker containers.
- E. Use systemd with different settings for each instance.
- F. Run mysqld with --datadir defined for each instance.
正解：A、E、F
質問 # 84
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be renamed using the RENAME ROLEstatement.
- B. It can be granted to user accounts.
- C. It is created as a locked account.
- D. It can be dropped using the DROP ROLEstatement.
- E. It is stored in the mysql.roletable.
- F. It can be protected with a password.
正解：B、D、F
解説：
Explanation/Reference:
質問 # 85
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. Look for queries with big prolonged spikes in row activity/access graph in the times series graph.
- C. Look for queries with low total latency times in the Latency section in the times series graph.
- D. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.
正解：B
質問 # 86
What does the binlog dump thread do?
- A. It connects to the master and asks it to send updates recorded in its binary logs.
- B. It monitors and schedules the rotation/deletion of the binary logs.
- C. It reads the relay log and executes the events contained in them.
- D. It acquires a lock on the binary log for reading each event to be sent to the slave.
正解：A
質問 # 87
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 implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.
- B. MySQL writes SDI to the binary log for distributed backups.
- C. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
- D. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
- E. MySQL keeps InnoDB metadata changes in .sdi files in datadir.
正解：C、D
質問 # 88
There are five MySQL instances configured with a working group replication.
Examine the output of the group members:
Which two statements are true about network partitioning in the cluster? (Choose two.)
- A. A manual intervention to force group members to be only the working two instances is required.
- B. The cluster will shut down to preserve data consistency.
- C. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
- D. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- E. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
正解：B、E
質問 # 89
Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:
Which statement is true?
- A. Increasing slave_parallel_workers will improve high availability.
- B. Cross-database constraints can cause database inconsistency.
- C. Setting slave_preserve_commit_order to on will improve data consistency.
- D. Each slave thread is responsible for updating a specific database.
- E. Setting transaction_allow_batching to on will improve data consistency.
- F. Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
正解：C
質問 # 90
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. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
- B. The cluster is running and there is at least one ONLINE instance.
- C. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').
- D. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
- E. The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').
正解：C
質問 # 91
Which statement is true about InnoDB persistent index statistics?
- A. Updating index statistics is an I/O expensive operation.
- B. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
- C. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
- D. Tables are scanned and index statistics recalculated when an instance is restarted.
- E. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
- F. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
正解：C
質問 # 92
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
- A. ibdata1
- B. mysql.ibd
- C. ib_logfile0
- D. undo_001
- E. ib_buffer_pool
- F. ibtmp1
正解：B、E
質問 # 93
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The query returns exactly 125 rows.
- B. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
- C. It takes more than 8 milliseconds to sort the rows.
- D. The countrytable is accessed as the first table, and then joined to the city table.
- E. 35 rows from the city table are included in the result.
正解：B、E
質問 # 94
You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.
Examine the message sequence generated during the first start of MySQL 8.0.18:
Which step or set of steps will resolve the errors?
- A. Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.
- B. Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.
- C. Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.
- D. Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.
- E. Start mysqld again using the --upgrade=FORCE option.
正解：E
質問 # 95
Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)
- A. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
- B. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
- C. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
- D. Use SET PERSIST binlog_expire_logs_seconds=<value>.
- E. Use PURGE BINARY LOGS to <binlog_name>.
- F. Set binlog_expire_logs_seconds in my.cnf.
正解：B、D
質問 # 96
Your my.cnf file contains these settings:
You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?
- A. long_query_time=5
log_throttle_queries_not_using_indexes=5 - B. long_query_time=5
log_throttle_queries_not_using_indexes=5
min_examined_row_limit=5000 - C. min_examined_row_limit=5000
- D. long_query_time=5
min_examined_row_limit=5000 - E. log_throttle_queries_not_using_indexes=5
min_examined_ row_limit=5000 - F. long_query_time=5
- G. log_throttle_queries_not_using_indexes=5
正解：E
質問 # 97
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 4
- B. QN = 3
- C. QN = 1
- D. QN = 2
- E. QN = 5
正解：C、D
質問 # 98
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members
- A. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- B. SELECT email,passwd FROM members
- C. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- D. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘; - E. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘; - F. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
正解：B、C
質問 # 99
You are asked to review possible options for a new MySQL instance. It will be a large, busy reporting data warehousing instance.
[mysql]
innodb_data_file_path=
Which two configurations would satisfy long-term storage demands? (Choose two.)
- A. ibdatal:12M:autoextend;ibdata2:12M:autoextend
- B. ibdatal:12M;/tmp/ibdata2:12M:autoextend
- C. ibdatal:12M
- D. ibdatal:12M:autoextend
- E. ibdatal:12M;ibdata2:12M:autoextend
- F. ibdatal:12M;ibdata2:12M;ibdata3:12M
正解：C、F
質問 # 100
......
最新版無料体験を掴み取れ！Oracle 1Z0-908問題集PDFは更新された：https://jp.fast2test.com/1Z0-908-premium-file.html
最新リリースの1Z0-908問題集はMySQL Database Administration認証済み：https://drive.google.com/open?id=19rVSSN7eScsA5tLXIxY2uLqFOhXhQhab