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.
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.
A. Schema definition of the file.
B. File system limitations.
C. Number of physical processing nodes.
D. Number of processing nodes in the default node pool.
E. Number of disks in the export or default disk pool connected to each processing node in the default node pool
A. Import the original job from a .dsx export.
B. Select the job,then right click Compare within.
C. Select the job,then right click Cross Project Compare.
D. Before making a change to a job make a copy of the job in a different category folder.
C. Check the message filters for the job.
D. View detailed runtime stats through Job monitor in Director Client.
A. Define columns for the output link.
B. Specify the remote server property.
C. Specify properties for the input link.
D. Define the connection properties to an ODBC data source.
A. When accessing DB2 data using the DB2 API stage.
B. When the output of the Lookup stage needs to be hashed partitioned.
C. When reference data is significantly larger than the streaming data (100:1).
D. When invoking a stored procedure within a database per row in the streaming link.
D. Round Robin
B. Key partitioned
C. Hash partitioned
D. Entire partitioned
E. Sorted in ascending order
E. Remove Duplicates
A. suite roles
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
12) What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)
A. RCP is not a feature of DataStage.
B. Only columns used in the data flow need to be defined.
C. Only columns that are defined asVarChar need RCP enabled.
D. Sequential files don’t require schema files when using RCP.
E. Columns not specifically used in the flow are propagated as if they were.
A. added column namedChange_Code
B. added column namedDifference_Value
C. Table Definition based on the after input link
D. Table Definition based on the keys of the input link
“Pass Any Exam. Any Time.” – 100% Guaranteed 28
A. Disable job monitoring.
B. Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
C. Unset the Preserve Partitioning flag on the output of each parallel dataset.
D. Explicitly specify hash partitioning and sorting on each input to the Join stage.
E. Add a parallel sort stage before each Join input, specifying the “Don’t Sort, Previously Grouped”
sort key mode for each key.
B. Where used
C. Dependent upon
D. Include Read only objects
You can watch and practice above questions in below video: