Hide Notes 

Slide 1: http://www.pass-sure.com 000-914 IBM System administrator for red brick wanehouse v6 IBM 000-914 Certification Exam is of core importance both in your Professional life and IBM Certification Path. With IBM Certification you can get a good job easily in the market and get on your path for success. Professionals who passed IBM 000-914 Certification Exam are an absolute favorite in the industry. If you pass IBM 000-914 Certification Exam then career opportunities are open for you. Here's what you can expect from the Pass-Sure IBM 000-914 course: * Up-to-Date IBM 000-914 questions designed to familiarize you with the real exam. * 100% correct IBM 000-914 answers you simply can't find in other 000-914 courses. * All of our tests are easy to download. Your file will be saved as a 000-914 PDF. * IBM 000-914 brain dump free content featuring the real 000-914 test questions. Thousands of IT Professionals before you have already passed their 000-914 certification exams using the IBM 000-914 Practice Exam from Pass-Sure.com. Once you start using our 000-914 exam questions you simply can't stop! You are guaranteed to pass your IBM 000-914 test with ease and in your first attempt. Our 000-914 Questions & Answers provide you an easy solution to your IBM 000-914 Exam Preparation. Our 000-914 Q&As contains the most updated IBM 000-914 real tests. You can use our 000-914 Q&As on any PC with most versions of Acrobat Reader and prepare the exam easily. Visit : http://www.pass-sure.com/exams.asp?examcode=000-914
Slide 2: Question: 1 Red Brick Decision Server is implemented on Windows NT by a ____________ that runs as a ____________ . A - single multithreaded process, Windows NT service B - Windows NT service, single multithreaded process C - NTFS file system, Windows NT service D - none of the above Answer: A Question: 2 The ______________ collects statistics for the dynamic statistic tables (DSTs) and performs the actions specified by ALTER SYSTEM commands. A - listener thread (rbwlsnr) B - process checker thread (rbwpchk) C - administration Daemon Process (rbwadmd) D - Red Brick API thread (rbwapid) Answer: C Question: 3 Target indexes and multi-column B-Tree on the foreign key columns of a tact table support: A - Natural join B - TARGETJoin C - Star index D - Clustered index Answer: B Question: 4 Which of the following definitions describe the STAR index? A - A sorted list of concatenated row IDs from the dimension tables named in the index key B - A bitmap index based on fact table rows C - An index built over multiple fact table columns D - A multi-table join index based on fact table foreign key values E - a and b F - a, b, c, and d G - a, c, and d H - c and d Answer: G Question: 5 The fill factor should always be set to 100% in cases of: A - Data spaces B - Star indexes C - TMU_REORG TEMPSPACE D - Small domain target indexes Answer: D
Slide 3: Question: 6 In cases where data is known to be skewed, the recommended target index domain should be: A - small B - normal C - large D - hybrid Answer: D Question: 7 The size of the memory work area for building indexes is set by which parameter? A - INDEX TEMPSPACE B - INDEX TEMPSPACE THRESHOLD C - INDEX MAXSPILLSPACE D - INDEX DIRECTORY MAXSIZE Answer: B Question: 8 The ‘default’ Red Brick Decision Server index is a: A - Star Index B - Target Index C - B-Tree Index D - Deferred Index Answer: C Question: 9 An ideal DSS STAR schema is said to be ____________ whereas a typical DLTP schema is said to be highly____________. A - Normalized/denormalized B - Factual/Dimensional C - Denormalized/normalized D - Current/historical Answer: C Question: 10 Which of the following describes a conformed dimension: A - Dimensions that have built-in hierarchies B - A dimension table that can be shared by one or more fact tables C - A set of attributes that change overtime D - All of the above Answer: B Question: 11 Fact tables in a data warehouse generally contain:
Slide 4: A - aggregate data B - descriptive text C - detail data D - both a and b E - both a and c Answer: E Question: 12 For a dimension table to participate in a STAR index, the table must be created with the ____ specification. A - CONSTRAINT B - MAX ROWS PER SEGMENT C - DATA IN D - DEFAULT Answer: B Question: 13 The purpose of the fill factor is: A - To tell a node when to split B - To reserve extra space in each node C - To specify when a node is 100% full D - None of the above Answer: B Question: 14 Views are useful for a wide variety of purposes, including: A - Decreasing security B - Simplifying query constraints C - Making administrative changes, such as database schema design changes visible to the users D - None of the above Answer: B Question: 15 Any table that is referenced by another table must have a: A - TARGET index B - STARindex C - Foreign key D - Primarykey Answer: D Question: 16 Decision-Support systems have (among others) the following characteristics A - Relational integrity B - Join paths based on business relations
Slide 5: http://www.pass-sure.com Pass-Sure Lifetime Membership Features; Pass-Sure Lifetime Membership Package includes over 2000 Exams in One Price. All exams Questions and Answers are included in package. All Audio Guides are included free in package. All Study Guides are included free in package. Lifetime login access. Unlimited download, no account expiry, no renewal, no hidden charges. Free updates for Lifetime. Free Download Access to All new exams added in future. Accurate answers with explanations (If applicable). Verified answers researched by industry experts. Study Material updated on regular basis. Questions, Answers and Study Guides are downloadable in PDF format. Audio Exams are downloadable in MP3 format. No authorization code required to open exam. Portable anywhere. 100% success Guarantee. Fast, helpful support 24x7. View list of All exams (Q&A) downloads http://www.pass-sure.com/allexams.asp View list of All Study Guides (SG) downloads http://www.pass-sure.com/study-guides.asp View list of All Audio Exams (AE) downloads http://www.pass-sure.com/audio-exams.asp Download All Exams Samples http://www.pass-sure.com/samples.asp To purchase $99 Lifetime Full Access Membership click here http://www.pass-sure.com/purchase.asp 3COM ADOBE APC Apple BEA BICSI CheckPoint Cisco Citrix CIW CompTIA ComputerAssociates CWNP DELL ECCouncil EMC Enterasys ExamExpress Exin ExtremeNetworks Filemaker Fortinet Foundry Fujitsu GuidanceSoftware HDI Hitachi HP Huawei Hyperion IBM IISFA Intel ISACA ISC2 ISEB ISM Juniper Legato Lotus LPI McAfee McData Microsoft Mile2 NetworkAppliance Network-General Nokia Nortel Novell OMG Oracle PMI Polycom RedHat Sair SASInstitute SCP See-Beyond SNIA Sun Sybase Symantec TeraData TIA Tibco TruSecure Veritas Vmware