The Best 1Z0-921 Exam Study Material Premium Files and Preparation Tool (Mar-2025) [Q46-Q65] – IT Certification Exam Questions & Answers

5/5 - (1 vote)

The Best 1Z0-921 Exam Study Material Premium Files and Preparation Tool (Mar-2025)

Get Instant Access to 1Z0-921 Practice Exam Questions

NO.46 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?

CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY ‘SecretPass123!,;

CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;

CREATE USER ,jenny,@’%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE

CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)

CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)

NO.47 You execute this statement:
SELECT NULL=NULL;
What is the result?

FALSE

NULL

TRUE

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

Implementing a three-node, single-primary InnoDB Cluster.

Edit the configuration file and increase the value for parallel_read_workers and reboot the server

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

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

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

NO.49 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.

NO.50 Which two are advantages of using Document Store in MySQL?

MySQL provides a NoSQL API to access the document store

MySQL can store XML as a schema-less database

MySQL is a document database allowing PDF and Word documents

MySQL provides a native data type to index PDF documents

MySQL provides a native data type to store JSON data as a document

NO.51 Which MySQL command is used to grant specific privileges to a user on a database?
Response:

GRANT

GIVE ACCESS

SET PRIVILEGES

GRANT PERMISSIONS

NO.52 Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

The number of machines per group must be 3, 5, 7 or 9.

use SSD,s for data and replication logs

Groups must be in even numbers; 2, 4, 6, 8.

isolated machine resources

Use Network-attached storage (NAS) for the data files.

smaller VM,s work best – with a maximum of eight vCPU,s and 16GB of RAM

Networks must be in separate regions.

NO.53 Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

Native Windows services

authentication via Pluggable Authentication Modules (PAMs)

Simple Authentication and Security Layer

SECURID authentication and authorization identity

authentication using SHA-256 password hashing

connections through the local host via the UNIX socket file

NO.54 What SQL keyword must be specified when creating a foreign key constraint?

a TRIGGER on the child table for cascading delete statements

a REFERENCES in the child table to the parent table

unique PRIMARY key values for both child and parent tables

the SET_FOREGIN variable in the my .cnf file

an index on the foreign key

NO.55 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?

The root password is not given and is blank. You must manually set the root password.

The root password inserted in the error log set by the –log-error=[file_name] variable

The root password displayed on the screen via a [warning] message.

The root_pw variable stored in the mysq1.install table.

As root, execute the show password command by using the SHA-256 password encryption plug-in.

NO.56 You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH) For accessing a new MySQL Enterprise Edition on an Oracle Cloud Infrastructure (OCI) Instance you ” Add SSH key ” information during the OCI instance setup. You want to use Putty from your Windows Client to install MySQL.
What are the correct steps to accomplish this?

Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.

Use the provided private key for authentication.

Convert the private key to ppk format first and use the new private key for authentication.

Open Port 22 on your OCI Instance and configure Putty with the ssh private key.

NO.57 Which three options are valid reasons for using a primary key in a table?

increasing performance when using select statements

exporting data faster with mysqldump

preventing duplicate keys

to make it easier to change the PRIMARY KEY value

automatic storage of data in a sorted order

maintaining a history of row insertions or updates

NO.58 An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

MySQL Enterprise Backup does not back up system data so that it is much faster.

MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.

mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.

mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.

mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

NO.59 Which two statements are true about MySQL Enterprise Firewall?

On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

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.

MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.

System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network’s primary domain.

NO.60 What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

Data is encrypted automatically, in real time, after it is written to storage.

Enables data-at-rest encryption by encrypting the physical files of the database.

Encryption key is stored in a centralized key memory location

Tablespace keys are managed manually behind the scenes.

NO.61 Which three are requirements for MySQL Group Replication (GR)?

Data to be replicated must be stored in the InnoDB transactional storage engine.

The use of global transaction identifiers is required.

Primary keys are required on every replicated table.

GR only works with MySQL versions 8.0.12 or higher.

The binary log format must be set to mixed.

The minimum number of required nodes for achieving a consensus is two.

NO.62 Which two statements about the download of MySQL Enterprise Backup are correct?

MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).

MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.

MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.

MySQL Enterprise Backup comes with all MySQL editions including community edition.

MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.

NO.63 What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

Browser pop-ups

Direct support call from an Oracle representative

SMS-notification tab on the dashboard

Application-to-application messaging

NO.64 You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.

Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.

Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

Go to the configuration section (MEM) and configure the default login credentials.

NO.65 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.

Loading …

Oracle 1Z0-921 (MySQL 2021 Implementation Essentials) Certification Exam is designed for professionals who are seeking to validate their expertise in implementing and managing MySQL databases. MySQL 2021 Implementation Essentials certification is recognized worldwide and demonstrates that an individual has the knowledge and skills required to design, install, and maintain MySQL databases. 1Z0-921 exam covers a wide range of topics, including MySQL architecture, installation and configuration, security, backup and recovery, performance tuning, and high availability solutions.

Oracle 1Z0-921 (MySQL 2021 Implementation Essentials) Exam is a certification exam designed to test the knowledge and skills of database administrators and developers in implementing and managing MySQL databases. 1Z0-921 exam covers a wide range of topics, including database architecture, installation and configuration, backup and recovery, security, performance tuning, and troubleshooting. Passing 1Z0-921 exam demonstrates that a candidate has a strong understanding of MySQL and can effectively manage and maintain MySQL databases in a production environment.

Validate your Skills with Updated 1Z0-921 Exam Questions & Answers and Test Engine: https://www.it-tests.com/1Z0-921.html