Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine?

• A. The InfiniBand port monitoring is automatic on the database servers and is managed by Enterprise Manager.
• B. The Infiniband subnet master location can be determined by using the getmaster command run on any database server.
• C. The InfiniBand port status may be displayed on the storage servers by using the LIST IBPORT command in the CELLCLI utility.
• D. The InfiniBand port status may be displayed on the Infiniband switches by using the LIST IBPORT command in the DBMCLI utility.
• E. The InfiniBand port status may be displayed on the database servers by using the LIST IBPORT command in the DBMCLI utility.
• F. The Infiniband subnet master location can be determined by using the getmaster command run on an IB switch.

解説: (PassTest メンバーにのみ表示されます)

You are patching your Exadata X6 Database Machine by applying a new image to the Storage Servers in a rolling fashion.
Your ASM environment on the Database Machine has five diskgroups stored on an unpartitioned Exadata storage grid, with redundancy settings as shown:
1. DATA_DBM1 - Normal Redundancy
2. RECO_DBM1 - Normal Redundancy
3. DBFS_DG - Normal Redundancy
4. DATA2_DBM1 - High Redundancy
5. DATA3_DBM1 High Redundancy
Which two diskgroups will not suffer from any data loss throughout the patching process even if there is a single disk failure on one of the cells

• A. RECO_DBM1
• B. DATA_DBM1
• C. DBFS_DG
• D. DATA3_DBM1
• E. DATA2_DBM1

解説: (PassTest メンバーにのみ表示されます)

You applied patches to both the storage servers and the database servers in your Exadata X6 Database Machine.
You use Database Replay for a 90-minute workload to verify that there are no performance regressions after applying the patches.
Which three options could you use to immediately measure the performance and to check for possible regressions caused by changes in the storage server software?

• A. cellcli list metrichistory
• B. SQL Access Advisor
• C. cellcli list alerthistory
• D. cellcli list metriccurrent
• E. SQL trace using dbms_monitor

Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP workloads at certain times of the day.
There are five RAC databases performing OLTP I/O. Two of them also perform batch I/O. There is another RAC database that performs only DSS I/O.
You are asked to resolve this problem so that the OLTP workload will not suffer when competing with the batch or DSS workloads.
You decide to use the I/O resource manager.
Which is the best way to solve this problem?

• A. Use the Database Resource Manager to give the OLTP category the highest priority and use EXADCLI calling EXACLI to create the OLTP category on all the cells.
• B. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to create the OLTP category and map all OLTP- oriented consumer groups in all databases to it.
• C. Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.
• D. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to give the OLTP consumer group the highest priority on all databases.

解説: (PassTest メンバーにのみ表示されます)

Which two are true about sparse griddisks and their use in disk groups on an X5 Exadata Database Machine?

• A. The virtual size of a sparse griddisk may exceed the physical size of the space occupied by the griddisk.
• B. Sparse diskgroups must be created using sparse griddisks.
• C. Sparse diskgroups may not be used for database snapshots.
• D. Additional space for a sparse griddisk is allocated as soon as newly written data is stored in the flashcache on a cell.
• E. Sparse diskgroups may be created using a combination of sparse and non-sparse griddisks.

解説: (PassTest メンバーにのみ表示されます)