2025年最新の実際に出ると確認された1Z0-902試験問題集と解答で1Z0-902無料更新 [Q26-Q47]

2025年最新の実際に出ると確認された1Z0-902試験問題集と解答で1Z0-902無料更新

実際問題を使って1Z0-902問題集で100%無料1Z0-902試験問題集

Oracle 1Z1-902試験に合格することにより、個人はOracle ExadataデータベースマシンX8Mシステムの実装と管理に関する知識と専門知識を実証できます。この認定は、個人がキャリアの見通しを強化し、データベース管理と管理の分野で新しい機会を開くのに役立ちます。

 

質問 # 26
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. 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
• B. OS I/O metrics using OS tools such as iostat on the storage servers
• C. OS I/O metrics using Enterprise Manager host pages for the storage servers
• 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 database servers

正解：C、D

解説：
1. OS I/O metrics using Enterprise Manager host pages for the storage servers: Enterprise Manager provides a detailed view of the storage server's performance including I/O metrics and statistics. You can use these metrics to analyze I/O performance and identify any bottlenecks.
2. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk: These commands are used to gather information about storage server performance, including I/O statistics, disk usage, and resource allocation.

質問 # 27
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. RoCE network interface cards in the database servers
• C. Cisco management switch
• D. RoCE network interface cards in the storage servers
• E. Cisco RDMA over Converged Ethernet (RoCE) switches
• F. power distribution units
• G. power supplies in the database servers

正解：A、D、F、G

解説：
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).

質問 # 28
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

• A. 'crsct1 stop cluster -all' on one of the database servers
• B. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
• C. shutdown -h now' on the affected storage server
• D. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
• E. CellCLI alter GRIDDISK all inactive on the affected storage server
• F. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

正解：C、E

解説：
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB The two commands that must be executed to safely power off the storage server in an Exadata X9M Database Machine are E and F.
Command E, CellCLI alter GRIDDISK all inactive, will deactivate all of the GRIDDISKS on the affected storage server. This will ensure that no data is lost during the power-off process.
Command F, shutdown -h now, will shut down the storage server. This will ensure that the storage server is completely powered off and no data is lost.
For more information on how to properly power off an Exadata Storage Server, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

質問 # 29
Which three of the following options are available for database consolidation on Exadata?

• A. Multiple Databases on a cluster
• B. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
• C. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
• D. Bare Metal deployment with one database per database server
• E. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
• F. A single database with one or more schema per application

正解：A、E、F

解説：
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
A) Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
C) A single database with one or more schema per application12.
E) Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how

質問 # 30
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

• A. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• B. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
• C. Configuring ASR is mandatory for all Database Machine assets.
• D. ASR Manager must be installed and configured on one of the database servers.
• E. ASR communicates with Oracle support services using HTTPS.
• F. ASR can upload configuration metadata to support problem resolution.

正解：B、D

質問 # 31
You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?

• A. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
• B. netstat -rn
• C. ifconfig -a legrep "re0| re1"
• D. cat /proc/net/bonding/bondeth0

正解：D

解説：
According to Oracle's documentation1, the client network on Exadata X9M-2 Database Server is used for client access to the database servers using Single Client Access Name (SCAN) and Oracle RAC Virtual IP (VIP) addresses. To verify that the client network is available via both client switches, you can use the command:
cat /proc/net/bonding/bondeth0
This command displays information about the bondeth0 interface, which is used for the client network on Exadata X9M-2 Database Server2. You can check if both interfaces (eth0 and eth1) are active and connected to different switches3.

質問 # 32
You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Exadata Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

• A. Set thresholds in ILOM and in Enterprise Manager because they are not preset anywhere and must be set in both places.
• B. No thresholds need to be set because they are preset in the ILOM and in Enterprise Manager
• C. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.
• D. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.

正解：B

解説：
For Exadata systems, hardware monitoring for components like the motherboard, memory, power, fans, and network cards on the database nodes is managed through the Integrated Lights Out Manager (ILOM). The ILOM provides built-in thresholds and sensor readings that are automatically recognized by Oracle Enterprise Manager.
These thresholds and alerts are already configured within ILOM for Exadata components, ensuring seamless integration with Enterprise Manager for alerting and monitoring purposes.
Enterprise Manager uses these pre-set ILOM thresholds and does not require additional configuration for monitoring hardware components. Therefore, administrators benefit from preset alerting mechanisms that are sufficient for comprehensive hardware status visibility.

質問 # 33
Which two statements are true about applying updates on Exadata systems?

• A. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
• B. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
• C. Failed storage server updates are automatically rolled back to a previous release.
• D. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
• E. Failed database server updates are rolled back to a working state on a previous release automatically.
• F. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.

正解：E、F

質問 # 34
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 and at least two storage servers in both racks
• B. on only one database server 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 database servers in both racks and one storage server in each rack
• F. on all storage servers in both racks
• G. on all database servers in the first rack

正解：A、C

解説：
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).

