최신 Oracle MySQL 1Z1-921 무료샘플문제:

1. 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)

2. 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)

3. How would you restrict a user Joe from accessing all MySQL database objects?

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

4. 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) Flash-archive recovery area
B) Cloud storage only
C) Both Cloud storage and local storage
D) Cloud tape library

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

질문과 대답: