Free Oracle 1Z0-902 Exam Braindumps (page: 2)

What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

  1. 1536GB
  2. 512GB
  3. 2048GB
  4. 768GB
  5. 1024GB
  6. 384GB

Answer(s): A

Explanation:

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 purposes.
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 caching.
PMEM is a new type of memory that combines the speed of DRAM with the persistence of flash.
Exadata X9M-2 Database Servers are designed to run Oracle Database workloads with high performance, scalability, and reliability.



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?

  1. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
  2. 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.
  3. 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.
  4. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
  5. 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(s): 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 Machine.
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 Machine.
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 Servers.
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, etc.
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, etc.
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, etc.
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 Servers. 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 reclamation.
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 server.
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 , etc.
Therefore, it runs on both Database Servers and Storage Servers



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 single- node server failure.
What ASM redundancy level should they use?

  1. Normal
  2. Sparse
  3. High
  4. External
  5. Extended

Answer(s): A

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 single- node 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 groups.
A failure group is a subset of disks within a disk group that are likely to fail at the same time due to common dependencies.
On Exadata Database Machine , each Storage Server is considered as a failure group by default.
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 extents.
Therefore, normal redundancy ensures data availability and performance during updates or single-node server failures.


Reference:

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata- administering-asm.html



Which three statements are true about the CELLCLI command?

  1. It can execute commands on multiple storage servers in parallel.
  2. It has command-line history.
  3. It requires root privileges to create CELLDISKS and GRIDDISKS.
  4. It can be executed on storage servers.
  5. It can be executed using the DCLI utility.

Answer(s): B,D,E

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 "cellcli" . 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 once.






Post your Comments and Discuss Oracle 1Z0-902 exam prep with other Community members:

1Z0-902 Exam Discussions & Posts