Question 1

Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

Accepted Answer

Explanation: A . ZFS Storage Appliance (ZFSSA) can't connect directly to the Exadata 100Gb RoCE network switches. ZFSSA uses Fibre Channel protocol to connect to the Exadata storage cells. C. When backing up multi-rack systems, sharing Exadata X9M switches is not recommended. Each rack should have its own switches to minimize the risk of data loss due to switch failure. Review the safety guidelines. Unpack Oracle Exadata Rack. Let the Exadata acclimatize for 24 hours. Place Exadata in its allocated space. Stabilize the Exadata Rack. Power on Exadata PDU A. Power on Exadata PDU B. This order ensures that the necessary safety precautions are taken before installing the Exadata Database Machine, and that the machine is allowed to acclimate to its new environment before being powered on.

Question 2

Which two statements are true about the types of Exadata X9M-2 storage servers: the High Capacity (HC) storage server, the Extreme Flash (EF) storage server and the Extended server?

Accepted Answer

A, D

Explanation: High Capacity (HC) Storage Server: The Exadata X9M-2 HC storage server is configured with a combination of hard disks and flash memory, providing a balance of storage capacity and performance. It includes 12 x 18 TB hard disk drives, which totals 216 TB of raw disk capacity . For flash storage, it has 4 x 6.4 TB PCIe flash cards totaling 25.6 TB of flash storage. This configuration uses NVMe Flash Accelerator F680 cards optimized for database caching . The persistent memory in the HC server totals 1.5 TB, enhancing performance for OLTP (Online Transaction Processing) workloads by providing ultra-fast access speeds compared to traditional flash storage . Extreme Flash (EF) Storage Server: The EF storage server in the Exadata X9M-2 model is an all-flash storage server designed for high IOPS and low latency, making it ideal for performance-intensive workloads. This configuration contains 8 x 6.4 TB PCIe flash cards, providing a raw capacity of 51.2 TB of high- performance flash storage . In terms of persistent memory, it includes 756 GB of Intel Optane Persistent Memory. This enhances flash storage performance by offloading data processing directly to persistent memory . The Exadata X9M-2 storage configurations—both HC and EF—are optimized for different workload requirements. The HC configuration caters to larger datasets needing high storage capacity, while the EF configuration is designed for workloads requiring high throughput and minimal latency.

Question 3

Which three component faults are covered by Oracle Auto Service Request (ASR)?

Accepted Answer

B, C, D

Explanation: Oracle ASR covers a range of hardware components on Exadata Database Machines to ensure rapid response and issue resolution. The covered hardware components include critical parts such as: Fan Trays: These are essential for cooling Exadata components and are covered by ASR in case of failures . System Controller (SC): Integral to the operation of Exadata storage servers, SC failures are reported by ASR to ensure the overall system’s reliability and availability . I/O Boards: ASR actively monitors and responds to failures in I/O boards, which are crucial for data processing and connectivity within Exadata storage servers . The ASR system is optimized to handle hardware-related issues proactively, ensuring that critical components are continuously monitored and replaced as necessary.

Question 4

What type of SRs does the ASR Manager generate for Exadata?

Accepted Answer

Explanation: Oracle Auto Service Request (ASR) on Exadata Database Machines is designed to proactively monitor and detect hardware and software issues. When a problem is detected, ASR Manager automatically opens a service request (SR) with Oracle Support. The primary focus of ASR is on hardware assets, such as storage servers, database servers, and network components, as well as software assets related to Exadata System Software and Oracle Database configurations .

Question 5

What are the two benefits of using Oracle Exadata Deployment Assistant (OEDA)?

Accepted Answer

Explanation: Oracle Exadata Deployment Assistant (OEDA) offers multiple benefits for configuring and deploying Exadata systems: Configuration Gathering and Rack File Creation: OEDA simplifies the setup of Exadata environments by collecting system-specific configuration details. It uses this information to generate the Exadata Rack configuration file, which outlines the optimal setup for the particular environment, streamlining the deployment process and ensuring compatibility with Oracle best practices . Lifecycle Management CLI for Exadata Systems: OEDA includes a command-line interface (CLI) that facilitates various lifecycle management tasks, specifically designed for Exadata systems. This CLI helps in automating deployment steps, adjusting configurations, and updating system parameters, tailored specifically for Exadata’s hardware and software environment .

Question 6

An Exadata storage server physical disk on an X9M-2 high-capacity full rack entered the predictive failure state. Which two steps must you perform to replace this failed physical disk?

Accepted Answer

Explanation: Once the physical disk has been replaced, you will need to create a new celldisk and griddisks on the replaced physical disk. After the griddisks have been dropped from the associated ASM diskgroups, you can then add the griddisks back into the ASM diskgroup they used to be a member of and rebalance the data on the effected griddisks. Finally, you should verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.

Question 7

Assume that the RDBMS and ASM instances are up and you are enabling write-back flash cache in
one cell server at a time.
Which step(s) should you perform before executing the following command you your Exadata X9M-8
Database Machine, which will set the cell flash cache mode to write-back?
#cellcli –e alter cell flashCacheMode=WriteBack

Accepted Answer

