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
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
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
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
When is sampling for Profiling a good idea? Select the best answer.
A. When the data set contains sensitive information like credit card numbers.
B. When the probability of data quality issues is small.
C. When the client provides assurances the quality of the data is good.
D. When the volume of data is large and there are storage and/or time constraints.
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
IDQ parameters can be defined at what levels? Choose all that apply.
A. Mappings
B. Mapplets
C. Re-usable Transformations
D. Rules
Where does Scorecarding fit into the data quality process?
A. Not at all - Scorecardlng is a separate process
B. At the start of the process only to assess current data quality levels
C. At the start and during regular intervals of the process to measure on-going data quality levels
D. At the end of the process only to prove the value of the data quality tool
What is the primary purpose of grouping data?
A. standardize data in preparation for matching
B. normalize data in preparation for matching
C. Improve match performance
D. improve match results
Which phrase best describes how organizations should view their approach to data quality?
A. As a one-off project addressing the issues in their data warehouse in batch
B. As an ongoing process addressing issues over time with a combination of fit-for-purpose approaches
C. As a real-time process addressing issues as they are introduced
D. As a batch process to be implemented to run on a monthly basis
