1z0-070 Exam - Oracle Exadata X5 Administration

NEW QUESTION 1
Which three are true about Exadata Smart Flash Log?

• A. Databases on the Database Machine use Exadata Smart Flash Log by default.
• B. I/O Resource Manager database plans can be used to enable or disable Exadata Smart Flash Log for individual databases.
• C. LGWR will not wait for writes to Exadata Smart Flash Log if the write to a disk-based logfile completes first.
• D. I/O Resource Manager category plans can be used to enable or disable Exadata Smart Flash Log for different I/O categories.
• E. The use of Exadata Smart Flash Logs is mandatory for support of production databases.

Answer: ABC

Explanation: A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases.
B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine.
C: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time.
Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better database performance.

NEW QUESTION 2
You are evaluating the performance of a SQL statement that accesses a very large table. You run this query:

Identify two reasons why the “physical read total bytes” statistic is greater than the “cell physical IO bytes eligible for predicate offload” statistic.

• A. There is an index on the column used in the WHERE clause, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.
• B. The table is an IOT and has an overflow segment, causing “cell multiblock physicalreads” to be requested by the database instance, resulting in additional I/O.
• C. There is an uncommitted transaction that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.
• D. The table is an index clustered table, causing “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.
• E. There are migrated rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

Answer: BE

NEW QUESTION 3
Which three statements are true about Automatic Hard Disk Scrubbing and repair on high- capacity storage servers in an X5 Database Machine?

• A. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is clean in the Smart Flash Cache.
• B. Hard disks are scanned every two weeks by default but only when disks are idle.
• C. Hard disks are scanned every two weeks by default in all situations.
• D. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is dirty in the Smart Flash Cache.
• E. Disk repair may be made from another mirror copy if the corrupt area is part of a Normal or High Redundancy Disk Group.

Answer: ACE

Explanation: The default schedule of scrubbing is every two weeks.
References:http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage- servers.htm

NEW QUESTION 4
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 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 theOLTP category and map all OLTP- oriented consumer groups in all databases to it.
• B. 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.
• 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 give the OLTP consumer group the highest priority on all databases.
• D. Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.

Answer: C

Explanation: You can manage I/O resources based on categories by creating a category plan.
You can add any number of categories, or modify the predefined categories. You should map consumer groups to the appropriate category for all databases that use the same cell storage. Any consumer group without an explicitly specified category defaults to the OTHER category.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- iorm.htm

NEW QUESTION 5
Which two statements are true about data paths used during RMAN backup and restore operations when media management servers use InfiniBand to connect to an X5 Database Machine?

• A. During backups, data blocks are always read from Smart Flash Cache by cellsrv.
• B. During restores, data blocks read from the media are sent to a database server that sends the blocks to cellsrv to be written.
• C. During backups, data blocks are read by cellsrv and sent to a database server, which sends the blocks to the media manager to be written to media.
• D. During backups, data blocks are read by cellsrv and sent directly to the media manager to be written to media.
• E. During restores, data blocks read from the media are sent directly to cellsrv to be written.

Answer: DE

Explanation: The fastest database backup is achieved via InfiniBand.
RMAN does not back up directly to tape. However, it will integrate with media management software such as Oracle Secure Backup and utilize their capabilities to manage tape libraries.
Exadata Database Machine: The Database Machine contains the databases that need to
be backed up. Oracle RMAN is the only mechanism to back up the databases that utilize Exadata Storage Servers as the storage. RMAN processes run on the database servers and interact with the Oracle Secure Backup (OSB) agent, which further interacts with the media management software and enables RMAN to communicate with the tape library.
References:http://apprize.info/data/oracle_4/6.html

NEW QUESTION 6
Identify three valid configuration options that can be implemented during the initial configuration process of a new X5 Database Machine by using the Exadata Deployment Assistant.

• A. Virtualized Computer Node configuration
• B. OS users that own the Grid Infrastructure installation
• C. Cluster configuration for up to 32 clusters
• D. The size for the system area on the first two disks in each cell
• E. Virtualized Storage node configuration

Answer: ACD

Explanation: Oracle Exadata Deployment Assistant has two main phases
Oracle Exadata Deployment Assistant can configure Oracle Exadata Database Machine, Recovery Appliance, or Oracle SuperCluster.
References: https://docs.oracle.com/cd/E55822_01/AMOGD/configurator.htm#AMOGD22056 https://www.toadworld.com/platforms/oracle/w/wiki/11469.oracle-exadata-deployment- assistance-oeda

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

• A. alter iormplan objective=high_throughput
• B. alter iormplan objective=balanced
• C. alter iormplan objective=low_latency
• D. alter iormplan objective= auto
• E. alter iormplan objective= ‘ ’

Answer: D

Explanation: The supported IORM objectives are auto, low_latency, balanced, and high_throughput. The recommended objective option is auto which allows IORM to continuously monitor the workloads, and select the best mode based on the active workloads currently on the cells.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- iorm.htm

