Free Oracle 1Z0-921 Exam Dumps Questions & Answers

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?

• A.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.
• B.MySQL Enterprise Monitor creates the required users automatically.
• C.Monitoring metrics need super and root privileges because they are not available for a less-privileged user.
• D.The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

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

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?

• A.Direct support call from an Oracle representative
• B.Application-to-application messaging
• C.SMS-notification tab on the dashboard
• D.Email
• E.Browser pop-ups

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?

• A.The customer account might have reached resource quota/limits.
• B.The customer reached the database instance limit of 32.
• C.The customer does not have proper user rights.
• D.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.

Which two statements are true about MySQL Enterprise Firewall?

• A.MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
• B.System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
• C.MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
• D.Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• E.On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• F.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.