Pass Your Exam Easily! 1Z0-921 Real Question Answers Updated on Apr 25, 2025
Actual Questions Answers Pass With Real 1Z0-921 Exam Dumps
NEW QUESTION # 17
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?
- A. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
- B. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
- C. A browser-based wizard to remotely deploy the MySQL Monitor Agent
- D. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
- E. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
Answer: B,D,E
NEW QUESTION # 18
Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:
- A. MySQL Query Analyzer
- B. MySQL Dashboard
- C. Query Analyzer
- D. MySQL Advisors
Answer: A
NEW QUESTION # 19
The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?
- A. To safely purge binary log files, perform these steps:
- B. Delete all binlog files manually on the file system to release storage spaces.
- C. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
- D. Execute the purge binary logs statement without argument.
- E. On the Master server, disable binlog by removing the --log-bin option.
Answer: A,C
NEW QUESTION # 20
Which statement would you use to remove the population column from the city table?
- A. ALTER TABLE city LESS population;
- B. DELETE population FROM city;
- C. ALTER TABLE city DELETE population;
- D. ALTER TABLE city DROP population;
- E. DROP population FROM city;
Answer: D
NEW QUESTION # 21
Which MySQL Enterprise Edition plug-in replaces real values with substitutes?
- A. MySQL Enterprise No-Login Authentication
- B. MySQL Enterprise Transparent Data Encryption (TDE)
- C. MySQL Enterprise Audit
- D. MySQL Enterprise Scalability
- E. MySQL Enterprise Data Masking and De-identification
Answer: E
NEW QUESTION # 22
Which three are requirements for MySQL Group Replication (GR)?
- A. The use of global transaction identifiers is required.
- B. GR only works with MySQL versions 8.0.12 or higher.
- C. Data to be replicated must be stored in the InnoDB transactional storage engine.
- D. The binary log format must be set to mixed.
- E. The minimum number of required nodes for achieving a consensus is two.
- F. Primary keys are required on every replicated table.
Answer: C,D,F
NEW QUESTION # 23
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 MASTER and SLAVE are grouped as one instance for monitoring.
- 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 mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
Answer: A,B
NEW QUESTION # 24
Which two statements are true about MySQL Enterprise Authentication?
- A. MySQL Enterprise Authentication supports Windows Active Directory.
- B. MySQL Enterprise Authentication determines what operation the user can perform.
- C. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
- D. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
- E. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
Answer: A,D
NEW QUESTION # 25
When should you perform a backup in a MySQL database?
Response:
- A. Only when the database size exceeds a certain limit.
- B. Only during scheduled maintenance windows.
- C. After every successful query execution.
- D. After critical data updates or before making significant changes to the database.
Answer: D
NEW QUESTION # 26
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 Enterprise Monitor and MySQL Audit
- C. MySQL Audit and MySQL Workbench
- D. MySQL Workbench and MySQL Enterprise Firewall
Answer: A
NEW QUESTION # 27
You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?
- A. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
- B. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.
- C. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
- D. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
Answer: B
NEW QUESTION # 28
Which activity will take place if a table is created with both the compression and encryption options?
- A. The compression is performed before tablespace data is encrypted.
- B. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.
- C. The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.
- D. The tablespace data is encrypted first and then compression is performed.
Answer: A
NEW QUESTION # 29
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 will be checked for errors and repaired.
- B. The table will be optimized and replicated.
- C. The table statistics will be stored.
- D. The table storage space will be reduced.
Answer: B
NEW QUESTION # 30
Which four authentication protocols are allowed when using MySQL Enterprise Authentication?
- A. authentication via Pluggable Authentication Modules (PAMs)
- B. Native Windows services
- C. SECURID authentication and authorization identity
- D. connections through the local host via the UNIX socket file
- E. Simple Authentication and Security Layer
- F. authentication using SHA-256 password hashing
Answer: A,B,D,F
NEW QUESTION # 31
You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?
- A. audit-log=FORCE_PLUS_PERMANENT
- B. LOAD PLUGIN=AUDIT_LOG
- C. audit_log_permanent=ON
- D. plugin-audit=ON, ALWAYS
- E. plugin-load=audit_log.so
Answer: A,C
NEW QUESTION # 32
The slave connects to the master and asks for updated records. What command was issued for this to happen?
- A. SLAVE START
- B. START SLAVE
- C. START RUN SLAVE
- D. SLAVE RUN
- E. RUN SLAVE
Answer: A
NEW QUESTION # 33
Which statement is used to create a new MySQL database?
Response:
- A. CREATE SCHEMA
- B. CREATE DATABASE
- C. CREATE TABLE
- D. NEW DATABASE
Answer: B
NEW QUESTION # 34
You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for 'test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?
- A. The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.
- B. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.
- C. The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.
- D. The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.
Answer: A
NEW QUESTION # 35
Which statement will display the status of the partitioning plug-in?
- A. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';
- B. SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';
- C. USE SYS SCHEMA; SHOW PLUGINS STATUS;
- D. SHOW PLUGINS WHERE Name= 'partition';
Answer: A
NEW QUESTION # 36
You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?
- A. CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE
- B. CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;
- C. CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;
- D. CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)
- E. CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)
Answer: E
NEW QUESTION # 37
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. Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.
- C. REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,;
- D. CREATE USER , joe,@1' %' DENY ALL PRIVILEGES
- E. CREATE USER ,joe'@,0.0.0.0, SET Password=PASSWORD(,% ! %,)
Answer: B
NEW QUESTION # 38
After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?
- A. The root password inserted in the error log set by the --log-error=[file_name] variable
- B. As root, execute the show password command by using the SHA-256 password encryption plug-in.
- C. The root password displayed on the screen via a [warning] message.
- D. The root_pw variable stored in the mysq1.install table.
- E. The root password is not given and is blank. You must manually set the root password.
Answer: B,D
NEW QUESTION # 39
You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?
- A. --copy-back-and-apply-log
- B. --uncompress
- C. --apply-log-and-copy-back
- D. --uncompress-and-apply-log
- E. --decompress
Answer: A,B
NEW QUESTION # 40
......
New 1Z0-921 Dumps - Real Oracle Exam Questions: https://passguide.dumpexams.com/1Z0-921-vce-torrent.html