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

質問 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 redo logs are not backed up at all.

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

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

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

（E）The archive tables are backed up first, then the transaction tables and redo logs.

正解：B 解答を投票する

質問 2

You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?

（A）PREFERRED

（B）VERIFY_CA

（C）REQUIRED

（D）VERIFY_IDENTITY

正解：C 解答を投票する

質問 3

Which two MySQL Server accounts are locked by default? (Choose two.)

（A）any user created without a password

（B）any new ROLE accounts

（C）any internal system accounts

（D）any user set as DEFINER for stored programs

（E）any user created with a username, but missing the host name

正解：C、D 解答を投票する

質問 4

You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

（A）Run mysqld with --datadir defined for each instance.

（B）Use resource groups to lock different instances on separate CPUs.

（C）Start mysqld or mysqld_safe using different option files for each instance.

（D）Run MySQL Server docker containers.

（E）Use systemd with different settings for each instance.

（F）Use system tools to lock each instance to its own CPU.

正解：A、C、E 解答を投票する

質問 5

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 master: --binlog-ignore-db=example

（C）on slave: --binlog-ignore-db=example

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

（E）on slave: --replicate-ignore-db=example

正解：A 解答を投票する

質問 6

Examine Joe's account:
CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'
GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'
All existing connections for joe are killed.
Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

（A）ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

（B）ALTER USER 'joe'@'%' PASSWORD HISTORY 0

（C）REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'

（D）ALTER USER 'joe'@'%' SET password='*invalid*'

（E）REVOKE USAGE ON *.* FROM 'joe'@'%'

（F）ALTER USER 'joe'@'%' ACCOUNT LOCK

正解：A、C 解答を投票する

質問 7

Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)

（A）SHOW STATUS;

（B）INFORMATION_SCHEMA.INNODB_TABLESTATS

（C）INFORMATION_SCHEMA.INNODB_METRICS

（D）INFORMATION_SCHEMA.STATISTICS

（E）SHOW ENGINE INNODB STATUS;

（F）SHOW TABLE STATUS;

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

質問 8

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

（A）dba.checkInstanceConfiguration()

（B）cluster.forceQuorumUsingPartitionOf()

（C）cluster.addInstance()

（D）dba.createCluster()

（E）dba.configureLocalInstance()

（F）dba.configureInstance()

（G）cluster.setPrimaryInstance()

正解：B、G 解答を投票する

質問 9

Which three are types of InnoDB tablespaces? (Choose three.)

（A）redo tablespaces

（B）data tablespaces

（C）schema tablespaces

（D）undo tablespaces

（E）encryption tablespaces

（F）temporary table tablespaces

正解：B、E、F 解答を投票する

質問 10

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

（A）GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
'tom'@'%';

（B）GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';

（C）GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';

（D）GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';

正解：A 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験