Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.
A. Remove the doors of the 1/8th rack. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack.
B. Activate all cores by using a software command. Activate all hard drives and flash drives. Create the grid disks. Expand the Oracle ASM diskgroups. Review the new configuration.
C. Remove the doors of the 1/8th rack. Add an additional Sun Datacenter InfiniBand Switch. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack. Configure the new hardware.
D. Activate all cores by using a software command. Activate all hard drives and flash drives.
Which table compression technique will not work on Exadata without licensing the Oracle Advanced Compression Option?
A. COMPRESS
B. COMPRESS BASIC
C. COMPRESS FOR OLTP
D. COMPRESS FOR QUERY
E. COMPRESS FOR ARCHIVE
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 reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.
A. Transformations can be applied directly on the file data using SQL or PL/SQL constructions.
B. External tables allow transparent parallelization inside the database.
C. Parallelizing loads with external tables enables more efficient space management.
D. External tables can take advantage of storage indexes to speed up data loads.
You are calculating the storage capacity that your customer will require on their ZFS Backup Appliance. Identify the set of factors that will affect this calculation.
A. database size, full/incremental cycle, RPO (Recovery Point Objective), and RTO (Recovery Time Objective)
B. database size, retention period, RPO (Recovery Point Objective), and compression
C. database size, full/incremental cycle, compression, and retention period
D. database size, compression, and backup window
E. full/incremental cycle, retention period, and ZFS Backup Appliance model
Which two statements are true about CellCLI?
A. Using a CellCLI command, you can change the SNMP subscribers or add multiple SNMP subscribers.
B. Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata storage cell.
C. With a simple CellCLI command, you can synchronize changes to all the storage cells in the Exadata realm.
D. Using a CellCLI command, you can see whether grid disks are being used by ASM or not.
E. You cannot use CellCLI to gather the serial numbers of physical disks.
Identify the relevant steps in the correct order for activating an Auto Service Request (ASR) configuration.
1.
Add SNMP traps manually or using OneCommand.
2.
Install ASR Manager.
3.
Activate a node on ASR Manager.
4.
Validate the configuration.
5.
Register ASR Manager with Oracle.
A. 2, 5, 1, 3, and 4
B. 2, 4, I, 3, and 5
C. 5, 2, 4, 1, and 3
D. 5, 4, 2, 1, and 3
Identify two tasks that the Database Resource Manager can perform, which the I/O Resource Manager cannot.
A. Manage I/O based on the application that is connected to the database.
B. Manage the number of parallel sessions for a query.
C. Manage I/O and CPU between databases on the same cluster or physical database host.
D. Terminate database sessions when certain limits have been reached. 100% Real QandAs | 100% Real Pass
E. Manage the throughput of an I/O-bound application based on the service name used for the connection.
What would be the best way to ensure that batch Jobs do not impact performance of online queries that use the same database?
A. Configure IORM to disable Flash Cache usage for batch workload.
B. Build a Database Resource Management Plan, giving priority to query workload.
C. Deploy Instance Caging to control batch jobs.
D. Configure and enable Parallel Query.
E. Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workload.
When using IORM, which statement accurately describes when redo log file writes take place?
A. Based on the priority of the user
B. Immediately
C. Based on the resource group of the user
D. Based on the intradatabase resource plan