IBM 000-421 試験概要:

IBM 000-421 試験シラバストピック:

IBM InfoSphere DataStage v8.5 認定 000-421 試験問題：

問題 #1
You have been given operational requirements to introduce data recovery to one of your parallel job designs. Additionally, you have been told that you are to use flat files as your intermediate data structure. Which two tasks will accomplish these objectives? (Choose two.)

A. Use the Hash File stage to write and read data between parallel jobs.
B. Enable checkpoint restartability in each of your parallel stages.
C. Use the Sequential stage to export and import data between jobs.
D. Break up the design by splitting it into at least two parallel jobs.

問題 #2
You have been asked to delete a shared container from the project by your customer. Before you do this you want to make sure it will not impact other objects in the project. How will you ensure that deleting the shared container will not cause a failure when jobs are recompiled?

A. Select the shared container, Right-click on the Where used (deep) command.
B. Advanced find, set Dependencies Of field equal to the container name, and Check the Option to Include nested results for Dependency searches.
C. Select the shared container, Right-click on the Dependencies (deep) command.
D. Select the shared container, Right-click on the Where used command.

問題 #3
A job contains a Sort stage that sorts a large volume of data across a cluster of servers. Due to new requirements, the customer has requested that this sorting be done on a subset of servers identified in the configuration file to minimize impact on database nodes. The $APT_CONFIG_FILE shows no sort disk pool for any node. Which two steps will accomplish this? (Choose two.)

A. Have an appropriate node constraint within the Sort stage.
B. Use the environment variable $APT_SCRATCH_SPACE_SORT_USAGE.
C. Define a non-default node pool with a subset of nodes in the parallel configuration file.
D. Create a sort scratch disk pool with a subset of nodes in the parallel configuration file.
E. Assign a separate config file just for the Sort stage.

問題 #4
Refer to the exhibit.

You are responsible for improving performance for a given job. From reviewing the job dump score, you notice that many tsort operators are inserted. Join_1 is on columns "account", "po_date" and "hdr_number". Join_2 is based on "account", "hdr_number", "paid_date".
Which two actions will help you improve the performance without changing the business logic?
(Select two)

A. Insert sort stage between Join_1 and Join_2, subsort ("Don't sort, previously sorted") on "account", sort "hdr_number" and "paid_date".
B. Partition on "account" and "hdr_number" for all joins. Change Join_1 to join on "account", "hdr_number" and "po_date". Add Add $APT_SORTJNSERTION_CHECK_ONLY to job parameter list and set it to "True".
C. Partition on account and hdr_numberfor all joins. Change Join_1 to join on "account", "hdr_number" and "po_date". Insert Sort between Join_1 and Join_2 and subsort ("Don't sort previously sorted") on "account".
D. Partition on account and hdrnumber for all joins. Change Join_1 to join on "account", "hdrnumber" and "po_date". Insert Sort between Join_1 and Join_2 and subsort ("Don't sort previously sorted") on "account" and "hdr_number" and sort on "paid_date".

問題 #5
What three element Names are required to create Shared metadata? (Choose three.)

A. Project Name
B. Schema
C. Host System
D. Database
E. Database Instance

解説：