1Z0-902試験問題集でPDF問題とテストエンジン
1Z0-902問題集で必ず試験合格させる
認証試験では、Oracle ExadataデータベースマシンX8Mのアーキテクチャ、インストール、構成、管理など、幅広いトピックをカバーしています。候補者は、組織のニーズを満たすソリューションを設計および実装する能力と、実装プロセス中に発生する可能性のある問題をトラブルシューティングする能力についてテストされます。
質問 # 15
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?
- A. list celldisk attributes name, deviceName, diskType, physicalFirmware
- B. list devices attributes name, deviceName, diskType, physicalFirmware
- C. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
- D. list cell attributes name, deviceName, diskType, physicalFirmware
正解：A
質問 # 16
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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- D. 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、C
質問 # 17
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. cat /proc/net/bonding/bondeth0
- C. netstat -rn
- D. ifconfig -a legrep "re0| re1"
正解：A
解説：
The checkbadlinks.pl script is a tool provided with the Exadata X9M-2 Database Server that allows you to verify the status of the InfiniBand links between the Database Server and the client switches. This script checks for bad links, and it can be used to identify any issues with the client network connectivity. To use the script, you can navigate to the directory where it is located, which is /opt/oracle.SupportTools/ibdiagtools/ and execute the command ./checkbadlinks.pl -all. This will give you a summary of the status of the links and it will indicate if there are any bad links. This command will check the client network on your Exadata X9M-2 Database Server is available via both client switches. Other commands like ifconfig, netstat and cat are not relevant to check the client network on Exadata X9M-2 Database Server
質問 # 18
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- 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. 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.
- D. 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.
正解：C、D
解説：
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.
質問 # 19
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. cat /proc/net/bonding/bondeth0
- C. netstat -rn
- D. ifconfig -a legrep "re0| re1"
正解：A
質問 # 20
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- 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. PMEM Cache section within Exadata Smart Statistics
- D. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- E. PMEM Cache section within Memory Statistics
正解：C、E
解説：
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)
質問 # 21
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?
- A. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
- B. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
- C. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
- D. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
正解：A、C
解説：
1. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine2.
2. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA2.
質問 # 22
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?
- A. the Power Distribution Units (PDUs)
- B. ASM instances
- C. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- D. the RDMA over Converged Ethernet (RoCE) switches
- E. the storage server ILOM
- F. Oracle clusterware on the database server
正解：A、D、E
解説：
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
質問 # 23
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 storage servers
- B. 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
- C. OS I/O metrics using Enterprise Manager host pages for the storage servers
- D. OS I/O metrics using OS tools such as iostat on the database servers
- E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
正解：D、E
解説：
The two monitoring tools that might be useful in examining I/O performance for the prod database are:
OS I/O metrics using OS tools such as iostat on the database servers.
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "I/O metrics can be collected from the database server using OS tools such as iostat [1], as well as from the storage servers using cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk". It also suggests using Enterprise Manager host pages for the storage servers to view OS I/O metrics.
質問 # 24
You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should use use to generate alerts for such an event?
- A. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
- B. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
- C. dbmcli -e "set alert ds_temp> 30" on each database server
- D. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
正解：C
質問 # 25
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. OS I/O metrics using OS tools such as iostat on the database servers
- E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
正解：A、E
解説：
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 *p1us . These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.
質問 # 26
A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU.
Which statement is correct?
- A. The installation cannot proceed until two power feeds are available per PDU.
- B. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
- C. A splitter cable can be used to provide power to all PDU cables.
- D. The installation can go ahead, no change is required.
正解：A
解説：
An Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs would typically require two power feeds per PDU, one for each of the two power distribution units (PDUs) in the rack. A single power feed per PDU is not sufficient to provide the necessary power to the servers and storage in the rack.
The installation cannot proceed until two power feeds are available per PDU. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], it is recommended that each PDU should have at least two power feeds from different power sources in the data center. This is to ensure redundancy and avoid any power interruption due to power failure on one of the power sources. Splitter cables are not recommended, as they can reduce efficiency and increase the risk of overheating. Rearranging the power cables within the rack is not recommended either, as it does not provide the necessary redundancy for the PDU.
質問 # 27
You use Enterprise Manager to monitor all the components of your Exadata Database Machine.
Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.
In which two sources would you find diagnostic messages related to this problem?
- A. alert logs for the ASM instances
- B. alert logs for the prod database instances
- C. alert logs for Enterprise Manager
- D. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- E. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
正解：D、E
質問 # 28
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 384GB
- B. 768GB
- C. 2048GB
- D. 1536GB
- E. 1024GB
- F. 512GB
正解：D
解説：
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
質問 # 29
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 root user
- B. hardware monitoring using the storage server ILOM
- C. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
- D. using the CELLCLI list LUN DETAIL command as the celladmin user
正解：C、D
質問 # 30
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?
- A. 4, 7, 8, 3, and 6
- B. 2, 7, 8, and 6
- C. 5, 8, 7, and 6
- D. 1, 8, 7, 3 and 6
- E. 2, 8, 7, 3, and 6
正解：D
解説：
In order to power off an Exadata Database Machine in an orderly fashion, the commands should be executed in the following order: 1) Execute "crscti stop cluster -all" as the grid user from one database server; 2) Execute "shutdown -h now" on all database servers; 3) Power off all network switches; 4) Execute "shutdown -h now" on all Exadata storage servers; and 5) Power off the rack using the power switches on the PDUs. This sequence of commands ensures that all services running on the Exadata Database Machine are in a clean state before powering off the system. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 543)
質問 # 31
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. 2,3,4,6,1,7,5
- C. 3,2,6,4,1,7,5
- D. 3,2,6,1,4,7,5
- E. 4,3,2,6,1,7,5
正解：D
質問 # 32
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.
7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?
- A. 7,6,9,11
- B. 0
- C. 44, 6, 9
- D. 10, 8, 2, 5
- E. 10, 8, 9, 11
正解：E
質問 # 33
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?
- A. Oracle clusterware on the database server
- B. the storage server ILOM
- C. the Power Distribution Units (PDUs)
- D. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- E. the RDMA over Converged Ethernet (RoCE) switches
- F. ASM instances
正解：A、D、F
解説：
Exadata-specific Enterprise Manager Plug-Ins are used to monitor different components of the Exadata Database Machine.
1. ASM instances: The Automatic Storage Management (ASM) instances can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the storage space, disk usage, and performance of the ASM instances.
2. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers: The HCC ratios on Extended (XT) storage servers can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the compression ratios and performance of the storage servers.
3. Oracle clusterware on the database server: The Oracle clusterware on the database server can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the health and performance of the clusterware.
質問 # 34
Which two statements are true about enabling write-back flash cache?
- A. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
- B. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
- C. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
- D. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
- E. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
正解：D、E
解説：
When enabling write-back flash cache in a rolling manner, it is important to use DBCLI to inactivate the grid disks on all cells first so that all the cells are in the same state before the process is started. In a non-rolling manner, you must drop the Persistent Memory Commit Accelerator (PMEMLog) first. Write-back flash cache is not on by default for High Capacity Storage Servers in High Redundancy configurations and can be used on Extreme Flash Storage Servers. It's also important to check if it's necessary to drop the flash cache before enabling write-back flash cache.
質問 # 35
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. changing the root password
- B. installing an alternative package manager
- C. configuring secure shell user equivalency for the cellmonitor user
- D. upgrading the Storage Server software package using rpm
- E. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
正解：A、C
解説：
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
質問 # 36
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 storage 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. OS I/O metrics using OS tools such as iostat on the database servers
- E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
正解：D、E
質問 # 37
......
合格させるOracle 1Z0-902試験最速合格にはFast2test：https://jp.fast2test.com/1Z0-902-premium-file.html
1Z0-902試験問題（更新されたのは2024年）100%リアル問題解答：https://drive.google.com/open?id=1X9v58C7eNs10oL4--DFf0ACzO7Wdxpgw