• ホーム
  • ブログ
  • [2023年12月] 実際問題を使って1Z0-902無料問題集サンプルと問題と練習テストエンジン [Q28-Q51]

[2023年12月] 実際問題を使って1Z0-902無料問題集サンプルと問題と練習テストエンジン [Q28-Q51]

Share

[2023年12月] 実際問題を使って1Z0-902無料問題集サンプルと問題と練習テストエンジン

合格させるOracle 1Z0-902試験問題でテスト復刻エンジンとPDF


Oracle Exadataデータベースマシンは、データベースワークロードに最適化された事前に構成され、事前に調整され、事前にテストされたデータセンターアプライアンスです。 OLTPとデータウェアハウジングワークロードの両方で、高性能、スケーラビリティ、および信頼性を提供します。 Oracle Exadata X8Mは、パフォーマンスと可用性をさらに向上させるための強化されたハードウェアとソフトウェア機能を含むOracle Exadataデータベースマシンの最新バージョンです。


Oracle 1Z0-902試験は、Exadata X8Mシステムを実装および維持したいプロフェッショナルを対象としています。この試験は、Exadataシステムのアーキテクチャ、データベース展開、構成および管理、バックアップおよびリカバリ、パフォーマンスチューニングなど、さまざまなトピックをカバーしています。試験には、候補者がExadata X8Mのコンポーネントとその相互作用について強い理解を持っていることが必要です。

 

質問 # 28
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 12x 32GB DIMMs.
  • B. Add 32x 64GB DIMMs.
  • C. Shutdown the Database Server if running.
  • D. Add 24x 32GB DIMMs.
  • E. Add 12x 64GB DIMMs.
  • F. Add 16x 32GB DIMMs.
  • G. Add 16x 64GB DIMMs.
  • H. Remove existing memory modules.
  • I. Memory cannot be expanded on Exadata X9M-2 Database Servers.

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


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

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

正解：C

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


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

正解：A

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


質問 # 31
You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes:

After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?

  • A. # xfs_growfs /uOl +20G
  • B. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
  • C. # resize2fs +20G /dev/VGExaDb/LVDbOral
  • D. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral

正解：D


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

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

正解：A、G

解説：
Reason B, corruption in the / (root) filesystem, is a valid reason for executing a storage server rescue procedure. If the root filesystem is corrupted, the storage server will no longer be able to boot and will need to be rescued.
Reason F, accidental loss of all data from all griddisks in a storage server, is also a valid reason for executing a storage server rescue procedure. If all data is accidentally lost from the griddisks in a storage server, the server will need to be rescued in order to recover the data.
For more information about the Exadata X9M-2 storage server rescue procedure, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation - Oracle Docs [2] Oracle Exadata Database Machine X9M-2 Storage Server Rescue Procedure - Oracle Docs [3] Oracle Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs [4] Oracle Exadata Database Machine X8M-2 Storage Server Rescue Procedure - Oracle Docs [5] Oracle Exadata Database Machine X9M-2 Storage Server Update Procedure - Oracle Docs [6] Oracle Exadata Database Machine X8M-2 Storage Server Update Procedure - Oracle Docs


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

  • A. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
  • 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 allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
  • D. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.

正解：C、D

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


質問 # 34
Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?

  • A. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
  • B. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
  • C. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
  • D. 1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
  • E. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.

正解：B


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

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

正解：A、B、E

解説：
According to Oracle's documentation1, the customer options for hosting the Platinum Services Advanced Support Gateway are:
Provide individual x86 64-Bit gateway hardware1
Purchase the recommended x86 64-Bit gateway hardware from Oracle1
Install on Oracle Database Appliance2


質問 # 36
How do ASM failure groups provide redundancy?

  • A. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
  • B. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
  • C. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
  • D. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.

正解：A

解説：
Failure groups provide redundancy in Oracle Exadata Database Machine X9M by ensuring that mirror copies of the data are written to different storage servers [1][2]. This prevents the potential for mirror copies to be written to the same server, which would cause a data loss if that server were to experience a physical disk failure. Furthermore, failure groups help to ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster, providing an extra layer of data protection. Additionally, Extended Redundancy mirrors data across data centers, providing the highest levels of data protection. Reference: Oracle Exadata Database Machine X9M Implementation Essentials [1][2], Chapter 5: Configuring Oracle ASM.


質問 # 37
Which two statements are true in regards to starting the Exadata Virtual Machine?

  • A. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
  • B. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
  • C. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
  • D. Use vm_maker boot-from-iso command to boot a virtual machine.
  • E. Use vm_maker -start-domain to start a virtual machine manually.

