When using a Sequential File stage as a source what are the two reject mode property options? (Choose two.)
A. Continue
B. Set
C. Convert
D. Save
E. Fail
正解:A,E
質問 2:
A job design consists of an input Sequential Files stage, a Sort stage, followed by a Transformer stage and an output Sequential File stage. In the input Sequential Files stage, the "Number of readers per node" property has been set to 3. The job is run on an SMP machine with a configuration file defined with 3 nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?
A. 8
B. 10
C. 6
D. 12
正解:A
質問 3:
Your job sequence must be restartable. It runs Job1, Job2, and Job3 serially. It has been compiled with "Add checkpoints so sequence is restartable". Job1 must execute every run even after a failure. Which two properties must be selected to ensure that Job1 is run each time, even after a failure? (Choose two.)
A. In the Job1 Activity stage set the Execution action to "Reset if required, then run".
B. Set the Job1 Activity stage to "Do not checkpoint run".
C. Set trigger on the Job1 Activity stage to "Unconditional".
D. In the Job1 Activity stage set the Execution action to "Run".
E. Use the Nested Condition Activity with a trigger leading to Job1; set the trigger expression type to "Unconditional".
正解:A,B
質問 4:
When optimizing a job, Balanced Optimization will NOT search the job for what pattern?
A. Links
B. Stages
C. Property Settings
D. Sequencers
正解:D
質問 5:
Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1. Before you create the package you will have to ensure the project is up to date with version 1. What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Choose two.)
A. Right-click the asset and click Update From Source Control Workspace.
B. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.
C. Right-click the asset and click Replace From Source Control Workspace.
D. Right-click the asset and click the Team Import command.
E. Right-click the asset and click the Deploy command.
正解:B,C
質問 6:
You are editing the configuration file. Which statement is true about file system efficiency?
A. Creating scratch disk spaces on an internal disk rather than on an NFS drive improves sort performance.
B. For the resource disk, it is best to use the partition where the engine is installed.
C. Using multiple scratch spaces in a logical node improves performance.
D. In a clustered environment where NAS is used for a common storage, you must specify the internal disk for scratch disk.
正解:A
質問 7:
What two project environment variables can be considered in your parallel jobs to support your optimization strategy of partitioning and sorting? (Choose two.)
A. $APT_RESTRICT_SORT_USAGE
B. $APT_NO_PART_INSERTION
C. $APT_PARTITION_FLUSH_COUNT
D. $APT_TSORT_STRESS_BLOCKSIZE
E. $APT_OPT_SORT_INSERTION
正解:B,D
質問 8:
Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of a new group of Product rows?
A. Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
B. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".
C. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
D. Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".
正解:C
質問 9:
Which two commands start a DataStage job named procRows in a project named DSProject. It also passes the value 200 to the numRows parameter. (Choose two.)
A. dsjob -run -mode normal -paramfile numRows=200 DSProject procRows
B. dsjob -run -mode validate -param numRows=200 DSProject procRows
C. dsjob -run -paramfile numRows=200 DSProject procRows
D. dsjob -run -queue HighPriority -param numRows=200 DSProject procRows
E. dsjob -run -mode normal -param numRows=200 DSProject procRows
正解:D,E
Fubuki -
Pass4Testさんからアプリバージョンを買いまして、わかりやすくまとめた本はなかった気がします。