NEW QUESTION 1
Which three are true concerning Exadata snapshot databases?

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

Answer: ACD

Explanation:
A: An Exadata snapshot database can be either a non-container database (non-CDB) or a container database (CDB). Creating an Exadata snapshot database of a CDB enables access to all of the pluggable databases in that container.
C: You can create two types of Exadata snapshots, depending on the current setup of your environment:
D: SPARSE disk group based database snapshots is functionality included in Exadata Storage Software. It requires Exadata Storage Software version 12.1.2.1.0 and Oracle Database 12c version 12.1.0.2 with bundle patch 5 or later. This feature is designed to work on native Exadata ASM storage disk groups. It uses ASM SPARSE grid disk based thin provisioning where snapshot databases created on a SPARSE disk group need only the space for changes plus some metadata, thereby enabling storage efficient snapshot databases.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- snapshots.htm#SAGUG-GUID-E1D6EF45-36EF-40E3-A57E-F80B749E6122
http://www.oracle.com/technetwork/database/exadata/learnmore/exadata-database-copy-twp-2543083.pdf

NEW QUESTION 2
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 3
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 4
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 5
Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?

• A. on an ACFS file system stored in a staging database on the Database Machine
• B. a ZFS over NFS file system mounted on a database server where the external table will be accessed
• C. an Exadata-based ACFS file system on the Database Machine
• D. a DBFS file system stored in a staging database on the Database Machine
• E. on local storage on one or more storage servers that are accessible to the database server where the load will be performed

Answer: ABE

NEW QUESTION 6
Which three are true concerning Hybrid Columnar Compression (HCC) deployed on Exadata storage?

• A. HCC can be used only when the Exadata Smart Flash Cache is configured in Write- Through mode.
• B. HCC data is never cached in the Exadata Smart Flash Cache.
• C. By default, decompression is performed by Exadata Storage Servers.
• D. Rows residing in HCC compressed segments, are always self- contained in a single database block.
• E. Rows residing in HCC compressed segments, are always self- contained in a single compression unit.
• F. Row-level locks are supported on HCC compressed data.

Answer: CEF

Explanation:
C: The decompression process typically takes place on the Oracle Exadata Storage Server in order to maximize performance and offload processing from the database server.
E: A logical construct called the compression unit is used to store a set of hybrid columnar compressed rows. When data is loaded, column values for a set of rows are grouped together and compressed. After the column data for a set of rows has been compressed, it is stored in a compression unit.
F: What happens when I update a row on compressed tables? What about locks?
Note: Oracle’s Hybrid Columnar Compression technology is a new method for organizing data within a database block. As the name implies, this technology utilizes a combination of both row and columnar methods for storing data. This hybrid approach achieves the compression benefits of columnar storage, while avoiding the performance shortfalls of a pure columnar format.

NEW QUESTION 7
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 8
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 9
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 10
You are evaluating the performance of a SQL statement that accesses a very large table. You run this query:

Identify two reasons why the “cell physical IO interconnect bytes” statistic is greater than the “cell physical IO interconnect bytes returned by smart scan” statistic.

• A. There is a transaction, which committed after the query began, 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.
• B. There are chained rows in the table, causing some “single block physical reads” to be requested by the database instance, resulting in additional I/O.
• C. The table is a hash clustered table, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.
• D. The table is list partitioned, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O.
• E. There is a local index on a list partitioned table on the column used in the WHERE clause, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O.

Answer: CD

Explanation:
C: Scan on a clustered table can prevent a Smart Scan from occur.
D: Scan on an index-organized table can prevent a Smart Scan from occur.
Note: The Cell physical IO interconnect bytes returned by smart scan metric shows how many bytes of I/O were returned by a smart scan to the database server.
References:https://uhesse.com/2011/01/19/exadata-part-i-smart-scan/

NEW QUESTION 11
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 12
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 13
Which two are benefits of an active/inactive configured InfiniBand network on Exadata Database Machine X5?

• A. Improved performance for Oracle Network traffic
• B. Improved reliability for Cache Fusion RAC network traffic
• C. Improved reliability when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands
• D. Improved performance for ASM rebalance network traffic
• E. Improved performance when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands

Answer: BC

Explanation:
Active-passive bonding provides reliability through failover.

NEW QUESTION 14
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 15
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 16
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 17
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?

• A. the number of database users
• B. Security Policies
• C. the number of database roles
• D. the number of simultaneous sessions
• E. the maintenance schedule

Answer: ABD

NEW QUESTION 18
You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to an X6 Exadata Database Machine.
The database currently supports an application requiring fast response times to satisfy stringent business requirements, and most of the application queries use indexed access to tables.
For which two cases would you consider dropping indexes that are not used for constraints after the migration to assure that Smart Scans occur?

• A. if Smart Scan performs better that any type of index scan on the corresponding table.
• B. if Smart only occur instead of index skip scans on the corresponding table.
• C. if Smart only occur instead of index range scans on the corresponding table.
• D. if Smart Scans performs equally well to any type of index scan on the corresponding table.

Answer: AC

NEW QUESTION 19
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 20
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 21
......