正解：B、D


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

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

正解：B

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


質問 # 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. cat /proc/net/bonding/bondeth0
  • B. netstat -rn
  • C. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
  • D. ifconfig -a legrep "re0| re1"

正解：A

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


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

正解：D


質問 # 41
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. cat /proc/net/bonding/bondeth0
  • C. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
  • D. ifconfig -a legrep "re0| re1"

正解：C


質問 # 42
Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?

  • A. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
  • B. In order to configure the servers with Oracle Exadata Deployment Assistant (OEDA), the new server information must be entered in OEDA, and the configuration file must contain existing nodes.
  • C. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
  • D. It is required to install OEDA on the first new database server.
  • E. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.

正解：A、B

解説：
https://docs.oracle.com/en/database/oracle/oracle-database/21/ladbi/db-on-exadata.html


質問 # 43
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 Storage server and install the MS APEX application.
  • B. Install Oracle Rest Data Services on each Database 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.

正解：C

解説：
To enable REST access to the MS process, you need to manually enable the REST services on each storage server by running the command cellcli -e "ALTER CELL ENABLE REST" and then configure authentication and authorization to ensure secure access. This is described in detail in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Securing the Exadata Database Machine).
https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/access-rest-api.html


質問 # 44
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 list LUN DETAIL command as the celladmin user
  • B. hardware monitoring using the storage server ILOM
  • C. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
  • D. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

正解：B、D

解説：
The CELLCLI CALIBRATE command can be used to check the health of all flash cards in the storage server, and it should be run after logging in as the celladmin user. The hardware monitoring using the storage server ILOM should also be used to check for errors and other potential issues with the flash cards. The CELLCLI list LUN DETAIL command should not be used to identify a damaged or failing flash card, since it will not provide any information about the health of the flash card.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/index.html


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

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

正解：C、D、E

解説：
The CellCLI utility supports command-line history.
Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface.
The dcli utility facilitates centralized management across an Oracle Exadata Storage Server Software realm by automating the execution of CellCLI commands on a set of cells and returning the output to the centralized management location where the dcli utility was run.


質問 # 46
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 list LUN DETAIL command as the celladmin user
  • B. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
  • C. hardware monitoring using the storage server ILOM
  • D. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

正解：A、D


質問 # 47
You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.
Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?

  • A. to the CELLMONITOR account using cellcli interactively on each storage server
  • B. to the CELLADMIN account using cellcli interactively on each storage server
  • C. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
  • D. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
  • E. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
  • F. to the CELLADMIN account by calling CELLCLI on all cells using DCLI

正解：B、D、F

解説：
To drop all celldisks on all the storage servers in an X9M-2 quarter rack, you should use the CELLADMIN account, which has the necessary privileges to perform this task. You can use the CELLCLI command-line interface to drop the celldisks. The best way to do this is by calling CELLCLI on all cells using DCLI (Oracle Database Command Line Interface) which allows you to run commands on multiple servers at once. Alternatively, you can use an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli. It is not recommended to use the CELLMONITOR account, as it has a more limited set of privileges. It is also important to note that EXACLI is not a valid tool for this task
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html


質問 # 48
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. Exadata storage realms using database-scoped security mode
  • B. File permissions on the griddisks in each storage server
  • C. Using EXADCLI instead of CELLCLI to create the griddisks
  • D. File permissions on the griddisks in each database server
  • E. Exadata storage realms using ASM-scoped security mode

正解：A、E

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


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

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

正解：D、E


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

正解：C、D


質問 # 51
......


Oracle Exadata Database Machine X8Mは、ミッションクリティカルなアプリケーションに高性能、スケーラビリティ、および信頼性を提供するように設計された強力なプラットフォームです。認定試験では、Exadataデータベースマシンアーキテクチャ、インストールと構成、データベース管理、パフォーマンスチューニング、バックアップと回復などのトピックについて説明します。

 

あなたを合格させる1Z0-902お手軽に試験合格リアル1Z0-902練習問題集で更新されたのは2023年12月27日：https://jp.fast2test.com/1Z0-902-premium-file.html

2023年最新の実際に出ると確認されたOracle 1Z0-902無料試験問題：https://drive.google.com/open?id=1X9v58C7eNs10oL4--DFf0ACzO7Wdxpgw

関するブログ

もっと
Oracle認証 1Z0-902試験問題集

弊社を連絡する

我々は１２時間以内ですべてのお問い合わせを答えます。

我々の働いている時間： ( GMT 0:00-15:00 )
月曜日から土曜日まで

サポート： 現在連絡 

English Deutsch 繁体中文 한국어

フレンドリーリンク

トップ試験