1Z0-902 Online Practice Questions and Answers

Correct Answer: DE

Explanation: According to the Oracle Exadata Database Machine Technical Architecture1 , the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers includes two ASM disk groups: DATA_ and RECO_. These disk groups are built on hard disks and flash disks inside the Exadata Storage Servers1. The correct statements about this configuration are: Option D: There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes. Storage indexes are a feature of Exadata Storage Software that can improve query performance by avoiding unnecessary I/O operations. Storage indexes use a small amount of flash memory to store metadata about data blocks stored on disk1. Option E: There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs. Exadata Smart Flash Logs are another feature of Exadata Storage Software that can improve database performance by using flash memory as an extension of the database redo log buffer. This can reduce latency and increase throughput for redo log writes1.

Correct Answer: C

Explanation: This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85). https://docs.oracle.com/en/engineered-systems/exadata-database- machine/sagug/exadata-storage-server-cellcli.html

Correct Answer: A

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. This means that they need a redundancy level that can tolerate at least one disk failure without losing data availability or performance. Therefore, the best option for them is normal redundancy . Normal redundancy provides two-way mirroring by default, which means that each data extent has a primary copy and a mirror copy on different disks in different failure groups1. A failure group is a subset of disks within a disk group that are likely to fail at the same time due to common dependencies2. On Exadata Database Machine , each Storage Server is considered as a failure group by default2. This means that if one Storage Server fails or needs to be updated , the data on its disks can still be accessed from another Storage Server that has the mirror copies of the same data extents2. Therefore, normal redundancy ensures data availability and performance during updates or single-node server failures. https://docs.oracle.com/en/engineered-systems/exadata-databasemachine/sagug/exadata-administering-asm.html

Correct Answer: CDF

According to Oracle's documentation12, the components that are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins are: The storage server ILOM2 The Power Distribution Units (PDUs)2 The RDMA over Converged Ethernet (RoCE) switches3

Correct Answer: AC

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. https://docs.oracle.com/en/engineered-systems/exadata-database- machine/dbmmn/index.html

Correct Answer: D

Explanation: According to Oracle's documentation1, to set a threshold for a metric on a database server, you need to use the create threshold command with the appropriate parameters. The set threshold command is used to modify an existing threshold2. Therefore, the command that you should use to generate alerts for such an event is: dbmcli -e "create threshold ds_temp comparison=`>', critical=30" on each database server1

Correct Answer: B

Explanation: The correct sequence is: uk.co.certification.simulator.questionpool.PList@da89390 uk.co.certification.simulator.questionpool.PList@da893e0 uk.co.certification.simulator.questionpool.PList@da89430 uk.co.certification.simulator.questionpool.PList@da894b0 uk.co.certification.simulator.questionpool.PList@da89500

Correct 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.

The correct statement about the patching features provided in Platinum Services is that patching services are available for the full software stack up to twice per year. Oracle Platinum Service covers Exadata storage software and firmware patching, and customers must also perform the database patching. The rolling and complete down time approaches are two options for patching, and patching should be scheduled for times when the system is not being heavily used. Patching is not done automatically during business hours. This is covered in section 4.13 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1]. [1] https://docs.oracle.com/en/ engineered-systems/exadata-database-machine/x9m/exad- implementing-database-machine-x9m.pdf Search results: [1] Oracle Exadata Storage Server Patching [1][2]. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest Oracle... [2] Patching and Upgrades. Oracle Database Machine provides automated patching and upgrades for the full Exadata software stack, up to twice a year, with... [3] Virtualized Exadata. Oracle Database Machine X9M-2 comes with a choice of two patching approaches to accommodate different customer needs: Rolling... [4] Jan 10, 2017 ... Exadata Patching Process. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest...

Correct Answer: CE

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.

Correct Answer: C