Attention please! Here is the shortcut to pass your Apr 05,2022 Hotest 1z0-908 practice exam! Get yourself well prepared for the Oracle Database Hotest 1z0-908 practice MySQL 8.0 Database Administrator exam is really a hard job. But don’t worry! We We, provides the most update 1z0-908 exam questions. With We latest 1z0-908 braindumps, you’ll pass the Oracle Database Hotest 1z0-908 study guide MySQL 8.0 Database Administrator exam in an easy way
We Geekcert has our own expert team. They selected and published the latest 1z0-908 preparation materials from Official Exam-Center.
The following are the 1z0-908 free dumps. Go through and check the validity and accuracy of our 1z0-908 dumps.Real questions from 1z0-908 free dumps. Download demo of 1z0-908 dumps to check the validity.
Question 1:
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_flush_log_at_trx_commit=1
B. buffer_pool_size=24G
C. innodb_log_file_size=1G
D. sync_binlog=0
E. innodb_doublewrite=0
F. max_connections=10000
G. innodb_undo_directory=/dev/shm
Correct Answer: ACF
Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-foramazon-rds-for-mysql-part-1-parameters-related-to-performance/
Question 2:
Which statement is true about InnoDB persistent index statistics?
A. Updating index statistics is an I/O expensive operation.
B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
F. Tables are scanned and index statistics recalculated when an instance is restarted.
Correct Answer: D
Reference: https://mariadb.com/kb/en/innodb-persistent-statistics/
Question 3:
Examine the modified output:
Seconds_Behind_ Master value is steadily growing.
What are two possible causes? (Choose two.)
A. The master is most probably too busy to transmit data and the slave needs to wait for more data.
B. One or more large tables do not have primary keys.
C. This value shows only I/O latency and is not indicative of the size of the transaction queue.
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.
Correct Answer: CD
Question 4:
You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of –ssl-mode will do this?
A. PREFERRED
B. VERIFY_CA
C. REQUIRED
D. VERIFY_IDENTITY
Correct Answer: C
Reference: https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/apigateway/10-0/install-configure-upgrade/enable-ssl-connections-for-mysql.html
Question 5:
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
A. installing and configuring the Connection Control plugin
B. avoiding concatenation of SQL statements and user-supplied values in an application
C. using stored procedures for any database access D. using PREPARED STATEMENTS
Correct Answer: C
Reference: https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql-injectionattacks/
Question 6:
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 found the mysqld service disabled and failed to start it.
D. systemd waited for 30 seconds before timing out and start up failed.
E. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
Correct Answer: E
Question 7:
Examine these entries from the general query log:
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
A. Connection 24 experiences a lock wait timeout.
B. Connection 25 experiences a lock wait timeout.
C. A deadlock occurs immediately.
D. All statements execute without error.
E. A deadlock occurs after innodb_lock_wait_timeout seconds.
Correct Answer: E
Question 8:
Examine this command, which executes successfully:
$ mysqlrouter –bootstrap [email protected]:port –directory=directory_path
Which activity is performed?
A. MySQL Router is configured based on the information in files in directory_path.
B. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
C. MySQL Router is restarted.
D. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
Correct Answer: B
Reference: https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html
Question 9:
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. Roll back the transaction and start the transaction again in the same session.
B. Re-execute the failed statement in your transaction.
C. Change the default database and re-execute the failed statement in your transaction.
D. Close the connection, reconnect, and start the transaction again.
Correct Answer: B
Question 10:
Binary log events for the `mydb1\’ schema must be copied to a different schema name `mydb2\’. Which command will do this?
A. mysqlbinlog –rewrite-db=\’mydb1->mydb2\’ | mysql
B. mysqlbinlog –datebase=mydb1 –database=mydb2 | mysql
C. mysqlbinlog –rewrite-db=\’mydb1\’ –rewrite-db=\’mydb2\’ | mysql
D. mysqlbinlog –read-from-remote-server –raw | sed `s/mydb1/mydb2/g\’ | mysql
Correct Answer: D
Question 11:
Examine this MySQL Shell command: dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)
A. It reconfigures InnoDB Cluster if the cluster was stopped.
B. It performs InnoDB Cluster instances rolling restart.
C. It only starts all InnoDB Cluster instances.
D. It is not mandatory that all instances are running and reachable before running the command.
E. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
F. It only stops and restarts all InnoDB Cluster instances.
G. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
Correct Answer: BD
Question 12:
Which two statements are true about MySQL server multi-source replication? (Choose two.)
A. It is not compatible with auto-positioning.
B. It needs to be re-instanced after a crash to maintain consistency.
C. It uses only time-based replication conflict resolution.
D. It relies on relay_log_recovery for resilient operations.
E. It does not attempt to detect or resolve replication conflicts.
F. It must use GTID replication.
Correct Answer: CF
Question 13:
Which command enables rule-based MySQL Auditing capabilities?
A. shell> mysql < audit_log_filter_linux_install.sql
B. shell> mysqld –initialize –log-raw=audit.log
C. mysql> INSTALL PLUGIN audit_log;
D. mysql> INSTALL COMPONENT audit_log;
Correct Answer: A
Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html
Question 14:
Examine this SQL statement:
mysql> GRANT [email protected] TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
A. Mark can grant the privileges assigned to the [email protected] role to another user.
B. ADMIN OPTION causes the role to be activated by default.
C. Mark can grant the [email protected] role to another user.
D. Mark can revoke the [email protected] role from another role.
E. ADMIN OPTION allows Mark to drop the role.
F. Mark must connect from localhost to activate the [email protected] role.
Correct Answer: AE
Question 15:
You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running
Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)
A. Stop all instances except the primary read/write master instance and run the restore.
B. Remove the @@GLOBAL.gtid_purged statement from the dump file.
C. Create the backup by using the –set-gtid-purged=OFF option.
D. Remove the group replication plugin from each instance before restoring.
E. Remove the @@GLOBAL.gtid_executed statement from the dump file.
F. Restore using the –set-gtid-purged=OFF option.
Correct Answer: BC
Reference: https://scriptingmysql.wordpress.com/2013/07/18/mysql-creating-and-restoring-databasebackups-with-mysqldump-and-mysql-enterprise-backup-part-1-of-2/
