[2023年11月最新リリース]1Z0-902問題集でOracle Engineered Systems認証
最新の完璧な1Z0-902問題集問題と解答で100%パスさせます
質問 # 19
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?
- A. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
- B. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
- C. The sparse_<DBM_NAME> diskgroup is created automatically.
- D. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
- E. The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.
正解：A、B
質問 # 20
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- B. 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.
- C. 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.
- 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.
正解：B、C
質問 # 21
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR can upload configuration metadata to support problem resolution.
- B. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- C. ASR Manager must be installed and configured on one of the database servers.
- D. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- E. ASR communicates with Oracle support services using HTTPS.
- F. Configuring ASR is mandatory for all Database Machine assets.
正解：D、E
解説：
A and F are true statements about Auto Service Request (ASR) with an Exadata Database Machine [1][2]. In order to use the ASR feature, ASR Manager must be installed and configured on a dedicated server which is external to the Database Machine, and it communicates with Oracle support services using HTTPS. Additionally, ASR can upload configuration metadata to support problem resolution, and it can open a service request (SR) automatically after sensors detect hardware faults.
Reference for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1][2].
質問 # 22
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 physicaldisk attributes name, deviceName, diskType, physicalFirmware
- B. list celldisk attributes name, deviceName, diskType, physicalFirmware
- C. list devices attributes name, deviceName, diskType, physicalFirmware
- D. list cell attributes name, deviceName, diskType, physicalFirmware
正解：A
解説：
This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85).
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-cellcli.html
質問 # 23
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Cache section within Memory Statistics
- 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 Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- E. PMEM Pool Misses in the Exadata Outlier Summary
正解：B、C
解説：
Option C shows the number of read hits from PMEM cache on storage servers which indicates how much data was served from PMEM instead of flash or disk1.
Option E shows detailed information about PMEM cache such as size, utilization, hit ratio, read latency and write latency2.
質問 # 24
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 CALIBRATE command on the storage server after logging in 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 list LUN DETAIL command as the celladmin user
正解：A、D
質問 # 25
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. 4, 7, 8, 3, and 6
- B. 1, 8, 7, 3 and 6
- C. 2, 8, 7, 3, and 6
- D. 5, 8, 7, and 6
- E. 2, 7, 8, and 6
正解：E
解説：
In order to completely power off an Exadata Database Machine in an orderly fashion, it's important to properly shut down the cluster first. The command "crscti stop cluster" as root should be executed from one of the database servers.
Once the cluster has been stopped, the next step is to shut down the database servers by executing the command "shutdown -h now" on all database servers.
Next, shut down the Exadata storage servers by executing the command "shutdown -h now" on all Exadata storage servers.
Finally, power off the rack using the power switches on the PDUs.
質問 # 26
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR can upload configuration metadata to support problem resolution.
- B. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- D. ASR communicates with Oracle support services using HTTPS.
- E. ASR Manager must be installed and configured on one of the database servers.
- F. Configuring ASR is mandatory for all Database Machine assets.
正解：A、C
解説：
D) ASR can upload configuration metadata to support problem resolution1.
E) ASR Manager opens a service request (SR) automatically after sensors detect hardware faults1
https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm
質問 # 27
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. 4, 7, 8, 3, and 6
- B. 1, 8, 7, 3 and 6
- C. 2, 8, 7, 3, and 6
- D. 5, 8, 7, and 6
- E. 2, 7, 8, and 6
正解：B
解説：
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)
質問 # 28
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 extends the hardware for the elastic configuration only.
- C. OECA allows one XT storage server in the configuration.
- D. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
- E. OECA reconfigures the size of disk groups and recreates grid disks.
正解：A、B
解説：
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.
References 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 ...
質問 # 29
A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA 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. A splitter cable can be used to provide power to all PDU cables.
- B. 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.
- C. The installation cannot proceed until two power feeds are available per PDU.
- D. The installation can go ahead, no change is required.
正解：B
質問 # 30
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. -> start /System
- B. -> start /SYSTEM/power
- C. You must be physically present in the data center to start an Exadata Storage Server.
- D. -> set /SYS power_state=ON
- E. -> start /SP/console
- F. -> start /SYS/power
正解：D
解説：
This command is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. This command sets the power state of the system to ON and starts the storage server. It is the only command that is able to start the storage server remotely. All the other commands are incorrect or require the user to be physically present in the data center.
質問 # 31
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 24x 32GB DIMMs.
- C. Add 32x 64GB DIMMs.
- D. Add 16x 32GB DIMMs.
- E. Remove existing memory modules.
- F. Shutdown the Database Server if running.
- G. Add 16x 64GB DIMMs.
- H. Add 12x 64GB DIMMs.
- I. Add 12x 32GB DIMMs.
正解：E、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.
質問 # 32
Which two statements are true about enabling write-back flash cache?
- A. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
- B. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
- C. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
- D. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
- E. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
正解：B、E
解説：
The two statements that are true about enabling write-back flash cache are:
When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
Before write-back flash cache is enabled, you need to drop the Flash Cache first.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "when enabling write-back flash cache in a rolling manner [1], grid disks need to be inactivated on all cells before enabling write-back flash cache". It also states that "before write-back flash cache can be enabled, the existing flash cache must be dropped".
質問 # 33
Which two statements are true about enabling write-back flash cache?
- A. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
- B. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
- C. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
- D. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
- E. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
正解：B、C
質問 # 34
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 1024GB
- B. 512GB
- C. 768GB
- D. 1536GB
- E. 384GB
- F. 2048GB
正解：F
解説：
The Exadata X9M-2 Database Machine uses powerful database servers, each with two 32-core x86 processors and 512 GB of memory (expandable up to 2 TB).
質問 # 35
Which three statements are true about the CELLCLI command?
- A. It can execute commands on multiple storage servers in parallel.
- B. It requires root privileges to create CELLDISKS and GRIDDISKS.
- C. It can be executed using the DCLI utility.
- D. It can be executed on storage servers.
- 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.
質問 # 36
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 physicaldisk attributes name, deviceName, diskType, physicalFirmware
- B. list celldisk attributes name, deviceName, diskType, physicalFirmware
- C. list devices attributes name, deviceName, diskType, physicalFirmware
- D. list cell attributes name, deviceName, diskType, physicalFirmware
正解：B
質問 # 37
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- B. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- C. A single database with one or more schema per application
- D. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- E. Multiple Databases on a cluster
- F. Bare Metal deployment with one database per database server
正解：A、C、E
解説：
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
A) Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
C) A single database with one or more schema per application12.
E) Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how
質問 # 38
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 query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- C. 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.
- 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).
質問 # 39
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- B. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- C. A single database with one or more schema per application
- D. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- E. Bare Metal deployment with one database per database server
- F. Multiple Databases on a cluster
正解：A、B、D
解説：
Options A, D, and F are available for database consolidation on Exadata. Option A refers to the use of multiple pluggable databases in one or more container databases on either a Virtual Machine or Bare Metal cluster. Option D refers to the use of multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently. And finally, Option F refers to the use of multiple Virtual Machine clusters supporting a single database for greatest resource isolation. This is 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.
質問 # 40
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Install on Oracle Database Appliance.
- B. Install in Oracle Virtual Machine with required hardware.
- C. Install on Exadata Engineered System.
- D. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- E. Provide individual x86 64-Bit gateway hardware.
正解：A、D、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
質問 # 41
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. -> start /System
- B. -> start /SYSTEM/power
- C. -> set /SYS power_state=ON
- D. You must be physically present in the data center to start an Exadata Storage Server.
- E. -> start /SP/console
- F. -> start /SYS/power
正解：F
解説：
ILOM (Integrated Lights Out Manager) is a remote management system that allows you to control and monitor Exadata Database Machine components, such as storage servers and database servers, from a remote location. The command "start /SYS/power" is used to power on the storage server in the Exadata Database Machine after hardware maintenance. This command can be executed remotely via ILOM.
質問 # 42
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?
- A. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.
- B. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.
- C. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.
- D. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.
正解：D
解説：
Exadata Secure RDMA Fabric isolation is a feature that allows you to use virtualization on the X9M-2 platform while maintaining security and isolation between multiple tenants or VM clusters. Secure Fabric isolation works by creating a dedicated network partition and VLAN ID for each Database VM cluster, which is used for cluster networking between the database servers in the VM Cluster. This ensures that the network traffic of each VM cluster is isolated from the others, and it prevents unauthorized access to the data or resources of other VM clusters. Secure Fabric isolation can also be used for other purposes such as client networking, Data Guard traffic, but it's mainly used to provide security and isolation between multiple tenants or VM clusters.
質問 # 43
......
最新の1Z0-902試験問題集でOracle試験トレーニング：https://jp.fast2test.com/1Z0-902-premium-file.html
2023年最新のの問題1Z0-902問題集で最新のOracle試験を使おう：https://drive.google.com/open?id=1X9v58C7eNs10oL4--DFf0ACzO7Wdxpgw