Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
Oracle Exadata
1z0-902
Oracle Exadata Database Machine X9M Implementation Essentials Questions and Answers

Pass the Oracle Exadata 1z0-902 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-902 Premium Access

View all detail and faqs for the 1z0-902 exam

Go to Exam

726 Students Passed

93% Average Score

92% Same Questions

Viewing page 3 out of 3 pages

Viewing questions 21-30 out of questions

Questions # 21:

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

Options:

Inactivate the grid disks on the cell.

Inactivate all the physical disks on the cell.

Drop the existing flash cache on the cell.

Shut down the CELL5RV service on the cell.

Disable the storage indexes on the cell.

Create a new flash cache on the cell.

Answer

C, F

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.

Questions # 22:

You use Enterprise Manager to monitor all the components of your Exadata Database Machine.

Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.

In which two sources would you find diagnostic messages related to this problem?

Options:

alert logs for Enterprise Manager

alert logs for the ASM instances

Enterprise Manager Alerts on the Exadata Storage Server Grid home page

Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances

alert logs for the prod database instances

Answer

B, E

Explanation

According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not.

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

Questions # 23:

Which statement is true about the Persistent Memory Commit Accelerator?

Options:

Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.

Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).

Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.

Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.

Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.

Answer

Explanation

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/new-features-exadata-system-software-release-23.html

Questions # 24:

You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.

1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.

2. Use drop down to add ZFS Storage Appliance Controllers.

3. You cannot add ZFS Storage Appliance to an Exadata Rack.

4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.

5. Use drop down to add ZFS Storage Trays.

6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.

7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.

8. Use drop down to add Exadata X9M EF Storage Servers.

9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.

10. Use drop down to add Exadata X9M Database Servers.

11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.

Which of these steps are correct and what is their correct order?

Options:

10, 8, 2, 5

4,1, 6, 9

10, 8, 9, 11

7,6,9,11

Answer

Explanation

The correct order of steps is 10, 8, 9, 11. The 10th step is to use the drop down to add Exadata X9M Database Servers, the 8th step is to use the drop down to add Exadata X9M EF Storage Servers, the 9th step is to use "Add Equipment" to add the ZFS Storage Controllers, and the 11th step is to use "Add Equipment" to add the ZFS Storage Trays. These steps are referenced in the Oracle Exadata Database Machine X9M Implementation Essentials Official Textbook, which is available online at https://docs.oracle.com/cd/E80437_01/E80437/html/index.html.

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/configuring-exadata.html

Questions # 25:

You are planning the monitoring configuration for your Exadata X9M Database Machine.

Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?

Options:

ASM instances

Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers

the storage server ILOM

the Power Distribution Units (PDUs)

Oracle clusterware on the database server

the RDMA over Converged Ethernet (RoCE) switches

Answer

C, D, F

Explanation

According to Oracle’s documentation12, the components that are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins are:

The storage server ILOM2

The Power Distribution Units (PDUs)2

The RDMA over Converged Ethernet (RoCE) switches3

Viewing page 3 out of 3 pages

Viewing questions 21-30 out of questions