NEW QUESTION 8
You are checking the status of the ports on one of the InfiniBand switches on your X5 Database Machine.
You run the getportstatus command as shown: [root@exampsw-ib2 bin] # getportstatus 17b
Port status for connector 17B Switch Port 2 Adminstate:......................Enabled LinkWidthEnabled: ...............1X or 4X
LinkWidthSupported:..............1X or 4X
LinkWidthActive..................4X
LinkSpeedSupported: .............2.5 Gbps or 5.0 Gbps or 10.0 Gbps LinkState: ......................Active
PhysLinkState: ................LinkUp
LinkSpeedActive: ..............10.0 Gbps
LinkSpeedEnabled: .............2.5 Gbps or 5.0 Gbps or 10.0 Gbps You have 36 ports to check.
Which two methods would you use to check the status of all 36 ports?

• A. Use the ibqueryerrors.pl script after logging in to the InfiniBand switch as root.
• B. Use Enterprise Manager Cloud Control.
• C. Use Enterprise Manager Express.
• D. Create user-defined metrics for the InfiniBand switch.

Answer: AB

Explanation: There are two approaches for monitoring Oracle Exadata Storage Servers: using a command-line interface (CLI) or using the graphical interface provided by the Oracle Enterprise Manager Cloud Control 12c console.
You can manually monitor the InfiniBand Switch Ports with the ibqueryerrors.pl command. Run the ibqueryerrors.pl command to report on switch port error counters and port configuration information using the command:
# ibqueryerrors.pl -rR -s RcvSwRelayErrors,XmtDiscards,XmtWait,VL15Dropped
References:http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html

NEW QUESTION 9
Which four are true about Exadata features?

• A. Storage Indexes persist across Exadata storage server reboots.
• B. Data Warehouse workloads will benefit from Smart Flash Cache configured in Write- Through mode.
• C. Hybrid Columnar Compressed tables can be compressed and decompressed on Exadata storage servers.
• D. Hybrid Columnar Compressed tables can be compressed and decompressed on the database servers.
• E. OLTP workloads will benefit from Smart Flash Cache configured in Write-Back mode.
• F. Storage Indexes persist across database server reboots.

Answer: CDEF

Explanation: CD: That data remains compressed not only on disk, but also remains compressed in the Exadata Smart Flash Cache, on Infiniband, in the database server buffer cache, as well as when doing back-ups or logshipping to Data Guard.
E (not B): Use the Write-Back Flash Cache feature to leverage the Exadata Flash hardware and make Exadata Database Machine a faster system for Oracle Database Deployments. Write-through cache mode is slower than write-back cache mode. However, write-back
cache mode has a risk of data loss if the Exadata Storage Server loses power or fails.
F: Storage indexes are not stored on disk; they are resident in the memory of the storage cell servers.

NEW QUESTION 10
Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine?

• A. IPMI can be used for server configuration and management on each database server.
• B. The Baseboard Management Controller (BMC), which supports IPMI, runs as amultithreaded process on the storage server O/S.
• C. The Baseboard Management Controller (BMC), which supports IPMI, runs as a single- threaded process on the storage server O/S.
• D. IPMI can be used for server configuration and management on each storage server.

Answer: AC

Explanation: A: IPMI – short for Intelligent Platform Management Interface – is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It’s not an Exadata command but rather a general Linux one.
To power on a cell or database server, issue this from another server:
# ipmitool -H prolcel01-ilom -U root chassis power on
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:# shutdown -h -y now
C: Like the KCS interface, the SSIF Interface is only specified as a ‘Single Threaded Interface’ for standard IPMI commands. That is, the BMC implementation is not expected to process more than one IPMI request at a time. While an implementation is allowed to have a degree of ‘command queuing’, for standard IPMI messages the SSIF lacks a ‘Seq’ field that software can use to match up particular instances of requests with responses.
References:https://www.intel.com/content/dam/www/public/us/en/documents/specification-updates/ipmi-intelligent-platform-mgt-interface-spec-2nd-gen-v2-0-spec-update.pdf

NEW QUESTION 11
As part of planning for database consolidation, you grouped your databases into two categories based on different technical and business objectives.
Which three statements are true about possible configurations for your Exadata X6 Database Machine fabric?

• A. The storage grid may be partitioned when deploying a single-rack Database Machine configuration using virtualization.
• B. The database grid may be partitioned when deploying a multirack Database Machine configuration.
• C. A single database cluster benefits from accessing multiple storage grids.
• D. Multiple database clusters may access the same storage grids.
• E. Multiple database clusters never benefit from accessing a single storage grid.

Answer: BCD

NEW QUESTION 12
Which two statements are true about RMAN incremental level-1 backups for a database running on an X5 Database Machine?

• A. Block Change tracking (BCT) is not needed for databases in an X5 Database Machine, because ASM automatically does block change tracking when diskgroups are built from griddisks.
• B. cellsrv filters blocks and returns only those that have changed since the last backup, fordatabases in archivelog mode.
• C. cellsrv returns all blocks that have been or might have been changed since the last backup, and RMAN filters the blocks that do not require backup.
• D. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelog mode.
• E. Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.

Answer: DE

