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
During a project export, typically what will the output be from the export?
A. An xml file containing all the mapping/mapplet/object definition
B. An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required
C. The contents of each Project (including the dependent reference tables) in a zip file
D. Projects will be exported to an .irob file
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 is not a function of Data Standardization?
A. Standardization converts data to standardized formats
B. Standardization can remove "noise"
C. Standardization corrects and automatically updates the data in your source system
D. Standardization can remove or replace bad or inconsistent data
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 two IDQ transformations can use parameters? Choose 2 answers
A. Comparison
B. Decision
C. Case converter
D. Address Validation
E. Labeller
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
How is the data loaded into DQA and how is it configured?
A. By running the DQ Client installer
B. The Analyst defines the table in the Analyst tool, and the mappings in the Developer tool create and populate the appropriate tables
C. The Analyst populates and creates the table in the Analyst tool
D. The Administrator needs to create a DQA Service and associate it with the staging database
Which DQ Transformations can be used to automatically consolidate matched records?
A. Consolidation
B. Match and Association
C. Key Gen and Consolidation
D. Key Gen, Association and Consolidation
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.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Informatica exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your DATA-QUALITY-10-DEVELOPER-SPECIALIST exam preparations and Informatica certification application, do not hesitate to visit our Vcedump.com to find your solutions here.