オンライン1Z0-902テストブレーン問題集とテストエンジン [Q12-Q29]

オンライン1Z0-902テストブレーン問題集とテストエンジン

リアルOracle 1Z0-902試験問題集には正解62問題と解答があります

質問 # 12
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. 4,1, 6, 9
B. 0
C. 7,6,9,11
D. 10, 8, 2, 5
E. 10, 8, 9, 11

正解：E

解説：
The correct order of steps is 10, 8, 9, 11. The 10th step is to use the drop down to add Exadata X9M Database Servers, the 8th step is to use the drop down to add Exadata X9M EF Storage Servers, the 9th step is to use "Add Equipment" to add the ZFS Storage Controllers, and the 11th step is to use "Add Equipment" to add the ZFS Storage Trays. These steps are referenced in the Oracle Exadata Database Machine X9M Implementation Essentials Official Textbook, which is available online at https://docs.oracle.com/cd/E80437_01/E80437/html/index.html.

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

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

正解：A、D

解説：
A recommended configuration best practice for backup and recovery on Exadata is to place the backup network on dedicated switches installed in the top of the rack (ToR). This provides a greater level of control and isolates the backup network from other workloads. Additionally, even if the backup is limited to writing to four tape drives, it is recommended to specify eight channels to expedite the restore process.
Another best practice is to set the RMAN FILESPERSET parameter to 1 for the level 1 incremental backup set. This will optimize the internal Recovery Appliance backup and restore processing. Finally, if off-site long-term backup retention is needed, Oracle Database Backup Cloud Service should be used as a low-cost, offsite scalable storage solution for a disaster recovery solution.

質問 # 14
Which dbmcli command is NOT valid on Exadata X9M?

A. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
B. dbmcli -e "LIST IBPORT DETAIL"
C. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
D. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"

正解：B

解説：
The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], this command is only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M.
https://forums.oracle.com/ords/apexds/map/tech/apps-infra/discussion/4342715/monitoring-roce-performance

質問 # 15
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 "alert metriccurrent ds_temp where metricValue > 30" on each database server
B. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
C. dbmcli -e "set alert ds_temp> 30" on each database server
D. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server

正解：B

解説：
The correct command to generate alerts for an event when the temperature of the database servers in an Exadata Full Rack exceeds 30C is "dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server". The dbmcli is the command-line interface for the Oracle Database Management Agent (DMA), which allows you to perform various management tasks on the Exadata servers. This command creates a threshold for the ds_temp metric with a comparison operator of ">" (greater than), and a critical value of 30. The threshold is set on all database servers in the Exadata Full Rack, so when the server temperature exceeds 30C, an alert will be generated.

質問 # 16
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

A. Using EXADCLI instead of CELLCLI to create the griddisks
B. Exadata storage realms using database-scoped security mode
C. File permissions on the griddisks in each database server
D. Exadata storage realms using ASM-scoped security mode
E. File permissions on the griddisks in each storage server

正解：B、D

解説：
Exadata storage realms using ASM-scoped security mode allows you to control which database can access which griddisks by creating realms at the ASM level, thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.2 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
Exadata storage realms using database-scoped security mode allows you to control which database can access which griddisks by creating realms at the database level [1], thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.3 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [2].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf [2] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf

質問 # 17
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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
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. 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.

正解：A、C

質問 # 18
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

A. Provide individual x86 64-Bit gateway hardware.
B. Install in Oracle Virtual Machine with required hardware.
C. Install on Oracle Database Appliance.
D. Install on Exadata Engineered System.
E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

正解：B、C、E

質問 # 19
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 Enterprise Manager host pages for the storage servers
B. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
C. OS I/O metrics using OS tools such as iostat on the storage servers
D. 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
E. OS I/O metrics using OS tools such as iostat on the database servers

正解：B、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.

質問 # 20
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?

A. Ask the system administrator to replace the broken disk with a spare.
B. Check the database to see if any rebalance operations are active.
C. Wait for a blue light to appear on the disk if the rebalance operation is running.
D. Wait for the email of the failure that Exadata or Enterprise Manager will send.
E Download and run the latest exadiag tool.
E. Call Oracle Support and make an appointment so that the drive can be replaced.

