1Z0-902 Oracle Exadata Database Machine X9M Implementation Essentials Exam
Earn associated certifications
Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.
Oracle Exadata Database Machine X9M Certified Implementation Specialist
Format: Multiple Choice
Duration: 90 Minutes
Number of Questions: 60
Passing Score: 64%
Validation: Exam has been validated for product version Oracle Exadata X9M
Prepare to pass exam: 1Z0-902
An Oracle Exadata Database Machine Service X9M Certified Implementation Specialist has demonstrated the knowledge and skills required to administer and configure Oracle Exadata. This candidate understands the Exadata Database Machine architecture and key capabilities, can use OEDA and OECA, has the skills to successfully install, troubleshoot, monitor and perform maintenance related tasks on the Exadata system.
Take recommended training
Complete one of the courses below to prepare for your exam (optional):
Earn the Oracle Exadata X9M Certified Implementation Specialist Credential
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience), in the learning subscription, provides the best preparation for passing the exam.
Examkingdom Oracle 1Z0-902 Exam pdf
Best Oracle 1Z0-902 Downloads, Oracle 1Z0-902 Dumps at Certkingdom.com
Review exam topics
Exadata Database Machine Architecture and Key Capabilities
Describe Exadata hardware architecture (2x database server types, 3x storage server types, power distribution, leaf and spine switches)
Describe Exadata software architecture and deployment scenarios
Describe Exadata Remote Direct Memory Access (RDMA) and Client network architecture (including multirack architecture, secure fabric)
Explain the impact of various diskgroup failure group choices
Describe the deployment options of Exadata including Virtualization and Bare Metal
Exadata Database Machine Site and Implementation Planning (OECA&OEDA)
Describe the function of Oracle Exadata Configuration Assistant and Oracle Exadata Deployment Assistant
Design an Exadata Database Machine with Oracle ZFS Storage in a single rack using Oracle Exadata Configuration Assistant
Configure Exadata Database virtual deployment using Oracle Exadata Deployment Assistant
Add additional database server to a physical Exadata Database Machine using Oracle Exadata Deployment Assistant
Describe physical site requirements and safety best practices for implementing Exadata (site planning, cooling, power)
Install and configure Oracle Exadata using Oracle Exadata Deployment Assistant
Exadata Database Machine Installation
Configure Exadata Database Server SP port (ILOM)
Describe the procedure for receiving the rack on site
Reconfigure the Exadata Database Machine to use a single power cable
Verify the firmware of an Exadata Storage Server
Set up Automatic Service Request (ASR) on the Exadata Database Machine
Exadata Database Machine Integration
Describe the network integration options of Exadata Database Machine
Connect Exadata Database Server in various scenarios, including client and backup networks
Exadata Database Machine Configuration and Administration
Create and configure Automatic Storage Management disk groups using Exadata
Configure Exadata software and resources using CellCLI or other tools
Use the CellCLI, ExaCLI, DCLI and ExaDCLI Exadata administration tools in various situations
Create an ACFS Filesystem for use with external tables
Back up the Exadata Database Machine and databases on Exadata
Enable Flash Cache Write Back
Start and restart an Exadata Virtual Machine
Exadata Database Machine Security
Configure Exadata security (storage, secure boot, cellwall, AIDE, ASM Scoped Security, Database Scoped Security, FIPS secure filesystem)
Implement Access Control for REST API
Exadata Database Machine Troubleshooting
Recover Storage Cell from disk failure
Use Exadata Software to troubleshoot client network disconnect
Exadata Database Machine Monitoring
Describe the monitoring recommendations for Exadata Database Machine database servers
Use Cloud Control or DBMCLI to monitor Exadata Database Machine Database Servers
Monitor Exadata Storage Server and Network using Command line or Cloud control
Describe the Enterprise Manager cloud Control architecture as it specifically applies to Exadata Database Machine
Use Enterprise Manager to discover Exadata Database Machine
Describe the Auto Service Request (ASR) function and how it relates to Exadata Database Machine
Describe Oracle Configuration Manager (OCM) and how it relates to Exadata Database Machine
Exadata Database Machine Updates
Describe how software is maintained on different Database Machine components
Use Exadata Software to deploy an update to an Exadata Database Machine without downtime
Use patchmgr to update a single storage server
Exadata Database Maintenance Tasks
Power Database Machine on and off
Safely shut down a single Exadata Storage Server
Replace a damaged physical disk on a cell
Replace a damaged flash card on a cell
Add additional storage to Exadata Database Servers
Use the Exadata Cell Software Rescue Procedure
Description
The Oracle Exadata Database Machine X9M is a state-of-the-art database machine that is designed to accelerate performance, improve scalability, and increase efficiency. In this practice test, you will have the opportunity to master the implementation essentials of the Oracle Exadata Database Machine X9M.
The course is designed to provide you with a clear understanding of the Exadata Database Machine, its architecture, and its key capabilities. You will learn how to plan for and implement the Exadata Database Machine on-site using the Oracle Exadata Configuration Assistant (OECA) and the Oracle Exadata Deployment Assistant (OEDA). You will also learn how to install, integrate, and configure the Exadata Database Machine, administer its databases, and secure the system.
This practice test includes 60 questions, divided into six categories: Exadata Database Machine Architecture and Key Capabilities, Exadata Database Machine Site and Implementation Planning (OECA&OEDA), Exadata Database Machine Installation, Exadata Database Machine Integration, Exadata Database Machine Configuration and Administration, and Exadata Database Machine Security. Each category contains 10 multiple-choice questions that are designed to test your knowledge in that specific area.
After completing this practice test, you will have gained a thorough understanding of the Oracle Exadata Database Machine X9M Implementation Essentials, and you will be well-prepared for the 1Z0-902 certification exam. Whether you are a database administrator, IT professional, or student, the knowledge and skills you will gain from this practice test will benefit you in your career.
Who this course is for:
Database administrators who want to learn how to implement the Oracle Exadata Database Machine X9M
IT professionals who are responsible for planning, installing, and integrating Exadata Database Machines
Anyone who wants to learn about the key capabilities and security features of the Exadata Database Machine
Individuals preparing for the 1Z0-902 certification exam
Students who are interested in learning about the latest technology for database machines
Sample Question and Answers
QUESTION 1
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
A. 1536GB
B. 512GB
C. 2048GB
D. 768GB
E. 1024GB
F. 384GB
Answer: C
QUESTION 2
Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata
Database Machine deployment?
A. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
B. 1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
C. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
D. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
E. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
Answer: C
Explanation:
Oracle KVM Guest: This is a virtual machine that runs on top of Oracle Linux KVM hypervisor. It can
be used to run Oracle Database or other applications on Exadata Database Machine2. Therefore, it
runs on the Database Servers.
Oracle Enterprise Manager Agent (OMA): This is a software agent that communicates with Oracle
Enterprise Manager Cloud Control and provides monitoring and management capabilities for
Exadata Database Machine2. Therefore, it runs on both Database Servers and Storage Servers.
ASM instance: This is an instance of Oracle Automatic Storage Management (ASM), which is a
volume manager and a file system for Oracle Database files. It manages disk groups that span across
multiple Storage Servers2. Therefore, it runs on the Database Servers.
RDBMS instance: This is an instance of Oracle Database that processes SQL statements and executes
transactions. It uses ASM disk groups to store data files, control files, redo log files, etc2. Therefore, it
runs on the Database Servers.
Automatic Diagnostic Repository Command Interpreter (ADRCI): This is a command-line tool that
enables you to view diagnostic data stored in the Automatic Diagnostic Repository (ADR). ADR is a
file-based repository for database diagnostic data such as trace files, alert logs, etc2. Therefore,
ADRCI runs on both Database Servers and Storage Servers, depending on where the ADR is located.
CELLCLI: This is a command-line interface that enables you to configure and manage Exadata Storage
Server Software. It allows you to perform tasks such as creating disk groups, monitoring cell health,
applying patches, etc2. Therefore, it runs on the Storage Servers.
Cell Server(CELLSRV): This is a process that runs on each Storage Server and handles I/O requests
from the Database Servers. It implements Exadata Smart Scan , which offloads data-intensive SQL
operations from the Database Servers to the Storage Servers2. Therefore, it runs on the Storage Servers.
diskmon: This is a process that monitors the status of disks and flash devices on each Storage
Server. It reports disk failures and performs automatic disk reclamation2. Therefore, it runs on the Storage Servers.
Restart Server (RS): This is a process that manages automatic restarts of critical processes such as
CELLSRV , MS , or OMA in case of failures. It also handles graceful shutdowns and startups of all
processes on each server2. Therefore, it runs on both Database Servers and Storage Servers.
Management Server (MS): This is a process that provides management services for each server such
as collecting metrics , logging events , executing commands from CELLCLI , etc2. Therefore, it runs on
both Database Servers and Storage Servers
QUESTION 3
Your customer needs to ensure that their data is available on the Exadata machine during updates.
The customer wants to be able to update one server at a time but still be protected against singlenode server failure.
What ASM redundancy level should they use?
A. Normal
B. Sparse
C. High
D. External
E. Extended
Answer: C
Explanation:
Your customer needs to ensure that their data is available on the Exadata machine during updates.
The customer wants to be able to update one server at a time but still be protected against singlenode
server failure. This means that they need a redundancy level that can tolerate at least one disk
failure without losing data availability or performance. Therefore, the best option for them is normal
redundancy . Normal redundancy provides two-way mirroring by default, which means that each
data extent has a primary copy and a mirror copy on different disks in different failure groups1. A
failure group is a subset of disks within a disk group that are likely to fail at the same time due to
common dependencies2. On Exadata Database Machine , each Storage Server is considered as a
failure group by default2. This means that if one Storage Server fails or needs to be updated , the
data on its disks can still be accessed from another Storage Server that has the mirror copies of the
same data extents2. Therefore, normal redundancy ensures data availability and performance during
updates or single-node server failures.
QUESTION 4
Which three statements are true about the CELLCLI command?
A. It can execute commands on multiple storage servers in parallel.
B. It has command-line history.
C. It requires root privileges to create CELLDISKS and GRIDDISKS.
D. It can be executed on storage servers.
E. It can be executed using the DCLI utility.
Answer: BDE
Explanation:
The statements that are true about the CellCLI command are:
It has command-line history . According to 1, you can use the up and down arrow keys to scroll
through previous commands that you entered in CellCLI . You can also use Ctrl+R to search for a
previous command by entering part of it .
It can be executed on storage servers . According to 1, you can invoke CellCLI by logging in to the
Exadata cell as cellmonitor , celladmin , or root user and typing oecellcli . Within CellCLI , you can
perform various management and monitoring tasks for the cell134.
It can be executed using the DCLI utility . According to 5, DCLI (distributed CLI) is another utility that
can be used to execute scripts and commands across multiple storage cells from a single
interface. You can use DCLI to run CellCLI commands on multiple cells at once54.
QUESTION 5
An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA
PDUs is being installed in a Data Center. However, the Data Center is only providing enough power
for a single cable from each PDU. Which statement is correct?
A. A splitter cable can be used to provide power to all PDU cables.
B. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
C. The installation cannot proceed until two power feeds are available per PDU.
D. The installation can go ahead, no change is required.
Answer: C
Explanation:
In order for an Exadata X9M-2 Elastic Rack to be installed, two power feeds are required for each of
the three-phase 24kVA PDUs. A single cable from each PDU will not be enough to power the rack,
and neither a splitter cable nor rearrangement of the power cables from the servers to the PDUs will
be able to provide sufficient power for the system. Therefore, the installation cannot proceed until
two power feeds are available per PDU.
For more information about power requirements for Exadata X9M-2 Elastic Racks, refer to the Oracle
Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation – Oracle Docs [2]
Exadata Database Machine X8M-2 Mid-Size Rack Installation – Oracle Docs
