Informatica PR000005 問題集

質問 1：
When profiling, why is it good to sort the value lists in both ascending and descending order?
A. It is good because it is easier to determine if a field is numeric or text.
B. There is no specific reason. It is simply a step of an ordered best practice approach.
C. None of the above.
D. Values with leading spaces or punctuation will typically sort to the top or bottom making them easier to identify.
正解：A

質問 2：
If the inputs to the Edit Distance Strategy below are 'john' and NULL, what will the resultingmatch score be?

A. 0
B. 0.5
C. 1.2
D. 1
正解：D

質問 3：
You want to derive the gender from a firstname, how would you do this?
A. Use a reference table with the firstname as the valid column and the gender in the second column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.
B. Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif
C. Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Custom Strings when applying the reference table in a strategy in the Standardizer. Use the firstname as input.
D. Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.
正解：A

質問 4：
During a project export, typically what will the output be from the export?
A. An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required
B. The contents of each Project (including the dependent reference tables) in a zip file
C. Projects will be exported to an .irob file
D. An xml file containing all the mapping/mapplet/object definition
正解：A

質問 5：
Which of these statements is true about Data Rules?
A. Data Rules must be run against the entire data set they are defined upon
B. A Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer
C. Once created a Data Rule cannot be changed...it can only be deleted and re-created
D. Data Rules can only be run on data in the project in which they were created
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which of the following is stored in the Staging repository?
A. Reference Tables
B. Authentication details
C. Mappings
D. Reference Tables and Audit information
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which transformation would you typically use to remove noise, symbols or words?
A. Standardizer
B. Comparison
C. Parser
D. Decision
正解：A