1z0-070 Exam - Oracle Exadata X5 Administration

NEW QUESTION 1
You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your X6 Database Machine. The Database Machine database version is 11.2.
You plan to perform a physical database migration using Transportable Database. Which two are requirements for this method?

• A. The source database must be deployed on a Little Endian platform,
• B. The source database must be at least 11.1.
• C. The source database must be at least 11.2.
• D. The source database must use only bigfile tablespaces.
• E. The source database must be deployed on a Big Endian platform.
• F. The source database must not use bigfile tablespaces.

Answer: AC

Explanation: Transportable database approach (TDB). If the source system is running Oracle 11.2 or above with Little Endian format, this method can be used to migrate the database to Exadata.
References:https://www.toadworld.com/platforms/oracle/w/wiki/11551.managing-troubleshooting-exadata-part-3-migrating-databases-to-exadata-database-machine-best- practices

NEW QUESTION 2
You plan to migrate an Oracle database supporting an online transaction processing (OLTP) workload to an X5 Exadata Database Machine.
The database machine is running database version 12.1.0.2. The source database has these attributes:
Database version: 12.1.0 Byte order: Big Endian Database size: 24 TB
You have decided to perform physical migration using the Transportable Tablespace method.
Examine this list of possible steps to accomplish this task.
1. Create a new 12.1.0.2 Exadata –based database.
2. Export the source system metadata using transportable Tablespace (TTS).
3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change them to the little endian format.
4. Import the metadata into the target database.
5. Use the RMAN CONVERT to change the database files to the little endian format on the source system.
Identify the required steps in the correct order.

• A. 1, 2, 4, 5
• B. 1, 2, 5, 3, 4
• C. 1, 2, 3, 4, 5
• D. 1, 2, 3, 4
• E. 1, 2, 5, 4, 3
• F. 1, 2, 5, 4

Answer: D

Explanation: Step 1: 1. Create a new 12.1.0.2 Exadata –based database.
Step 2: 2. Export the source system metadata using transportable Tablespace (TTS). Step 3: 3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change them to the little endian format.
Step 4: 4. Import the metadata into the target database.
This method is often chosen when migrating between platforms with different endian formats, or in cases where physical re-organization is not necessary.
The transportable tablespace method is generally mu References:https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/mig-transportable-tablespace.html

NEW QUESTION 3
Which three statements are true about the EXADCLI utility?

• A. It may be run interactively.
• B. It can be used to execute EXACLI scripts on multiple storage servers in parallel.
• C. It can be used to execute O/S commands on multiple storage servers in parallel.
• D. It can be used to execute EXACLI commands on multiple storage servers in parallel.
• E. It uses the same security mechanism as the EXACLI command.
• F. It may be used to execute DBMCLI commands on multiple database nodes in parallel.

Answer: DEF

Explanation: The exadcli utility runs commands on multiple remote nodes in parallel threads.
You can issue an ExaCLI command to be run on multiple remote nodes. Remote nodes are referenced by their host name or IP address. Unlike dcli, exadcli can only execute ExaCLI commands. Other commands, for example, shell commands, cannot be executed using exadcli.

NEW QUESTION 4
You are planning the monitoring configuration for your X5 Database Machine.
Which two components are monitored directly through the use of Exadata –specific Enterprise Manager Plug-Ins?

• A. the database server Clusterware
• B. the storage server ILOM
• C. ASM instances
• D. the database server O/S
• E. the Infiniband switches

Answer: BE

Explanation: The Oracle Enterprise Manager Grid Control Exadata Monitoring plug-in bundle allows you to monitor the following key components of Exadata machine:
References:http://www.oracle.com/technetwork/oem/grid-control/exadata-plug-in-bundle- 188771.html

NEW QUESTION 5
The InfiniBand switches on your X5 Database Machine contain the software version as confirmed using the version command:
[root@exampsw –ib2 bin] # version SUN DCS 36p version: 1.3.3-2 Build time: Apr 4 2015 11:15:19
SP board info:
Manufacturing Date: 2014.05.05 Serial Number: “NCD3X0178” Hardware Revision: 0x0006 Firmware Revision: 0x0102 BIOS version: NOW1R112 BIOS date: 04/24/2014
Which two tools are useful for monitoring the InfiniBand switches for fan problems and by which users should they be run?

• A. Run the env_test command on the switches after logging in as the ilom-admin user.
• B. Run the getfanspeed command on the switches after logging in as root.
• C. Run the env_test command on the switches after logging in as root.
• D. Run the showtemps command on the switches after logging in as the ilom-admin user.

