[Q14-Q36] Verified 1Z1-921 dumps Q&As – Pass Guarantee Exam Dumps Test Engine [2025]

QUESTION 14
The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server.
Which statement is correct?

The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

MySQL Enterprise Monitor creates the required users automatically.

The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.

Monitoring metrics need super and root privileges because they are not available for a less-privileged user.

QUESTION 15
How would you restrict a user Joe from accessing all MySQL database objects?

CREATE USER ,joe’@,0.0.0.0, SET Password=PASSWORD(,% ! %,)

REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,;

UPDATE mysql.user SET Password=PASSWORD(,Invalid,) WHERE User=,joe’;

Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

CREATE USER , joe,@1′ %’ DENY ALL PRIVILEGES

QUESTION 16
Which two methods help prevent MySQL security risks?

Use a firewall to control access to MySQL ports.

Transmit plain (unencrypted) data over networks.

Ensure that MySQL accounts have short and easy passwords.

Allow unauthorized clients to connect to the server.

Use the secure installation script “mysql_alays_secure_installation”.

Grant only permissions that a user requires.

QUESTION 17
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database

A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

A browser-based wizard to remotely deploy the MySQL Monitor Agent

QUESTION 18
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?

On the Master server, disable binlog by removing the –log-bin option.

Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.

To safely purge binary log files, perform these steps:

Execute the purge binary logs statement without argument.

Delete all binlog files manually on the file system to release storage spaces.

QUESTION 19
Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

Allocating more CPU to the database instance to improve throughput performance.

Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.

Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.

Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.

Increasing the storage capacity so that the database can store more data to scale.

QUESTION 20
Which two statements are true about MySQL Enterprise Authentication?

MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.

MySQL Enterprise Authentication determines what operation the user can perform.

MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).

MySQL Enterprise Authentication supports Windows Active Directory.

MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..

QUESTION 21
Which three are characteristics of the JSON data type?

A set of SQL functions substantially support the SQL utilization of the data type.

It supports indexing directly against the JSON-defined column.

It validates the JSON syntax on insert or merge.

Comparisons of JSON values are not case-sensitive.

Key or array references enable quick read-access to look up document elements directly.

It is based on the TEXT data type.

QUESTION 22
Which of the following statements is true regarding MySQL user account privileges?
Response:

A user with the SUPER privilege can only read data from the database.

The GRANT option allows a user to revoke privileges from other users.

The USAGE privilege allows a user to connect to the MySQL server but grants no other privileges.

The RELOAD privilege allows a user to delete data from a table.

QUESTION 23
Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

Both the tables, t1 and t2, are created.

Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

Only the t2 table is created.

Only the t1 table is created.

QUESTION 24
An Oracle Cloud Infrastructure customer already has many database instances configured and running in the cloud; however, they are reporting that they are unable to create any more instances.
What could be the problem?

The customer does not have proper user rights.

The customer reached the database instance limit of 32.

The customer account might have reached resource quota/limits.

The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to-date.

QUESTION 25
When should you perform a backup in a MySQL database?
Response:

Only during scheduled maintenance windows.

After critical data updates or before making significant changes to the database.

After every successful query execution.

Only when the database size exceeds a certain limit.

QUESTION 26
Which statement adds a column with the largest integer data type?

ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;

ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;

ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);

ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);

QUESTION 27
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?

Flash-archive recovery area

Cloud storage only

Cloud tape library

Both Cloud storage and local storage

QUESTION 28
You execute this statement:
SELECT NULL=NULL;
What is the result?

FALSE

NULL

0

TRUE

1

QUESTION 29
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?

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.

Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.

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.

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.

QUESTION 30
Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

MySQL Enterprise Monitor and MySQL Audit

MySQL Workbench and MySQL Enterprise Firewall

MySQL Audit and MySQL Workbench

SQL Enterprise Monitor and MySQL Enterprise Authentication

QUESTION 31
Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

MySQL Servers with Group Replication to replicate data to all members of the cluster.

MySQL Online Hot Backup to keep data consistent and always ready to be used.

MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.

MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.

MySQL Router to ensure client requests are load balanced and routed to the correct servers.

QUESTION 32
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?

–uncompress-and-apply-log

–apply-log-and-copy-back

–copy-back-and-apply-log

–uncompress

–decompress

QUESTION 33
Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

creating e-mail alerts and SNMP traps for MySQL warnings

starting and stopping the MySQL instance

analyzing executed MySQL queries

deploying MySQL agent on supported target operating system

monitoring the availability of the MySQL Instance

tracing import and export with mysqldump

QUESTION 34
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?