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

Answer: ACD

Explanation:
A: To further accelerate OLTP workloads, the Exadata Smart Flash Cache also implements a special algorithm to reduce the latency of log write I/Os called Exadata Smart Flash Logging.
C: 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.
D: Exadata X5-2 introduces Extreme Flash Storage Servers. Each Extreme Flash storage server contains eight 1.6 TB state-of-the-art PCI Flash drives. PCI flash delivers ultra-high performance by placing flash memory directly on the high speed PCI bus rather than behind slow disk controllers and directors.
References:http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds- 2406241.pdf
http://www.oracle.com/technetwork/articles/database/exadata-write-back-flash- 2179184.html

NEW QUESTION 2
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 3
Which four statements are true about the configuration of Auto Service Request (ASR) for use with an X5 Database Machine?

• A. ASR Manager software may be installed on one of the database servers in the Database Machine.
• B. ASR can connect to the Internet using Simple Network Management Protocol (SNMP), using a proxy server.
• C. ASR Manager can connect to the Internet directly with HTTPS.
• D. ASR Manager can connect to the Internet with HTTPS using a proxy server.
• E. ASR can connect to the Internet directly using Simple Network Management Protocol (SNMP).
• F. ASR Manager software may be installed on a server that is not part of the Database Machine.

Answer: ACDF

Explanation:
C: If you need to use HTTPS for security purposes, you can set up HTTPS/SSL for the ASR Manager HTTP receiver.
D: As part of the registration process for ASR Manager, you can optionally set the ASR Manager to access the internet through a proxy server.
References:https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.ht m#ASRUD137

NEW QUESTION 4
You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.
You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.
You issue this command on the first cell:

You examine the output from the first cell which contains:

Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?

• A. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC
• B. CT_IO_UTIL_SM and CT_IO_UTIL_LG
• C. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC
• D. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ

Answer: D

NEW QUESTION 5
Identify two supported modifications to an X5 Database Machine.

• A. installing a Host Bus Adapter (HBA) in the compute nodes
• B. installing additional Operating System (O/S) packages on the computer nodes
• C. installing additional Operating System (O/S) packages on the Exadata storage servers
• D. installing a Host Bus Adapter (HBA) in the storage servers
• E. replacing the Cisco Ethernet switch with another make or model
• F. replacing the Infiniband switches with another make or model

Answer: BD

Explanation:
B: Updating Exadata Database Servers (compute nodes).
The software and firmware components that are updated for a specific release depend on the current Exadata software release the database server is running and the release you are updating to. Linux operating system packages and Exadata software are always updated while firmware may be updated for only a small selection of the components or not at all.
D: The storage cells (storage servers/nodes) contain HBAs, and spare PCI I/O slots. References:https://docs.oracle.com/cd/E41033_01/html/E55032/bbgiabie.html
http://docs.oracle.com/cd/E80920_01/DBMMN/updating-exadata-software.htm#DBMMN-
GUID-AB25ED9A-7920-441A-9A60-14ED2753B01C

NEW QUESTION 6
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 7
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 8
Which three are sources for alerts from storage servers in an X5 Database Machine?

• A. Software errors reported by the MS process on the storage servers
• B. Hardware sensor alerts reported by the CELLSRV process on the storage servers
• C. Software errors reported by the RS process on the storage servers
• D. Hardware sensor alerts detected by the ILOM on the storage servers
• E. Metrics that have administrator-defined thresholds on the storage servers

Answer: ABE

Explanation:
AB: The Management Server (MS) process receives the metrics data from CELLSRV, keeps a subset of metrics in memory, and writes to an internal disk-based repository hourly. In addition, the MS process can generate alerts for important storage cell hardware or software events.

NEW QUESTION 9
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 10
You are planning your deployment of Enterprise Manager to monitor all the components of an X5 Database Machine.
A part of the requirement is to provide for high availability of the monitoring infrastructure. If the host running the agent that has Database Machine targets bound to it fails, the
monitoring of these targets must be done by another agent.
Which three statements are true regarding the configuration used to support this requirement?

• A. Database Machine plug-ins must be deployed to at least two Enterprise Manager agents.
• B. Fail back to the original agent when the host is restarted is done automatically.
• C. Fail over to any secondary agent is done automatically.
• D. Fail over to any secondary agent must be done manually.
• E. Database machine plug-ins must be deployed to all Enterprise Manager agents.
• F. Fail back to the original agent when the host is restarted must be done manually.

Answer: BCE

NEW QUESTION 11
Which two statements are true about Auto Service Request (ASR) with an X5 Database Machine?

• A. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
• B. Configuring ASR is mandatory for all Database Machine assets.
• C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• D. ASR Manager must be installed and configured on one of the database servers.
• E. ASR can upload configuration metadata to support problem resolution.
• F. ASR communicates with Oracle support services using HTTPS.

Answer: AC

Explanation:
A: Oracle recommends that you install Oracle ASR Manager on an external, standalone server.
C: Oracle ASR is designed to generate Oracle service requests automatically when certain types of faults are detected on Oracle products that are qualified for Oracle ASR.
Oracle ASR works only for specific component faults. Most of the common components, such as disks, fans, and power supplies, are covered. However, some components are not covered. For example, Oracle ASR does not cover InfiniBand events; there are specific images and specific InfiniBand switch firmware that you must use. You cannot upgrade these components independently.

NEW QUESTION 12
Which three must be true for a Smart Scan to occur for a table?

