Exam 000-418 study material Made available by Testkingprep.com
Free 000-418 Exam Preparation Questions Exam 000-418: InfoSphere DataStage v8.0
For Latest 000-418 Exam Questions and study guides- visit- http://www.testkingprep.com/000-418.html
Question:1 A customer must compare the value of a decimal field to that of an integer field to determine whether to drop a row of data. What would be the correct stage to use for this requirement? A. The Transformer stage B. The Switch stage C. The Filter stage D. The Compare stage Answer: A Question:2 Multiple "resource disk" entries for each node allows for which two events? (Choose two.) A. Buffers to be written/read in multiple disk locations. B. File Sets and Data Sets to be written/read in multiple locations. C. Prevents jobs from aborting if a single resource disk location fills. D. Additional processes to handle all I/O. Answer: B, C Question:3 Which two statements are correct when using the Oracle Enterprise stage? (Choose two.) A. Define variable $TNS_ADMIN to point to the tnsnames.ora file location. B. $APT_ORCHHOME/bin must appear before $ORACLE_HOME/bin in the $PATH. C. DataStage Designer requires connectivity to the Oracle database during job development. D. Add $ORACLE_HOME/bin to the $PATH and $ORACLE_HOME/lib to the $LIBPATH, $LD_LIBRARY_PATH, or $SHLIB_PATH. Answer: B, D Question:4 When defining a message handler, which three actions can be specified for a message? (Choose three.) A. Demote to "Warning". B. Suppress from log. C. Demote to "Informational". D. Promote to "Warning". E. Promote to "Fatal". Answer: B, C, D Question:5 What is the lowest cost partitioning method for parallel stage to sequential stage? A. SortMerge B. Round Robin C. Entire D. Ordered Answer: B Question:6 Click the Exhibit button. You are asked to populate a star schema. You decide to use the Slowly Changing Dimensions (SCD) stage to load a dimension table named PRODDIM. Based on the dump score fragment, how many Data Sets are in this job?
For Latest 000-418 Exam Questions and study guides- visit- http://www.testkingprep.com/000-418.html
A. 8 B. 1 C. 9 D. 0
For Latest 000-418 Exam Questions and study guides- visit- http://www.testkingprep.com/000-418.html
Answer: C Question:7 You are tasked with determining the cause of a job that fails to scale beyond 3 nodes. Based on the job design, you suspect that the problem is related to highly un-even data distribution across partitions. Which two product features would help you confirm this hypothesis? (Choose two.) A. Enable Job Trace in the Designer Client B. $APT_PM_SHOW_PARTITION_COUNTS C. $APT_RECORD_COUNTS D. Job Monitor Tool in the Director Client Answer: C, D Question:8 Which two statements are correct about XML stages and their usage? (Choose two.) A. XML Output stage can invoke an XSLT style sheet for XML to tabular transformations. B. XML Output stage converts tabular data to XML hierarchical structure. C. XML Input stage converts XML data to tabular format. D. XML Transformer stage converts XSLT data to tabular format. Answer: B, C Question:9 Which two statements describe both File Sets and Data Sets? (Choose two.) A. File and Data Sets preserve partitioning. B. File and Data Sets are stored in internal format. C. File and Data Sets contain header file and data files. D. File and Data Sets are readable by external applications. Answer: A, C Question:10 Which two environment variables should be set to "True" to allow you to see operator process statistics at run-time in the job log? (Choose two.) A. $APT_PM_PLAYER_STATISTICS B. $APT_PM_PLAYER_MEMORY C. $APT_PM_PLAYER_TIMING D. $OSH_DUMP Answer: B, C
For Latest 000-418 Exam Questions and study guides- visit- http://www.testkingprep.com/000-418.html
For complete Exam 000-418 Training kits and Self-Paced Study Material Visit: http://www.testkingprep.com/000-418.html
http://www.testkingprep.com/
For Latest 000-418 Exam Questions and study guides- visit- http://www.testkingprep.com/000-418.html