To better understand the data flowing through a job, it is desirable to have structural information about the datasets captured in the job log. Which environment variable can provide this information?
A. $APT_NO_PART_INSERTION
B. $APT_PM_PLAYER_MEMORY
C. $OSH_STDOUT_MSG
D. $OSH_PRINT_SCHEMAS
正解:D
質問 2:
A client has multiple servers connected with a high bandwidth switch and has installed DataStage on one of them. There are five files (with the same record layout) that must be retrieved from three other servers using FTP. Which approach will retrieve and process all five files in the minimal amount of time?
A. In a single job, use five separate FTP Enterprise stages with output links to a single Sort Funnel stage. Next, process the records without landing to disk.
B. In a single job, use three separate FTP Enterprise stages (one for each machine) with output links to a single Sort Funnel stage. Next, process the records without landing to disk.
C. Use a single FTP Enterprise stage and specify five URI properties (one for each file). Next, process the records without landing to disk.
D. Create a sequence containing five separate DataStage jobs which each retrieve a single file and append it to a common Data Set. Next, process the resulting Data Set in an sixth DataStage job.
正解:C
質問 3:
There is a requirement to transfer a large file using an FTP Enterprise stage. How can you minimize processing time when a transfer failure occurs?
A. Use a sequencer to check transfer status and restart the job from the beginning on failure.
B. Manually split the file into multiple files and specify restartable mode on a transfer.
C. Specify restartable mode on a transfer of the single file.
D. Create multiple readers to transfer file data and specify restartable mode on Input link tab.
正解:B
質問 4:
You are given a job requirement that requires calculations based on the latest currency exchange rate. You decide to invoke a Web service to obtain the latest exchange rate.
What are two ways that you can perform a Web service invocation in a DataStage job to obtain the latest exchange rate? (Select two)
A. Use Web Services Client stage as a lookup.
B. Use Web Services Transformer stage.
C. Use WISD Input stage.
D. Call a Web Service using a DSRoutine inside the Parallel Transformer stage.
正解:A,B
質問 5:
What is the correct restructure stage to extract data from four input columns (three of which carry vectors) and output them into two columns with one vectors in a subrecord and the non-vector carrying column being passed through the stage?
A. Make Subrecord Stage
B. Column Export Stage
C. Column Import Stage
D. Split Subrecord Stage
正解:C
質問 6:
Which three methods can be used to import metadata from a Web Services Description Language (WSDL) document? (Choose three.)
A. Job Stage Column tab properties entered using "Load" feature
B. Orchestrate Schema Definitions
C. Web Services WSDL Definitions
D. Web Service Function Definitions
E. XML Table Definitions
正解:C,D,E
質問 7:
Which two property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose two.)
A. Specify properties for the input link.
B. Define columns for the output link.
C. Specify the remote server property.
D. Define the connection properties to an ODBC data source.
正解:A,D
質問 8:
Which three of the following are valid options for the dsjob command? (Choose three.)
A. Purging log files
B. Stopping a job
C. Compiling a job
D. Accessing log files
E. Setting an alias for a job
正解:B,D,E