Jun-2023 Get Totally Free Updates on 1Z0-902 Dumps PDF Questions
Prepare With Top Rated High-quality 1Z0-902 Dumps For Success in 1Z0-902 Exam
The Oracle 1z1-902 certification exam is a multiple-choice exam that contains 70 questions. The exam duration is two hours, and candidates must score at least 63% to pass the exam. The exam is available in English and Japanese languages and can be taken online or in-person at a Pearson VUE testing center. Upon passing the exam, candidates will receive an Oracle certification that validates their skills and knowledge in implementing and managing the Exadata Database Machine X8M.
The Oracle 1z1-902 (Oracle Exadata Database Machine X8M Implementation Essentials) Certification Exam is designed to validate the skills and knowledge of IT professionals who are responsible for implementing and managing Oracle Exadata Database Machine X8M. The exam covers a range of topics related to Exadata implementation and management, and candidates should have a strong understanding of Oracle database technology and experience with Oracle database administration and performance tuning to succeed on the exam.
The Oracle 1Z0-902 exam is intended for professionals who want to implement and maintain the Exadata X8M system. The exam covers various topics, including the architecture of the Exadata system, database deployment, configuration, and management, backup and recovery, and performance tuning. The exam requires candidates to have a strong understanding of Exadata X8M components and their interactions.
NEW QUESTION # 37
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?
- A. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
- B. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
- C. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
- D. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
Answer: A,C
Explanation:
1. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine2.
2. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA2.
NEW QUESTION # 38
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. Wait for the email of the failure that Exadata or Enterprise Manager will send.
- B. Download and run the latest exadiag tool.
- C. Call Oracle Support and make an appointment so that the drive can be replaced.
- D. Wait for a blue light to appear on the disk if the rebalance operation is running.
- E. Ask the system administrator to replace the broken disk with a spare.
- F. Check the database to see if any rebalance operations are active.
Answer: C
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 # 39
You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?
- A. The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.
- B. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
- C. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
- D. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
Answer: A
Explanation:
The MS process on Exadata storage servers is natively endowed with REST services and these services are enabled by default. However, it is important to create appropriate roles and users to ensure security when accessing these services. This way, it is possible to disable ssh access to the storage servers, and still enable REST access to the MS process. It's not necessary to install Oracle Rest Data Services on each Database or Storage server or install the MS APEX application, the MS process on the storage servers already have REST services by default.
NEW QUESTION # 40
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- B. PMEM Cache section within Exadata Smart Statistics
- C. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- D. PMEM Pool Misses in the Exadata Outlier Summary
- E. PMEM Cache section within Memory Statistics
Answer: C,E
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 # 41
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?
- A. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
- B. CellCLI alter GRIDDISK all inactive on the affected storage server
- C. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
- D. shutdown -h now' on the affected storage server
- E. 'crsct1 stop cluster -all' on one of the database servers
- F. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
Answer: D
Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB
NEW QUESTION # 42
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 at least two storage servers in both racks
- C. on all storage servers in both racks
- D. on all database servers in the second rack
- E. on only one database server in both racks
- F. on all database servers in the first rack
- G. on all database servers and at least two storage servers in both racks
Answer: C,F
NEW QUESTION # 43
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Install on Oracle Database Appliance.
- B. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- C. Provide individual x86 64-Bit gateway hardware.
- D. Install in Oracle Virtual Machine with required hardware.
- E. Install on Exadata Engineered System.
Answer: A,B,C
Explanation:
According to Oracle's documentation1, the customer options for hosting the Platinum Services Advanced Support Gateway are:
Provide individual x86 64-Bit gateway hardware1
Purchase the recommended x86 64-Bit gateway hardware from Oracle1
Install on Oracle Database Appliance2
NEW QUESTION # 44
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- B. 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.
- 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. 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.
Answer: B,D
Explanation:
According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:
1. 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.
2. 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.
NEW QUESTION # 45
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?
- A. Add 16x 64GB DIMMs.
- B. Add 24x 32GB DIMMs.
- C. Remove existing memory modules.
- D. Shutdown the Database Server if running.
- E. Add 16x 32GB DIMMs.
- F. Add 32x 64GB DIMMs.
- G. Add 12x 64GB DIMMs.
- H. Add 12x 32GB DIMMs.
- I. Memory cannot be expanded on Exadata X9M-2 Database Servers.
Answer: A,C,D
Explanation:
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.
NEW QUESTION # 46
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 cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
- B. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
- C. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
- D. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
Answer: C
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 # 47
Which two statements are true about applying updates on Exadata systems?
- A. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- B. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- C. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- D. Failed database server updates are rolled back to a working state on a previous release automatically.
- E. Failed storage server updates are automatically rolled back to a previous release.
- F. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
Answer: A,D
NEW QUESTION # 48
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. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- B. Replace the failed physical disk.
- C. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- D. Create a new celldisk and new griddisks on the replaced physical disk.
- E. Add the griddisks back into the ASM diskgroup they used to be a member of.
- F. Rebalance the data on the effected griddisks before performing a manual drop command.
Answer: A,B
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 # 49
Which two statements are true about applying updates on Exadata systems?
- A. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- B. Failed storage server updates are automatically rolled back to a previous release.
- C. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- D. Failed database server updates are rolled back to a working state on a previous release automatically.
- E. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- F. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
Answer: B,E
Explanation:
According to Oracle's documentation12, some of the statements that are true about applying updates on Exadata systems are:
Failed storage server updates are automatically rolled back to a previous release1.
When running a "yum update" for a new Exadata release, all other repositories should be disabled1.
NEW QUESTION # 50
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. 5, 8, 7, and 6
- B. 4, 7, 8, 3, and 6
- C. 1, 8, 7, 3 and 6
- D. 2, 8, 7, 3, and 6
- E. 2, 7, 8, and 6
Answer: C
Explanation:
In order to power off an Exadata Database Machine in an orderly fashion, the commands should be executed in the following order: 1) Execute "crscti stop cluster -all" as the grid user from one database server; 2) Execute "shutdown -h now" on all database servers; 3) Power off all network switches; 4) Execute "shutdown -h now" on all Exadata storage servers; and 5) Power off the rack using the power switches on the PDUs. This sequence of commands ensures that all services running on the Exadata Database Machine are in a clean state before powering off the system. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 543)
NEW QUESTION # 51
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- B. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- C. The incline of any access route ramp must be less than or equal to 6 degrees.
- D. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- E. Oracle Exadata Rack may only be installed on raised floor environments.
- F. 914mm of space required above the rack height is required for maintenance access.
Answer: E
Explanation:
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors Oracle Exadata Database Machine X9M Implementation Essentials states that Exadata racks are designed to be installed on flat surfaces, not raised floor environments. It is not required to install the rack on raised floor environments. Additionally, the other options listed are all requirements for validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 41)
NEW QUESTION # 52
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. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- B. Rebalance the data on the effected griddisks before performing a manual drop command.
- C. Replace the failed physical disk.
- D. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- E. Create a new celldisk and new griddisks on the replaced physical disk.
- F. Add the griddisks back into the ASM diskgroup they used to be a member of.
Answer: B,C
NEW QUESTION # 53
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Manually created Quarantine
- B. Database Quarantine
- C. SQL Plan Quarantine
- D. Cell Offload Quarantine
- E. Disk Region Quarantine
Answer: A,B
NEW QUESTION # 54
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- B. PMEM Cache section within Exadata Smart Statistics
- C. PMEM Pool Misses in the Exadata Outlier Summary
- D. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- E. PMEM Cache section within Memory Statistics
Answer: E
NEW QUESTION # 55
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?
- A. Using EXADCLI instead of CELLCLI to create the griddisks
- B. Exadata storage realms using ASM-scoped security mode
- C. File permissions on the griddisks in each database server
- D. File permissions on the griddisks in each storage server
- E. Exadata storage realms using database-scoped security mode
Answer: B,E
Explanation:
Exadata storage realms using ASM-scoped security mode allows you to control which database can access which griddisks by creating realms at the ASM level, thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.2 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
Exadata storage realms using database-scoped security mode allows you to control which database can access which griddisks by creating realms at the database level [1], thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.3 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [2].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf [2] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf
NEW QUESTION # 56
A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU.
Which statement is correct?
- A. A splitter cable can be used to provide power to all PDU cables.
- B. The installation cannot proceed until two power feeds are available per PDU.
- C. The installation can go ahead, no change is required.
- D. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
Answer: C
Explanation:
According to the Oracle Exadata Database Machine X9M-2 Data Sheet1, each PDU has two power input cables that can be connected to separate power sources for redundancy. However, if only one power source is available per PDU, then a single cable can be used to provide sufficient power for normal operation.
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
NEW QUESTION # 57
......
Get 100% Success with Latest Oracle Engineered Systems 1Z0-902 Exam Dumps: https://www.dumpsactual.com/1Z0-902-actualtests-dumps.html
1Z0-902 Free Certification Exam Easy to Download PDF Format 2023: https://drive.google.com/open?id=1bVuBg0kOPfk7C80nF8AAbBk7MU35lf-4
