完全版1Z0-902練習テスト62特別な問題と解答が待ってます！
Oracle Engineered Systems問題集で1Z0-902試験完全版問題で試験学習ガイド
Oracle 1Z0-902認定試験は、Oracle Exadata Database Machine X8Mの実装に認定を受けたい専門家を対象としています。試験は、Exadata X8Mシステムの展開、構成、管理、トラブルシューティング、システムパフォーマンスの最適化に関する候補者の知識と技能をテストします。試験は、データベース管理者、システム管理者、システムアーキテクトなど、Exadata X8Mシステムの実装と管理を担当する個人を対象としています。
オラクル 1z1-902 試験は、Exadata Database Machine X8M の導入と管理に関連する広範囲なトピックをカバーしています。これらのトピックには、Exadata Database Machine のインストールと設定、Oracle データベースのExadata プラットフォーム上での展開、パフォーマンス調整と最適化、バックアップとリカバリー、そしてセキュリティが含まれます。この試験は、これらの分野におけるプロフェッショナルの知識とスキルをテストし、Exadata Database Machine X8M を実装および管理する能力があることを確認するために設計されています。
Oracle Exadata Database Machine X8Mは、ミッションクリティカルなデータベースのための極端なパフォーマンス、スケーラビリティ、可用性を提供する高性能データベースアプライアンスです。OLTP、データウェアハウジング、アナリティクスなどのOracleデータベースワークロードに最適化されたパフォーマンスを提供するように設計されています。このアプライアンスは、最適なパフォーマンスとスケーラビリティを提供するために共にエンジニアリングされたハードウェアとソフトウェアの構成要素を組み合わせています。
質問 # 17
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. The incline of any access route ramp must be less than or equal to 6 degrees.
- B. Oracle Exadata Rack may only be installed on raised floor environments.
- C. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- D. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- E. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- F. 914mm of space required above the rack height is required for maintenance access.
正解：B
解説：
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
質問 # 18
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. SQL Plan Quarantine
- B. Manually created Quarantine
- C. Disk Region Quarantine
- D. Cell Offload Quarantine
- E. Database Quarantine
正解：A、D
解説：
A and E are the two correct quarantine types that can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine. A is correct because SQL Plan Quarantine will disable Smart Scan for all queries related to the SQL plan that was placed in the SQL Plan Quarantine [1]. E is correct because the Cell Offload Quarantine will disable Smart Scan for all queries offloaded to Oracle Database Exadata Storage Server Software [2]. The other statements (B, C, and D) are incorrect.
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 13 [1][2]: Oracle Database Exadata Storage Server Software [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 15 [1][2]: Oracle Database Exadata Storage Server Configuration
質問 # 19
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 384GB
- B. 512GB
- C. 1024GB
- D. 1536GB
- E. 2048GB
- F. 768GB
正解：C
解説：
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the maximum DRAM capacity you can expand an X9M-2 DB Server is 1024GB. This is the maximum amount of DRAM that can be installed in the server. The specific steps for adding DRAM are outlined in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_hardware_memory.html.
質問 # 20
Which three statements are true about the CELLCLI command?
- A. It requires root privileges to create CELLDISKS and GRIDDISKS.
- B. It can be executed using the DCLI utility.
- C. It has command-line history.
- D. It can execute commands on multiple storage servers in parallel.
- E. It can be executed on storage servers.
正解：B、C、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.
質問 # 21
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. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
- C. ifconfig -a legrep "re0| re1"
- D. netstat -rn
正解：B
質問 # 22
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- C. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- D. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
正解：C
解説：
1. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'" is valid command and it is used to list the historical values for metrics where the name starts with "DS_."
2. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " is valid command and it is used to list the current value of the metric named "DS_TEMP"
3. dbmcli -e "LIST IBPORT DETAIL" is valid command and it is used to list the InfiniBand ports and details of the Exadata X9M.
"dbmcli" is a command-line tool that is used to manage and monitor the Exadata Database Machine. It allows you to perform various tasks such as managing the database, storage, and network components, and monitoring the performance and health of the machine. The command "dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15" is not a valid command, it is not supported on Exadata X9M.
質問 # 23
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 dcli command.
- B. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
- C. Copy and execute the script on all storage servers using the EXACLI command.
- D. 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. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
正解：A
質問 # 24
An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA 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 can go ahead, no change is required.
- B. The installation cannot proceed until two power feeds are available per PDU.
- C. 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.
- D. A splitter cable can be used to provide power to all PDU cables.
正解：B
解説：
In order for an Exadata X9M-2 Elastic Rack to be installed, two power feeds are required for each of the three-phase 24kVA PDUs. A single cable from each PDU will not be enough to power the rack, and neither a splitter cable nor rearrangement of the power cables from the servers to the PDUs will be able to provide sufficient power for the system. Therefore, the installation cannot proceed until two power feeds are available per PDU.
For more information about power requirements for Exadata X9M-2 Elastic Racks, 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] Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/exadata-site-requirements.html
質問 # 25
Which two statements are true about applying updates on Exadata systems?
- A. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- B. Failed storage server updates are automatically rolled back to a previous release.
- C. Failed database server updates are rolled back to a working state on a previous release automatically.
- D. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- E. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- F. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
正解：B、F
解説：
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.
質問 # 26
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " - C. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
正解：C
質問 # 27
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 and are enabled by default, however, appropriate roles and users should be created to ensure security.
- D. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
正解：C
質問 # 28
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 storage server
- D. Exadata storage realms using ASM-scoped security mode
- E. File permissions on the griddisks in each database server
正解：A、C
質問 # 29
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. Memory cannot be expanded on Exadata X9M-2 Database Servers.
- B. Add 16x 64GB DIMMs.
- C. Add 16x 32GB DIMMs.
- D. Add 12x 32GB DIMMs.
- E. Add 24x 32GB DIMMs.
- F. Shutdown the Database Server if running.
- G. Remove existing memory modules.
- H. Add 32x 64GB DIMMs.
- I. Add 12x 64GB DIMMs.
正解：B、F、G
解説：
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.
The steps required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration are as follows:
Shutdown the Database Server if running.
Remove existing memory modules.
Add 16x 64GB DIMMs.
For reference, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "the lowest memory configuration for the Exadata X9M-2 Database Servers is 384GB and the highest is 768GB [1]. The memory upgrade is done in increments of 64GB using 16x 64GB DIMMs".
質問 # 30
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 prod database instances
- B. alert logs for Enterprise Manager
- C. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
- D. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- E. alert logs for the ASM instances
正解：C、D
質問 # 31
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Database Quarantine
- B. SQL Plan Quarantine
- C. Cell Offload Quarantine
- D. Manually created Quarantine
- E. Disk Region Quarantine
正解：A、B
質問 # 32
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. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- 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. Bare Metal deployment with one database per database server
正解：A、C、D
質問 # 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. the storage server ILOM
- B. the Power Distribution Units (PDUs)
- C. the RDMA over Converged Ethernet (RoCE) switches
- D. Oracle clusterware on the database server
- E. ASM instances
- F. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
正解：A、D、E
質問 # 34
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?
- A. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
- B. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
- C. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
- D. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
正解：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.
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.
質問 # 35
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?
- A. OECA facilitates PDU power selection initially and after equipment addition.
- B. OECA reconfigures the size of disk groups and recreates grid disks.
- C. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
- D. OECA allows one XT storage server in the configuration.
- E. OECA extends the hardware for the elastic configuration only.
正解：B、C
解説：
The correct answers are Options A and D. Option A is correct because OECA reconfigures the size of disk groups and recreates grid disks. Option D is correct because OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
質問 # 36
......
1Z0-902正真正銘のベスト資料、オンライン練習試験：https://www.jpntest.com/shiken/1Z0-902-mondaishu
優れもの良質な1Z0-902問題集が待ってます：https://drive.google.com/open?id=1B00rjVcMlI2kfeXLv2wHArHLC4XOnL1g