Answer: CD

Explanation: C: Login as root on IB switch and run,
# env_test
Example output include:
Starting FAN test: Fan 0 not present
WARNING Fan 1 running slow rpm 5450 limit 6440
WARNING Fan 2 running slow rpm 5341 limit 6440
WARNING Fan 3 running slow rpm 5341 limit 6440
D: The showtemps command displays internal temperatures for the switch.
The following example shows how to display switch temperatures with the showtemps command.
# showtemps
Back temperature 29
Front temperature 30
SP temperature 36
Switch temperature 52, maxtemperature 56 All temperatures OK
#
References:http://myoraclediary.blogspot.se/2014/04/all-about-infiniband-switches-on- exadata.html

NEW QUESTION 6
Which statement is true about operating systems in an X5 Database Machine multirack configuration consisting of two full racks and one Exadata storage expansion rack?

• A. All Exadata storage servers used by the same virtual cluster nodes must run the same O/S but Exadata Storage Servers in different clusters may run different operating systems.
• B. All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.
• C. All Exadata storage servers may run Oracle Virtual Machine (OVM).
• D. All Exadata storage servers must run Oracle Linux.
• E. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same version of Oracle Virtual Machine (OVM).

Answer: D

Explanation: On both physical and virtual deployments, Exadata systems use minimal Linux distributions to ensure that just the RPMs needed to run Oracle database, are installed and enabled.
References:http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds- 2406241.pdf

NEW QUESTION 7
Which three statements are true about Recovery Manager (RMAN) daily differential incremental backup strategies on an X5 Database Machine for a database having 25% or more of its blocks modified each day and which has an 8 k block size?

• A. Fast incremental backups when 50% or more of the blocks have changed since the last backup, will run as slowly as normal incremental backup.
• B. Enabling Block Change Tracking (BCT) on the database can result in reduced consumption of storage network bandwidth.
• C. Enabling Block Change Tracking (BCT) on the database can result in a reduction ofphysical I/O on the cells during incremental backups.
• D. For level-1 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
• E. For level-0 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
• F. cellsrv returns only blocks that have changed since the last backup.

Answer: ACF

Explanation: A: Fast Incremental backups is possible with Block change tracking, which is initially introduced from version 10.2 onwards, by this tool it's very useful to reduce the RMAN incremental backup duration.
If the changes are something around 20% then in this situation BCT helps a lot.
C: Exadata Storage Server offload capability combined with RMAN block change tracking will efficiently perform large I/Os at the storage-tier level, returning only individual changed blocks for incremental backups and increasing the backup performance of the system.
Note: Level 1 backup: A level 1 backup includes only those blocks that have been changed since the "parent" backup was taken. Remember a parent backup may be either a level 0 or a level 1 backup.
Block change tracking allows indeed the highest benefit for databases where the changes are not so high,
Level 0 backup: A level 0 incremental backup is physically identical to a full backup and it includes every data block in the file except empty blocks. The only difference is that the level 0 backup is recorded as an incremental backup in the RMAN repository, so it can be used as the parent for a level 1 backup.
References:http://www.dba-oracle.com/t_rman_backup_types.htm http://www.oracle.com/technetwork/database/availability/maa-tech-wp-sundbm-backup- 11202-183503.pdf
https://www.toadworld.com/platforms/oracle/w/wiki/11124.fast-incremental-backups-active- data-guard

NEW QUESTION 8
You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your X5 Database Machine and its assets.
Which three statements are true about this configuration?

• A. Simple Network Management Protocol (SNMP) traps are used to send notifications fromdatabase servers to the ASR Manager.
• B. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager.
• C. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
• D. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
• E. Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager.
• F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to the Enterprise Manager.

Answer: BCF

Explanation: B: Oracle ASR Manager only processes SNMP traps that are sent from IP addresses that Oracle ASR Manager recognizes.
Example of Exadata Storage Server SNMP Trap
This example shows the SNMP trap for an Exadata Storage Server disk failure. The corresponding hardware alert code has been highlighted.
2011-09-07 10:59:54 server1.example.com [UDP: [192.85.884.156]:61945]:
RFC1213-MIB::sysUpTime.0 = Timeticks: (52455631) 6 days, 1:42:36.31 SNMPv2-SMI::snmpModules.1.1.4.1.0 = OID: SUN-HW-TRAP-
MIB::sunHwTrapHardDriveFault
SUN-HW-TRAP-MIB::sunHwTrapSystemIdentifier = STRING: Sun Oracle Database Machine
Etc.
C (not D): The ASR Manager uses the SNMP GET protocol to query ASR assets for additional fault information.
To configure fault telemetry, choose one of the following three options:
Add SNMP Trap Destinations Using OneCommand (recommended for new installations) Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility
Add SNMP Trap Destinations for a Single Server
References: http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm
https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch5_troubleshooting.htm#ASRUD 331

