[Q15-Q33] 1z1-902リアル試験問題解答は更新された[2023年02月16日]

1z1-902リアル試験問題解答は更新された[2023年02月16日]

お手軽に合格させる最新Oracle 1z1-902問題集には62問があります

質問 15
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?

A. You must be physically present in the data center to start an Exadata Storage Server.
B. -> start /SYSTEM/power
C. -> start /System
D. -> set /SYS power_state=ON
E. -> start /SP/console
F. -> start /SYS/power

正解: C

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

正解: E

解説:
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)

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

正解: B

質問 18
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

A. 6, 3, 1, 9, 7, 8
B. 6, 8, 3, 4, 2, 1
C. 6, 1, 2, 7, 5, 8
D. 6, 2, 1, 8, 4, 5

正解: A

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

質問 20
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

A. Oracle Exadata Rack may only be installed on raised floor environments.
B. 914mm of space required above the rack height is required for maintenance access.
C. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
D. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
E. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
F. The incline of any access route ramp must be less than or equal to 6 degrees.

正解: A

解説:
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors Oracle Exadata Database Machine X9M Implementation Essentials states that Exadata racks are designed to be installed on flat surfaces, not raised floor environments. It is not required to install the rack on raised floor environments. Additionally, the other options listed are all requirements for validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 41)

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

正解: A,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.

質問 22
You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?

A. Copy and execute the script on all storage servers using the EXACLI command.
B. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
C. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
D. Copy and execute the script on all storage servers using the dcli command.
E. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.

正解: E

解説:
This can be done by using the 'cellcli -e' command, which allows you to execute commands in parallel on all storage servers. For more information about executing CELLCLI commands in parallel, please refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

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

正解: C

解説:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], before doing anything else you should call Oracle Support and make an appointment so that the drive can be replaced. If Platinum Support is enabled, then you can call Oracle Support and they will arrange for the disk to be replaced. If Platinum Support is not enabled, then you can arrange for the disk to be replaced through Enterprise Manager Cloud Control.

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

A. 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
B. 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
C. 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
D. 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,C

質問 25
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

A. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
B. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
C. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
D. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.

正解: A,C

解説:
Oracle Exadata Deployment Assistant (OEDA) enables customers to deploy Oracle Exadata Database Machine in virtualized environments and it support both bare metal and virtual machine deployment in an Exadata X9M Quarter Rack.
OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack, and it sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], OEDA deployment steps include setup, configure, deploy, and manage. The number of VMs in an Exadata rack is limited by the available resources in the rack, such as CPU, Memory, and Storage.

質問 26
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

A. Add 16x 64GB DIMMs.
B. Memory cannot be expanded on Exadata X9M-2 Database Servers.
C. Add 32x 64GB DIMMs.
D. Add 16x 32GB DIMMs.
E. Remove existing memory modules.
F. Add 12x 32GB DIMMs.
G. Add 24x 32GB DIMMs.
H. Shutdown the Database Server if running.
I. Add 12x 64GB DIMMs.

正解: A,E,H

解説:
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.

質問 27
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

A. Cell Offload Quarantine
B. Manually created Quarantine
C. Database Quarantine
D. Disk Region Quarantine
E. SQL Plan Quarantine

正解: B,C

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

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

正解: D,E,F

解説:
A Exadata supports multiple pluggable databases in one or more container databases, which enables database consolidation by allowing multiple databases to be consolidated into a single container database. This can be deployed on a Virtual Machine or Bare Metal cluster.
D Multiple databases spanning a Bare Metal and Virtual Machine cluster provide resource isolation and consolidation concurrently. It allows multiple databases to be deployed on both Bare Metal and Virtual Machine clusters, providing isolation and consolidation at the same time.
E Multiple Databases on a cluster allows multiple databases to be deployed on a single cluster, which enables consolidation of databases by reducing the number of clusters required.

質問 29
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.

正解: C,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.

質問 30
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 Cache section within Exadata Smart Statistics
C. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
D. PMEM Cache section within Memory Statistics
E. PMEM Pool Misses in the Exadata Outlier Summary

正解: B,D

解説:
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)

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

正解: B

解説:
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.

質問 32
Which statement is true about the patching features provided in Platinum Services?

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

正解: D

解説:
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...

質問 33
......

Oracle 1z1-902 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Exadata Softwareを使用して、ダウンタイムなしでExadata DatabaseMachineにアップデートをデプロイします OracleExadataDeploymentAssistantを使用してExadataDatabase仮想デプロイメントを構成します
トピック 2	Exadataソフトウェアを使用して、クライアントのネットワーク切断 Exadataデータベースのマシンアーキテクチャと主要機能のトラブルシューティングを行います
トピック 3	単一のExadataStorageServerを安全にシャットダウンします OracleExadataConfigurationAssistantおよびOracleExadataDeploymentAssistantの機能を説明します
トピック 4	コマンドラインまたはクラウド制御を使用してExadataStorageServerとネットワークを監視しますクライアントとバックアップネットワークを含むさまざまなシナリオでExadataDatabaseServerを接続します
トピック 5	さまざまなデータベースマシンコンポーネントでソフトウェアがどのように維持されているかを説明する Exadataソフトウェアアーキテクチャと導入シナリオを説明する
トピック 6	仮想化やベアメタルを含むExadataの導入オプションを説明する Exadataデータベースサーバーにストレージを追加する
トピック 7	Exadataを実装するための物理サイトの要件と安全性のベストプラクティスの説明 Exadataリモートダイレクトメモリアクセス（RDMA）とクライアントネットワークアーキテクチャの説明
トピック 8	Oracle Configuration Manager（OCM）と、それがExadataDatabaseMachineとどのように関連しているかを説明しますさまざまなディスクグループ障害グループの選択の影響を説明します
トピック 9	Auto Service Request（ASR）機能と、それがExadataDatabaseMachineとどのように関連しているかを説明します ExadataDatabase Machineで自動ServiceRequest（ASR）を設定します

最新の1z1-902学習ガイド2023年最新の- 提供するのはテストエンジンとPDF：https://www.passtest.jp/Oracle/1z1-902-shiken.html

最新版を今すぐ試そう1z1-902練習テスト問題解答：https://drive.google.com/open?id=1qTMWOyN7JZjUX2oyLdHTfXAaIrPIkx6D

関するブログ

もっと

1z1-902 無料問題集