A 100MB input dataset has even distribution across 400 unique key values.
When run with a 4-node configuration file, which two changes could improve sort performance in this scenario? (Select two)
A. Alter the Sort stage properties to perform a stable sort.
B. Convert all numeric fields to varchars.
C. Set $APT_TSORT_STRESS_BLOCKSIZE to 50M
D. Specify Round Robin partitioning on the input link to the Sort stage.
E. Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.
正解:C,E
質問 2:
Which three of the following are valid schema formats? (Choose three.)
A. Decimal Columns
B. Integer Columns
C. Aggregator Columns
D. Total Columns
E. Raw Columns
正解:A,B,E
質問 3:
What two data sources support direct lookups? (Select two)
A. Oracle
B. Teradata
C. SqIServer
D. DB2
E. ODBC
正解:A,D
質問 4:
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? (Select two)
A. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.
B. Right-click the asset and click Replace From Source Control Workspace.
C. Right-click the asset and click the Team Import command.
D. Right-click the asset and click the Deploy command.
正解:A,C
質問 5:
Which three statements are true about stage variables in a Transformer Stage? (Choose three.)
A. Stage variables can be set to NULL.
B. The expression executed for a stage variable can refer to a stage variable which is executed later.
C. A stage variable in one Transformer can refer to a stage variable in another Transformer, as long as the second Transformer was processed earlier in the job flow.
D. Varchar stage variables can be initialized with spaces.
E. Stage variables are refreshed with default values before each new input row is processed.
正解:A,B,D
質問 6:
You have a parallel shared container that is used by other parallel jobs within your project. Part of the logic in this shared container has been changed. Which two statements are true regarding this change to the parallel shared container? (Choose two.)
A. Jobs using this parallel shared container need to be re-compiled only when the metadata of the container is changed.
B. Jobs using this parallel shared container need to be re-compiled.
C. You can create a sequencer to re-compile all of the routines using this shared container.
D. Use usage analysis and multi-compile to re-compile job using this shared container.
正解:B,D
質問 7:
When using Runtime Column Propagation, which three stages require a schema file? (Select three)
A. Peek stage
B. DB2 Enterprise stage
C. Sequential File stage
D. File Set stage
E. Column Import stage
正解:C,D,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 8:
You are required to use a Make Vector stage in your job. What three requirements must be met in order to use this stage? (Choose three.)
A. Input columns must form a numeric sequence.
B. All columns are combined into a vector of the same length as the number of columns.
C. Input columns must all be of the same data type.
D. Columns must be in consecutive order.
E. Input columns that do not have a name of form <column_name>0 to <column_name>n, where <column_name> is the column name and 0 and n are the first and last of its consecutive numbers will not be included in the vector and will be dropped.
正解:A,B,C