1z0-902 Exam Results

According to 1, Exadata X9M-2 Database Servers are based on Intel Xeon Platinum 8368Y processors with 32 cores and 768 GB of DRAM memory per server. This memory can be expanded up to 1.5 TB per server by adding 24 x 32 GB DIMMs. The DRAM memory is used for buffer cache, PGA, and other database purposes1. Exadata X9M-2 Database Servers also have 25.6 TB of Persistent Memory Acceleration (PMEM) per server, which is used for log writes and columnar data caching1. PMEM is a new type of memory that combines the speed of DRAM with the persistence of flash2. Exadata X9M-2 Database Servers are designed to run Oracle Database workloads with high performance, scalability, and reliability2

On Exadata systems, ASM disk group configurations require that:

Grid Disks Must Have Similar Performance Characteristics: Within a disk group, grid disks must not only be of the same size but also need to exhibit similar performance traits. This consistency ensures balanced I/O operations and optimizes the performance for ASM mirroring and striping across disks​.

Sparse Diskgroups: These are specialized virtual objects that reside within the DATA disk group. Sparse diskgroups are used to support snapshots and other space-efficient storage solutions by creating virtual representations of grid disks within an existing disk group without consuming additional physical space​.

These characteristics are fundamental to ensuring that ASM maintains optimal performance and storage efficiency on Exadata platforms.

A and E are the two correct quarantine types that can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine. A is correct because SQL Plan Quarantine will disable Smart Scan for all queries related to the SQL plan that was placed in the SQL Plan Quarantine [1]. E is correct because the Cell Offload Quarantine will disable Smart Scan for all queries offloaded to Oracle Database Exadata Storage Server Software [2]. The other statements (B, C, and D) are incorrect.

[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 13 [1][2]: Oracle Database Exadata Storage Server Software [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 15 [1][2]: Oracle Database Exadata Storage Server Configuration