試験準備には欠かさないトップクラスのOracle 1Z0-902試験学習ガイド練習問題最新版
今すぐ1Z0-902問題を使おう1Z0-902問題集PDFで合格しよう
質問 # 28
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. High
- B. Sparse
- C. Normal
- D. Extended
- E. External
正解：A
解説：
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf
質問 # 29
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. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- C. PMEM Pool Misses in the Exadata Outlier Summary
- D. PMEM Cache section within Exadata Smart Statistics
- E. PMEM Cache section within Memory Statistics
正解：E
質問 # 30
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. hardware monitoring using the storage server ILOM
- B. using the CELLCLI list LUN DETAIL command as the celladmin user
- 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
正解：A、B
質問 # 31
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.
https://forums.oracle.com/ords/apexds/map/tech/apps-infra/discussion/4342715/monitoring-roce-performance
質問 # 32
How do ASM failure groups provide redundancy?
- A. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- B. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
- C. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
- D. 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.
正解：A
解説：
In an Automatic Storage Management (ASM) environment, failure groups are used to provide redundancy for the storage disks. Failure groups are used to group together a set of disks and ensure that no two copies of the same data are stored on the same physical disk or storage server. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
For example, if the disks in a failure group are mirrored, one copy of the data is stored on one set of disks, and the other copy is stored on another set of disks. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
ASM failure groups also provide the option to spread the data across different storage servers, this way, even if a storage server fails, data can still be accessed from the other storage servers in the group. This will improve the availability of the data.
質問 # 33
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.
質問 # 34
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 768GB
- B. 1536GB
- C. 2048GB
- D. 1024GB
- E. 384GB
- F. 512GB
正解：C
質問 # 35
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 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.
- B. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- 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'.
正解：B、C
解説：
1. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
2. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/
質問 # 36
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 alert ds_temp> 30" on each database server
- B. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
- C. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
- D. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
正解：C
解説：
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 5-54) recommends using the dbmcli command to set thresholds on metrics, such as temperature. To do this, you should use the following command:
dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server.
This will generate an alert if the temperature exceeds 30C.
質問 # 37
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 extends the hardware for the elastic configuration only.
- D. OECA allows one XT storage server in the configuration.
- E. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
正解：A、C
解説：
B and E are true statements for the Oracle Exadata Configuration Assistant (OECA). OECA facilitates PDU power selection initially and after equipment addition, and it allows for the elastic configuration of the hardware. It does not reconfigure the size of disk groups or recreate grid disks, nor does it allow for a single XT storage server in the configuration. The "Add Equipment" input option does allow for the allocation of RU slots for customer equipment.
Reference for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources.
Search results: [1] Oracle Exadata Database Machine X8-2 [1][2]: Configuration Assistant Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [2] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Add Equipment: This input option allows you to allocate RU slots for ... [3] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [4] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Power Selection [1][2]: This input option allows you to select PDU power initially ... [5] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ...
質問 # 38
You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?
- A. list celldisk attributes name, deviceName, diskType, physicalFirmware
- B. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
- C. list cell attributes name, deviceName, diskType, physicalFirmware
- D. list devices attributes name, deviceName, diskType, physicalFirmware
正解：B
質問 # 39
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
質問 # 40
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 all storage servers using the EXACLI 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 each storage server using the DCLI command.
正解：A
解説：
According to Oracle's documentation1, the Cell Control Command-Line Interface (CellCLI) utility is the command-line administration tool for Oracle Exadata System Software. It can be used to perform various tasks on Exadata Storage Servers, such as creating and managing objects, monitoring performance, and configuring alerts.
To run CELLCLI commands on multiple cells simultaneously, you can use the Distributed Command-Line Interface (dcli) utility2. The dcli utility allows you to execute commands or scripts on a group of cells or hosts in parallel. You can use the dcli utility to copy files from one cell or host to multiple cells or hosts using the -f option3. You can also use the dcli utility to execute commands or scripts on multiple cells or hosts using the -l option to specify a user name and the -g option to specify a file containing a list of cells or hosts3.
Therefore, to achieve your requirement of running a script with several CELLCLI commands on each cell in your Exadata full rack simultaneously, you must:
Copy and execute the script on all storage servers using the dcli command.
質問 # 41
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
- A. It collects configuration information on demand.
- B. It collects configuration information automatically.
- C. Collected configuration information can be uploaded manually to Oracle.
- D. It is mandatory to install OCM on all database servers.
- E. Collected configuration information can be uploaded automatically to Oracle.
- F. It is mandatory to install OCM on at least one database server.
正解：C、D、F
解説：
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, OCM is mandatory to install on at least one database server and can be used to collect configuration information on demand. The collected information can then be uploaded either manually or automatically to Oracle.
質問 # 42
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 all storage servers using the EXACLI 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 each storage server using the DCLI command.
正解：D
解説：
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].
質問 # 43
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
解説：
According to Oracle's documentation1, to set a threshold for a metric on a database server, you need to use the create threshold command with the appropriate parameters. The set threshold command is used to modify an existing threshold2.
Therefore, the command that you should use to generate alerts for such an event is:
dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server1
質問 # 44
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
解説：
After running the commands above, the filesystem mounted on /u01 is on the logical volume /dev/mapper/VGExaDb-LVDbOral. So, to add 20G of space to the filesystem mounted on /u01, the command that needs to be run is:
lvextend -L +20G --verbose /dev/mapper/VGExaDb-LVDbOral
This command will extend the logical volume /dev/mapper/VGExaDb-LVDbOral by 20 GB of space. It is important to note that the option --verbose is used to display the progress of the operation.
質問 # 45
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- B. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- C. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- D. Run the appropriate patchmgr preqequisite check step for each component being updated.
- E. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- F. Run exachk and resolve only WARNINGS that you have not seen before.
正解：A、C、D、E
質問 # 46
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.
質問 # 47
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, 8, 3, 4, 2, 1
- B. 6, 3, 1, 9, 7, 8
- C. 6, 1, 2, 7, 5, 8
- D. 6, 2, 1, 8, 4, 5
正解：B
質問 # 48
......
Oracle 1Z0-902（Oracle Exadata Database Machine X8M実装エッセンシャル）認定試験は、Oracle ExadataデータベースマシンX8Mの実装と管理に関与している専門家のスキルと知識をテストするために設計されています。この試験は、Oracleデータベース管理の経験があり、Exadataの実装のスキルを向上させようとしている人向けです。
無料Oracle Engineered Systems 1Z0-902試験問題：https://www.jpntest.com/shiken/1Z0-902-mondaishu
問題集練習試験問題学習ガイドは1Z0-902試験で使える：https://drive.google.com/open?id=1B00rjVcMlI2kfeXLv2wHArHLC4XOnL1g