Explanation: D: Whenever data blocks change, the Change Tracking Writer (CTWR) background process tracks the changed blocks in a private area of memory.
When RMAN performs an incremental backup on the Exadata platform, cellsrv filters out unwanted blocks and sends back only those that have changed since the last level 0 or level 1 backup.
E: For the Exadata platform, you may choose to allow cellserv to do all the blocking filtering for incremental backups.
Note: RMAN block change tracking is used to improve the performance of incremental backup. The level 0 incremental backup scans the entire database but level 1 incremental backups use the block change tracking file to scan only the blocks that have changed since the last backup. This significantly reduces the amount of reads that are required on the database.
References: Expert Oracle Exadata (29 Aug 2015), page 319

NEW QUESTION 13
Identify three valid reasons for creating multiple griddisks on a single harddisk-based celldisk.

• A. to implement storage realms so that storage that can be reserved for specific resource consumer groups in the same database
• B. to enable the creation of normal or high redundancy ASM diskgroups
• C. to segregate storage into multiple pools with different performance characteristics
• D. to enable disk mirroring for the system area
• E. to implement storage realms so that storage can be reserved for specific databases
• F. to implement storage realms so that storage that can be reserved for specific Grid Infrastructure

Answer: BCF

Explanation: Creating multiple grid disks per cell disk allows you to create multiple pools of storage on the same Exadata Storage Server. The multiple grid disks can be assigned to separate ASM diskgroups, which can be provisioned to different databases.
Note: Griddisk is a logical disk that can be created on a celldisk. In a standard Exadata deployment we create griddisks on hard disk based celldisks only. While it is possible to create griddisks on flashdisks, this is not a standard practice.
F: After you complete the cell configuration, you can perform the following optional steps on the storage cell:
References:https://docs.oracle.com/cd/E80920_01/SAGUG/SAGUG.pdf

NEW QUESTION 14
Which two statements are true about the X5 Exadata storage server rescue procedure?

• A. The rescue procedure can be executed from the CELLBOOT USB flash drive.
• B. An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.
• C. The rescue procedure can be used to repair corruption in an ASM diskgroup.
• D. The rescue procedure can be used to restore a corrupt system area.
• E. The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.

Answer: AD

Explanation: The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.
References:http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage- servers.htm#GUID-710814E7-4691-49EE-95AD-726D2D6C5BFE

NEW QUESTION 15
Which three statements are true about bulk data loading capabilities in an X5 Database Machine environment?

• A. DBFS must use the DBFS_DG diskgroup for any DBFS store.
• B. DBFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
• C. DBFS must be used to have a POSIX-compliant shared storage solution that is accessible from the database servers on a Database Machine.
• D. DBFS must be used to bulk load data into a production database on the Database Machine.
• E. ACFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
• F. ACFS must be used to have a POSIX –compliant shared storage solution that is accessible from the database servers on a Database Machine.
• G. ACFS may use the DBFS_DG diskgroup to contain the ADVM volume file.

Answer: BCD

Explanation: External tables on DBFS file-systems provide the probably the most high-performance way to bulk load data into your database.
Bulk Data Loading
Describe the various options for staging data to be bulk loading into Database Machine Configure the Database File System (DBFS) feature for staging input data files
Use external tables based on input data files stored in DBFS to perform high-performance data loads

NEW QUESTION 16
Which two are true concerning Columnar Flash Caching?

• A. It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.
• B. It automatically transforms ROW STORE COMPRESS compressed data into a purecolumnar format during Exadata Smart Flash Cache population.
• C. Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.
• D. It is enabled by default.
• E. It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.
• F. It improves single-row lookup performance.

Answer: DE

Explanation: D: In-Memory Columnar Caching on cells is enabled by default when the INMEMORY_SIZE is configured. You do not need to do anything to get this enhancement.
E: Columnar Flash Caching implements a dual format architecture in Exadata flash by automatically transforming frequently scanned Hybrid Columnar Compressed data into a pure columnar format as it is loaded into the flash cache.

NEW QUESTION 17
You plan to consolidate multiple mission-critical databases onto a single rack Exadata X6
database Machine.
You do not plan to use virtualization on the database servers.
You have identified two database categories, based on differing availability and maintenance objectives.
Which two choices will be the best solution?

• A. Create a single database cluster that accesses a single storage grid.
• B. Create a single database cluster that accesses multiple storage grids.
• C. Partition the Exadata storage servers into two separate storage grids.
• D. Create a single storage grid and share space on the celldisks using Exadata storage realms.
• E. Partition the database servers into two separate clusters.

Answer: BE

NEW QUESTION 18
Which components of an Exadata storage server image, if updated, may require that a patch also be applied to the database servers in an Exadata X6 Database Machine?

• A. Linux operating system on the storage server
• B. InfiniBand HCA firmware on the storage server
• C. Storage server hard disk device drivers
• D. Storage server flash device drivers

Answer: D

Explanation: Exadata patches are intended for and include fixes for both the storage servers and Compute servers, and optionally InfiniBand switches.
Patching order
You should patch the Exadata Database Machines in the following sequence
References: https://www.toadworld.com/platforms/oracle/w/wiki/11640.oracle-exadata- patching