Master 2021 Latest The Questions MySQL Database Administration and Pass 1Z0-908 Real Exam!
Penetration testers simulate 1Z0-908 exam PDF
NEW QUESTION 35
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Use resource groups to lock different instances on separate CPUs.
- B. Start mysqld or mysqld_safe using different option files for each instance.
- C. Use systemd with different settings for each instance.
- D. Use system tools to lock each instance to its own CPU.
- E. Run MySQL Server docker containers.
- F. Run mysqld with --datadir defined for each instance.
Answer: B,C,F
NEW QUESTION 36
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 37
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 38
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is a row-level lock.
- B. The lock is at the metadata object level.
- C. The lock is an exclusive lock.
- D. The lock is an intentional lock.
- E. The lock is at the table object level.
- F. The lock is a shared lock.
Answer: C,E
NEW QUESTION 39
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 40
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 41
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. VERIFY_IDENTITY
- D. REQUIRED
Answer: D
NEW QUESTION 42
Examine this command, which executes successfully:
mysqlpump --user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
- A. information_schema
- B. employee
- C. mysql
- D. world
- E. sys
Answer: A,E
NEW QUESTION 43
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 44
Which two queries are examples of successful SQL injection attacks? (Choose two.)
- A. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--'; - B. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- C. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
- D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- E. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- F. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--';
Answer: B,F
NEW QUESTION 45
Examine this SQL statement:
Which set of privileges will allow Tom to execute this SQL statement?
- A. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%'; - B. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
- C. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO 'tom'@'%';
- D. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';
Answer: C
NEW QUESTION 46
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 47
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 48
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 49
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 50
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 51
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 52
......
Penetration testers simulate 1Z0-908 exam: https://www.actual4cert.com/1Z0-908-real-questions.html
Bestselling On-The-Job Reference Exam Questions: https://drive.google.com/open?id=1btaiZ3NetvCunzScgG2bHg-6EMJikIYs