Real Oracle 1z1-902 Exam Questions [Updated 2024]
1z1-902 Exam Dumps Pass with Updated 2024 Oracle Exadata Database Machine X8M Implementation Essentials
The 1Z0-902 exam covers a range of topics related to the Oracle Exadata Database Machine X8M, including hardware and software architecture, configuration, deployment, and maintenance. 1z1-902 exam also covers topics such as backup and recovery, performance tuning, and troubleshooting. Passing 1z1-902 exam demonstrates that an individual has the skills and knowledge necessary to implement and manage Oracle Exadata Database Machine X8M systems effectively.
Oracle 1z1-902 certification exam is designed for professionals who want to validate their knowledge and skills in implementing and managing Oracle Exadata Database Machine X8M systems. Oracle Exadata Database Machine X8M Implementation Essentials certification exam is intended for individuals who have already gained experience in database administration, database design, and Oracle technologies. Passing 1z1-902 exam is a great achievement and can open up new opportunities for professionals looking to advance their careers.
NEW QUESTION # 29
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?
- A. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
- B. using the CELLCLI list LUN DETAIL command as the celladmin user
- C. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
- D. hardware monitoring using the storage server ILOM
Answer: B,D
NEW QUESTION # 30
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. SQL Plan Quarantine
- B. Manually created Quarantine
- C. Disk Region Quarantine
- D. Database Quarantine
- E. Cell Offload Quarantine
Answer: A,E
Explanation:
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
NEW QUESTION # 31
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. The incline of any access route ramp must be less than or equal to 6 degrees.
- B. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- C. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- D. 914mm of space required above the rack height is required for maintenance access.
- E. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- F. Oracle Exadata Rack may only be installed on raised floor environments.
Answer: C
NEW QUESTION # 32
Which three statements are true about the CELLCLI command?
- A. It can be executed using the DCLI utility.
- B. It can be executed on storage servers.
- C. It can execute commands on multiple storage servers in parallel.
- D. It requires root privileges to create CELLDISKS and GRIDDISKS.
- E. It has command-line history.
Answer: A,B,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 once54.
NEW QUESTION # 33
How do ASM failure groups provide redundancy?
- A. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
- B. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
- C. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- D. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
Answer: C
Explanation:
According to Oracle's documentation12, ASM failure groups provide redundancy by storing mirror copies of data on different disks or storage servers. When ASM allocates an extent for a normal redundancy file, ASM allocates a primary copy and a secondary copy. ASM chooses the disk on which to store the secondary copy so that it is in a different failure group than the primary copy1. This way, if one disk or storage server fails, ASM can still access the data from another failure group2.
Therefore, the statement that is true about how ASM failure groups provide redundancy is:
Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
NEW QUESTION # 34
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.
- B. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.
- C. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.
- D. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
Answer: A,B
NEW QUESTION # 35
Which two statements are true in regards to starting the Exadata Virtual Machine?
- A. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
- B. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
- C. Use vm_maker boot-from-iso command to boot a virtual machine.
- D. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
- E. Use vm_maker -start-domain to start a virtual machine manually.
Answer: A,E
NEW QUESTION # 36
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?
- A. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
- B. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- C. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
- D. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
Answer: C,D
Explanation:
The two actions that are not appropriate for monitoring how a large production table is accessed in order to leverage the benefits of the Exadata Platform are A) querying VSSYSTEMEVENTS and filtering for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table; and B) querying v$segmentstatistics and filtering for the Object ID of your table from dbaobjects and the the column STATISTICNAME='optimized physical reads'. Instead, you should query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table (C), or run the CellCli-command list activerequest, filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS (D). These two methods are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Monitoring the Exadata Database Machine).
NEW QUESTION # 37
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?
- A. on all database servers in both racks and one storage server in each rack
- B. on all storage servers in both racks
- C. on at least two storage servers in both racks
- D. on all database servers in the first rack
- E. on all database servers and at least two storage servers in both racks
- F. on all database servers in the second rack
- G. on only one database server in both racks
Answer: C,E
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).
NEW QUESTION # 38
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- B. PMEM Pool Misses in the Exadata Outlier Summary
- C. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- D. PMEM Cache section within Memory Statistics
- E. PMEM Cache section within Exadata Smart Statistics
Answer: A,E
Explanation:
Option C shows the number of read hits from PMEM cache on storage servers which indicates how much data was served from PMEM instead of flash or disk1.
Option E shows detailed information about PMEM cache such as size, utilization, hit ratio, read latency and write latency2.
NEW QUESTION # 39
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?
- A. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using
SFP28 transceivers and OM4 fiber cable for client network - B. 2x 10Gb ports on eth1 and eth2 using FU45 cat6 cable for client network, and 2x 25Gb ports on eth11 and eth12 using SFP28 transceivers and OM4 fiber cable for backup network
- C. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network
- D. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network
Answer: B,D
NEW QUESTION # 40
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST IBPORT DETAIL"
- D. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
Answer: B
Explanation:
1. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'" is valid command and it is used to list the historical values for metrics where the name starts with "DS_."
2. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " is valid command and it is used to list the current value of the metric named "DS_TEMP"
3. dbmcli -e "LIST IBPORT DETAIL" is valid command and it is used to list the InfiniBand ports and details of the Exadata X9M.
"dbmcli" is a command-line tool that is used to manage and monitor the Exadata Database Machine. It allows you to perform various tasks such as managing the database, storage, and network components, and monitoring the performance and health of the machine. The command "dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15" is not a valid command, it is not supported on Exadata X9M.
NEW QUESTION # 41
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?
- A. Call Oracle Support and make an appointment so that the drive can be replaced.
- B. Ask the system administrator to replace the broken disk with a spare.
- C. Check the database to see if any rebalance operations are active.
- D. Download and run the latest exadiag tool.
- E. Wait for a blue light to appear on the disk if the rebalance operation is running.
- F. Wait for the email of the failure that Exadata or Enterprise Manager will send.
Answer: A
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], before doing anything else you should call Oracle Support and make an appointment so that the drive can be replaced. If Platinum Support is enabled, then you can call Oracle Support and they will arrange for the disk to be replaced. If Platinum Support is not enabled, then you can arrange for the disk to be replaced through Enterprise Manager Cloud Control.
NEW QUESTION # 42
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool Misses in the Exadata Outlier Summary
- B. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- C. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- D. PMEM Cache section within Exadata Smart Statistics
- E. PMEM Cache section within Memory Statistics
Answer: D,E
Explanation:
The AWR report has two sections that show statistics for X9M Persistent Memory Cache: the PMEM Cache section within Memory Statistics and the PMEM Cache section within Exadata Smart Statistics. Both of these sections provide detailed information about the read and write hits and misses, as well as the total capacity and utilization of the PMEM cache. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 515)
NEW QUESTION # 43
How do ASM failure groups provide redundancy?
- A. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
- B. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
- C. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- D. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
Answer: C
Explanation:
In an Automatic Storage Management (ASM) environment, failure groups are used to provide redundancy for the storage disks. Failure groups are used to group together a set of disks and ensure that no two copies of the same data are stored on the same physical disk or storage server. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
For example, if the disks in a failure group are mirrored, one copy of the data is stored on one set of disks, and the other copy is stored on another set of disks. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
ASM failure groups also provide the option to spread the data across different storage servers, this way, even if a storage server fails, data can still be accessed from the other storage servers in the group. This will improve the availability of the data.
NEW QUESTION # 44
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 384GB
- B. 1024GB
- C. 2048GB
- D. 1536GB
- E. 768GB
- F. 512GB
Answer: C
Explanation:
The Exadata X9M-2 Database Machine uses powerful database servers, each with two 32-core x86 processors and 512 GB of memory (expandable up to 2 TB).
NEW QUESTION # 45
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST IBPORT DETAIL"
- D. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
Answer: C
Explanation:
The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], this command is only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M.
https://forums.oracle.com/ords/apexds/map/tech/apps-infra/discussion/4342715/monitoring-roce-performance
NEW QUESTION # 46
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?
- A. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
- B. alert logs for the prod database instances
- C. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- D. alert logs for the ASM instances
- E. alert logs for Enterprise Manager
Answer: B,D
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.
NEW QUESTION # 47
......
Oracle 1z1-902 exam is designed to test the skills and knowledge of professionals who are interested in implementing the Oracle Exadata Database Machine X8M. 1z1-902 exam is a vendor-specific certification that is intended for IT professionals who are responsible for implementing and managing the Exadata Database Machine in their organizations. Oracle Exadata Database Machine X8M Implementation Essentials certification is a great way for professionals to demonstrate their expertise in implementing and managing Oracle Exadata Database Machine X8M.
1z1-902 Exam Dumps, 1z1-902 Practice Test Questions: https://www.ipassleader.com/Oracle/1z1-902-practice-exam-dumps.html
Free 1z1-902 Exam Dumps to Pass Exam Easily: https://drive.google.com/open?id=1wApeaPKb9M3hzHbCFsFXS8IAJ3JYS9Qd