• A. cell_offload_processing must be true in sessions issuing SQL statements that access the table.
• B. The query must be executed serially.
• C. The query must be executed in parallel.
• D. Direct path reads must be used at run time.
• E. The ASM diskgroup containing the table’s tablespace must have a 4 Mbyte AU size.
• F. The ASM diskgroup containing the table’s tablespace must have cell.smart_scan_capable set to true.

Answer: ADF

Explanation:
A: pt_param( ‘cell_offload_processing’ ’TRUE’) hint is used to enable the exadata smart scan feature in sql execution process.
D: Direct reads bypass the buffer cache and go directly into the process PGA. Cell offload operations occur for direct reads only.
F: The cell.smart_scan_capable attribute must be set to TRUE.

NEW QUESTION 13
You must replace the battery on the disk controller in three Exadata storage servers and must power off the affected storage servers.
Which two commands must you execute to safely power off the storage servers in an X5 Database Machine?

• A. ‘shutdown -h now’on the affected storage servers
• B. CellCLI> LIST GRIDDISK WHERE STATUS != ‘inactive’
• C. CellCLI > LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != ‘Yes’
• D. ‘crsctl stop cluster –all’on one of the database servers
• E. CellCLI> ALTER GRIDDISK ALL INACTIVE

Answer: CE

Explanation:
C: Step 1:
Run the following command to check if there are other offline disks
CellCLI> LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'
If any grid disks are returned, then it is not safe to take the storage server offline because proper Oracle ASM disk group redundancy will not be intact.
E: Step 2:
Inactivate all the grid disks when Oracle Exadata Storage Server is safe to take offline using the following command:
CellCLI> ALTER GRIDDISK ALL INACTIVE
Taking the storage server offline when one or more grid disks are in this state will cause Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly.

NEW QUESTION 14
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 15
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 16
Identify two valid reasons for executing an X5 Exadata storage server rescue procedure.

• A. Accidental loss of all data from all griddisks in a storage server
• B. Corruption in the /(root) filesystem
• C. Corruption in a normal or high redundancy ASM diskgroup
• D. The failure of both physical disks 0 and 1
• E. Only the failure of physical disk 1
• F. Only the failure of physical disk 0

Answer: BD

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.

NEW QUESTION 17
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 18
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 19
You plan to partition the database and storage grids in an X5-2 full rack, creating two clusters and two storage grids without using virtualization.
One cluster will be used for production and should consist of six database servers and nine storage servers.
The other cluster will be used for test and development, and should consist of two database servers and five storage servers.
The storage must be partitioned so that the storage servers are visible only to the appropriate database servers that are meant to access them.
What must be done to achieve this?

• A. Configure Exadata realms using Oracle ASM-scoped security mode.
• B. Configure Exadata realms using Database –scoped security mode.
• C. Edit the CELLI
• D. ORA file on each database server to contain IP addresses of storage servers in the storage grid associated with the cluster to which that database server belongs.
• E. Edit the CELLINI
• F. ORA file on each database server to contain IP addresses of storage servers in the storage grid associated with the cluster to which that database server belongs.
• G. Edit the CELLI
• H. ORA file on each database server to contain IP addresses of database servers which are allowed access to specific storage servers in the same storage grid.
• I. Edit the CELLI
• J. ORA file on each storage server on contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that storage server belongs.

Answer: C

Explanation:
The cellinit.ora file is host-specific, and contains all database IP addresses that connect to the storage network used by Oracle Exadata Storage Servers. This file must exist for each
database that connect to Oracle Exadata Storage Servers.
The cellinit.ora file contains the database IP addresses. The cellip.ora file contains the storage cell IP addresses. Both files are located on the database server host.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-configuring.htm#SAGUG20369

NEW QUESTION 20
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 21
Which three are true concerning Storage Indexes?

• A. A maximum of eight table columns for any table are indexed per storage region.
• B. The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan.
• C. Storage Indexes persist across any Exadata storage server reboots.
• D. The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
• E. A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL.
• F. Different storage regions may have different columns indexed for the same table.

Answer: ADE

Explanation:
A: Each disk in the Exadata storage cell is divided into equal sized pieces called storage regions (default 1MB). There is an index entry for every storage regions (1MB of data stored on disk). Each entry contains the minimum and maximum value for columns seen in ‘where’ clause predicates. Information for up to 8 columns can be stored. The index is then used to eliminate disk IO by identifying which storage regions don’t match the ‘where’ clause of a query.

NEW QUESTION 22
Which three factors should you consider when choosing a method for migrating a database to the X5 Database Machine?

• A. The down time allowed for the migration
• B. Endian format of the source database
• C. Number of tablespaces in the source database
• D. The type of database workloads
• E. Size of the source database

Answer: BDE

Explanation:
B: Endian format: Non-Exadata format
D: Use Real Production Workload
– Real Application Testing (RAT) References:

NEW QUESTION 23
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 24
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.

NEW QUESTION 25
Which three are true concerning Smart Scans?

• A. The decision to perform a Smart Scan is made by the Optimizer.
• B. Smart Scans are only possible during full table scans or fast full index scans.
• C. Smart Scans are possible on Index Organized Tables (IOTs).
• D. Smart Scans always outperform scans that are not offloaded.
• E. Smart Scans are possible on heap organized tables.
• F. Smart Scans are possible on uncompressed B*Tree indexes.

Answer: ABF

Explanation:
B: In order for queries to take advantage of Exadata’s Offloading capabilities, the optimizer must decide to execute a statement with a Full Table Scan or a Fast Full Index Scan.
F: Smart Scans can be used for full scanning through B*Tree index segments. References: Expert Oracle Exadata - K. Osborne, et al., (Apress, 2011) BBS, page 346

NEW QUESTION 26
......