Oracle Engineered Systems Certified Official Practice Test 1Z0-902 - Apr-2023
Ace Oracle 1Z0-902 Certification with Actual Questions Apr 05, 2023 Updated
What is the salary of Oracle Exadata Database Machine X9M Implementation Essentials
The Average salary of different countries of Oracle Exadata Database Machine X9M Implementation Essentials Professionals
United States: USD 69,000
United Kingdom: Pounds 61746
India: INR 4140251
NEW QUESTION 27
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?
- A. Oracle clusterware on the database server
- B. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- C. the Power Distribution Units (PDUs)
- D. the RDMA over Converged Ethernet (RoCE) switches
- E. the storage server ILOM
- F. ASM instances
Answer: A,E,F
Explanation:
1. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor ASM instances.
2. Additionally, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor the storage server ILOM.
3. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) also recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor Oracle clusterware on the database server.
NEW QUESTION 28
You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.
The new storage servers are called DM01CEL08 through dmoicel14.
After creating 96 new griddisks, you issued this SQL statement:
How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?
- A. 12 consisting of seven griddisks each
- B. 1 consisting of all 96 griddisks
- C. 0 because the new griddisks will be added to the existing faiigroups
- D. 96 consisting of one griddisk each
- E. 7 consisting of 12 griddisks each
Answer: B
Explanation:
This SQL statement is adding the new griddisks to the existing diskgroup "DATA" and creating one new failgroup, consisting of all 96 griddisks. The "REBALANCE POWER 512" option tells the system to perform a rebalance operation with a power of 512. It means the system distributes the data evenly across all the disks in the diskgroup using a power of 512.
NEW QUESTION 29
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Cache section within Memory Statistics
- B. PMEM Cache section within Exadata Smart Statistics
- C. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- D. PMEM Pool Misses in the Exadata Outlier Summary
- E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
Answer: A,B
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 30
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. The installation can go ahead, no change is required.
- B. A splitter cable can be used to provide power to all PDU cables.
- C. 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.
- D. The installation cannot proceed until two power feeds are available per PDU.
Answer: D
Explanation:
An Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs would typically require two power feeds per PDU, one for each of the two power distribution units (PDUs) in the rack. A single power feed per PDU is not sufficient to provide the necessary power to the servers and storage in the rack.
The installation cannot proceed until two power feeds are available per PDU. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], it is recommended that each PDU should have at least two power feeds from different power sources in the data center. This is to ensure redundancy and avoid any power interruption due to power failure on one of the power sources. Splitter cables are not recommended, as they can reduce efficiency and increase the risk of overheating. Rearranging the power cables within the rack is not recommended either, as it does not provide the necessary redundancy for the PDU.
NEW QUESTION 31
Which two statements are true about applying updates on Exadata systems?
- A. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- B. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- C. Failed database server updates are rolled back to a working state on a previous release automatically.
- D. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- E. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- F. Failed storage server updates are automatically rolled back to a previous release.
Answer: C,F
Explanation:
When applying updates on Exadata systems, database server updates are automatically rolled back to a working state on a previous release if the update fails. This ensures that the system can be restored to a working state in the event of a failed update. Additionally, storage server updates are also automatically rolled back to a previous release in the event of a failed update.
This is documented in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and more information can be found on the Oracle support website [1][2].
NEW QUESTION 32
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?
- A. Oracle clusterware on the database server
- B. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- C. the Power Distribution Units (PDUs)
- D. the RDMA over Converged Ethernet (RoCE) switches
- E. the storage server ILOM
- F. ASM instances
Answer: A,E,F
NEW QUESTION 33
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 8.0
- B. Oracle Linux 7.5
- C. Oracle Linux 7.7
- D. Oracle Linux 7.9
Answer: D
Explanation:
RoCE (RDMA over Converged Ethernet) and Persistent Memory are features that are supported by Oracle Linux. The minimum version of Oracle Linux required to support RoCE and Persistent Memory is Oracle Linux 7.9.
RoCE is a low-latency, high-bandwidth networking technology that enables fast data transfer between servers using converged Ethernet networks. It is supported by Oracle Linux 7.9 and later versions, which includes the necessary kernel modules and user-space libraries to enable RoCE.
Persistent Memory is a technology that allows data to be stored in non-volatile memory (NVM) devices, such as NVDIMMs (Non-Volatile Dual In-line Memory Modules), which can be accessed at near-DRAM speeds. Oracle Linux 7.9 and later versions include support for Persistent Memory, which includes kernel modules and user-space libraries to enable Persistent Memory.
NEW QUESTION 34
Which statement is true about the Persistent Memory Commit Accelerator?
- A. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
- B. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
- C. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
- D. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
- E. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
Answer: C
NEW QUESTION 35
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?
- A. Normal
- B. Sparse
- C. Extended
- D. External
- E. High
Answer: E
Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf
NEW QUESTION 36
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. alert logs for the ASM instances
- B. alert logs for Enterprise Manager
- C. alert logs for the prod database instances
- D. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
- E. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
Answer: D,E
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 storage servers in both racks
- B. on all database servers in both racks and one storage server in each rack
- C. on all database servers in the second rack
- D. on at least two storage servers in both racks
- E. on only one database server in both racks
- F. on all database servers and at least two storage servers in both racks
- G. on all database servers in the first rack
Answer: D,F
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 three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
- A. Collected configuration information can be uploaded manually to Oracle.
- B. It is mandatory to install OCM on at least one database server.
- C. It collects configuration information on demand.
- D. Collected configuration information can be uploaded automatically to Oracle.
- E. It is mandatory to install OCM on all database servers.
- F. It collects configuration information automatically.
Answer: B,D,E
NEW QUESTION 39
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. 4, 7, 8, 3, and 6
- C. 2, 7, 8, and 6
- D. 5, 8, 7, and 6
- E. 1, 8, 7, 3 and 6
Answer: C
NEW QUESTION 40
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. Cisco management switch
- B. Cisco RDMA over Converged Ethernet (RoCE) switches
- C. fans in the storage servers
- D. RoCE network interface cards in the database servers
- E. power distribution units
- F. power supplies in the database servers
- G. RoCE network interface cards in the storage servers
Answer: C,E,F,G
Explanation:
Auto Service Request (ASR) will raise service requests for component failures in RoCE network interface cards in the storage servers, fans in the storage servers, power distribution units, and power supplies in the database servers. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book , which states "ASR will raise service requests for component failures in RoCE network interface cards in the storage servers [1], fans in the storage servers, power distribution units, and power supplies in the database servers" (page 5-11).
NEW QUESTION 41
Which two statements are true in regards to starting the Exadata Virtual Machine?
- A. Use vm_maker boot-from-iso command to boot a virtual machine.
- B. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
- C. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
- D. Use vm_maker -start-domain to start a virtual machine manually.
- E. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
Answer: D,E
NEW QUESTION 42
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- B. Run exachk and resolve only WARNINGS that you have not seen before.
- C. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- D. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- E. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- F. Run the appropriate patchmgr preqequisite check step for each component being updated.
Answer: A,D,E,F
NEW QUESTION 43
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?
- A. corruption in the / (root) filesystem
- B. the failure of both physical M.2 disks
- C. the failure of physical disk 0 and 11
- D. corruption in a normal or high redundancy ASM diskgroup
- E. moving all disks from one cell to another as part of a chassis-level component failure
- F. accidental loss of all data from all griddisks in a storage server
- G. the failure of physical disk 1
Answer: A,F
Explanation:
Reason B, corruption in the / (root) filesystem, is a valid reason for executing a storage server rescue procedure. If the root filesystem is corrupted, the storage server will no longer be able to boot and will need to be rescued.
Reason F, accidental loss of all data from all griddisks in a storage server, is also a valid reason for executing a storage server rescue procedure. If all data is accidentally lost from the griddisks in a storage server, the server will need to be rescued in order to recover the data.
For more information about the Exadata X9M-2 storage server rescue procedure, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation - Oracle Docs [2] Oracle Exadata Database Machine X9M-2 Storage Server Rescue Procedure - Oracle Docs [3] Oracle Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs [4] Oracle Exadata Database Machine X8M-2 Storage Server Rescue Procedure - Oracle Docs [5] Oracle Exadata Database Machine X9M-2 Storage Server Update Procedure - Oracle Docs [6] Oracle Exadata Database Machine X8M-2 Storage Server Update Procedure - Oracle Docs
NEW QUESTION 44
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
Answer: B
NEW QUESTION 45
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 the first rack
- B. on at least two storage servers in both racks
- C. on all database servers and at least two storage servers in both racks
- D. on all database servers in both racks and one storage server in each rack
- E. on all database servers in the second rack
- F. on only one database server in both racks
- G. on all storage servers in both racks
Answer: A,G
NEW QUESTION 46
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
- D. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
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 47
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- B. Multiple Databases on a cluster
- C. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- D. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- E. A single database with one or more schema per application
- F. Bare Metal deployment with one database per database server
Answer: A,B,D
Explanation:
A Exadata supports multiple pluggable databases in one or more container databases, which enables database consolidation by allowing multiple databases to be consolidated into a single container database. This can be deployed on a Virtual Machine or Bare Metal cluster.
D Multiple databases spanning a Bare Metal and Virtual Machine cluster provide resource isolation and consolidation concurrently. It allows multiple databases to be deployed on both Bare Metal and Virtual Machine clusters, providing isolation and consolidation at the same time.
E Multiple Databases on a cluster allows multiple databases to be deployed on a single cluster, which enables consolidation of databases by reducing the number of clusters required.
NEW QUESTION 48
You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?
- A. 2,6,1,4,3,7,5
- B. 3,2,6,4,1,7,5
- C. 4,3,2,6,1,7,5
- D. 3,2,6,1,4,7,5
- E. 2,3,4,6,1,7,5
Answer: E
Explanation:
This ordering is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. First, the Exadata should be stabilized and unpacked (Steps 2 and 3). Then, the safety guidelines should be reviewed (Step 4). The Exadata should then be allowed to acclimatize for 24 hours (Step 4). After that, the Exadata PDU A should be powered on (Step 6) and the Exadata should be placed in its allocated space (Step 6). Finally, the Exadata PDU B should be powered on (Step 7).
NEW QUESTION 49
......
Learn about the difficulty of the Oracle 1Z0-902 Exam
The Oracle 1Z0-902 Exam is an important exam for candidates. They have to study hard to pass the exam. But if you don't want to spend lots of time and energy preparing for the exam, you could get Oracle 1Z0-902 exam dumps from us.
With this, you could save a lot of time and effort. You could easily practice the 1Z0-902 questions and answers, and you could also get the latest 1Z0-902 exam questions. So, you could pass the exam easily.
If you are unable to read the entire syllabus, then you must read the table of contents. The table of contents of the exam will help you to find out the topics that you have to focus on for the exam.
There are two ways to get the best result in the exam. One of the ways is to buy the study material. The other way is to attend the lectures of the trainers who are experienced in the field. Both the methods will help you to get the best result in the exam.
These are the steps that you need to follow to prepare for the exam. If you are unable to follow the steps then you can take the help of the professional trainers. They will guide you and will help you to get the best result in the exam.
What is Oracle 1Z0-902 Exam
Oracle Exadata Database Machine X9M Implementation Essentials Exam is an industry-recognized certification that is offered by Oracle. With the Oracle 1Z0-902 Exam, you will be able to build a complete portfolio of technical skills that will help you work for Oracle.
Oracle Exadata Database Machine (XDB) is a high-performance data warehouse appliance. It is designed to deliver performance that is 10x faster than traditional storage arrays, while simultaneously providing up to 100 times higher transaction rates than existing enterprise-class databases. Oracle Exadata Database Machine (XDB) is built on the latest generation of Oracle Exadata Database Technology (XDT), which enables the platform to deliver breakthrough performance. Oracle 1Z0-902 exam dumps are the key of success.
Oracle Exadata Database Machine (XDB) is an extension of Oracle Exadata Database Technology (XDT) that extends the benefits of database technology to the storage layer. It provides a new level of scalability, performance, and resiliency that is unparalleled by any other storage solution available.
The braindumps dose not provide guarantee to pass the exam and didn't provide the refund money policy failed the exam. We are offer real products questions in our actual testing engine simulator for learning tests to improve, update and ensure correct totally synchronous committed finding style to motivate customer. We are providing free demo account PDF for the confidence to get certified scores rate and customer service support remote team will help you to get disk difficult courses.
Try Free and Start Using Realistic Verified 1Z0-902 Dumps Instantly.: https://www.dumpstorrent.com/1Z0-902-exam-dumps-torrent.html
2023 The Most Effective 1Z0-902 with 62 Questions Answers: https://drive.google.com/open?id=18IL5yE_K5I1qLjFGtfyUOG1gl9Z0vXgy