Certification Training for 1z1-908 Exam Dumps Test Engine [2021]
Sep 25, 2021 Step by Step Guide to Prepare for 1z1-908 Exam
NEW QUESTION 39
A colleague complains about slow response time on your website.
Examine this query and output:
What is the most likely cause for the high number of lock waits?
- A. You use the InnoDB storage engine and statements wait while data is inserted.
- B. You use the MyISAM storage engine for most common tables.
- C. Your table accesses wait for the operating system level flush.
- D. The Innodb Buffer pool is full.
Answer: A
NEW QUESTION 40
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. Use the Clone Plugin to copy the data to another MySQL system.
- C. Take a logical backup of the MySQL system.
- D. Take a physical backup of the MySQL system.
Answer: C
NEW QUESTION 41
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 allows scanning of other locations to discover more innodb tablespaces.
- B. It adds more temporary workspace in addition to the innodb_tmpdir location.
- C. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
- D. It is not necessary because innodb_data_home_dir is already defined.
- E. It defines all innodb tablespace options relative to a starting parent directory.
Answer: D
NEW QUESTION 42
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
Answer: B
NEW QUESTION 43
Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)
- A. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
- B. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
- C. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.
- D. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
- E. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
Answer: D,E
NEW QUESTION 44
Examine this query:
What information does this query provide?
- A. total memory used across all connections associated with the user on thread number 10
- B. total memory used across all connections associated with the user on connection number 10
- C. total memory used by the first 10 connections
- D. total memory used by the first 10 threads
- E. total memory used by connection number 10
- F. total memory used by thread number 10
Answer: E
NEW QUESTION 45
Which two statements are true about using backups of the binary log? (Choose two.)
- A. They allow for point-in-time recovery of the data.
- B. Binary logs can always be used to unapply unwanted schema changes.
- C. Multiple binary logs can be used to restore data.
- D. Multiple binary logs can be applied in parallel for faster data restoration.
- E. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
Answer: A,B
NEW QUESTION 46
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. Re-execute the failed statement in your transaction.
- B. Change the default database and re-execute the failed statement in your transaction.
- C. Roll back the transaction and start the transaction again in the same session.
- D. Close the connection, reconnect, and start the transaction again.
Answer: A
NEW QUESTION 47
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /usr/mysql
- B. /etc/my.cnf
- C. /var/lib/mysql
- D. /usr/bin
- E. /usr
Answer: D
NEW QUESTION 48
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:
Which statement is true?
- A. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
- B. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- C. Replication will work.
- D. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- E. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
Answer: D
NEW QUESTION 49
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 = 1
- C. QN = 3
- D. QN = 5
- E. QN = 2
Answer: B,E
NEW QUESTION 50
Which three are characteristics of a newly created role? (Choose three.)
- A. It is created as a locked account.
- B. It can be protected with a password.
- C. It is stored in the mysql.roletable.
- D. It can be dropped using the DROP ROLEstatement.
- E. It can be granted to user accounts.
- F. It can be renamed using the RENAME ROLEstatement.
Answer: B,D,E
Explanation:
Explanation/Reference:
NEW QUESTION 51
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. The cluster will shut down to preserve data consistency.
- B. 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.
- C. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- D. A manual intervention to force group members to be only the working two instances is required.
- E. The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
Answer: A,E
NEW QUESTION 52
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. Create the backup by using the --set-gtid-purged=OFF option.
- C. Remove the group replication plugin from each instance before restoring.
- D. Remove the @@GLOBAL.gtid_executed statement from the dump file.
- E. Remove the @@GLOBAL.gtid_purged statement from the dump file.
- F. Restore using the --set-gtid-purged=OFF option.
Answer: B,E
NEW QUESTION 53
t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?
- A. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
- B. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
- C. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.
- D. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
Answer: A
NEW QUESTION 54
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
Answer: D
NEW QUESTION 55
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 executes flush tables with read lock.
- B. The backup created is a consistent data dump.
- C. It enforces consistent backups for all storage engines.
- D. This option uses the READ COMMITTED transaction isolation mode.
- E. It is a cold backup.
Answer: A,D
NEW QUESTION 56
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/.mysqlrc file
- B. $MYSQL_HOME/my.cnf file
- C. DATADIR/mysqld-auto.cnf file
- D. $HOME/.mylogin.cnf file
- E. $HOME/.my.cnf file
- F. $HOME/.mysql/auth/login file
- G. /etc/my.cnf file
Answer: B,C,G
NEW QUESTION 57
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. It restores files from the backup directory to their original MySQL server locations.
- B. The copy-back process is used to overwrite a new backup over an existing backup.
- C. The copy-back process makes inconsistent backups.
- D. It restores files from the data directory to their original MySQL server locations.
Answer: A,B
NEW QUESTION 58
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They contain events that describe only administrative commands run on the master.
- B. They are pulled from the master to the slave.
- C. They are pushed from the master to the slave.
- D. They contain events that describe all queries run on the master.
- E. They contain events that describe database changes on the master.
Answer: C,E
NEW QUESTION 59
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:
You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?
- A. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- C. RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - D. RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - E. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;
Answer: D
NEW QUESTION 60
You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)
- A. *.sdifiles
- B. ibbackupfiles
- C. *.CSMfiles
- D. ib_logfile*files
- E. *.ibdfiles
Answer: D,E
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/innodb-backup.html
NEW QUESTION 61
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)
- A. PIPE
- B. TCP
- C. DIRECT
- D. FILE
- E. IPv4
- F. MEMORY
- G. SOCKET
- H. IPv6
Answer: A,B,F,G
NEW QUESTION 62
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. using stored procedures for any database access
- B. installing and configuring the Connection Control plugin
- C. using PREPARED STATEMENTS
- D. avoiding concatenation of SQL statements and user-supplied values in an application
Answer: A
Explanation:
Explanation/Reference: https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql-injection-attacks/
NEW QUESTION 63
Examine these statements and output:
Which statement is true?
- A. The user is authorized as the accounting@localhostuser.
- B. The user is authorized as the rsmith@localhostuser.
- C. The user is logged in with --user=accountingas an option.
- D. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
- E. The user is authenticated as the anonymous proxy user ‘’@’%’.
Answer: B
NEW QUESTION 64
......
Ultimate Guide to Prepare 1z1-908 Certification Exam for MySQL Database Administration: https://www.validdumps.top/1z1-908-exam-torrent.html
MySQL Database Administration 1z1-908 Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=1vo6uE2_587wiR4L1ZAMmur4Ak4c0Oh4B