We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z1-921 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | MySQL 2021 Implementation Essentials |
| Exam Number: | 1Z0-921 |
| Exam Duration: | 90-120 |
| Related Certifications: | MySQL 2021 Certified Implementation Specialist |
| Available Languages: | English |
| Certificate Validity Period: | Oracle certifications typically do not expire |
| Exam Price: | $245 USD |
| Exam Format: | Multiple Choice |
| Real Exam Qty: | 52-70 |
| Passing Score: | 60%-63% |
| Sample Questions: | Oracle 1Z1-921 Sample Questions |
| Exam Way: | Online proctored or Pearson VUE test center |
| Pre Condition: | No mandatory prerequisite exams. Basic MySQL database administration and SQL knowledge recommended. |
| Official Syllabus URL: | https://education.oracle.com/mysql-2021-implementation-essentials/pexam_1Z0-921 |
Oracle 1Z1-921 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: High Availability and Replication | - Replication and Scalability
|
| Topic 2: Leverage MySQL Enterprise Monitor | - Enterprise Monitor Features
|
| Topic 3: MySQL Database Service and HeatWave | - Cloud Database Services
|
| Topic 4: Leverage MySQL Backup | - Backup and Recovery
|
| Topic 5: Installation and Architecture | - MySQL Infrastructure Architecture
|
| Topic 6: MySQL Security | - Security Management
|
| Topic 7: MySQL Kubernetes | - Kubernetes Operations
|
| Topic 8: Oracle MySQL Enterprise Product Suite | - Enterprise Edition and Community/Standard Edition
|
| Topic 9: Database Design | - Database Objects and SQL
|
Oracle MySQL 2021 Implementation Essentials Sample Questions:
1. You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?
A) LOAD PLUGIN=AUDIT_LOG
B) audit_log_permanent=ON
C) plugin-audit=ON, ALWAYS
D) plugin-load=audit_log.so
E) audit-log=FORCE_PLUS_PERMANENT
2. What three are ways to export and import data in MySQL Workbench?
A) Table Data Export and Import Wizard
B) Data Modeling Import Export Wizard
C) Binary Data Export and Import Wizard
D) SQL Data Export and Import Wizard
E) Result Data Export and Import
F) Backup Data Export and Import Wizard
3. Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?
A) Your instance does not have a public IP address, so you cannot connect with a public subnet.
B) You must have an Internet gateway to connect to a public address on an Oracle Linux instance.
C) You can connect directly to an instance over the internet, without a public IP address.
D) You must have an IPSec VPN to connect to an Oracle Linux instance.
E) You can connect directly to the VCN without a define subnet.
4. 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 offers backup based on Oracle RMAN with optimized row locking.
D) MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
E) MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
5. 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 Enterprise Monitor and MySQL Audit
C) MySQL Workbench and MySQL Enterprise Firewall
D) MySQL Audit and MySQL Workbench
Solutions:
| Question # 1 Answer: B,E | Question # 2 Answer: A,D,E | Question # 3 Answer: C,E | Question # 4 Answer: A,C,E | Question # 5 Answer: A |
By Hedy
