1Z0-515 (Data Warehousing 11g Essentials) Document version: 19.10.11 1Z0-515 Exam Questions Important Note About 1Z0-515 PDF techeXams’ 1Z0-515 PDF is a comprehensive compilation of questions and answers that have been developed by our team of certified professionals. In order to prepare for the actual exam, all you need is to study the content of this exam questions. An average of approximately 10 to 15 hours should be spent to study these exam questions and you will surely pass your exam. It’s our guarantee. Copyright techeXams holds the copyright of this material. techeXams grants you a limited license to view and study this material, either for personal or commercial use. Unauthorized reproduction or distribution of this material, or any portion thereof, may result in severe civil and criminal penalties, and will be prosecuted to the maximum extent possible under law. Disclaimer Neither this guide nor any material in this guide is sponsored, endorsed or affiliated with any of the respective vendor. All trademarks are properties of their respective owners. 1 © Copyright www.techeXams.ws 2011 1Z0-515 Practice Exams, 1Z0-515 Audio Trainings, 1Z0-515 Study Guides 1Z0-515 Exam Questions Question: 1 A Full Rack Oracle Exadata Database Machine can contain 100 TB of disk space with high performance. How much user data should you conservatively estimate this configuration can hold? A. 100 TB B. 75 TB C. 50 TB D. 28 TB E. 20 TB Answer: A Question: 2 Identify the action that you CANNOT perform using Database Resource Manager. A. Define Consumer Groups. B. Create rules to map sessions to Consumer Groups. C. Define a Resource Plan. D. Allocate individual CPUs to Consumer Groups. Answer: B Question: 3 You will be implementing a data warehouse for one of your customers. In your design process, which index type is most likely to be used to improve the performance of some queries where the data is of low cardinality? A. Bitmap indexes B. B*tree indexes C. Reverse indexes D. Invisible indexes Answer: A 2 © Copyright www.techeXams.ws 2011 1Z0-515 Practice Exams, 1Z0-515 Audio Trainings, 1Z0-515 Study Guides 1Z0-515 Exam Questions Question: 4 Identify the statement about ASM that is NOT true. A. ASM is easier to manage than file systems. B. ASM delivers the performance of raw partitions. C. ASM is an extra cost option for Oracle databases. D. ASM delivers automatic striping and mirroring. Answer: B Question: 5 For data warehousing, identify the benefits that would NOT be provided by the use of RAC. A. Distribute workload across all the nodes. B. Distribute workload to some of the nodes. C. Provide parallel query servers. D. Provide high availability for all the operations. Answer: B Question: 6 Your customer is looking to implement ad-hoc analysis in a data warehouse. Which approach is least likely to be used assuming that the customer does not want the expense of managing view? A. Star schema B. Snowflake schema C. Third normal form schema D. OLAP Answer: A 3 © Copyright www.techeXams.ws 2011 1Z0-515 Practice Exams, 1Z0-515 Audio Trainings, 1Z0-515 Study Guides 1Z0-515 Exam Questions Question: 7 Which feature would enable higher availability during maintenance operations while also improving query response performance? A. Partitioning B. Materialized views C. Bitmap Indexing D. OLAP Answer: A Get Full Version of Exam 1Z0-515 PDF Q&A techeXams presents authentic, genuine and valid study material, which promise 100% success in very first attempt. To take optimal results for 1Z0-515 exam, you need to buy full version of 1Z0-515 question and answer. An average of approximately 10 to 15 hours should be spent to study these exam questions and you will surely pass your exam. So come join us and quench your thirst for knowledge. Get complete 1Z0-515 questions and answers by visiting URL “http://www.techexams.ws/exams/1Z0-515 .do” 4 © Copyright www.techeXams.ws 2011 1Z0-515 Practice Exams, 1Z0-515 Audio Trainings, 1Z0-515 Study Guides