Refined of C2090-303 exam price materials and braindumps for IBM certification for IT engineers, Real Success Guaranteed with Updated C2090-303 pdf dumps vce Materials. 100% PASS IBM InfoSphere DataStage v9.1 exam Today!
2021 May C2090-303 Study Guide Questions:
Q21. - (Topic 2)
You are using the Complex Flat File stage as a source in your job. What are two types of data specifically supported by the Complex Flat File stage for your job? (Choose two.)
A. XML files.
B. Mainframe data sets with VSAM files.
C. Mainframe data files with DB2 tables.
D. Data from files that contain Hadoop record types.
E. Data from flat files that contain multiple record types.
Answer: B,E
Q22. - (Topic 2)
Which job log message heading identifies the score in the job log?
A. OSH script ...
B. main_program: orchgeneral: loaded
C. main_program: Broadcasting score.
D. main_program: This step has 3 datasets:...
Answer: D
Q23. - (Topic 2)
What role must a user have to delete shared metadata assets from the repository?
A. DataStage Administrator
B. Business Glossary Administrator
C. Common Metadata Administrator
D. Information Analyzer Administrator
Answer: C
Regenerate C2090-303 test preparation:
Q24. - (Topic 2)
What two repositories does the Source Code Control Integration for DataStage and QualityStage serve? (Choose two.)
A. WebSphere Repository
B. Source Code Repository
C. Universe Project Repository
D. InformationAnalyzer Repository
E. Information Server metadata Repository
Answer: B,E
Q25. - (Topic 1)
In addition to the table and schema names, whattwo element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)
A. Database
B. Host system
C. Project name
D. Database instance
E. DataStage server system name
Answer: A,B
Q26. - (Topic 1)
Which two actions are available when editing a message handler? (Choose two.)
A. Abort job
B. Demote to warning
C. Suppress from job log
D. Demote to informational
E. Suppressfrom the project
Answer: C,D
100% Guarantee C2090-303 secret:
Q27. - (Topic 2)
The data going into the target Sequential File stage is sorted in each partition by the Date field. You want the data in the sequential file to be sorted by Date. Which collection algorithm should you choose in the Sequential File stage?
A. Auto
B. Ordered
C. Sort Merge
D. Round Robin
Answer: C
Q28. - (Topic 2)
In a Transformer expression for a stage variable, there is a nullable input column. Assume the legacy NULL processing option isturned off. What happens when a row is processed that contains NULL in that input column?
A. The job aborts.
B. The row is rejected.
C. NULL is written to the stage variable.
D. The value written to the stage variable is undetermined.
Answer: C
Q29. - (Topic 2)
What are the two Transfer Protocol Transfer Mode property options for the FTP Enterprise stage? (Choose two.)
A. FTP
B. EFTP
C. TFTP
D. SFTP
E. RFTP
Answer: A,D
Q30. - (Topic 1)
In a Transformer, which two mappings can be handled by default type conversions. (Choose two.)
A. Integer input columnmapped to raw output column.
B. Date input column mapped to a string output column.
C. String input column mapped to a date output column.
D. String input column mapped to integer output column.
E. Integer input column mapped to string output column.
Answer: D,E