What Address Validator output field should you use to determine the quality of addressvalidated?
A. Locality / City
B. ElementlnputStatus
C. Match Code
D. MSA
With respect to field matching in IDQ, which best describes the approach to address matching?
A. No standardization is necessary, map input fields to the match transformation
B. Standardize address fields and use address line, locality, region and postcode fields as input to the match transformation
C. Standardize address fields and use the discrete address component fields, locality, region and postcode fields as input to the match transformation
D. Standardize address fields, create a group key field which contains parts of the address fields and only use the group key for address matching
Where are IDQ mappings saved?
A. In the location specified in your Source object
B. In the Staging Database
C. In the Model Repository
D. On the Object Explorer tab in the Developer
What transformation would you use to standardize data using a reference table?
A. Labeler
B. Decision
C. Standardizer
D. Parser
Which is the best combination of functions to effectively implement a data quality project?
A. Company Executives and IT
B. IT and Business
C. IT and Administration
D. Sales and Marketing
When importing a flat file into a project. Developer and Analyst Tool work exactly the same
A. TRUE
B. FALSE
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.
Users would export DQ mappings to PowerCenter for which of the following reasons? Choose all that apply.
A. Performance
B. Scalability
C. Batch access
D. DQ as part of ETL process
Which two IDQ transformations can use parameters? Choose 2 answers
A. Comparison
B. Decision
C. Case converter
D. Address Validation
E. Labeller
What versions of PowerCenter can an IDQ 9.1 mapping be exported to?
A. PC 8.6.1 and higher
B. PC 8.51 and higher
C. All PC versions
D. PC 8.11, PC 8.51 and PC 8.6
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
What must you do in order to utilize Data Quality accelerators in PowerCenter? Choose 2 answers
A. Import accelerators directly to Power Center
B. Install accelerators directly to PowerCenter
C. Install accelerators into Developer
D. Export accelerator mapplets and/or mappings to PowerCenter
Select the transformation that will not allow a DQ mapplet to validate as a rule in version 9.1.
A. Expression Transformation
B. Address Validation Transformation
C. Aggregator Transformation
D. Labeler Transformation
In the Case Converter transformation which of the following is not a valid Case Transform?
A. Upper Case
B. Lower Case
C. Toggle merge Case
D. Sentence Case
What statement best describes IDQ's Web service capabilities?
A. Mappings can only be created as a web service through PC integration
B. DQ has both native web service functionality and allows integration through PC
C. DQ mappings can only be made accessible through native means
D. DQ has not web service support