IBM InfoSphere DataStage v9.1 C2090-303 Prüfungsfragen mit Lösungen:
1. Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)
A) A single XML Stage, which can be used as a source, target, or transformation.
B) XML Stage can be found in the Database folder on the palette.
C) It includes the XML Input, XML Output, and XML Transformer stages.
D) XML Stages are Plug-in stages.
E) Uses a unique custom GUI interface called the Assembly Editor.
2. Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a RemoveDuplicates stage. How can this be accomplished?
A) Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount.
B) Hash-partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount.
C) Hash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.
D) Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.
3. The ODBC stage can handle which two SQL Server data types? (Choose two.)
A) Date
B) SmallDateTime
C) Datetime
D) GUID
E) Time
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? (Choose two.)
A) Right-click the asset and click Update From Source Control Workspace.
B) Right-click the asset and click the Team Import command.
C) Right-click the asset and click the Deploy command.
D) Right-click the asset and click the Team command to update the Source Control Workspace with the asset.
E) Right-click the asset and click Replace From Source Control Workspace.
5. You want to find out which table definitions have been loaded into a job, and specifically which stages of the job they has been loaded into? How will you determine this?
A) Select the job, right-click, then click the Find where used command. Then right-click and select "Show the dependency path from the job".
B) Select the job, right-click, then click the Find dependencies command. Then right-click and select "Show the dependency path from the job".
C) Select the job, right-click, then click the Find where used (deep) command.
D) Select the job, right-click, then click the Find dependencies (deep) command.
Fragen und Antworten:
| 1. Frage Antwort: A,E | 2. Frage Antwort: A | 3. Frage Antwort: B,D | 4. Frage Antwort: D,E | 5. Frage Antwort: B |
1284 Kundenbewertungen
