A2090-421 by IBM Valid Free Exam Practice Test

Question 1

A star schema data warehouse consists of four dimension tables and one fact table. How many Slowly Changing Dimensions (SCD) stages will you need in your jobs to update the star schema tables?

A. five B. three C. two D. four

Correct Answer: D

Question 2

In which two situations is it appropriate to use a Sparse Lookup? (Choose two.)

A. When invoking a stored procedure within a database per row in the streaming link. B. When the output of the Lookup stage needs to be hashed partitioned. C. When accessing DB2 data using the DB2 API stage. D. When reference data is significantly larger than the streaming data (100:1).

Correct Answer: A,D

Question 3

What are two fundamental functions of the Information Server Source Code Integration based on the Eclipse Team framework? (Choose two.)

A. Rollback Changes B. Send to Source Code Control Workspace C. Replace from Source Code Control Workspace D. Commit Changes

Correct Answer: B,C

Question 4

You found there were common functional requirements in the data mapping specification. The required functions are same but the record formats are different. Which action will allow you to effectively implement common logic?

A. Create parallel routines. B. Create parallel shared containers and define columns combining all data formats. C. Create separate jobs and choose appropriate job within a job sequence. D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary columns needed for the logic.

Correct Answer: D

Question 5

What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)

A. Columns not specifically used in the flow are propagated as if they were. B. Only columns that are defined as VarChar need RCP enabled. C. RCP is not a feature of DataStage. D. Only columns used in the data flow need to be defined. E. Sequential files don't require schema files when using RCP.

Correct Answer: A,D

Question 6

You are setting up user roles on Information Server Web console. Which two roles are required to allow a user to edit DataStage jobs? (Select two)

A. DataStage Developer B. DataStage super operator C. Information Analyzer Data Administrator D. Suite User role

Correct Answer: A,B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

What two features enable a job with a Sequential File stage to read from sequential files with different numbers of columns and types? (Select two)

A. Schema File property B. Subrecord data type C. Runtime Column Propagation D. Vector data type

Correct Answer: B,C

Question 8

How is Runtime Column Propagation (RCP) enabled for use in DataStage Jobs?

A. RCP is by default available for all DataStage Projects. B. Set the APT_ENABLE_RCP environment variable to TRUE. C. Use the DataStage Administrator to enable RCP for the project. D. Use RCP definition wizard to initialize RCP for project use. E. Use the Info Server web console to enable RCP

Correct Answer: C

Question 9

You have been asked to assess the impact of replacing the DB2 Enterprise Stage with the DB2 Connector. You must identify all of the jobs and shared containers that use the DB2 Enterprise Stage.
What two Advanced Find criteria would you set to identify the jobs and containers? (Choose two.)

A. Type B. Where used C. Dependent upon D. Include Read only objects

Correct Answer: A,B

Question 10

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 Where used command. D. Select the shared container, Right-click on the Dependencies (deep) command.

Correct Answer: A

Question 11

Click the Exhibit button.

These three Sequential Files shown in the exhibit need to be joined. Join_1 is on Columns CustID and OrderID. Join_2 is on CustID and LocationID. What is the most efficient hash partitioning strategy for each link?

A. For LinkA Hash Partition on OrderID and CustID; For LinkB Hash Partition on OrderID and CustID; For LinkC Hash Partition on LocationID and CustID; For LinkD Hash Partition on LocationID and CustID. B. For LinkA Hash Partition on CustID, OrderID and LocationID; For LinkB Hash Partition on CustID, OrderID and LocationID; For LinkC Hash Partition on CustID, OrderID and LocationID; For LinkD Hash Partition on CustID, OrderID and LocationI C. For LinkA Hash Partition on CustID;
For LinkB Hash Partition on CustID;
For LinkC Same Partition;
For LinkD Hash Partition on CustID. D. For LinkA Hash Partition on CustID and OrderID; For LinkB Hash Partition on CustID and OrderID; For LinkC Hash Partition on CustID and LocationID; For LinkD Hash Partition on CustID and LocationID.

Correct Answer: C

IBM Assessment: InfoSphere DataStage v8.5 - A2090-421 Exam Practice Test