1Z0-902 Exam Info and Free Practice Test All-in-One Exam Guide May-2023
Pass Oracle 1Z0-902 Actual Free Exam Q&As Updated Dump May 28, 2023
The Oracle 1z1-902 exam, also known as the Oracle Exadata Database Machine X8M Implementation Essentials exam, is a certification exam designed to test the knowledge and skills of IT professionals in implementing and managing the Oracle Exadata Database Machine X8M system. This exam is intended for professionals who have experience with this system and want to validate their expertise in this area.
Oracle: How to Prepare and Pass the Oracle 1Z0-902 Exam
Study Tips For Completing The Oracle Exadata Database Machine X9M Implementation Essentials
How To Score High on Oracle 1Z0-902 Exam: A guide about how to succeed in the Oracle 1Z0-902 Exam
Are you planning to get the certification of Oracle 1Z0-902 from the leading IT provider, Certifications Pass? If yes, then this question is for you.
To begin with, the certification of Oracle 1Z0-902 is one of the most highly demanded certifications around. So if you want to get a high-paying job and a comfortable career in this competitive field, then you need to go for this certification.
As we have seen in this article, the preparation process for the Oracle 1Z0-902 certification exam is not a walk in the park. But if you do everything right during this period, it is pretty sure that you can achieve success with ease. Certification-Question Oracle 1Z0-902 exam dumps are the best.
We understand that the certification of Oracle 1Z0-902 is not easy, and it requires a lot of dedication and hard work. However, in this article, we are going to discuss the preparation process in detail and teach you how to prepare for this exam without any stress.
The Oracle 1Z0-902 (Oracle Exadata Database Machine X8M Implementation Essentials) Certification Exam is designed to test the skills and knowledge of professionals who are involved in the implementation and management of Oracle Exadata Database Machine X8M. The exam is intended for those who have experience in Oracle database administration and are looking to advance their skills in Exadata implementation.
NEW QUESTION # 27
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?
- A. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- B. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- C. Add the griddisks back into the ASM diskgroup they used to be a member of.
- D. Replace the failed physical disk.
- E. Create a new celldisk and new griddisks on the replaced physical disk.
- F. Rebalance the data on the effected griddisks before performing a manual drop command.
Answer: B,D
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.
NEW QUESTION # 28
Which three statements are true about the CELLCLI command?
- A. It can execute commands on multiple storage servers in parallel.
- B. It requires root privileges to create CELLDISKS and GRIDDISKS.
- C. It can be executed using the DCLI utility.
- D. It can be executed on storage servers.
- E. It has command-line history.
Answer: C,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 once54.
NEW QUESTION # 29
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR can upload configuration metadata to support problem resolution.
- B. ASR Manager must be installed and configured on one of the database servers.
- C. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- D. ASR communicates with Oracle support services using HTTPS.
- E. Configuring ASR is mandatory for all Database Machine assets.
- F. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
Answer: A,F
Explanation:
1. ASR can upload configuration metadata to support problem resolution1.
2. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults1
https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm
NEW QUESTION # 30
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 10Gb ports on eth3 and eth4 using RJ45 cat6 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 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using SFP28 transceivers and OM4 fiber cable for client network
- D. 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
Answer: A,D
NEW QUESTION # 31
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Cache section within Exadata Smart Statistics
- B. PMEM Cache section within Memory Statistics
- C. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- D. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- E. PMEM Pool Misses in the Exadata Outlier Summary
Answer: B,D
Explanation:
The "cell PMEM cache Read Hits" in the "Database IOs" portion of the "Performance Summary" will show the number of reads that have been satisfied from the Persistent Memory Cache. The "PMEM Cache" section within "Memory Statistics" will give detailed information about the usage of the Persistent Memory Cache, such as cache size, used size, hit rate, etc. This information can help to identify if the Persistent Memory Cache is being used effectively and if there are any issues with it.
NEW QUESTION # 32
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Cell Offload Quarantine
- B. Disk Region Quarantine
- C. SQL Plan Quarantine
- D. Manually created Quarantine
- E. Database Quarantine
Answer: C,E
NEW QUESTION # 33
You are updating your Exadata X9M-2 Elastic Database Machine with 6 database servers and 12 High Capacity Storage Servers. You will be using patchmgr to apply updates across the entire machine while still maintaining database availability.
Assuming you are driving patchmgr from an external server, which statement is true about the execution phase?
- A. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
- B. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
- C. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
- D. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
Answer: A
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], patchmgr can be used to apply updates in a rolling manner while still maintaining database availability. It will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption. This is done by invoking patchmgr with the -rolling argument and specifying the component groups in the input file.
NEW QUESTION # 34
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?
- A. OS I/O metrics using Enterprise Manager host pages for the storage servers
- B. OS I/O metrics using OS tools such as iostat on the database servers
- C. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
- D. OS I/O metrics using OS tools such as iostat on the storage servers
- E. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod
database instances using SQL *p1us
Answer: B,C
NEW QUESTION # 35
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:
What steps and in which order should they be executed?
- A. 6, 2, 1, 8, 4, 5
- B. 6, 3, 1, 9, 7, 8
- C. 6, 8, 3, 4, 2, 1
- D. 6, 1, 2, 7, 5, 8
Answer: B
NEW QUESTION # 36
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 # 37
How do ASM failure groups provide redundancy?
- A. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
- B. 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.
- C. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- D. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
Answer: A
NEW QUESTION # 38
You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should use use to generate alerts for such an event?
- A. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
- B. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
- C. dbmcli -e "set alert ds_temp> 30" on each database server
- D. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
Answer: B
Explanation:
The correct command to generate alerts for an event when the temperature of the database servers in an Exadata Full Rack exceeds 30C is "dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server". The dbmcli is the command-line interface for the Oracle Database Management Agent (DMA), which allows you to perform various management tasks on the Exadata servers. This command creates a threshold for the ds_temp metric with a comparison operator of ">" (greater than), and a critical value of 30. The threshold is set on all database servers in the Exadata Full Rack, so when the server temperature exceeds 30C, an alert will be generated.
NEW QUESTION # 39
Which statement is true about the patching features provided in Platinum Services?
- A. The rolling and complete down time approaches are two options to patching.
- B. Patching services are available for the full software stack up to twice per year.
- C. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
- D. Patching is done automatically during business hours.
Answer: B
Explanation:
Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.
NEW QUESTION # 40
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: B,D
Explanation:
1. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
2. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/
NEW QUESTION # 41
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?
- A. 7,6,9,11
- B. 4,1, 6, 9
- C. 10, 8, 9, 11
- D. 10, 8, 2, 5
- E. 0
Answer: C
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.
NEW QUESTION # 42
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?
- A. 2, 8, 7, 3, and 6
- B. 2, 7, 8, and 6
- C. 5, 8, 7, and 6
- D. 4, 7, 8, 3, and 6
- E. 1, 8, 7, 3 and 6
Answer: C
Explanation:
Option 5 stops the clusterware on all database servers as the grid user3.
Option 8 shuts down all Exadata storage servers using their ILOM interfaces1.
Option 7 shuts down all database servers using their ILOM interfaces1.
Option 6 powers off the rack using the power switches on the PDUs2.
NEW QUESTION # 43
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Cache section within Exadata Smart Statistics
- B. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- C. PMEM Cache section within Memory Statistics
- D. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- E. PMEM Pool Misses in the Exadata Outlier Summary
Answer: A,C
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 # 44
......
Online Questions - Valid Practice 1Z0-902 Exam Dumps Test Questions: https://www.fast2test.com/1Z0-902-premium-file.html
Latest 1Z0-902 Actual Free Exam Updated 62 Questions: https://drive.google.com/open?id=1cNlCayi8r8FP6TgCtmoja178aVFqXJaw