1Z0-921無料問題集「Oracle MySQL 2021 Implementation Essentials」

質問 1

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

（A）MySQL Enterprise Backup will back up from Slave automatically.

（B）It provides multi-master access where the application can write and read data across the database servers.

（C）MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.

（D）You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

（E）It allows backup to be done on the slave without impacting the master.

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

質問 2

Which two deployment architectures could you use for scaling-out database reads?

（A）Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.

（B）Edit the configuration file and increase the value for parallel_read_workers and reboot the server

（C）Implementing a three-node, single-primary InnoDB Cluster.

（D）Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.

（E）Altering the storage engine for all tables to memory to increase performance.

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

質問 3

MySQL is installed on a Linux server with the configuration:
Which two methods can change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

（A）Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';

（B）Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

（C）Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

（D）Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';

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

質問 4

The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?

（A）

（B）

（C）

（D）

正解：A 解答を投票する

質問 5

What is Kubernetes in the context of MySQL?
Response:

（A）A database engine for MySQL.

（B）A cloud service provided by Oracle for MySQL databases.

（C）A database management tool for MySQL.

（D）An open-source container orchestration platform.

正解：D 解答を投票する

質問 6

Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

（A）MySQL Enterprise Transparent Data Encryption (TDE)

（B）MySQL Enterprise Data Masking and De-identification

（C）MySQL Enterprise Audit

（D）MySQL Enterprise No-Login Authentication

（E）MySQL Enterprise Scalability

正解：B 解答を投票する

質問 7

Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

（A）Your instance does not have a public IP address, so you cannot connect with a public subnet.

（B）You can connect directly to an instance over the internet, without a public IP address.

（C）You can connect directly to the VCN without a define subnet.

（D）You must have an IPSec VPN to connect to an Oracle Linux instance.

（E）You must have an Internet gateway to connect to a public address on an Oracle Linux instance.

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

質問 8

Which statement is used to create a new MySQL database?
Response:

（A）CREATE SCHEMA

（B）NEW DATABASE

（C）CREATE TABLE

（D）CREATE DATABASE

正解：D 解答を投票する

1Z0-921 無料問題集「Oracle MySQL 2021 Implementation Essentials」

弊社を連絡する

関連リンク

トップ試験