[Jan 25, 2022] 1Z0-908 Exam Dumps PDF Guaranteed Success with Accurate & Updated Questions
Pass 1Z0-908 Exam - Real Test Engine PDF with 86 Questions
NEW QUESTION 46
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is a shared lock.
- B. The lock is at the metadata object level.
- C. The lock is a row-level lock.
- D. The lock is at the table object level.
- E. The lock is an exclusive lock.
- F. The lock is an intentional lock.
Answer: D,E
NEW QUESTION 47
Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)
- A. SHOW INDEXES FROM manufacturing.parts;
- B. DESCRIBE manufacturing.parts;
- C. SELECT * FROM information_schema.COLUMN_STATISTICS;
- D. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- E. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';
Answer: C,E
NEW QUESTION 48
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 is not necessary because innodb_data_home_diris already defined.
- B. It moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
- C. It defines all innodb tablespace options relative to a starting parent directory.
- D. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
- E. It allows scanning of other locations to discover more innodb tablespaces.
Answer: A
NEW QUESTION 49
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?
- A. global_variables
- B. user_variables_by_thread
- C. variables_by_thread
- D. session_variables
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/worklog/task/?id=6629
NEW QUESTION 50
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
- A. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - B. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency - C. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - D. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID; - E. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC; - F. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
Answer: A,B
NEW QUESTION 51
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. systemd found the mysqld service disabled and failed to start it.
- B. MySQL server was not started due to a problem while executing process 2732.
- C. MySQL server continued to start up even though another process existed.
- D. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
- E. systemd waited for 30 seconds before timing out and start up failed.
Answer: D
NEW QUESTION 52
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The countrytable is accessed as the first table, and then joined to the city table.
- B. The query returns exactly 125 rows.
- C. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
- D. It takes more than 8 milliseconds to sort the rows.
- E. 35 rows from the city table are included in the result.
Answer: C,E
NEW QUESTION 53
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 defines all innodb tablespace options relative to a starting parent directory.
- B. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
- C. It adds more temporary workspace in addition to the innodb_tmpdir location.
- D. It is not necessary because innodb_data_home_dir is already defined.
- E. It allows scanning of other locations to discover more innodb tablespaces.
Answer: D
NEW QUESTION 54
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /usr/bin
- B. /var/lib/mysql
- C. /usr
- D. /etc/my.cnf
- E. /usr/mysql
Answer: A
NEW QUESTION 55
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.pemcertificate file.
- B. Change the group ownership of the mysqldirectory to the mysqluser group.
- C. Remove the world read/execute privilege from the accountingdirectory.
- D. Remove world read privileges from the public_key.pemfile.
- E. Remove group read/write privileges from the private_key.pemfile.
- F. Change the parent directory owner and group to mysql.
Answer: B,F
NEW QUESTION 56
Which two statements are true about using backups of the binary log? (Choose two.)
- A. Binary logs can always be used to unapply unwanted schema changes.
- B. Multiple binary logs can be applied in parallel for faster data restoration.
- C. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
- D. They allow for point-in-time recovery of the data.
- E. Multiple binary logs can be used to restore data.
Answer: A,D
NEW QUESTION 57
Examine this query:
What information does this query provide?
- A. total memory used by the first 10 connections
- B. total memory used by connection number 10
- C. total memory used across all connections associated with the user on thread number 10
- D. total memory used across all connections associated with the user on connection number 10
- E. total memory used by thread number 10
- F. total memory used by the first 10 threads
Answer: B
NEW QUESTION 58
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTERcommand 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 master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
- C. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- E. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
Answer: C
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION 59
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 restarted.
- C. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- D. MySQL Router is configured based on the information in files in directory_path.
Answer: C
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html
NEW QUESTION 60
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The query returns exactly 125 rows.
- B. It takes more than 8 milliseconds to sort the rows.
- C. 35 rows from the city table are included in the result.
- D. The country table is accessed as the first table, and then joined to the city table.
- E. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
Answer: C,E
NEW QUESTION 61
Which command enables rule-based MySQL Auditing capabilities?
- A. mysql> INSTALL PLUGIN audit_log;
- B. shell> mysqld --initialize --log-raw=audit.log
- C. mysql> INSTALL COMPONENT audit_log;
- D. shell> mysql < audit_log_filter_linux_install.sql
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html
NEW QUESTION 62
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
- A. Use mysql_config_editor to create an encrypted file.
- B. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
- C. Use mysql_secure_installation to encrypt stored login credentials.
- D. Use the AES_ENCRYPT() MySQL function on the option file.
Answer: A
NEW QUESTION 63
Examine the modified output:
Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
- A. The parallel slave threads are experiencing lock contention.
- B. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- C. One or more large tables do not have primary keys.
- D. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- E. The master is producing a large volume of events in parallel but the slave is processing them serially.
Answer: D,E
NEW QUESTION 64
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. innodb_doublewrite=0
- B. innodb_undo_directory=/dev/shm
- C. innodb_flush_log_at_trx_commit=1
- D. sync_binlog=0
- E. max_connections=10000
- F. buffer_pool_size=24G
- G. innodb_log_file_size=1G
Answer: C,E,G
Explanation:
Explanation/Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/
NEW QUESTION 65
Which two statements are true about the mysql_config_editor program? (Choose two.)
- A. It manages the configuration of client programs.
- B. It will use [client] options by default unless you provide --login-path.
- C. It can be used to create and edit SSL certificates and log locations.
- D. It manages the configuration of the MySQL Firewall feature.
- E. It manages the configuration of user privileges for accessing the server.
- F. It can move datadir to a new location.
- G. It provides an interface to change my.cnf files.
Answer: A,B
NEW QUESTION 66
You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?
- A. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
- B. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
- C. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
- D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
Answer: A
NEW QUESTION 67
Examine this list of MySQL data directory binary logs:
binlog.000001
binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
- A. All databases are backed up to the output file.
- B. All details regarding deleted logs and master metadata are captured in the output file.
- C. All binary logs are backed up and then deleted.
- D. All databases, excluding master metadata, are backed up to the output file.
- E. All binary logs are deleted from the master.
- F. All non-active binary logs are removed from the master.
Answer: D,E
NEW QUESTION 68
......
Get New 1Z0-908 Certification Practice Test Questions Exam Dumps: https://www.practicedump.com/1Z0-908_actualtests.html
Real 1Z0-908 Exam Dumps Questions Valid 1Z0-908 Dumps PDF: https://drive.google.com/open?id=12IedrmuZi9ZoU2hKL796rVtbH_YXRRHt