0% found this document useful (0 votes)
45 views7 pages

Oracle X9M Database Machine Exam Questions

The document contains a series of multiple-choice questions and answers related to the Oracle Exadata Database Machine X9M, including topics on monitoring configurations, patching features, Oracle Configuration Manager, AWR report statistics, and network connection types. Each question is accompanied by an explanation of the correct answers, referencing the official Oracle Exadata Database Machine X9M Implementation Essentials textbook. The document serves as a study resource for individuals preparing for the 1Z0-902 certification exam.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
45 views7 pages

Oracle X9M Database Machine Exam Questions

The document contains a series of multiple-choice questions and answers related to the Oracle Exadata Database Machine X9M, including topics on monitoring configurations, patching features, Oracle Configuration Manager, AWR report statistics, and network connection types. Each question is accompanied by an explanation of the correct answers, referencing the official Oracle Exadata Database Machine X9M Implementation Essentials textbook. The document serves as a study resource for individuals preparing for the 1Z0-902 certification exam.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

dumpssheet 1Z0-902 QUESTIONS BY Kerr 12-12-2023 6QA - Page 1

Free Questions for 1Z0-902


Shared by Kerr on 12-12-2023
For More Free Questions and Preparation Resources

Check the Links on Last Page


dumpssheet 1Z0-902 QUESTIONS BY Kerr 12-12-2023 6QA - Page 2

Question 1
Question Type: MultipleChoice

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?

Options:
A- on at least two storage servers in both racks
B- on only one database server in both racks
C- on all database servers in the first rack
D- on all storage servers in both racks
E- on all database servers and at least two storage servers in both racks
F- on all database servers in the second rack
G- on all database servers in both racks and one storage server in each rack

Answer:
A, E

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

Question 2
Question Type: MultipleChoice

Which statement is true about the patching features provided in Platinum Services?
dumpssheet 1Z0-902 QUESTIONS BY Kerr 12-12-2023 6QA - Page 3

Options:
A- Oracle Platinum Service covers Exadata storage software and firmware patching, but
customers must perform the database patching.
B- Patching services are available for the full software stack up to twice per year.
C- The rolling and complete down time approaches are two options to patching.
D- Patching is done automatically during business hours.

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][Link]
[Link]

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...
dumpssheet 1Z0-902 QUESTIONS BY Kerr 12-12-2023 6QA - Page 4

Question 3
Question Type: MultipleChoice

Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata
Database Machine?

Options:
A- It is mandatory to install OCM on all database servers.
B- It collects configuration information automatically.
C- It collects configuration information on demand.
D- It is mandatory to install OCM on at least one database server.
E- Collected configuration information can be uploaded automatically to Oracle.
F- Collected configuration information can be uploaded manually to Oracle.

Answer:
B, C, E

Explanation:
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 [Link] 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.

Question 4
Question Type: MultipleChoice

Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
dumpssheet 1Z0-902 QUESTIONS BY Kerr 12-12-2023 6QA - Page 5

Options:
A- PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
B- PMEM Pool Misses in the Exadata Outlier Summary
C- cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
D- PMEM Cache section within Memory Statistics
E- PMEM Cache section within Exadata Smart Statistics

Answer:
C, E

Explanation:
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.

Question 5
Question Type: MultipleChoice

You have been asked by Oracle Support to check the firmware of the hard & flash disks in a
storage server. Which cellcli command should you use to get this information?

Options:
A- list celldisk attributes name, deviceName, diskType, physicalFirmware
B- list cell attributes name, deviceName, diskType, physicalFirmware
C- list physicaldisk attributes name, deviceName, diskType, physicalFirmware
D- list devices attributes name, deviceName, diskType, physicalFirmware

Answer:
C

Explanation:
dumpssheet 1Z0-902 QUESTIONS BY Kerr 12-12-2023 6QA - Page 6

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

[Link]
[Link]

Question 6
Question Type: MultipleChoice

Which two of the following network connection types can be deployed on the client network ports
of an Exadata X9M-2 Database Server?

Options:
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:
[Link]
dumpssheet 1Z0-902 QUESTIONS BY Kerr 12-12-2023 6QA - Page 7

To Get Premium Files for 1Z0-902 Visit


[Link]

For More Free Questions Visit


[Link]

Common questions

Powered by AI

The AWR report sections that provide detailed insights about X9M Persistent Memory Cache performance include 'cell PMEM cache Read Hits' in the Database IOs portion of the Performance Summary and the 'PMEM Cache' section within Exadata Smart Statistics, which provide metrics on usage and efficiency .

To check the firmware of disks in an Exadata storage server, the command 'list physicaldisk attributes name, deviceName, diskType, physicalFirmware' should be used with cellcli, providing valuable disk and firmware details necessary for system maintenance .

Oracle Platinum Services manages the patching of Exadata systems by providing services for the full software stack up to twice per year. Customers can choose between rolling and complete downtime approaches to schedule patches, ensuring minimal impact on system operation during patching .

To effectively monitor all components in a multirack Database Machine configuration, Enterprise Manager agents must be deployed on all database servers and at least two storage servers in each rack. This ensures comprehensive coverage across all racks and servers in the configuration .

Oracle Configuration Manager (OCM) for an Exadata Database Machine automatically collects configuration information and can do so on demand. It can upload this collected information automatically to Oracle for analysis, which aids in system support and optimization .

Exadata X9M-2 Database Server's client network ports can be configured with various networking options, including 2x 25Gb ports using SFP28 transceivers with OM4 fiber cables for both backup and client networks or a combination of 25Gb ports for client networks and 10Gb ports using RJ45 cat6 cables for backup networks .

You might also like