正解：A

質問 # 21
Which dbmcli command is NOT valid on Exadata X9M?

A. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
B. dbmcli -e "LIST IBPORT DETAIL"
C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "

正解：A

質問 # 22
Which three statements are true about the CELLCLI command?

A. It can execute commands on multiple storage servers in parallel.
B. It has command-line history.
C. It can be executed using the DCLI utility.
D. It can be executed on storage servers.
E. It requires root privileges to create CELLDISKS and GRIDDISKS.

正解：B、C、D

解説：
The statements that are true about the CellCLI command are:
It has command-line history . According to 1, you can use the up and down arrow keys to scroll through previous commands that you entered in CellCLI . You can also use Ctrl+R to search for a previous command by entering part of it .
It can be executed on storage servers . According to 1, you can invoke CellCLI by logging in to the Exadata cell as cellmonitor , celladmin , or root user and typing "cellcli" . Within CellCLI , you can perform various management and monitoring tasks for the cell134.
It can be executed using the DCLI utility . According to 5, DCLI (distributed CLI) is another utility that can be used to execute scripts and commands across multiple storage cells from a single interface. You can use DCLI to run CellCLI commands on multiple cells at once54.

質問 # 23
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

A. the failure of physical disk 1
B. corruption in a normal or high redundancy ASM diskgroup
C. moving all disks from one cell to another as part of a chassis-level component failure
D. accidental loss of all data from all griddisks in a storage server
E. the failure of physical disk 0 and 11
F. the failure of both physical M.2 disks
G. corruption in the / (root) filesystem

正解：E、G

解説：
The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.

質問 # 24
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

A. ZFS Snapshots can provide rapid cloning of development and test environment.
B. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
C. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
D. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.

正解：B、C

質問 # 25
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. 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.

正解：A、B

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

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

正解：C、D

解説：
According to Oracle's documentation12, some of the statements that are true about applying updates on Exadata systems are:
Failed storage server updates are automatically rolled back to a previous release1.
When running a "yum update" for a new Exadata release, all other repositories should be disabled1.

質問 # 27
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

A. the failure of physical disk 0 and 11
B. the failure of physical disk 1
C. corruption in a normal or high redundancy ASM diskgroup
D. moving all disks from one cell to another as part of a chassis-level component failure
E. accidental loss of all data from all griddisks in a storage server
F. the failure of both physical M.2 disks
G. corruption in the / (root) filesystem

正解：F、G

解説：
The two valid reasons are:
corruption in the / (root) filesystem . According to 1, this is one of the scenarios that requires a storage server rescue procedure , because it prevents the storage server from booting up normally . The rescue procedure will re-image the root filesystem with a fresh copy of the operating system and restore the configuration files from a backup1.
the failure of both physical M.2 disks . According to 2, each Exadata Storage Server X9M-2 has two physical M.2 disks that store the operating system and configuration files for the storage server . If both M.2 disks fail , then the storage server cannot boot up or function properly . The rescue procedure will replace the failed M.2 disks with new ones and re-image them with the operating system and configuration files2.

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

正解：E

解説：
This ordering is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. First, the Exadata should be stabilized and unpacked (Steps 2 and 3). Then, the safety guidelines should be reviewed (Step 4). The Exadata should then be allowed to acclimatize for 24 hours (Step 4). After that, the Exadata PDU A should be powered on (Step 6) and the Exadata should be placed in its allocated space (Step 6). Finally, the Exadata PDU B should be powered on (Step 7).

質問 # 29
......

有効な1Z0-902テスト解答とOracle 1Z0-902試験PDF：https://www.jpntest.com/shiken/1Z0-902-mondaishu

Oracle 1Z0-902認定リアル2023年最新の模擬試験：https://drive.google.com/open?id=1kkEfVQzr8e3DO7KJ9Br4ig7kIxVB3CAB