1z1-908 무료 덤프문제 온라인 액세스

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.Change the default database and re-execute the failed statement in your transaction.
• B.Close the connection, reconnect, and start the transaction again.
• C.Re-execute the failed statement in your transaction.
• D.Roll back the transaction and start the transaction again in the same session.

You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

• A.It creates a logical backup of all MySQL user accounts.
• B.It returns an error because the mysqldump command should have been used.
• C.It creates a logical backup of only the users database.
• D.It creates a logical backup of all metadata, but contains no table data.

Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?

• A.The relay logs from the master should be used to replace the corrupted relay logs.
• B.The slave needs to be restored from backup.
• C.The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
• D.The slave relay logs should be deleted; then execute START SLAVE;

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 of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
• B.Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
• C.Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
• D.Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
• E.Replication will work.

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

• A.mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
• B.mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
• C.mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
• D.mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql