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

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

What does the binlog dump thread do?

• A.It monitors and schedules the rotation/deletion of the binary logs.
• B.It reads the relay log and executes the events contained in them.
• C.It connects to the master and asks it to send updates recorded in its binary logs.
• D.It acquires a lock on the binary log for reading each event to be sent to the slave.

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.RESET MASTER;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• C.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;
• 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;

User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)

• A.ALTER USER baduser@hostname PASSWORD DISABLED;
• B.ALTER USER baduser@hostname DEFAULT ROLE NONE;
• C.ALTER USER baduser@hostname ACCOUNT LOCK;
• D.ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
• E.ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

Which two statements are true about MySQL Enterprise Backup? (Choose two.)

• A.It supports backup of a remote MySQL system.
• B.It creates logical backups.
• C.It supports restoring to a remote MySQL system.
• D.It supports backing up only table structures.
• E.It supports the creation of incremental backups.
• F.It can perform hot or warm backups.