Get Latest [Sep-2021] Conduct effective penetration tests using Fast2test 1Z0-908
Penetration testers simulate 1Z0-908 exam PDF
NEW QUESTION 36
Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)
- A. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';
- B. SELECT * FROM information_schema.COLUMN_STATISTICS;
- C. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- D. DESCRIBE manufacturing.parts;
- E. SHOW INDEXES FROM manufacturing.parts;
Answer: A,B
NEW QUESTION 37
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 38
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 39
Which two statements are true about the mysql_config_editor program? (Choose two.)
- A. It provides an interface to change my.cnf files.
- B. It can move datadir to a new location.
- C. It will use [client] options by default unless you provide --login-path.
- D. It manages the configuration of client programs.
- E. It manages the configuration of the MySQL Firewall feature.
- F. It can be used to create and edit SSL certificates and log locations.
- G. It manages the configuration of user privileges for accessing the server.
Answer: C,D
NEW QUESTION 40
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)
- A. InnoDB tablespaces outside the datadir are able to be cloned.
- B. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
- C. It is always slower than {recoveryMethod: 'incremental'}.
- D. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
- E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
- F. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
Answer: B,C,F
NEW QUESTION 41
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
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION 42
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
- B. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
- C. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
- D. Execute SET GLOBAL log_error = '<new error log file>'.
Answer: B
NEW QUESTION 43
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 44
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 public_key.pemfile.
- B. Change the parent directory owner and group to mysql.
- C. Remove world read privileges from the server-cert.pemcertificate file.
- D. Remove group read/write privileges from the private_key.pemfile.
- E. Change the group ownership of the mysqldirectory to the mysqluser group.
- F. Remove the world read/execute privilege from the accountingdirectory.
Answer: B,E
NEW QUESTION 45
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. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
- C. 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.
- D. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- E. A manual intervention to force group members to be only the working two instances is required.
Answer: A,B
NEW QUESTION 46
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 COMPONENT audit_log;
- D. mysql> INSTALL PLUGIN audit_log;
Answer: A
NEW QUESTION 47
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 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
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It supports only non-blob datatypes.
- B. It supports all indexes transparently.
- C. It enforces encryption from disk to memory and over network transmission.
- D. It decrypts data for use in memory.
- E. It does not support the transportable tablespaces feature.
Answer: B,D
NEW QUESTION 50
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?
RESET MASTER;
- A. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- - B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- C. bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - D. SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - E. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER;
Answer: D
NEW QUESTION 51
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 52
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. *.ibd files
- B. *.sdi files
- C. *.CSM files
- D. ibbackup files
- E. ib_logfile* files
Answer: A,E
NEW QUESTION 53
Examine this statement, which executes successfully:
You want to improve the performance of this query:
Which change enables the query to succeed while accessing fewer rows?
- A. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
- B. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- C. ALTER TABLE world.city ADD INDEX (Name);
- D. ALTER TABLE world.city ADD INDEX (Population);
- E. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- F. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
Answer: B
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
NEW QUESTION 54
......
Tested Material Used To 1Z0-908 Test Engine: https://www.fast2test.com/1Z0-908-premium-file.html
Steps Necessary To Pass The 1Z0-908 Exam: https://drive.google.com/open?id=1GEtW4oPoIH62lNXYWmJkoVaYv5Rb8smk