Pass 1z1-908 Exam in First Attempt Guaranteed 2021 Dumps!
1z1-908 Dumps Full Questions - Exam Study Guide
NEW QUESTION 30
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members
- A. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- B. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- C. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘; - D. SELECT email,passwd FROM members
- E. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- F. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;
Answer: A,D
NEW QUESTION 31
Which two MySQL Server accounts are locked by default? (Choose two.)
- A. any user created with a username, but missing the host name
- B. any user created without a password
- C. any internal system accounts
- D. any new ROLE accounts
- E. any user set as DEFINER for stored programs
Answer: C,E
NEW QUESTION 32
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 non-active binary logs are removed from the master.
- C. All databases, excluding master metadata, are backed up to the output file.
- D. All binary logs are deleted from the master.
- E. All binary logs are backed up and then deleted.
- F. All details regarding deleted logs and master metadata are captured in the output file.
Answer: C,D
NEW QUESTION 33
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 data.
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 34
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 keeps InnoDB metadata changes in .sdi files in datadir.
- B. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
- C. MySQL writes SDI to the binary log for distributed backups.
- D. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
- E. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.
Answer: B,D
NEW QUESTION 35
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
- A. MySQL Router is restarted.
- B. MySQL Router is configured based on the information in files in directory_path.
- C. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- D. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
Answer: C
NEW QUESTION 36
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?
- A. user_variables_by_thread
- B. global_variables
- C. variables_by_thread
- D. session_variables
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/worklog/task/?id=6629
NEW QUESTION 37
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 38
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. named pipes
- B. TCP/IP
- C. X Protocol
- D. SOCKET
- E. shared memory
- F. UDP
Answer: A,B,E
NEW QUESTION 39
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 40
Which three statements are true about MySQL replication? (Choose three.)
- A. Binary logs contain only transactions originating from a single MySQL instance.
- B. A replication user must have the SELECT privilege for all tables that need to be replicated.
- C. Each slave must have its own MySQL user for replication.
- D. Any instance can have multiple slaves, but it can have only one master.
- E. Replication can use only TCP/IP connections.
- F. Binary logging must be enabled on the master in order to replicate to other instances.
- G. Each instance in a replication topology must have a unique server ID.
Answer: B,F,G
NEW QUESTION 41
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 42
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 43
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. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
- B. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
- C. Set binlog_expire_logs_seconds in my.cnf.
- D. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
- E. Use PURGE BINARY LOGS to <binlog_name>.
- F. Use SET PERSIST binlog_expire_logs_seconds=<value>.
Answer: B,F
NEW QUESTION 44
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)
- A. NDB
- B. ARCHIVE
- C. InnoDB
- D. MyISAM
- E. MEMORY
Answer: D,E
NEW QUESTION 45
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 46
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. MySQL Enterprise Backup will automatically back up from an available slave.
- B. It guarantees near real-time replication between a master and a slave.
- C. You can scale writes by creating a replicated mesh.
- D. It allows backup to be done on the slave without impacting the master.
- E. You can scale reads by adding multiple slaves.
Answer: D,E
NEW QUESTION 47
Examine the modified output:
Seconds_Behind_ Mastervalue 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. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- C. The parallel slave threads are experiencing lock contention.
- D. One or more large tables do not have primary keys.
- E. The master is producing a large volume of events in parallel but the slave is processing them serially.
Answer: A,E
Explanation:
Explanation
NEW QUESTION 48
Which two statements are true about MySQL server multi-source replication? (Choose two.)
- A. It is not compatible with auto-positioning.
- B. It relies on relay_log_recovery for resilient operations.
- C. It does not attempt to detect or resolve replication conflicts.
- D. It must use GTID replication.
- E. It uses only time-based replication conflict resolution.
- F. It needs to be re-instanced after a crash to maintain consistency.
Answer: D,E
NEW QUESTION 49
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. A deadlock occurs after innodb_lock_wait_timeout seconds.
- C. A deadlock occurs immediately.
- D. All statements execute without error.
- E. Connection 25 experiences a lock wait timeout.
Answer: B
NEW QUESTION 50
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. PREFERRED
- B. VERIFY_CA
- C. VERIFY_IDENTITY
- D. REQUIRED
- E. DISABLED
Answer: D
NEW QUESTION 51
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 instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').
- C. The cluster is running and there is at least one ONLINE instance.
- 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').
Answer: B
NEW QUESTION 52
You plan to install MySQL Server by using the RPM download.
Which two statements are true? (Choose two.)
- A. You must manually initialize the data directory.
- B. You can provide the root password interactively.
- C. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.
- D. The functionality is split among several RPM package files.
- E. MySQL uses the RPM relocatable installation target feature.
- F. You can find the root password in the error log after the first start.
Answer: C,F
NEW QUESTION 53
Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)
- A. NDB
- B. ARCHIVE
- C. InnoDB
- D. MyISAM
- E. MEMORY
Answer: D,E
Explanation:
Explanation/Reference: https://zetcode.com/mysql/storageengines/
NEW QUESTION 54
......
MySQL Database Administration Free Certification Exam Material from Prep4sureGuide with 86 Questions: https://www.prep4sureguide.com/1z1-908-prep4sure-exam-guide.html
Use Real 1z1-908 - 100% Cover Real Exam Questions: https://drive.google.com/open?id=1Qg0uKDouv44Gg9sPd-7Qm-OsQO32VYdy