1z0-908-整理v1.pdf - 墨天轮文档

1z0-908-整理v1.pdf

刀马

147页

2次

2025-07-12

免费下载

Untitled Exam

Number: 000-000

Passing Score: 800

Time Limit: 120 min

File Version: 1.0

Exam A

QUESTION 1

Examine this command, which executes successfully:

mysqlbackup --user=dba --password --port=3306 --with-timestamp --backup-dir=/export/backups backup-

and-apply-log

Which statement is true?

A. The backup accesses the MySQL server files by using a pre-existing connection

B. The database server is put into a read-only state for the duration of the backup.

C. An offline backup of InnoDB tables is taken.

D. The backup can be impacted when DDL operations run during the backup.

Correct Answer: D

Section: (none)

Explanation

Explanation/Reference:

错误不会使用预先存在的连接，而是通过提供的凭据（、、）建立新的

A) – MEB “ ” --user --password --port

连接。

MySQL

错误备份期间数据库保持读写状态（热备份）。仅短暂锁定以确保一致性，但不会将服务器设为只

B) – MEB

读。

错误这不是离线备份。执行的是在线备份（表在备份期间仍可访问）。

C) – backup-and-apply-log InnoDB

正确操作（如、）在备份期间运行时可能导致备份不一致或失败。

D) – DDL ALTER TABLE DROP TABLE

会使用锁来减少问题，但无法完全阻止语句的影响。

MEB DDL

热备份

命令是的一部分组件，允许您备份正在运行的实例（包括

mysqlbackup MySQL Enterprise Backup MySQL

表），同时将对作，同时生成数据库的一致快照。当复制表时，对表的读取和写入可以继续。

mysqlbackup

还可以创建压缩的备份文件，并备份表的子集和数据库。结合二进制日

MySQL Enterprise Backup MySQL

志，用户可以执行时间点恢复。是的一部分企业订阅。有关更多详细信

MySQL Enterprise Backup MySQL

息，请参阅概述。

MySQL Enterprise Backup InnoDBInnoDBInnoDB

https://dev.mysql.com/doc/mysql-backup-excerpt/8.0/en/innodb-backup.html

QUESTION 2

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:

Master:

Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-321,

bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-50,

Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Gtids_purged: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-100,

bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-10,

cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Slave:

Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-160,

cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-70,

cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Which statement is true?

of 147

免费下载

mysql ocp

关注

评论