1Z0-908試験無料問題集（142題）「Oracle MySQL 8.0 Database Administrator 認定」

出題：1

You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

A. on master: --replicate-ignore-db=example

B. on slave: --binlog-ignore-db=example

C. on master: --binlog-ignore-db=example

D. on slave: --replicate-wild-ignore=example.%

E. on slave: --replicate-ignore-db=example

正解：A 解答を投票する

出題：2

Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

正解：B,E 解答を投票する

出題：3

Examine this command, which executes successfully:

Which statement is true?

A. Only InnoDB data and log files are backed up.

B. Only non-encrypted files are backed up.

C. Only tables stored in their own tablespaces are backed up.

D. The backup includes only data files and their metadata.

E. Only files for MySQL or Its built-in storage engines are backed

正解：A 解答を投票する

出題：4

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 INDEX (Population);

B. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

C. ALTER TABLE world.city ADD SPATIAL INDEX (Name);

D. ALTER TABLE world.city ADD INDEX (Name);

E. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

F. ALTER TABLE world.city ADD SPATIAL INDEX (Population);

正解：A 解答を投票する

出題：5

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 --include-databases=% > full-backup-$(date +%Y%m$d).sql

B. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql

C. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which two methods allow a DBA to reset a user's password? (Choose two.)

正解：B,D 解答を投票する

出題：7

Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

A. Change the group ownership of the mysql directory to the mysql user group.

B. Remove the world read/execute privilege from the accounting directory.

C. Remove group read/write privileges from the private_key.pem file.

D. Remove world read privileges from the server-cert.pem certificate file.

E. Change the parent directory owner and group to mysql.

F. Remove world read privileges from the public_key.pem file.

正解：A,E 解答を投票する

出題：8

Which two are use cases of MySQL asynchronous replication? (Choose two.)

A. It allows backup to be done on the slave without impacting the master.

B. MySQL Enterprise Backup will automatically back up from an available slave.

C. You can scale writes by creating a replicated mesh.

D. It guarantees near real-time replication between a master and a slave.

E. You can scale reads by adding multiple slaves.

正解：A,E 解答を投票する

出題：9

Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

A. It fails if at least one of the roles does not exist.

B. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.

C. Existing connections can continue to use the roles' privileges until they reconnect.

D. It fails if any of the roles is specified in the mandatory_roles variable.

E. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.

F. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

正解：B,C 解答を投票する

出題：10

A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1.Confirm that secure_file_priv='/var/tmp'
2.mysql> DROP TABLE shop.customers;
3.shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)

A. mysql> SOURCE '/var/tmp/customers.sdi'

B. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi

C. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE

D. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE

E. shell> cp /backup/customers.sdi /var/tmp

F. shell> cp /backup/customers.frm /var/lib/mysql/shop/

G. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

H. shell> cp /backup/customers.sdi /var/lib/mysql/shop/

正解：B,D 解答を投票する

1Z0-908試験無料問題集「Oracle MySQL 8.0 Database Administrator 認定」