Oracle 1Z0-921 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| MySQL Security | 20% | - Data Masking and De-identification - Authorization and privilege management - Transparent Data Encryption (TDE) - Password policies and authentication - MySQL Enterprise Firewall - MySQL Enterprise Audit |
| MySQL Enterprise Monitor | 10% | - Features and benefits - Custom Advisors configuration - Query Analyzer usage - Architecture: Service Manager and Agents |
| Backup and Recovery | 10% | - MySQL Enterprise Backup overview - Data import/export with MySQL Workbench - Install and configure backup - Backup encryption and compression |
| MySQL Database Service and HeatWave | 10% | - Monitoring and management - HeatWave setup and usage - High availability configuration - Service overview and provisioning |
| High Availability and Replication | 10% | - InnoDB Cluster deployment - Replication concepts and setup - GTID-based replication - High availability solutions overview |
| Database Design | 15% | - Basic SQL queries - Indexes, constraints and joins - Table partitioning - Create and manage databases and tables - MySQL Document Store - MySQL data types |
| Oracle MySQL Enterprise Product Suite | 10% | - Differences between MySQL Enterprise Edition, Community Edition and Standard Edition - Oracle products certified to work with MySQL Enterprise Edition - Products and features of MySQL Enterprise Edition |
| Installation and Architecture | 15% | - MySQL infrastructure architecture overview - Configure MySQL Enterprise Server settings - Install MySQL Enterprise Server |
Oracle MySQL 2021 Implementation Essentials Sample Questions:
1. 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?
A) Go to the configuration section (MEM) and configure the default login credentials.
B) Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
C) 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.
D) Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
2. 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?
A) --uncompress-and-apply-log
B) --uncompress
C) --copy-back-and-apply-log
D) --decompress
E) --apply-log-and-copy-back
3. Which is true about inserting an additional line in a single document stored in MySQL document store?
A) The path specified must be an array position past the end of an array using the JSON_POSITION statement.
B) You specify the new element,s position in the JSON_ARRAY_INSERT statement.
C) Any new lines can only be inserted at the end of the document.
D) You cannot insert a single line, you have to replace the entire document with a new document.
4. Which two statements are true about MySQL Enterprise Authentication?
A) MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
B) MySQL Enterprise Authentication determines what operation the user can perform.
C) MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
D) MySQL Enterprise Authentication supports Windows Active Directory.
E) MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
5. Which three statements describe MySQL Enterprise Backup?
A) MySQL Enterprise Backup provides the point-in-time recovery functionality.
B) MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
C) MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
D) MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
E) MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: B,C | Question # 3 Answer: B | Question # 4 Answer: C,D | Question # 5 Answer: A,C,E |
973 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
