Online Access Free 1z0-070 Practice Test

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.Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.
• 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 give the OLTP consumer group the highest priority on all databases.
• C.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.
• D.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.

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

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

Which three are true concerning Exadata snapshot databases?

• A.They can be created only on sparse ASM disk groups.
• B.They are supported on non-container databases.
• C.They are based on a read-write copy of an existing database.
• D.They don't support all Exadata features.
• E.They can be created on any type of ASM disk group.
• F.They are integrated with the Multitenant architecture.

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.DATA3_DBM1
• B.DBFS_DG
• C.RECO_DBM1
• D.DATA_DBM1
• E.DATA2_DBM1

You plan to migrate a database supporting an OLTP workload to your new X5 Database Machine.
The current database instance supports a large number of short duration sessions and a very high volume of short transactions.
Which three X5 Database Machine features can improve performance for this type of workload?

• A.Faster optimization due to an Exadata-specific optimizer
• B.Reduced I/O latency for reads due to read flashcache on all Exadata X5 and later models
• C.Ultra high I/O performance for reads and writes when using Exadata Extreme Flash in X5 and later models
• D.Reduced I/O latency for writes due to writeback flashcache on all Exadata X5 and later models
• E.An improved highly efficient undo and redo architecture