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.
Consider the following setup:
User A1 belongs to resource group High on Database A.
User B2 belongs to resource group Low on Database B.
User C3 is a user on Database C without any DBRM setup.
DBRM setup:
Database A: Resource group High gets 80% and Low gets 20%.
Database B: Resource group High gets 60% and Low gets 40%.
IORM setup:
Database A: Share=20, limit=5
Database B: Share=30, limit=10
Database C: 5 shares
Total number of shares in the IORM setup = 100
What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?
A. Al = 36%, B2=18%, and C3=9%
B. Al = 33%, B2=33%, and C3=33%
C. AI = 10%, B2=5%, and C3=20%
D. Al = 8%, B2=12%, and C3=5%
E. Al = 5%, B2=10%, and C3=85%
High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?
A. Enable Write-Back Flash Cache due to heavy DBWR usage.
B. Enable Write-Back Flash Cache due to heavy LGWR usage.
C. Swap hard disks to High Capacity disks.
D. Tune the application to reduce I/O requests. 100% Real QandAs | 100% Real Pass
E. Leverage IORM to give priority to critical workloads.
Which is a best practice for High Availability (HA) in an Exadata environment?
100% Real QandAs | 100% Real Pass
A. Checksums performed on the Exadata Storage Server ensure logical consistency of block content.
B. When a standby database is in place, DB_BLOCK_CHECKING is not required and thus not recommended.
C. Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.
D. Due to the different architecture that Exadata has with storage servers, compared to regular Storage Area Network, DB_LOST_WRITE_PROTECT need not be set.
E. Stretched RAC is the best alternative for Exadata that combines both HA and DR into one.
Storage indexes are unique to the Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:
1.
The Exadata cell services software conducts I/O requests on I MO storage regions.
2.
cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.
3.
The database is started.
4.
Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.
5.
A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.
6.
A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.
7.
MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the I/O request.
A. 3. 7, 5, 2, 1, 6, and 4
B. 3, 7, 1, 5, 6, 2, and 4
C. 3, 6, 1. 7, 2, 5 and 4
D. 3, 5, 1, 7, 6, 2. and 4
100% Real QandAs | 100% Real Pass
After migrating from legacy disk-based configuration, which three approaches would you use to evaluate the efficiency of Exadata Flash Cache?
A. Review the Flash Hit rate via cellcli metrics.
B. Compare Optimized Physical Reads and Total Read Requests in Automatic Workload Repository (AWR).
C. Review the IOSTAT data that is gathered from each compute node by OS Watcher.
D. Evaluate the Smart Flash Logging efficiency metrics via CellCLI.
E. Check I/O latency on large I/O to Temp in AWR.
Which statement is true about instance caging setup?
A. Instance caging is the right approach to make sure that database instances are not stealing memory from each other.
B. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
C. Database instances need to be restarted to make changes to cpu_count effective.
D. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing
E. The init.org parameter resource_manager_plan should be set.
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.
Which two statements are true about Exadata memory capabilities?
100% Real QandAs | 100% Real Pass
A. X3-8 can be purchased in a Half Rack configuration with 2 TB of memory.
B. X3-2 memory can be expanded to 512 GB per node from 256 GB.
C. X3-2 memory can be upgraded to use Flash in the compute nodes.
D. X3-8 memory is fixed at 4 TB per a Rack.
E. X3-2 can be purchased in a Half Rack configuration with 256 GB per node.
Which three migration options are available when you migrate a database from the Big Endian format system to Exadata?
A. Data Pump Export and Import
B. transportable database
C. transportable tablespaces
D. Data Guard
E. Insert as Select
