Oracle MySQL 2021 Implementation Essentials - 1Z0-921 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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 *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,) B. CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,; C. CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE; D. CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired) E. CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE

Discussion 0

Correct Answer: D Vote an answer

Question 2

What three are ways to export and import data in MySQL Workbench?

A. SQL Data Export and Import Wizard B. Result Data Export and Import C. Backup Data Export and Import Wizard D. Table Data Export and Import Wizard E. Data Modeling Import Export Wizard F. Binary Data Export and Import Wizard

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 3

Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:

A. MySQL Dashboard B. MySQL Advisors C. Query Analyzer D. MySQL Query Analyzer

Discussion 0

Correct Answer: D Vote an answer

Question 4

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

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

Discussion 0

Correct Answer: D Vote an answer

Question 5

You have created your Compute instance using an Oracle-provided Oracle Linux image.
You want to log in to your OCI Compute instance using SSH. Which three items do you need for this process?

A. The root user B. SSH public key C. User Password D. Public IP address E. The opc user F. SSH private key

Discussion 0

Correct Answer: E Vote an answer

Question 6

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 Workbench and MySQL Enterprise Firewall C. MySQL Enterprise Monitor and MySQL Audit D. MySQL Audit and MySQL Workbench

Discussion 0

Correct Answer: A Vote an answer

Question 7

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?

A. 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. B. MySQL Enterprise Backup does not back up system data so that it is much faster. C. 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. D. 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. E. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

Discussion 0

Correct Answer: D,E Vote an answer

Question 8

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

A. 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. B. It provides multi-master access where the application can write and read data across the database servers. C. MySQL Enterprise Backup will back up from Slave automatically. D. It allows backup to be done on the slave without impacting the master. E. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.

Discussion 0

Correct Answer: A,C,D Vote an answer