NEW QUESTION 9
You are designing the monitoring architecture and procedures for an X5 Database Machine fabric consisting of two full racks, to provide for the monitoring for all components on the critical path of the admin network.
Which two components need to be monitored?

• A. the Infiniband leaf switches
• B. the power distribution units
• C. the Cisco 48 port Catalyst Ethernet Switch
• D. the InfiniBand spine switches

Answer: CD

Explanation: The Cisco Catalyst 4948 Ethernet switch is supplied with the Oracle Exadata Rack. D: Figure: Running the Subnet Manager in Different Rack Configurations

References:
https://docs.oracle.com/cd/E18476_01/doc.220/e18478/GUID-9FF8B5B0-3481-4B73-89D3-108CBD7EB989.htm#ELMOG76346
http://docs.oracle.com/cd/E80920_01/DBMIN/configuring-exadata.htm#DBMIN21274

NEW QUESTION 10
In which scenario will griddisks residing on the same celldisk have balanced performance characteristics in an X5 High Capacity Exadata Storage Server?

• A. griddisks on memory based celldisks
• B. griddisks on hard disk-based celldisk consumed by ASM when creating diskgroups using ASM-based Intelligent Data Placement (IDP)
• C. griddisks on hard disk-based celldisks consumed by the Database Smart Flash Cache
• D. griddisks on Flash-based celldisks

Answer: B

Explanation: Intelligent Data Placement enables you to specify disk regions on Oracle ASM disks for best performance. Using the disk region settings, you can ensure that frequently accessed data is placed on the outermost (hot) tracks which have greater speed and higher bandwidth. In addition, files withsimilar access patterns are located physically close, reducing latency. Intelligent Data Placement also enables the placement of primary and mirror extents into different hot or cold regions.
References:https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#O STMG10072

NEW QUESTION 11
Which two statements are true about backup performance when using Recovery Manager (RMAN) on an X5 Database Machine?

• A. Backups are fast because the Infiniband network is faster than fiber channel storage, so RMAN read I/O operations are faster than in traditional storage networks.
• B. Backups are fast, because physical I/Os operations are reduced by the use of the Storage Index by cellsrv.
• C. Backups are fast, because data blocks are read from the Database Flash Cache.
• D. Backups are fast, because all data blocks are read from the Exadata Smart Flash Cache.
• E. For incremental backups using Block Change Tracking, cellsrv filters blocks and returns only those that have changed since the last backup.

Answer: DE

Explanation: D: The storage server software manages the flash cache and can recognize different types of I/O requests so that non-repeatable data access like RMAN backup I/O does not flush database blocks from the cache. It also prioritizes frequently accessed block types such as redo logs, control files, and index root blocks.
E: RMAN block change tracking allows incremental backups to run very quickly and efficiently. With block change tracking, only the areas of the database that have been modified since the last incremental backup or full backup are read from disk.

NEW QUESTION 12
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?

• A. the CELLINIT.ORA files on the database servers in CLUSA
• B. the CELLIP.ORA files on the database servers in CLUSA
• C. the CELLINIT.ORA files on the database servers in CLUSB
• D. the CELLIP.ORA files on all existing Exadata storage servers
• E. the CELLIP.ORA files on the database servers in CLUSB
• F. the CELLIP.ORA files on all newly added Exadata storage servers

Answer: BE

Explanation: The cellip.ora is the configuration file, on every compute node (database server), that tells ASM instances which cells are available to this cluster.
The cellip.ora file contains the storage cell IP addresses. References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-configuring.htm#SAGUG20369

NEW QUESTION 13
Which two completely prevent a Smart Scan from occurring?

• A. querying a table containing many chained rows
• B. querying a table containing many migrated rows
• C. performing a minimum or maximum function on an indexed column
• D. performing a Fast Full Index scan on a reverse key index
• E. referencing more than 255 columns form an OLTP compressed table in a query
• F. querying a table containing a JSON column

Answer: BE

