Question No : 1
Which two migration will result in the least down time for a physical or logical migration of a
database with active users during the migration?
A. using GoldenGate
B. using SQL Developer migration tools
C. using Data Guard Physical Standby
D. using cross-platform transportable tablespaces
E. using incremental cross-platform RMAN restore
Answer: A,E
Explanation: A: Zero Downtime Migration to Oracle Exadata using Oracle GoldenGate
– Reduce downtime for any method
– Zero data loss fallback
– Phased migration
E: Cross Platform Incremental Backups
– Reduce downtime for Transportable Tablespaces
Question No : 2
Identify the three values to which the cell_flash_cache attribute can be set.
A. read
B. WRITE
C. KEEP
D. DEFAULT
E. NONE
Answer: C,D,E
Explanation: There are three values the CELL_FLASH_CACHE attribute can be set to.
DEFAULT specifies
the cache used for a DEFAULT object is automatically managed as described in the
previous
section. NONE specifies that the object will never be cached. KEEP specifies the object
should
be kept in cache.
Note: The CELL_FLASH_CACHE can be assigned to a database table, index, partition and
LOB column.
Question No : 3
Which two statements are true about enabling write-back flash cache?
A. When enabling write-back flash cache in a non rolling manner, it is important to ensure
that asmdeactivatonoutcome is set to YES and asmModestatus is set to ONLINE for all
grid disks.
B. Before using write-back flash cache, you need to verify the minimum required versions.
C. Before write back-flash cache is enabled, you need to drop the Flash Cache first.
D. The setting flashCacheMode should be set to writeback by updating cellinit.ora and
restarting cellsrv.
E. When enabling write-back flash cache in a rolling manner, dcli should be used to
inactivate the grid disks on all cells first.
Answer: B,C
Explanation: B: Exadata storage version 11.2.3.2.1 is the minimum version required to
use this write back flash cache option.
C: Steps for Enabling Write back flash cache:
First of all, you don’t need the stop CRS or database (This is ROLLING method) ,you can
do it cell by cell.
* drop flashcache
* Be sure asmdeactivationoutcome is YES is before disabling grid disk
Question No : 4
Exadata Database Machine offers an Intelligent Platform Management Interface for the
various components in the Exadata product. Which option is true?
A. IPMI can be used to remotely start and stop servers.
B. IPMI can be used to remotely log in to the operating system.
C. IPMI commands can be executed by using SNMP traps.
D. IPMI settings can be secured by backing up the Oracle Linux installation on the storage
system.
Answer: A
Explanation: 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
Question No : 5
Identify two ways to reduce the risks associated with the software updates that are
performed on a production Exadata system.
A. Patch all systems at once instead of one at a time.
B. Test on an Exadata system that is identical to the production system first.
C. Updating an engineered system has no risk.
D. Patch on the standby system first by using Data Guard Standby First Patch Apply.
E. Create a system-wide firmware and software snapshot first.
Answer: B,D
Explanation: Patch Installation and Testing
Guidelines
1. Review patch documentation
• README and referenced Support Notes
2. (B) Validate in test environment
• Verify patch installation (HealthCheck Note 1070954.1)
• Verify functionality and performance
• Automate
• Define and test fallback plans
3. Apply in production environment
• (D) Data Guard Standby-First Patch Apply
• Monitor for regressions
Support Note 1262380.1
No comments:
Post a Comment