최신 1Z0-908 무료덤프 - Oracle MySQL 8.0 Database Administrator

문제1

Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?

A. mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql

B. mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql

C. mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql

D. mysqlbinlog --stop-position=500324 binlog.000036 | mysql

정답: C

문제2

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 redo logs are backed up only if there are changes showing for the transactions tables.

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

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

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

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

정답: A

문제3

Which statement is true about InnoDB persistent index statistics?

A. Tables are scanned and index statistics recalculated when an instance is restarted.

B. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

C. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

D. Updating index statistics is an I/O expensive operation.

E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

F. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

정답: C

문제4

You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

A. It adds more temporary workspace in addition to the innodb_tmpdir location.

B. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

C. It defines all innodb tablespace options relative to a starting parent directory.

D. It allows scanning of other locations to discover more innodb tablespaces.

E. It is not necessary because innodb_data_home_dir is already defined.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제5

Which three are types of information stored in the MySQL data dictionary? (Choose three.)

A. view definitions

B. access control lists

C. server configuration rollback

D. server runtime configuration

E. InnoDB buffer pool LRU management data

F. stored procedure definitions

G. performance metrics

정답: A,D,G

문제6

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

B. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

C. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

정답: A

문제7

Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

A. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.

B. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

C. Physical upgrades are much faster because they do not require restarting the mysqld process.

D. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

E. Logical upgrades are much faster because they do not require restarting the mysqld process.

F. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.

정답: B,E

문제8

Examine this query and its output:

Which two statements are true? (Choose two.)

A. User bob had the largest total time waiting for locks.

B. The root user had the largest single wait time.

C. The root user had the largest number of modified rows for a SELECT statement.

D. The app user had the highest total number of rows read from storage engines.

E. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

정답: D,E

문제9

Which two statements are true about using backups of the binary log? (Choose two.)

A. Multiple binary logs can be applied in parallel for faster data restoration.

B. Multiple binary logs can be used to restore data.

C. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.

D. They allow for point-in-time recovery of the data.

E. Binary logs can always be used to unapply unwanted schema changes.

정답: D,E

문제10

Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

A. It is read and processed at the beginning of startup configuration.

B. This file is for storing MySQL server_uuid values only.

C. This file is for logging purposes only and is never processed.

D. It is always updated with changes to system variables.

E. It is read and processed at the end of startup configuration.

F. This file is for storing MySQL Server configuration options in ISON format.

정답: D,E

최신 1Z0-908 무료덤프 - Oracle MySQL 8.0 Database Administrator

우리와 연락하기

유용한 링크

최신 업데이트