1Z0-902 Exadata X9M Implementation Practice Questions
Prepare for 1Z0-902 with more than an answer.
Unlock the full exam and previous versions
- v1Version 1 251 questions Current
- 1z0-070Legacy Oracle Exadata X5 Administration 98 questions Locked
- 1z0-338Legacy Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials 80 questions Locked
- Exam fee
- $245 USD
- Level
- Specialist
- Valid for
- Does not expire
Domains covered on the exam 10
- 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
- Exadata Database Machine Security
- Exadata Database Machine Troubleshooting
- Exadata Database Machine Monitoring
- Exadata Database Machine Updates
- Exadata Database Maintenance Tasks
- 1
A new Exadata administrator is reviewing the monitoring setup. They discover that Automatic Service Request (ASR) is configured and want to understand the flow of information when a fault is detected. What is the correct sequence of events after a hardware component on a storage server reports a fault?
sequenceDiagram participant SS as Storage Server participant ILOM as ILOM/SP participant ASRM as ASR Manager participant Oracle as Oracle Support SS->>ILOM: Reports hardware fault ILOM->>ASRM: Sends SNMP trap with fault data ASRM->>Oracle: Creates secure Service Request Oracle-->>ASRM: Acknowledges SR & assigns engineerShow answer details
Correct answer: B
This option correctly describes the ASR workflow. The hardware-level monitoring is done by the ILOM (Service Processor). Upon detecting a fault, the ILOM sends a standardized SNMP trap to the ASR Manager software. The ASR Manager then interprets the fault, collects relevant diagnostic information, and opens a secure connection to Oracle Support to automatically log a Service Request (SR).
- 2
The command
dbmcli -e "ALTER DBSERVER cpuCoreCount=_____, memoryQuantity=256G"is used to resize a virtual machine on an Exadata database node. Which option represents a valid value for thecpuCoreCountparameter?Show answer details
Correct answer: A
On Exadata virtualized platforms, CPU cores must be allocated to VMs in increments of 2. Therefore, 10 is a valid even number for the
cpuCoreCount. Values like 7, 9, or 11 are invalid as they are odd numbers and would result in a configuration error. - 3
True or False: In an Exadata X9M environment, enabling Flash Cache in Write-Back mode improves read performance but has no impact on write performance.
Show answer details
Correct answer: B
This statement is false. While Write-Through mode primarily benefits reads, Write-Back mode is specifically designed to accelerate write performance. In Write-Back mode, writes are acknowledged as complete once they are written to the persistent flash cache, without immediately waiting for the write to the slower hard disks. This significantly reduces write latency.
- 4
A system administrator needs to verify the firmware version of the physical hard disks and flash devices within a specific Exadata Storage Server. Which
cellclicommand provides this information?Show answer details
Correct answer: C
The
LIST PHYSICALDISKcommand in CellCLI is used to query attributes of the physical storage devices. ThephysicalFirmwareattribute specifically displays the firmware version of the disk controller for both hard disks and flash devices.CELLDISKis a logical layer, andLUNis a different object within the storage server. - 5
An Exadata X9M machine is configured with high redundancy ASM disk groups, meaning there are three failure groups. A catastrophic failure causes an entire storage server, which constitutes one failure group, to go offline permanently. What is the state of the ASM disk groups immediately following this failure?
Show answer details
Correct answer: B
High redundancy (three failure groups) is designed to tolerate the loss of two failure groups. When one storage server (one failure group) fails, the ASM disk group remains online and fully operational because two good copies of every data extent still exist on the remaining two failure groups. ASM will begin a rebalance operation to restore full redundancy across the surviving storage servers, but the database remains available throughout.
- 6
A financial services company is deploying a new Exadata X9M Quarter Rack for a critical OLTP application. The security architect mandates that all administrative access to the storage servers must be strictly controlled and logged, and network traffic between database servers and storage servers must be isolated. During the OEDA configuration, which security feature should be configured to create firewall-like rules that restrict access to storage server services based on source IP addresses?
Show answer details
Correct answer: B
CellWall is the Exadata Storage Server's built-in firewall feature. It allows administrators to define IP-based access control rules for services running on the storage cells, effectively restricting which database servers can communicate with them. This directly addresses the requirement for network traffic isolation and controlled access. ASM Scoped Security controls access to disk groups, AIDE monitors file integrity, and Secure Boot ensures the integrity of the boot process, but none of them function as a network firewall like CellWall.
- 7
During a routine maintenance window, an administrator needs to update the firmware on a single, specific Exadata Storage Server without impacting the entire rack or causing application downtime. The update must be performed using the recommended command-line utility. Which command correctly initiates this process?
Show answer details
Correct answer: D
The
patchmgrutility is the standard tool for applying updates to Exadata components. To update a single storage server, the-cellsflag is used to specify the target cell by name or IP address, and the-upgradeflag initiates the patching process. The other commands are either incorrect syntax (dbmcli) or perform different functions (cellcli for validation, patchmgr for prereq checks). - 8
An Exadata administrator observes a sudden degradation in I/O performance for a specific database. Investigation reveals that a single flash card on one storage cell has failed. The administrator needs to replace the card. Which TWO statements accurately describe the process and its impact? (Select TWO)
Show answer details
Correct answer: B, C
Exadata flash cards are designed to be hot-swappable, allowing for replacement without powering down the storage server, which minimizes downtime.
Once the new physical card is detected, the Exadata software automatically handles the configuration, including re-creating the necessary Flash Cache and Flash Log structures without manual intervention.
- 9
A hospital is migrating its electronic health record (EHR) system to a new Exadata X9M machine. Compliance regulations require that the database files, which are stored in ASM, must be encrypted. The security team also requires that the underlying operating system files on the database servers are protected by a FIPS 140-2 validated cryptographic module. Which Exadata security feature directly addresses the FIPS compliance requirement for the OS filesystem?
Show answer details
Correct answer: C
Exadata provides a specific configuration to enable FIPS mode for the operating system's cryptographic modules. This ensures that all cryptographic operations performed by the OS (such as SSH, SSL) use FIPS 140-2 validated algorithms, meeting the compliance requirement. TDE encrypts database files within ASM, but does not affect the OS filesystem's cryptographic modules. Database Vault controls privileged user access, and CellWall is a network firewall.
- 10
True or False: When adding a new database server to an existing physical Exadata Database Machine using the Oracle Exadata Deployment Assistant (OEDA), the process is fully automated and does not require any manual intervention after the initial configuration file is created.
Show answer details
Correct answer: B
While OEDA automates a significant portion of the process, adding a new database server requires several manual steps. These include physically racking the server, connecting power and network cables, and performing initial ILOM configuration before OEDA's automated scripts can be run to integrate the server into the cluster.
