Oracle Exadata X5 Administration - 1z1-070 Exam Questions

QUESTION NO: 1
You plan to consolidate your company's INVENTORY and SALES databases onto your new Exadata X6 Database Machine.
You are considering consolidation of all schemas into one RAC database.
Which three factors would you need to consider before choosing this approach?

QUESTION NO: 2
Which two activities are supported on the storage servers in an Exadata X6 Database Machine?

QUESTION NO: 3
You have partitioned an X5-2 full rack into two four-node RAC clusters called CLUSA and CLUSB.
No virtualization is used and the storage grid has not been partitioned.
Which two set of files on which servers must be modified after connecting an Exadata storage expansion rack to your X5-2 Exadata Database Machine on the InfiniBand network so that the storage servers in the expansion rack are added to the storage grid?

QUESTION NO: 4
You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Exadata X6 Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

QUESTION NO: 5
You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = low_latency
alter iormplan active
There are no database or category plans defined.
You are encountering disk I/O performance problems at certain times, which vary by day and week.
DSS and Batch workloads perform well some of the time.
Further investigation shows that at times, the workloads are all OLTP I/Os, at other times all batch I/Os, and sometimes a bit of each.
You wish to have disk I/O managed so that performance will be optimized for all workloads.
Which statements would you issue to all Exadata Storage Servers to achieve this?

QUESTION NO: 6
Which two statements are true about the use of DBFS, ACFS, and external file systems and components in an X5 Database Machine environment?

QUESTION NO: 7
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

QUESTION NO: 8
Which three are true about Exadata Smart Flash Log?

QUESTION NO: 9
You are in the process of upgrading your X5 Database Machine half rack to a full rack.
The new storage servers are called DM01CEL08 through DM01CEL14.
After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATA diskgroup by executing this SQL statement?

QUESTION NO: 10
Examine this list of software components:
1. Oracle Virtual Machine (OVM)
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server (CELLSRV)
8. diskmon
Identify the location where these software components can run in the standard Exadata Database Machine deployment.