[2025年04月]更新の1Z0-921試験問題集合格させるのは2025年最新のMySQL 2021 Implementation Essentials [Q10-Q34]

[2025年04月]更新の1Z0-921試験問題集合格させるのは2025年最新のMySQL 2021 Implementation Essentials

無料で使える1Z0-921試験問題集で合格させるお手軽に試験合格

質問 # 10
You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Which two are possible reasons for this problem?

• A. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• B. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• C. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
• D. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
• E. The MASTER and SLAVE are grouped as one instance for monitoring.

正解：B、E

質問 # 11
Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

• A. MySQL Enterprise Data Masking and De-identification
• B. MySQL Enterprise Transparent Data Encryption (TDE)
• C. MySQL Enterprise No-Login Authentication
• D. MySQL Enterprise Audit
• E. MySQL Enterprise Scalability

正解：A

質問 # 12
You are using the innoDB engine and the innodb_f ile_per_table option is set.
You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory.
What will happen to the inventory table?

• A. The table statistics will be stored.
• B. The table will be checked for errors and repaired.
• C. The table will be optimized and replicated.
• D. The table storage space will be reduced.

正解：C

質問 # 13
Which Oracle product is certified to work with MySQL Enterprise Edition?

• A. Oracle Enterprise Backup
• B. Oracle Data Pump
• C. Oracle Application Express
• D. Oracle Enterprise Manager

正解：D

質問 # 14
Which two statements are true about MySQL Enterprise Firewall?

• A. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• B. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
• C. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.
• D. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• E. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
• F. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.

正解：B、D

質問 # 15
Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

• A. You forgot to create the correct SSL/TLC certificate during the setup process.
• B. The OCI instance is still in the "creation" process.
• C. You forgot to enable port 3306.
• D. The opc user can be used to access MySQL only with the created SSH-Key.
• E. Only root is allowed to access from non-localhost.

正解：C

質問 # 16
What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

• A. Encryption key is stored in a centralized key memory location
• B. Enables data-at-rest encryption by encrypting the physical files of the database.
• C. Data is encrypted automatically, in real time, after it is written to storage.
• D. Tablespace keys are managed manually behind the scenes.

正解：B

質問 # 17
Which is true about inserting an additional line in a single document stored in MySQL document store?

• A. You specify the new element,s position in the JSON_ARRAY_INSERT statement.
• B. The path specified must be an array position past the end of an array using the JSON_POSITION statement.
• C. You cannot insert a single line, you have to replace the entire document with a new document.
• D. Any new lines can only be inserted at the end of the document.

正解：A

質問 # 18
When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?

• A. Cloud storage only
• B. Both Cloud storage and local storage
• C. Flash-archive recovery area
• D. Cloud tape library

正解：A、B

質問 # 19
Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

• A. MySQL Servers with Group Replication to replicate data to all members of the cluster.
• B. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.
• C. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.
• D. MySQL Router to ensure client requests are load balanced and routed to the correct servers.
• E. MySQL Online Hot Backup to keep data consistent and always ready to be used.

正解：A、B、D

質問 # 20
Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

• A. SQL Enterprise Monitor and MySQL Enterprise Authentication
• B. MySQL Audit and MySQL Workbench
• C. MySQL Workbench and MySQL Enterprise Firewall
• D. MySQL Enterprise Monitor and MySQL Audit

正解：A

質問 # 21
Which statement will display the status of the partitioning plug-in?

• A. SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';
• B. SHOW PLUGINS WHERE Name= 'partition';
• C. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';
• D. USE SYS SCHEMA; SHOW PLUGINS STATUS;

正解：C

質問 # 22
The user 'fwuser'@'localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?

• A.
• B.
• C.

正解：C

質問 # 23
Which two statements are true about MySQL Enterprise Authentication?

• A. MySQL Enterprise Authentication determines what operation the user can perform.
• B. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
• C. MySQL Enterprise Authentication supports Windows Active Directory.
• D. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
• E. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).

正解：C、E

質問 # 24
Which activity will take place if a table is created with both the compression and encryption options?

• A. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.
• B. The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.
• C. The compression is performed before tablespace data is encrypted.
• D. The tablespace data is encrypted first and then compression is performed.

正解：C

質問 # 25
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.

正解：B

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

• A. You can connect directly to the VCN without a define subnet.
• B. You must have an IPSec VPN to connect to an Oracle Linux instance.
• C. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.
• D. Your instance does not have a public IP address, so you cannot connect with a public subnet.
• E. You can connect directly to an instance over the internet, without a public IP address.

正解：A、E

質問 # 27
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. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
• B. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
• C. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
• D. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

正解：A、C

質問 # 28
Which two deployment architectures could you use for scaling-out database reads?

• A. Altering the storage engine for all tables to memory to increase performance.
• B. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.
• 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. Edit the configuration file and increase the value for parallel_read_workers and reboot the server

正解：A、C

質問 # 29
You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

• A. Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;
• B. Execute the sakila-data. sqi script to populate the database
• C. Use mysqldump to import data from the sakila_dummy database sample data set.
• D. Use MySQL Enterprise High Availability to access one of the available data tables

正解：A

質問 # 30
Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

• A. Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.
• B. Increasing the storage capacity so that the database can store more data to scale.
• C. Allocating more CPU to the database instance to improve throughput performance.
• D. Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.
• E. Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.

正解：B

質問 # 31
How would you restrict a user Joe from accessing all MySQL database objects?

• A. UPDATE mysql.user SET Password=PASSWORD(,Invalid,) WHERE User=,joe';
• B. CREATE USER ,joe'@,0.0.0.0, SET Password=PASSWORD(,% ! %,)
• C. CREATE USER , joe,@1' %' DENY ALL PRIVILEGES
• D. Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.
• E. REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,;

正解：D

質問 # 32
You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

• A.
• B.
• C.
• D.
• E.

正解：B

質問 # 33
Which three are characteristics of the JSON data type?

• A. It supports indexing directly against the JSON-defined column.
• B. A set of SQL functions substantially support the SQL utilization of the data type.
• C. It validates the JSON syntax on insert or merge.
• D. Comparisons of JSON values are not case-sensitive.
• E. Key or array references enable quick read-access to look up document elements directly.
• F. It is based on the TEXT data type.

正解：A、C、E

質問 # 34
......

Oracle 1Z0-921認定試験に合格するには、候補者はMySQLデータベースの実装に関連するさまざまなトピックの習熟度を示す必要があります。これらのトピックには、MySQLサーバーの構成、データベースの設計と作成、データ型と構造、SQLクエリの最適化、バックアップとリカバリ、セキュリティ、トラブルシューティングが含まれます。この試験は、105分以内に完了する必要がある70の複数選択の質問で構成されています。

 

1Z0-921試験問題集、1Z0-921練習テスト問題：https://www.passtest.jp/Oracle/1Z0-921-shiken.html

無料1Z0-921学習ガイド試験問題と解答：https://drive.google.com/open?id=1_TLyX53cjlpJGYOjbRz6njj-Z1CHPvuv