Explanation: To enable the write-back flash cache on an Exadata X9M-8 storage cell, the existing flash cache must be removed before transitioning to a new mode. This is because the flash cache configuration— whether set to write-through or write-back—requires a re-initialization of the flash storage to apply the new caching behavior. The steps are as follows: Drop the Existing Flash Cache: Before altering the cache mode, any existing flash cache on the cell must be dropped. This clears the existing configuration and allows the system to reallocate flash resources under the new mode. The command for this is: # cellcli -e "drop flashcache" Create a New Flash Cache in Write-Back Mode: After dropping the existing flash cache, you can create a new flash cache with write-back mode enabled. This step ensures that the flash cache is configured correctly to handle write operations before they reach disk, thus accelerating write-heavy workloads. The relevant command to set write-back mode is: # cellcli -e "create flashcache all" This process will reset the flash cache with the write-back mode enabled, thereby caching both read and write operations effectively .

Question 8

What does the following command do? root@rul6 -]# for j in {01..23} ; do ipmitool sunoem cli "set /SP/network/test ping=192.168.1.1$j'' ; done

Accepted Answer

B

Explanation: The given command uses a for loop with ipmitool to issue ping commands sequentially to a range of IP addresses in the management network: for j in {01..23}; do ipmitool sunoem cli "set /SP/network/test ping=192.168.1.1$j"; done This script verifies the connectivity of the ILOM management network before the Exadata installation. Each server’s Service Processor (SP) is tested for reachability, confirming that the management network setup is operational across the full rack .

Question 9

Which two statements are true in regards to starting the Exadata Virtual Machine?

Accepted Answer

Explanation: Statement B is true as the vm_maker —start-domain command can be used to start a virtual machine manually, as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 65). Statement E is also true as the vm_maker —auto-start command can be used to configure a virtual machine to start automatically when the KVM host is started [1][2], as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 66).

Question 10

For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

Accepted Answer

ACEG

Explanation: According to the Oracle Auto Service Request (ASR) documentation1, ASR raises service requests for qualified Oracle products that are detected with specific faults. The qualified Exadata products include2: Database servers Storage servers InfiniBand switches Cisco switches (X8M and later systems) Power distribution units (PDUs)

Question 11

You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers. Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?

Accepted Answer

AE

Explanation: In order to monitor all components of this multirack configuration, Enterprise Manager agents must be deployed on at least two storage servers in both racks and all database servers in both racks. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book [1], in which it states "To monitor all components of the multirack configuration, you must deploy agents on all database servers and at least two storage servers in each rack" (page 6-15).

Question 12

In order two support a new application, you are planning to add a RAC VM cluster to an existing Oracle Exadata X9M-2 deployment. Which two methods can be considered?

Accepted Answer

B, E

Explanation: For adding a new RAC (Real Application Clusters) VM cluster to an existing Oracle Exadata X9M-2 deployment, you can utilize the Oracle Exadata Deployment Assistant (OEDA). OEDA is available in two interfaces: OEDA Web-based Configuration Tool: This web-based interface facilitates the configuration of Exadata environments, supporting both physical and virtual deployments. The graphical interface helps in defining VM clusters, including RAC clusters, and ensures the configuration aligns with Oracle best practices . OEDA Command Line Interface (CLI): For more advanced or automated tasks, the command-line interface (oedacli) allows for precise control over the deployment process. It supports various configuration actions such as adding or removing clusters, resizing ASM disk groups, and managing VM clusters . These tools are specifically designed for Exadata configurations and provide a streamlined approach for deploying and managing RAC clusters in both physical and virtualized environments.

Question 13

When receiving an Exadata Database Machine rack on site, which of the following statements is INCORRECT?

Accepted Answer

E

Explanation: The handling and installation of an Exadata Database Machine rack require caution and adherence to recommended guidelines: Shipping Brackets: Shipping brackets are specifically designed for transportation purposes and should not be reused for permanent installation. Permanent floor mounting should use approved rack- mounting equipment to ensure stability and safety . Steering and Pushing the Rack: Exadata racks should be steered from the rear due to fixed front casters. It is critical to avoid pushing the rack from the side panels, which could cause it to tip over, presenting a serious safety risk. This careful movement ensures safe positioning and prevents damage to the equipment during installation.

Question 14

How many 128GB Persistent Memory DIMMS are included in Exadata X9M-2 Extended (XT) Storage Servers?

Accepted Answer

A

Explanation: The Exadata X9M-2 Extended (XT) Storage Server does not include any Persistent Memory (PMEM) DIMMs. The XT server configuration primarily serves as a cost-effective archival storage option and lacks the performance features available in the HC (High Capacity) and EF (Extreme Flash) storage servers. This configuration does not include Persistent Memory, which is leveraged in other models for accelerating OLTP workloads and providing extremely low-latency data access .

Question 15

You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?

Accepted Answer

B

Explanation: The correct sequence is: Review the safety guidelines. This is important to ensure a safe and successful installation1. Unpack Oracle Exadata Rack. This involves removing the packaging materials and inspecting the rack for damage or missing components1. Place Exadata in its allocated space. This involves moving the rack to its final location and securing it with bolts and brackets1. Let the Exadata acclimatize for 24 hours. This is recommended to allow the rack components to adjust to the ambient temperature and humidity before powering on1. Stabilize the Exadata Rack. This involves leveling the rack and adjusting its height if needed1. Power on Exadata PDU B. This involves connecting PDU B to a power source and turning it on1. Power on Exadata PDU A. This involves connecting PDU A to a power source and turning it on1

Free Oracle 1Z0-902 Actual Exam Questions