最新的MySQL Database Administration認證 1z1-908考試題庫

問題1

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup
--optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?

A. The transaction tables are backed up first, then the archive tables and redo logs.

B. The archive tables are backed up first, then the transaction tables and redo logs.

C. The redo logs are backed up first, then the transaction and archive tables.

D. The redo logs are not backed up at all.

E. The redo logs are backed up only if there are changes showing for the transactions tables.

正確答案: E

問題2

Examine this command, which executes successfully:

Which two statements are true? (Choose two.)

A. A raw backup is created.

B. The backup operation will finish only when apply-log is executed.

C. The --backup-dir option holds temporary output, status, and metadata files.

D. The backup operation will finish only when backup-and-apply-log is executed.

E. A single-file backup is created.

正確答案: B,C

問題3

Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?

A. It prevents the audit log from being removed or rotated.

B. It will force the load of the audit plugin even in case of errors at server start.

C. It causes the audit log to be created if it does not exist.

D. It prevents the audit plugin from being removed from the running server.

正確答案: D

問題4

An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage...
The instance 'host1:3377'' was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
The instance 'host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata. Please use the most up to date instance: 'host1:3377'.
(RuntimeError)
Which statement is true?

A. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).

B. The cluster is running and there is at least one ONLINE instance.

C. The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').

D. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').

E. The instance deployed on host3 must be rebuilt with a backup from the primary instance.

正確答案: D

問題5

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. DESCRIBE manufacturing.parts;

C. SHOW INDEXES FROM manufacturing.parts;

D. EXPLAIN SELECT INDEXES FROM manufacturing.parts;

E. SELECT * FROM information_schema.COLUMN_STATISTICS;

正確答案: A,E

問題6

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

A. doublewrite buffer

B. change buffer

C. InnoDB Data Dictionary

D. user privileges

E. table data

F. primary indexes

正確答案: A,C

問題7

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

A. They do not back up views, stored procedures, or configuration files.

B. They allow direct copying of table rows with operating system copy commands.

C. They do not use additional disk space.

D. There is a slight performance cost while the snapshot is active.

E. They work best for transaction storage engines that can perform their own recovery when restored.

F. They take roughly twice as long as logical backups.

G. The backup window is almost zero from the perspective of the application.

正確答案: A,C,E

最新的Oracle MySQL 8.0 Database Administrator - 1z1-908免費考試真題

最新更新

站內鏈接

聯系我們