Oracle Exadata 11g Essentials Exam Study Guide

1 Oracle Exadata 11g EssentialsExam Study GuideLiviu AdomnicaGlobal Enablement Project ManagerWWA&C Partner EnablementObjective & AudienceObjectiveHelp you prepare to take the Oracle Exadata 11g Essentials (1Z0-536) exam by providing pointers to resources that you can use in your AudienceTechnical ConsultantsStrong foundation and expertise in implementing the Oracle Exadata database MachineParticipated in Exadata implementationsCandidates must also have knowledge of Oracle database , Data Warehousing and Real Application training and field experience are recommendedFor Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation Proprietary and Confidential Exam Topics & ObjectivesExam TopicsThe Oracle Exadata 11g Essentials exam consists of six topics:1.

2 Oracle database 11g software 2. Oracle Exadata software 3. Oracle database Machine hardware 4. Configuration 5. Administration 6. Best practicesExam ObjectivesThe exam objectives are defined by learner or practitioner level of knowledge:Learner-level: questions require the candidate to recall information to determine the correct : Define the term : questions require the candidate to derive the correct answer from the application of their knowledge, which can only be attained by extensive experience with the : The client requests xyz functionality, would you recommend a, b or c?For Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation Proprietary and Confidential Training OptionsFor each exam topic there have been identified alternative training options that areavailable at Oracle .

3 The training options are divided into three categories:Boot CampsThe Boot Camps are designed as a "jump start" training to enhance your skills by providing role-based training on industry-leading Oracle solutions and services. The boot camps are built as concise, intensive, and real-time training to give partners a competitive advantage as they prepare to build powerful solutions for their own customer base. Partners can choose to attend these boot camps in class or in a live virtual class format to maximize the effectiveness and the time allocated to Training (delivered by Oracle University)Partners can take any publicly-scheduled Oracle University courses at steep discounts. Benefit from hands on experience to gain real working skill and work toward Oracle TrainingOracle Partners are entitled free access to the Oracle Knowledge Center (OUKC), a vast library of recorded product courses.

4 New courses are regularly added to the library, providing partners with the latest information and training to master new products or to increase proficiency on the new Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation Proprietary and Confidential Topic 1: Oracle database 11g softwareObjectivesLevelUse common database featuresPractitionerLeverage performance featuresPractitionerMonitor with Enterprise ManagerLearnerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp OverviewSample QuestionsWhich feature can reduce the amount of I/O processed and is unique to the Exadata Storage Server?A. database Resource ManagerB. Storage IndexesC. PartitioningD. ParallelismFor Oracle employees and authorized partners only.

5 Do not distribute to third parties. 2011 Oracle Corporation Proprietary and Confidential Topic 2: Oracle Exadata softwareObjectivesLevelDescribe specific uses of offloading processingPractitionerImplement I/O resource managementPractitionerExplain the architecture of I/O Resource ManagerPractitionerDescribe the software architecture used by Oracle Exadata software LearnerUse Smart Flash CachePractitionerCompress data in a variety of waysPractitionerUse ASMP ractitionerUnderstand how storage indexes operateLearnerUse intelligent data placement for optimal performancePractitionerConfigure data structures to insure cachingLearnerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp -Smart featuresOracle Exadata 11g Technical Boot Camp -CompressionOracle Exadata 11g Technical Boot Camp -Storage indexesOracle Exadata 11g

6 Technical Boot Camp -Resource ManagerOracle Exadata 11g Technical Boot Camp -I/O Resource ManagerOracle Exadata 11g Technical Boot Camp -Flash CacheSample QuestionsWhich three are valid caching hints for a SQL statement?A. CACHEB. NOCACHEC. RECACHED. FLUSHE. EVICTWhat should you do in order to use Hybrid Column Compression without having to update recent data frequently?A. Batch write operations to increase the efficiency of Partition table and use HCC on older, less updated Use HCC in archive Avoid HCCFor Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation Proprietary and Confidential Topic 3: Oracle database Machine hardware ObjectivesLevelAdminister disks on the Oracle Exadata database MachinePractitionerUse network configuration optionsLearnerManage storage on different disk configurationsPractitionerUnderstand memory capabilities of the different modelsLearnerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampSample QuestionsHow many IP addresses do you need to assign for each Exadata Storage Cell?

7 A. 0B. 1C. 3D. 5E. It depends on the number of Exadata Storage Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation Proprietary and Confidential Topic 4: Configuration ObjectivesLevelConfigure Oracle Exadata database MachinesPractitionerManage users and permissionsLearnerRecommend the appropriate size Oracle database MachinePractitionerTest Oracle database Machine after installation to verify successPractitionerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp -CellCLI, DCLI and ADRCIO racle Exadata 11g Technical Boot Camp -Sizing for the database MachineSample QuestionsWhich Exadata Storage Server users can edit configuration files?A. sysB. guestC. masterD. rootFor Oracle employees and authorized partners only.

8 Do not distribute to third parties. 2011 Oracle Corporation Proprietary and Confidential Topic 5: Administration ObjectivesLevelLoad and backup dataPractitionerImplement failure and recovery proceduresPractitionerInstall software onto Oracle Exadata database MachinePractitionerMonitor operation of Oracle Exadata database MachinePractitionerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp - Exadata and availabilityOracle Exadata 11g Technical Boot Camp -Backup and recoverySample QuestionsSomeone has pulled a Flash Card from a storage cell. What should you do to obtain HA?A. You must alter ASM to alert You must recreate any grid disks that use the The cell must be Nothing, as it will continue working just Oracle employees and authorized partners only.

9 Do not distribute to third parties. 2011 Oracle Corporation Proprietary and Confidential Topic 6: Best practices ObjectivesLevelImplement best practices for performancePractitionerImplement best practices for consolidationPractitionerImplement best practices for storagePractitionerImplement best practices for migrationPractitionerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp - database Machine PerformanceOracle Exadata 11g Technical Boot Camp -Best practices for data loadingOracle Exadata 11g Technical Boot Camp -Consolidation of mixed workloadsOracle Exadata 11g Technical Boot Camp -Migrating to the database MachineOracle Exadata 11g Technical Boot Camp -Why you don t need an Exadata database MachineSample QuestionsWhen designing a storage strategy for use on the Exadata Storage Server, you A.

10 Have one grid disk on a cell Have two grid disks on a cell Have the failure group for a grid disk on a different cell Have the failure group for a grid disk on the same cell Use an inner grid disk for Use an outer grid disk for consolidating multiple databases onto a single Oracle Exadata database Machine, which approach should you take to help the machine support a mixed workload?A. Make sure that all high priority applications are Make sure that all high priority applications are Make sure that all high priority applications are either all latency-sensitive or all Make sure that high priority applications are balanced between latency-sensitive and Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation Proprietary and Confidential Exam RegistrationHow to register for the exam?