With regard to a Basic Import which of the following is FALSE?
A. Once added, the target will display resolution for each folder imported.
B. A conflict resolution can be selected to apply to all imported objects.
C. Default is replace, options include rename or reuse.
D. The import can consist of an XML file and a Zip file containing the reference tables
What Address Validator output field should you use to determine the quality of addressvalidated?
A. Locality / City
B. ElementlnputStatus
C. Match Code
D. MSA
When using field matching which is the best approach if using First Name as a match field?
A. Never use First Name as it is not necessary
B. No standardization of First Name field is necessary
C. Use the Edit Distance strategy
D. Create Soundex or NYSIIS value for the First Name and use it in match
Which of the following will not work when adding transformations to mappings?
A. Double click on the transformation in the transformation palette
B. Click and drag the transformation onto the mapping
C. From the Mapping menu, select Add Transformation
D. Right click and choose Add Transformation on the mapping
Should data be standardized before it reaches the Address Validator?
A. Yes, street and directional abbreviations should always be expanded to their unabbreviated form.
B. No, any change may cause problems to the AV transformation.
C. Yes, if after review, specific problems have been identified that are causing address to not validate that otherwise would.
D. Yes, they should all be upper case.
Which definition describes Column Profiling?
A. Colum profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys
B. Column profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important information about each attribute
C. Column profiling identifies the attributes for referential integrity
D. Column profiling is the process of creating a normalized schema for your target system
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. Once created a Data Rule cannot be changed...it can only be deleted and re-created
C. A Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer
D. Data Rules can only be run on data in the project in which they were created
Which of the following will Impact the total amount of time it takes to execute a column profiling process?
A. Number of Columns in the file
B. Number of Rows in the source data
C. Amount of memory and speed of the processor on the server
D. All of the above
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
D. 1.2
Which of the following cannot be executed in BOTH the Analyst and the Developer Tool?
A. A rule created in the Analyst Tool
B. A mapplet created in the Developer Tool and validated as a rule
C. A mapplet created in the Developer Tool and validated as a mapplet
D. A reusable rule created in the Analyst Tool