Explanation: B: Migrated Rows is a special case of chained rows. Migrated rows still affect performance, as they do in conventional storage situations, but with the additional overhead of reducing the beneficial effects of “Smart Scan” in addition to increasing the number of I/Os
E: Smart Scans - broadly speaking and ignoring edge cases - can only transport a maximum of 254 columns from a single (non-HCC) segment. Requesting more columns will simply disable Smart Scans for that segment.
An interesting limitation to Exadata Smart Scans - if more than 254 columns from a table (not HCC compressed, more on that in moment) need to be projected, Smart Scans for that particular segment will be disabled and Exadata will fall back to conventional I/O. This means that the number of columns in the projection clause can make a significant difference to performance, since only Smart Scans allow taking advantage of offloading and particularly avoiding I/O via Storage Indexes.

NEW QUESTION 14
Which two statements are true regarding the use of Auto Service Request (ASR) with an X6 Database Machine?

• A. The database server ILOMs must use SMTP over the management network for notifications to ASR Manager.
• B. The database server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.
• C. The storage server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.
• D. The database server MS process must have SNMP traps configured to use the management network for notifications to ASR Manager.

Answer: BC

Explanation: B: Database Server ILOM plug-in
Monitoring databases and their instances, ASM environments, the Grid Infrastructure, and the host software environment are done by Enterprise Manager in the usual way as these are standard targets. But monitoring the hardware for the database servers requires the ILOM plug-in, as there is no Management Server (MS) on the database servers to receive SNMP traps from the ILOM. The plug-in will receive sensor state and availability data from the ILOM including alerts based on pre-set ILOM thresholds.
C: Exadata Storage Server plug-inextends the monitoring of exadata cells in addition to providing a GUI interface. The plug-in uses an SSH connection to the cellmonitor user on the cells and uses list commands only. This is for interactive monitoring. One may also set thresholds using the plug-in which are distinct from any thresholds set using cellcli utility as the celladmin user. For alerts to be sent to the plug-in, SNMP traps are used as follows:
Cell ILOM alerts are sent to the cell Management Server (MS) via an SNMP trap. The MS then send SNMP notifications onward to the plug-in.
Cell alerts flagged by MS itself, such as cell thresholds being exceeded, or ADR software alerts, are sent to the plug-in using SNMP.
References: https://dbatrain.wordpress.com/2011/06/
http://docs.oracle.com/cd/E21659_01/html/E21660/z40015671004046509.html

NEW QUESTION 15
You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Exadata X6 Database Machine.
You use RAC for your databases and also use Data Guard, having standby databases on another Database Machine.
You want to have scripts that contain the appropriate commands to patch your environment.
Your patch bundle is one the first database server and is located at/uo1/stage. You have downloaded the oplan utility to the first database server and run:
$ORACLE_HOME/oplan/oplan generateApplySteps /u01/stage
Which two statements are true concerning the type of instructions oplan will generate?

• A. Instructions for patching the Grid Infrastructure home on the primary location
• B. Instructions for patching the Data Guard environment on the standby location
• C. Instructions for patching the RAC Oracle Home on the primary location
• D. Instructions for patching only storage servers
• E. Instructions for patching all components on the Database Machine

Answer: AC

Explanation: Oplan generates instructions for all of the nodes in the cluster. Note:

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

Answer: DE

Explanation: HIGH redundancy provides protection against 2 simultaneous disk failures from 2 distinct storage servers or 2 entire storage servers. HIGH redundancy provides redundancy during Exadata storage server rolling upgrades.
References:http://blog.umairmansoob.com/choosing-high-vs-normal-redundancy-with- exadata/

NEW QUESTION 17
An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state.
Identify the two steps that you must perform to replace this failed physical disk.

• A. Add the griddisks back into the ASM diskground they used to be a member of.
• B. Create a new celldisk and new griddisks on the replaced physical disk.
• C. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
• D. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
• E. Replace the failed physical disk.

Answer: CE

Explanation: You may need to replace a physical disk because the disk is in warning - predictive failure status. The predictive failure status indicates that the physical disk will soon fail, and should be replaced at the earliest opportunity. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance relocates the data from the predictively failed disk to other disks.
Note: After the physical disk is replaced, the grid disks and cell disks that existed on the previous disk in that slot are re-created on the new physical disk. If those grid disks were part of an Oracle ASM group, then they are added back to the disk group, and the data is rebalanced on them, based on the disk group redundancy and ASM_POWER_LIMIT parameter.
References:http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#DBMMN21047

NEW QUESTION 18
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.

• A. 1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.
• B. 1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
• C. 1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
• D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.
• E. 2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.

Answer: B

Explanation: Automatic Diagnostic Repository Command Interpreter (ADRCI) can be used on an Exadata storage server.