A customer has three databases named CC. FIN, and DW. The CC database is for their CallCenter. Even a slight decrease in the response time of the database would mean more people "on hold" in their data center. The orders received through the CallCenter are stored in the Finance (FIN) database. Both databases, CC and FIN, serve as sources for the Data Warehouse (DW) database. All databases use the same Automatic Storage Management (ASM) diskgroup and therefore, the same physical disks on Exadata storage. The customer wants to dynamically control the resources that are available for the CallCenter database because this has direct impact on their operations?
Which option should be implemented?
ADBRMon the CC database
BDBRM on all the databases
CIORM, because DBRM cannot be changed for an existing session
DIORM and DBRM
Which is the best location to point your customer to, for finding the latest Exadata patches?
Aowner's guide
BPatch database in MyOracle Support
CMyOracle Support note 888828.1
DMyOracle Supportfor database patches, ULN for OS patches, and Sun Support for Server and InfiniBand patches.
Exadata Database Machine offers an Intelligent Platform Management Interface for the various components in the Exadata product. Which option is true?
AIPMI can be used to remotely start and stop servers.
BIPMI can be used to remotely log in to the operating system.
CIPMI commands can be executed by using SNMP traps.
DIPMI settings can be secured by backing up the Oracle Linux installation on the storage system.
Which two statements are true about enabling write-back flash cache?
AWhen 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.
BBefore using write-back flash cache, you need to verify the minimum required versions.
CBefore write back-flash cache is enabled, you need to drop the Flash Cache first.
DThe setting flashCacheMode should be set to writeback by updating cellinit.ora and restarting cellsrv.
EWhen enabling write-back flash cache in a rolling manner, dcli should be used to inactivate the grid disks on all cells first.
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
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?
AAl = 36%, B2=18%, and C3=9%
BAl = 33%, B2=33%, and C3=33%
CAI = 10%, B2=5%, and C3=20%
DAl = 8%, B2=12%, and C3=5%
EAl = 5%, B2=10%, andC3=85%
Consider this CellCLI command:
CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;
Which two statements describe what happens when you execute this command?
AIt creates one 423 GB grid disk on the first available cell hard disk.
BIt creates one 423 GB grid disk on each available cell hard disk.
CIt creates grid disks on the outermost 423 GB that is available on each hard disk.
DIt creates grid disks on the innermost 423 GB that is available on each hard disk.
EIt creates an Exadata Smart Flash Cache on all flash drives.
You get a Host Unreachable error when you attempt to connect to a server through a network terminal command line. What are two other ways in which you can connect?
AUse the ILOM Web GUI.
BUse the dcli command at the root prompt on a database node.
CAttach a terminal device tothe back panel of the server with a serial cable.
DConnect by using SQL *Plus.
ELog in as root on the database node using the Net1 IP address.
Identify three best practices for applying asmdeactivationoutcome es on Exadata Database Servers and Exadata Storage Servers?
ABacking up database servers and storage cells is not recommended before performing plannedmaintenance.
BDatabase server updates can be rolled back using the "yum downgrade"procedure.
CBundle patches do not require testing before being installed on a production system.
DIt is recommended that Exadata systems with Data Guard configured use the"Standby First" patching approach.
EPatching should never be interrupted due to a connection drop. It is therefore recommended that you use VNC or the screen utility.
FBefore patching cells in a rolling manner, you must check asmdeactivationoutcome amModestatus and make sure that cells on all disks are online and that
The mpstat output from OS Watcher shows a database node as being 90% idle on an average. What would you do to get a full picture of CPU utilization on the entire Exadata RAC cluster?
AAverage the mpstat id1 output from all the nodes.
BAsk application users if they have noticed a slowdown in screen response.
CLook for an increase in batch job servicing times.
DA & B above
Identify three Exadata Storage Server software processes and their purpose?
ACELLSRV: The Cell Server is responsible for servicing disk I/O and predicate processing offload.
BCELLSRV: The Cell Server is responsible for balancing workload to other storage servers.
CMS: The Management Server is responsible for storage cell management and configuration.
DMS: The Management Server is responsible for starting a local Enterprise Manager agent.
ERS: The Restart Server is responsible for Automatic Storage Management (ASM) instance restart.
FRS: The Restart Server is responsible for CELLSRV and MS monitoring and restart.
Which two attributes describe key benefits of the InfiniBand network?
AAll Exadata database servers have a direct path link to each Exadata Storage Server.
BCell-to-cell communication uses Reliable Datagram Sockets (RDS) over InfiniBand to achieve low latency.
CExpanding from two Full racks to four only requires adding an external InfiniBand switch to be at the top of the fat-tree topology.
DEach InfiniBand link provides 10 Gigabits of bandwidth.
EOracle's interconnect protocol uses direct memory access (DMA) to eliminate buffer copies and reduce CPU use.
Which two statements are true about troubleshooting failed patching activities?
ADependency issues found during yum updates require rolling back to a previous release before retrying.
BBundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.
CFailed OS patches on database servers can be rolled back.
DFailed storage cell patches are rolled back to the previous release automatically.
EDatabase server OS updates can be rolled back using opatch auto -rollback.
FDependency issues found during yum updates should be ignored using the force option.
Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?
AINSERT
Binsert with an append hint
CUPDATE
DCREATE TABLE AS SELECT
Your customer wants to increase the size of the DATA diskgroup on the Exadata systems. The customer is currently using 600 GB disks. Which two are the best options that you would recommend?
Aadding a High Capacity Storage expansion rack
Bexpanding the Exadata rack from a Half Rack to a Full Rack
Cmoving underutilized grid disks from the RECO diskgroup to DATA
Dadding a ZFS storage appliance
Eadding a High Performance Storage expansion rack
What are two choices that a customer must make that impact diskgroup creation?
AWhat is the level of redundancy required?
BWhat OS will be run?
CWhere will disk backups be written?
DHow many databases will run on the cluster?
When would be the best time to run an Exadata health check (exachk)?
Abefore patching, before upgrades, before backups, and on a regular basis
Bafter patching, after upgrades, and after backups
Conly when advised by Oracle Support
Dbefore and after patching, when advised by Oracle Support, andona regular basis
Eonly after a hardware failure
Fmonthly and after a hardware failure
Which two statements describe correct network configuration for Exadata Database Machine?
AThe InfiniBand network subnet manager runs on all database servers to achieve High Availability.
BOracle Clusterware communication is configured to use the management network.
CThe InfiniBand network interfaces on Linux servers are configured using active-passive bonding.
DDatabase connections to the SCAN listener route through the Ethernet switch in the Exadata rack.
EDatabase servers are deployed with three logical network interfaces configured: management, client access, and private.
How would you execute CellCLI commands and scripts?
Ausing SQL*Plus on database nodes
Bby CellCLI commands executed on the database nodes
Cusing third party tools after installing the CellCLI RPM plug-in
Ddirectly executing the commands and scripts on the Exadata storage cell
Eremotely by connecting to Port 1521 using SSL
Which two statements are true about migrating your database to Exadata?
ABecause Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.
BUsing Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.
CASM and database best practice configuration supplied during Exadata deployment should be retained during and after migration,
DLogical migration methods allow more flexibility than physical methods to change the database structure for best performance.
EAll indexes should be dropped when migrating to Exadata.
Which statement is true about Exadata Storage Servers?
AThe Exadata Storage Server automatically deletes old diagnostic and metric files.
BExadata requires a running database instance on all storage servers and database servers.
CRedundancy for user data stored in a database that is running on Exadata is achieved with RAID5.
DCommunication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.
EExadata uses network affinity to determine which storage server data is written.
Your customer is hesitant to install the Oracle Configuration Manager in their environment. Give them three ways in which it will benefit their Exadata Database
Machine support experience and potentially resolve some of the issues they are having with the length of time it is taking Oracle to process their Exadata Service
Requests (SRs).
AHost information can be gathered and sent to Oracle for license compliance.
BPotential issues can be addressed before they impact operations.
CPriority handling can be extended for SRs, with attached configuration.
DExadata patching cannot be done successfully without the Oracle Configuration Manager.
ERoot cause analysis can be accelerated.
Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?
Adatabase views
BInfiniBand networking
CFlash Cache
Dhigh performance SAS2 disk drives
Ecell offloading
In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?
AEnable Smart Flash Log.
BExecute alter table … cell_flash_cache=keep on heavily scanned tables.
CEnable Write Back Flash Cache.
DCreate an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.
Identify the three values to which the cell_flash_cache attribute can be set.
