1Z0-902 Online Practice Questions and Answers

Correct Answer: AD

According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:

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

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

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: BCE

It collects configuration information automatically (B). OCM gathers detailed configuration information about a variety of designated Oracle products and components across an enterprise on a regular basis2. It collects configuration

information on demand ? OCM can also collect configuration information manually when requested by the user or by Oracle Support2.

Collected configuration information can be uploaded automatically to Oracle (E). OCM can upload the collected configuration information to My Oracle Support automatically for analysis and support purposes3.

Correct Answer: BE

Explanation: According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not. https://docs.oracle.com/en/engineered-systems/exadata-database- machine/sagug/exadata-administering-asm.html

Correct Answer: C

Oracle KVM Guest: This is a virtual machine that runs on top of Oracle Linux KVM hypervisor. It can be used to run Oracle Database or other applications on Exadata Database Machine2. Therefore, it runs on the Database Servers. Oracle Enterprise Manager Agent (OMA): This is a software agent that communicates with Oracle Enterprise Manager Cloud Control and provides monitoring and management capabilities for Exadata Database Machine2. Therefore, it runs on both Database Servers and Storage Servers. ASM instance: This is an instance of Oracle Automatic Storage Management (ASM), which is a volume manager and a file system for Oracle Database files. It manages diskgroups that span across multiple Storage Servers2. Therefore, it runs on the Database Servers. RDBMS instance: This is an instance of Oracle Database that processes SQL statements and executes transactions. It uses ASM disk groups to store data files, control files, redo log files, etc2. Therefore, it runs on the Database Servers. Automatic Diagnostic Repository Command Interpreter (ADRCI): This is a command-line tool that enables you to view diagnostic data stored in the Automatic Diagnostic Repository (ADR). ADR is a file-based repository for database diagnostic data such as trace files, alert logs, etc2. Therefore, ADRCI runs on both Database Servers and Storage Servers, depending on where the ADR is located. CELLCLI: This is a command-line interface that enables you to configure and manage Exadata Storage Server Software. It allows you to perform tasks such as creating disk groups, monitoring cell health, applying patches, etc2. Therefore, it runs on the Storage Servers. Cell Server(CELLSRV): This is a process that runs on each Storage Server and handles I/O requests from the Database Servers. It implements Exadata Smart Scan , which offloads data-intensive SQL operations from the Database Servers to the Storage Servers2. Therefore, it runs on the Storage Servers. diskmon: This is a process that monitors the status of disks and flash devices on each Storage Server. It reports disk failures and performs automatic disk reclamation2. Therefore, it runs on the Storage Servers. Restart Server (RS): This is a process that manages automatic restarts of critical processes such as CELLSRV , MS , or OMA in case of failures. It also handles graceful shutdowns and startups of all processes on each server2. Therefore, it runs on both Database Servers and Storage Servers. Management Server (MS): This is a process that provides management services for each server such as collecting metrics , logging events , executing commands from CELLCLI , etc2. Therefore, it runs on both Database Servers and Storage Servers

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: AE

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:

A. changing the root password

E. configuring secure shell user equivalency for the cellmonitor user

https://docs.oracle.com/en/engineered-systems/exadata-database- machine/dbmso/exadata-introduction.html

Correct Answer: AD

Explanation: According to the Oracle documentation1, two statements that are true about enabling write-back flash cache are:

Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations (A). This is because write-back flash cache provides better performance and reliability for data file writes than write-through flash

cache. Before write-back flash cache is enabled, you need to drop the Flash Cache first (D). This is because changing the flash cache mode requires recreating the flash cache with a different configuration.

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: F

Explanation: According to Oracle documentation1, Exadata Storage software has a complete set of automated operations for hard disk maintenance, when a hard disk has failed or has been flagged as a problematic disk. It will initiate a rebalance operation to redistribute data across other disks and mark the failed disk with an amber light.