質問 # 35
What are two recommended configuration best practices for backup and recovery on Exadata?

• A. 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.
• B. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.
• C. 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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

正解：B、D

質問 # 36
What are two recommended configuration best practices for backup and recovery on Exadata?

• 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.
• B. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
• C. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.
• 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.

正解：A、D

質問 # 37
What type of SRs does the ASR Manager generate for Exadata?

• A. backup and restore failures
• B. operating system components
• C. hardware assets
• D. data entry errors
• E. software assets

正解：C、E

解説：
Oracle Auto Service Request (ASR) on Exadata Database Machines is designed to proactively monitor and detect hardware and software issues. When a problem is detected, ASR Manager automatically opens a service request (SR) with Oracle Support. The primary focus of ASR is on hardware assets, such as storage servers, database servers, and network components, as well as software assets related to Exadata System Software and Oracle Database configurations.

質問 # 38
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. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
• C. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
• D. 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.

正解：D

解説：
The MS process on Exadata storage servers is natively endowed with REST services and these services are enabled by default. However, it is important to create appropriate roles and users to ensure security when accessing these services. This way, it is possible to disable ssh access to the storage servers, and still enable REST access to the MS process. It's not necessary to install Oracle Rest Data Services on each Database or Storage server or install the MS APEX application, the MS process on the storage servers already have REST services by default.

質問 # 39
You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?

• A. netstat -rn
• B. ifconfig -a legrep "re0| re1"
• C. cat /proc/net/bonding/bondeth0
• D. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all

正解：D

質問 # 40
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?

• A. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
• B. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
• C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
• D. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.

正解：B、C

解説：
A . YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/

質問 # 41
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

• A. Oracle Linux 7.9
• B. Oracle Linux 7.5
• C. Oracle Linux 7.7
• D. Oracle Linux 8.0

正解：D

解説：
RoCE, or Remote Direct Memory Access over Converged Ethernet, is a high-speed networking technology that allows data to be transferred between servers, storage, and other devices over Ethernet. Persistent Memory is a form of non-volatile memory that can be used to store data without losing it when power is lost.
Oracle Linux 8.0 supports both RoCE and Persistent Memory, allowing Exadata systems to leverage the benefits of both technologies. For more information on Oracle Linux 8.0 and its features, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.

質問 # 42
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

• A. 'crsct1 stop cluster -all' on one of the database servers
• B. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
• C. shutdown -h now' on the affected storage server
• D. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
• E. CellCLI alter GRIDDISK all inactive on the affected storage server
• F. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

正解：C

解説：
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB

質問 # 43
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?

• A. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
• B. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
• C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
• D. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.

正解：B、C

解説：
A) YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
C) You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/

質問 # 44
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 and at least two storage servers in both racks
• B. on only one database server 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 database servers in both racks and one storage server in each rack
• F. on all storage servers in both racks
• G. on all database servers in the first rack

正解：A、C

解説：
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).

質問 # 45
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. Sparse
• B. Normal
• C. Extended
• D. High
• E. External

正解：B

解説：
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-database-machine/sagug/exadata-administering-asm.html

質問 # 46
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,1,4,7,5
• C. 3,2,6,4,1,7,5
• D. 2,3,4,6,1,7,5
• E. 4,3,2,6,1,7,5

正解：C

解説：
The correct sequence is:
Review the safety guidelines. This is important to ensure a safe and successful installation1.
Unpack Oracle Exadata Rack. This involves removing the packaging materials and inspecting the rack for damage or missing components1.
Place Exadata in its allocated space. This involves moving the rack to its final location and securing it with bolts and brackets1.
Let the Exadata acclimatize for 24 hours. This is recommended to allow the rack components to adjust to the ambient temperature and humidity before powering on1.
Stabilize the Exadata Rack. This involves leveling the rack and adjusting its height if needed1.
Power on Exadata PDU B. This involves connecting PDU B to a power source and turning it on1.
Power on Exadata PDU A. This involves connecting PDU A to a power source and turning it on1

質問 # 47
......

Oracle 1z1-902試験に合格するためには、Oracle Exadata Database Machine X8Mアーキテクチャ、構成、および管理について強い理解が必要です。また、Smart Scan、Smart Flash Cache、Hybrid Columnar Compressionなどの主要な機能の実装と管理に熟練している必要があります。さらに、データベース管理およびパフォーマンスチューニングの概念についての確固たる理解が必要であり、Oracle Enterprise Managerを使用してOracle Exadata Database Machine X8Mを管理および監視する経験も必要です。Oracle 1z1-902認定により、ITプロフェッショナルは、この強力なテクノロジーを実装および管理する専門知識を証明し、求人市場で競争優位性を獲得することができます。

 

合格させる1Z0-902試験問題は更新された87問あります：https://www.jpntest.com/shiken/1Z0-902-mondaishu

1Z0-902試験問題集、テストエンジン練習テスト問題：https://drive.google.com/open?id=1kkEfVQzr8e3DO7KJ9Br4ig7kIxVB3CAB