All Obstacles During 1Z0-902 Exam Preparation with 1Z0-902 Real Test Questions
Fully Updated Free Actual Oracle 1Z0-902 Exam Questions
To take the Oracle 1z1-902 exam, candidates must have a solid understanding of database concepts and architecture, as well as experience with Oracle database administration and management. They should also be familiar with the Exadata Database Machine X8M hardware and software components, including the storage servers, database servers, InfiniBand network, and Exadata software. Additionally, candidates should be familiar with backup and recovery strategies, as well as performance tuning techniques.
Oracle 1Z0-902: Oracle Exadata Database Machine X8M Implementation Essentials exam is a widely recognized certification exam that is intended to validate the skills and knowledge of professionals who are looking to implement Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification exam is designed to demonstrate that the candidate has the necessary skills and knowledge to implement Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification is highly valued in the IT industry and can help professionals advance their careers.
NEW QUESTION # 34
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 32GB DIMMs.
- B. Shutdown the Database Server if running.
- C. Add 16x 64GB DIMMs.
- D. Memory cannot be expanded on Exadata X9M-2 Database Servers.
- E. Add 12x 64GB DIMMs.
- F. Add 12x 32GB DIMMs.
- G. Add 32x 64GB DIMMs.
- H. Add 24x 32GB DIMMs.
- I. Remove existing memory modules.
Answer: B,C,I
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.
The steps required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration are as follows:
Shutdown the Database Server if running.
Remove existing memory modules.
Add 16x 64GB DIMMs.
For reference, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "the lowest memory configuration for the Exadata X9M-2 Database Servers is 384GB and the highest is 768GB [1]. The memory upgrade is done in increments of 64GB using 16x 64GB DIMMs".
NEW QUESTION # 35
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?
- A. ZFS Snapshots can provide rapid cloning of development and test environment.
- B. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
- C. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
- D. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
Answer: B,C
Explanation:
1. ZFS Storage Appliance (ZFSSA) can't connect directly to the Exadata 100Gb RoCE network switches. ZFSSA uses Fibre Channel protocol to connect to the Exadata storage cells. C. When backing up multi-rack systems, sharing Exadata X9M switches is not recommended. Each rack should have its own switches to minimize the risk of data loss due to switch failure.
NEW QUESTION # 36
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. Each component type must be upgraded independently of the other.
- 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 with all database and storage servers listed in a single input file.
Answer: D
NEW QUESTION # 37
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. Check the database to see if any rebalance operations are active.
- B. Ask the system administrator to replace the broken disk with a spare.
- C. Call Oracle Support and make an appointment so that the drive can be replaced.
- D. Wait for the email of the failure that Exadata or Enterprise Manager will send.
E Download and run the latest exadiag tool. - E. Wait for a blue light to appear on the disk if the rebalance operation is running.
Answer: B
NEW QUESTION # 38
You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?
- A. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
- B. Copy and execute the script on all storage servers using the EXACLI command.
- C. Copy and execute the script on all storage servers using the dcli command.
- D. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
- E. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
Answer: C
Explanation:
According to Oracle's documentation1, the Cell Control Command-Line Interface (CellCLI) utility is the command-line administration tool for Oracle Exadata System Software. It can be used to perform various tasks on Exadata Storage Servers, such as creating and managing objects, monitoring performance, and configuring alerts.
To run CELLCLI commands on multiple cells simultaneously, you can use the Distributed Command-Line Interface (dcli) utility2. The dcli utility allows you to execute commands or scripts on a group of cells or hosts in parallel. You can use the dcli utility to copy files from one cell or host to multiple cells or hosts using the -f option3. You can also use the dcli utility to execute commands or scripts on multiple cells or hosts using the -l option to specify a user name and the -g option to specify a file containing a list of cells or hosts3.
Therefore, to achieve your requirement of running a script with several CELLCLI commands on each cell in your Exadata full rack simultaneously, you must:
Copy and execute the script on all storage servers using the dcli command.
NEW QUESTION # 39
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. Exadata storage realms using database-scoped security mode
- B. File permissions on the griddisks in each storage server
- C. Using EXADCLI instead of CELLCLI to create the griddisks
- D. File permissions on the griddisks in each database server
- E. Exadata storage realms using ASM-scoped security mode
Answer: B,C
NEW QUESTION # 40
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. fans in the storage servers
- B. power supplies in the database servers
- C. power distribution units
- D. RoCE network interface cards in the storage servers
- E. Cisco management switch
- F. Cisco RDMA over Converged Ethernet (RoCE) switches
- G. RoCE network interface cards in the database servers
Answer: A,B,C,D
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 sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool Misses in the Exadata Outlier Summary
- B. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- C. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- D. PMEM Cache section within Exadata Smart Statistics
- E. PMEM Cache section within Memory Statistics
Answer: E
NEW QUESTION # 42
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- B. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- C. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- D. Run exachk and resolve only WARNINGS that you have not seen before.
- E. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- F. Run the appropriate patchmgr preqequisite check step for each component being updated.
Answer: A,C,E,F
NEW QUESTION # 43
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. configuring secure shell user equivalency for the cellmonitor user
- B. upgrading the Storage Server software package using rpm
- C. changing the root password
- D. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- E. installing an alternative package manager
Answer: A,C
Explanation:
According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
1. changing the root password
2. configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html
NEW QUESTION # 44
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. SQL Plan Quarantine
- C. Disk Region Quarantine
- D. Database Quarantine
- E. Cell Offload Quarantine
Answer: A,D
NEW QUESTION # 45
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. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
- B. 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.
- 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 Storage server and install the MS APEX application.
Answer: B
NEW QUESTION # 46
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 OS tools such as iostat on the database servers
- B. OS I/O metrics using Enterprise Manager host pages for the storage servers
- C. 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
- D. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
- E. OS I/O metrics using OS tools such as iostat on the storage servers
Answer: C,D
Explanation:
According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer.
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 *plus. These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.
NEW QUESTION # 47
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 CALIBRATE command on the storage server after logging in as the root user
- C. using the CELLCLI list LUN DETAIL command as the celladmin user
- D. hardware monitoring using the storage server ILOM
Answer: A,C
NEW QUESTION # 48
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: B
NEW QUESTION # 49
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 512GB
- B. 384GB
- C. 768GB
- D. 1536GB
- E. 1024GB
- F. 2048GB
Answer: F
NEW QUESTION # 50
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 database servers and at least two storage servers in both racks
- C. on at least two storage servers in both racks
- D. on all database servers in the second rack
- E. on all storage servers in both racks
- F. on only one database server in both racks
- G. on all database servers in the first rack
Answer: A,B
NEW QUESTION # 51
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?
- A. ZFS Snapshots can provide rapid cloning of development and test environment.
- B. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
- C. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
- D. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
Answer: B,C
Explanation:
A) ZFS Storage Appliance (ZFSSA) can't connect directly to the Exadata 100Gb RoCE network switches. ZFSSA uses Fibre Channel protocol to connect to the Exadata storage cells.
C) When backing up multi-rack systems, sharing Exadata X9M switches is not recommended. Each rack should have its own switches to minimize the risk of data loss due to switch failure.
Review the safety guidelines.
Unpack Oracle Exadata Rack.
Let the Exadata acclimatize for 24 hours.
Place Exadata in its allocated space.
Stabilize the Exadata Rack.
Power on Exadata PDU A.
Power on Exadata PDU B.
This order ensures that the necessary safety precautions are taken before installing the Exadata Database Machine, and that the machine is allowed to acclimate to its new environment before being powered on.
NEW QUESTION # 52
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 2048GB
- B. 512GB
- C. 384GB
- D. 768GB
- E. 1536GB
- F. 1024GB
Answer: E
Explanation:
According to 1, Exadata X9M-2 Database Servers are based on Intel Xeon Platinum 8368Y processors with 32 cores and 768 GB of DRAM memory per server. This memory can be expanded up to 1.5 TB per server by adding 24 x 32 GB DIMMs. The DRAM memory is used for buffer cache, PGA, and other database purposes1. Exadata X9M-2 Database Servers also have 25.6 TB of Persistent Memory Acceleration (PMEM) per server, which is used for log writes and columnar data caching1. PMEM is a new type of memory that combines the speed of DRAM with the persistence of flash2. Exadata X9M-2 Database Servers are designed to run Oracle Database workloads with high performance, scalability, and reliability2
NEW QUESTION # 53
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool Misses in the Exadata Outlier Summary
- B. cell PMEM cache Read Hits in the Database IOs portion of the Performance 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: 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 # 54
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. Check the database to see if any rebalance operations are active.
- B. Ask the system administrator to replace the broken disk with a spare.
- C. Call Oracle Support and make an appointment so that the drive can be replaced.
- D. Wait for the email of the failure that Exadata or Enterprise Manager will send.
- E. Wait for a blue light to appear on the disk if the rebalance operation is running.
- F. Download and run the latest exadiag tool.
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 # 55
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 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
- C. 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
- 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: A,B
Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
NEW QUESTION # 56
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 list LUN DETAIL command as the celladmin user
- B. using the CELLCLI CALIBRATE command on the storage server after logging in 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
Explanation:
The CELLCLI CALIBRATE command can be used to check the health of all flash cards in the storage server, and it should be run after logging in as the celladmin user. The hardware monitoring using the storage server ILOM should also be used to check for errors and other potential issues with the flash cards. The CELLCLI list LUN DETAIL command should not be used to identify a damaged or failing flash card, since it will not provide any information about the health of the flash card.
NEW QUESTION # 57
......
Validate your 1Z0-902 Exam Preparation with 1Z0-902 Practice Test: https://www.practicevce.com/Oracle/1Z0-902-practice-exam-dumps.html
Free 1Z0-902 Questions for Oracle 1Z0-902 Exam [Apr-2024]: https://drive.google.com/open?id=1B3eiiEmmTbNvz1sUGuPelgQdoqKWiqF5