Latest IBM C2090-424 Dumps PDF Questions and Answers

100% Success and Guarantee to Pass

2017 Latest IBM Latest  IBM C2090-424 Dumps Exam Practice Ques Practice  Questio tions ns And And An Answe swers rs Online Free Download http://www.lead4pass.com/C2090-424 http://www .lead4pass.com/C2090-424.html .html

Vendor: IBM Exam Code:  C2090-424 Exam Name: IBM IBM Cert Certif ifie ied d Solu Soluti tion on Developer  Version:   Demo Question No : 1 Using a DB2 for z/OS source database, a 200 million row source table with 30 million distinct values must be aggregated to calculate the average value of two column attributes. What would provide optimal performance while satisfying the

100% Success and Guarantee to Pass business requirements? A. Select all source rows using a DB2 API stage.Aggregate using a Sort Aggregator. B. Using custom SQL with AVG functions and a DISTINCT clause, select all source rows using a DB2 Enterprise stage. C. Using custom SQL with an ORDER BY clause based on key columns, select all source rows using the DB2 API stage.Aggregate using a Hash Aggregator. D. Select all source rows using a DB2 Enterprise stage, use a parallel Sort stage with the specified sort keys,calculate the average values using a parallel Transformer with stage variables and output link constraints. Answer: A

Question No : 2 Which three methods can be used to import metadata from a Web Services Description Language(WSDL) document? (Choose three.) A. XML Table Definitions B. Web Services WSDL Definitions C. Orchestrate Schema Definitions D. Web Service Function Definitions E. Job Stage Column tab properties entered using "Load" feature Answer: A,B,D

Question No : 3 Which two statements are correct when referring to an Aggregator Stage? (Choose two.) A. Use Sort method for a limited number of distinct key values. B. Use Hash method for a limited number of distinct key values. C. Use Sort method with a large number of distinct key-column values.

100% Success and Guarantee to Pass D. Use Hash method with a large number of distinct key-column values. Answer: B,C

Question No : 4 Which Information Server client application must be used to manage project-level roles for DataStage? A. Directorclient B. Designer client C. WebSphere Information Services Director D. Web console for IBM Information Server Answer: D

Question No : 5 You have a job that reads in Sequential File followed by a Transformer stage. When you run this job, which partitioning method will be used by default? A. Hash B. Same C. Random D. Round Robin Answer: D

Question No : 6 You are setting up project defaults. Which three items can be set in DataStage Administrator? (Choose three.) A. suite roles

100% Success and Guarantee to Pass B. default for compile options C. defaults for environment variables D. default for Runtime Column Propagation E. default prompting options, such asAutosave job before compile Answer: B,C,D

Question No : 7 Which statement is true about buffering? A. The buffer operator uses both memory and disk storage. B. The framework uses /tmp by default for buffering on Unix systems. C. In a clustered environment, using a disk space on an NFS mount for buffering improves performance. D. The "buffer" scratch disk pool needs to be defined to allow the framework to perform data buffering. Answer: A

Question No : 8 Which two statements are true about the use of named node pools? (Choose two.) A. Named node pools can allow separation of buffering from sorting disks. B. Clustered environments must have named node pools for data processing. C. Using appropriately named node pools forcesDataStage to use named pipes between stages. D. Named node pools constraints will limit stages to be executed only on the nodes defined in the node pools. Answer: A,D

100% Success and Guarantee to Pass Question No : 9 Which two properties can be set to read a fixed width sequential file in parallel? (Choose two.) A. Set Read Method to "File Pattern". B. Set the Execution mode to "Parallel". C. Set the "Read from Multiple Nodes" optional property to a value greater than 1. D. Set the "Number of ReadersPer Node" optional property to a value greater than 1. Answer: C,D

Question No : 10 Which statement is true about the Web Services Pack? A. Web Services Pack generates a WSDL. B. Web Services Pack makes a service request using SOAP. C. Web Services Pack communicates by Enterprise Java Beans. D. Web Services Pack is configured from within the Information Services Director application. Answer: B

Question No : 11 A customer wants to select the entire order details for the largest transaction for each of 2 million customers from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement? A. Partition on customer key, sort on customer key and transaction amount, remove duplicates on customer key. key. B. Use a Sort Aggregator stage with calculated column based on the maximum

100% Success and Guarantee to Pass value of transaction amount column. C. Partition and sort the input to a Filter stage by customer number. Filter with the clause "MAX(transaction_amount)". D. Partition and sort the input to aRemoveDuplicates stage using the customer key and transaction amount columns. Remove duplicates on customer key. Answer: A

Question No : 12 You found there were common functional requirements in the data mapping specification. The required functions are same but the record formats are different. Which action will allow you to effectively implement common logic? A. Create parallel routines. B. Create separate jobs and choose appropriate job within a job sequence. C. Create parallel shared containers and define columns combining all data formats. D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary columns needed for the logic. Answer: D

Question No : 13 You have run ten instances of the same job the previous evening. You want to examine the job logs for all instances but can only find five of them. How can you avoid this in the future for this job? A. Change the Auto-purge settings in Administrator. B. Change the Auto-purge settings for the job in Director. C. Set the $APT_AUTOPURGE_LOG environment variable to False. D. Set the $APT_AUTOLOG_PURGE environment variable to False. Answer: B

100% Success and Guarantee to Pass Question No : 14 Which three actions can improve sort performance in a DataStage job? (Choose three.) A. Specify only the key columns which are necessary. B. Minimize the number of sorts used within a job flow. C. Adjust the "Restrict Memory Usage" option in the Sort stage. D. Run the job sequentially so that only one sort process is invoked. E. Use the stable-sort option to avoid the random ordering of non-key data. Answer: A,B,C

Question No : 15 Which two features of Data Sets make them suitable for job restart points? (Choose two.) A. They are persistent. B. They are indexed to improve access. C. They are compressed to minimize storage space. D. They use the same data types as the parallel framework. Answer: A,D

http://www.lead4pass.com/C2090-424 http://www.lead4pass.com/C2090-424.html .html