検証済みの1z1-902試験問題集PDF [2023年最新] 成功の秘訣はここにある
ベストを体験せよ！1z1-902試験問題トレーニングを提供していますFast2test
Oracle 1Z0-902試験では、ExadataデータベースマシンX8Mの実装に関連する幅広いトピックをカバーしています。候補者は、ExadataデータベースマシンX8Mアーキテクチャ、ハードウェアおよびソフトウェアコンポーネント、展開と構成、管理と監視、バックアップと回復、パフォーマンスチューニングの知識でテストされます。この試験は、候補者がExadataデータベースマシンX8M環境を実装および維持するために必要なスキルと知識を確保するように設計されています。
質問 # 16
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 sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
- C. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
- D. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
正解：B、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.
質問 # 17
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- B. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- C. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- D. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- E. Run exachk and resolve only WARNINGS that you have not seen before.
- F. Run the appropriate patchmgr preqequisite check step for each component being updated.
正解：A、B、D、F
質問 # 18
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, 9, 11
- B. 7,6,9,11
- C. 10, 8, 2, 5
- D. 0
- E. 4,1, 6, 9
正解：A
解説：
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.
質問 # 19
Which three of the following options are available for database consolidation on Exadata?
- A. Bare Metal deployment with one database per database server
- B. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- C. Multiple Databases on a cluster
- D. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- E. A single database with one or more schema per application
- F. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
正解：C、D、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.
質問 # 20
You are updating your Exadata X9M-2 Elastic Database Machine with 6 database servers and 12 High Capacity Storage Servers. You will be using patchmgr to apply updates across the entire machine while still maintaining database availability.
Assuming you are driving patchmgr from an external server, which statement is true about the execution phase?
- A. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
- B. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
- C. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
- D. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
正解：D
質問 # 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. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
- B. cat /proc/net/bonding/bondeth0
- C. ifconfig -a legrep "re0| re1"
- D. netstat -rn
正解：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
質問 # 22
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure.
What ASM redundancy level should they use?
- A. External
- B. Sparse
- C. High
- D. Extended
- E. Normal
正解：C
解説：
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf
質問 # 23
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,3,4,6,1,7,5
- B. 3,2,6,4,1,7,5
- C. 2,6,1,4,3,7,5
- D. 3,2,6,1,4,7,5
- E. 4,3,2,6,1,7,5
正解：A
質問 # 24
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. 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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
正解：B、D
質問 # 25
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. 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. 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
質問 # 26
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,3,4,6,1,7,5
- B. 3,2,6,1,4,7,5
- C. 3,2,6,4,1,7,5
- D. 2,6,1,4,3,7,5
- E. 4,3,2,6,1,7,5
正解：B
質問 # 27
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?
- A. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- B. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
- C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- D. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
正解：A、D
質問 # 28
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?
- A. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- B. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
- C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- D. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
正解：A、D
解説：
The two actions that are not appropriate for monitoring how a large production table is accessed in order to leverage the benefits of the Exadata Platform are A) querying VSSYSTEMEVENTS and filtering for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table; and B) querying v$segmentstatistics and filtering for the Object ID of your table from dbaobjects and the the column STATISTICNAME='optimized physical reads'. Instead, you should query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table (C), or run the CellCli-command list activerequest, filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS (D). These two methods are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Monitoring the Exadata Database Machine).
質問 # 29
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?
- A. OECA reconfigures the size of disk groups and recreates grid disks.
- B. OECA extends the hardware for the elastic configuration only.
- 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 facilitates PDU power selection initially and after equipment addition.
正解：C、D
質問 # 30
Which three statements are true about the CELLCLI command?
- A. It can be executed on storage servers.
- B. It requires root privileges to create CELLDISKS and GRIDDISKS.
- C. It has command-line history.
- D. It can execute commands on multiple storage servers in parallel.
- E. It can be executed using the DCLI utility.
正解：A、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.
質問 # 31
......
Oracleの1Z0-902試験は、Exadata X8Mシステムを実装および維持するためのプロフェッショナルにとって重要な認定資格です。この試験は、Exadataシステムのアーキテクチャ、データベースの展開、構成、および管理、バックアップとリカバリ、パフォーマンスチューニングなど、さまざまなトピックをカバーしています。試験に合格すると、候補者は世界中の雇用主に認められるOracle Exadata Database Machine X8M Implementation Essentials認定を受けます。
最新の100%合格保証付きの素晴らしい1z1-902試験問題PDF：https://jp.fast2test.com/1z1-902-premium-file.html
練習サンプルと問題集と秘訣には2023年最新の1z1-902有効なテスト問題集：https://drive.google.com/open?id=1FhkD29THtXzvjQhNuIm8YkG8sIerq40m