Question 1

The Pattern Parser is used in conjunction with which transformation?

Accepted Answer

A)  Token Parser 
B)  Standardizer 
C)  Exception 
D)  Labeler 
A)  Token Parser 
B)  Standardizer 
C)  Exception 
D)  Labeler

Question 2

When sharing Projects across teams which of the following is True?

Accepted Answer

A)  The same icon is used to indicate a shared and non shared project. 
B)  Comments that are added to a profile in the Analyst can be viewed by the Developer in the same profile in the Developer Tool. 
C)  Permissions need to be assigned to each Folder within the project so users of shared projects can access all the objects. 
D)  Rules that were created In the Analyst Tool will be visible In the Developer but Developer built rules can not be made available in the Analyst. 
A)  The same icon is used to indicate a shared and non shared project. 
B)  Comments that are added to a profile in the Analyst can be viewed by the Developer in the same profile in the Developer Tool. 
C)  Permissions need to be assigned to each Folder within the project so users of shared projects can access all the objects. 
D)  Rules that were created In the Analyst Tool will be visible In the Developer but Developer built rules can not be made available in the Analyst.

Question 3

Which of the following is NOT a required step for using DQ for Excel?

Accepted Answer

A)  In Excel, choose to Add a service and either enter the URL address or select the .wsdl or .xml file to be imported. 
B)  Build and Test a web Services Mapping in the Developer Tool. 
C)  Export the Mapping to PowerCenter and test. 
D)  Create and Deploy the mapping as an Application. 
A)  In Excel, choose to Add a service and either enter the URL address or select the .wsdl or .xml file to be imported. 
B)  Build and Test a web Services Mapping in the Developer Tool. 
C)  Export the Mapping to PowerCenter and test. 
D)  Create and Deploy the mapping as an Application.

Question 4

What functionality does Data Quality Assistant provide?

Accepted Answer

A)  Consolidate duplicates into master record 
B)  Bad record management 
C)  Automatically consolidates data 
D)  ReGroup records for matching 
A)  Consolidate duplicates into master record 
B)  Bad record management 
C)  Automatically consolidates data 
D)  ReGroup records for matching

Question 5

When is sampling for Profiling a good idea?

Accepted 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. 
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.

Question 6

Which two IDQ transformations can use parameters?

Accepted Answer

A)  Comparison 
B)  Decision 
C)  Case converter 
D)  Address Validation 
E)  Labeller 
A)  Comparison 
B)  Decision 
C)  Case converter 
D)  Address Validation 
E)  Labeller

Question 7

Which parameter function is supported in IDQ 9.1?

Accepted Answer

A)  Set parameter for RTM Location/ Path 
B)  Set parameter for RTM Name 
C)  Ability to parameterise relational and flat-file connections 
D)  All of the above 
A)  Set parameter for RTM Location/ Path 
B)  Set parameter for RTM Name 
C)  Ability to parameterise relational and flat-file connections 
D)  All of the above

Question 8

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

Accepted Answer

A)  0 
B)  0.5 
C)  1 
D)  1.2 
A)  0 
B)  0.5 
C)  1 
D)  1.2

Question 9

What is the primary purpose of grouping data?

Accepted Answer

A)  standardize data in preparation for matching 
B)  normalize data in preparation for matching 
C)  Improve match performance 
D)  improve match results 
A)  standardize data in preparation for matching 
B)  normalize data in preparation for matching 
C)  Improve match performance 
D)  improve match results

Question 10

When using field matching which is the best approach if using First Name as a match field?

Accepted Answer

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 
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

Question 11

Which statements describe the Consolidation Transformation?

Accepted Answer

A)  a passive transformation 
B)  an active transformation 
C)  a transformation which is found only in PowerCenter 
D)  creates a single, consolidated record from records identified as possible duplicates by the Match transformation 
A)  a passive transformation 
B)  an active transformation 
C)  a transformation which is found only in PowerCenter 
D)  creates a single, consolidated record from records identified as possible duplicates by the Match transformation

Question 12

Which is true with regard to Profiles?

Accepted Answer

A)  The Developer can only review Profiles created by the Analyst but can not create any profiles themselves 
B)  The Developer can take Analyst built profiles with rules and generate a mapping ensuring lossless translation of Information between specification and Implementation. 
C)  Comments, Tags and Rules can only be applied to profiles in the Analyst Tool 
D)  Only one Tag can be applied to each object in a project. 
A)  The Developer can only review Profiles created by the Analyst but can not create any profiles themselves 
B)  The Developer can take Analyst built profiles with rules and generate a mapping ensuring lossless translation of Information between specification and Implementation. 
C)  Comments, Tags and Rules can only be applied to profiles in the Analyst Tool 
D)  Only one Tag can be applied to each object in a project.

Question 13

How much data can DQA handle?

Accepted Answer

A)  2000 rows and 20 columns 
B)  Million rows and 100 columns 
C)  There are no built-in restrictions. Large deployments will require more hardware and database tuning 
D)  Maximum 1 million rows and up to 10,000 columns 
A)  2000 rows and 20 columns 
B)  Million rows and 100 columns 
C)  There are no built-in restrictions. Large deployments will require more hardware and database tuning 
D)  Maximum 1 million rows and up to 10,000 columns

Question 14

Select the transformation that will not allow a DQ mapplet to validate as a rule in version 9.1.

Accepted Answer

A)  Expression Transformation 
B)  Address Validation Transformation 
C)  Aggregator Transformation 
D)  Labeler Transformation 
A)  Expression Transformation 
B)  Address Validation Transformation 
C)  Aggregator Transformation 
D)  Labeler Transformation

Question 15

Accelerators provide which of the following?

Accepted Answer

A)  Rules 
B)  Reference tables 
C)  Demonstration mappings 
D)  Demonstration data objects 
E)  Profiles 
A)  Rules 
B)  Reference tables 
C)  Demonstration mappings 
D)  Demonstration data objects 
E)  Profiles

Question 16

IDQ parameters can be defined at what levels? Choose all that apply.

Accepted Answer

A)  Mappings 
B)  Mapplets 
C)  Re-usable Transformations 
D)  Rules 
E)  None of the above 
A)  Mappings 
B)  Mapplets 
C)  Re-usable Transformations 
D)  Rules 
E)  None of the above

Question 17

A customer wants to be able to review data on the overall quality of each record, which technique should be used?

Accepted Answer

A)  Scorecarding 
B)  Matching 
C)  Grading 
D)  Standardization 
A)  Scorecarding 
B)  Matching 
C)  Grading 
D)  Standardization

Question 18

Which of the following is not true when it comes to creating and updating Reference Tables?

Accepted Answer

A)  Reference Tables can be updated from a Value Frequency list in the Developer 
B)  All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst 
C)  Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories 
D)  Reference Tables can be imported and exported using the Developer Tool 
A)  Reference Tables can be updated from a Value Frequency list in the Developer 
B)  All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst 
C)  Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories 
D)  Reference Tables can be imported and exported using the Developer Tool

Question 19

Which of the following will Impact the total amount of time it takes to execute a column profiling process?

Accepted Answer

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 
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

Question 20

When changes are made to a mapplet in IDQ 9.1 that has been integrated into PowerCenter, howare those changes propagated to the integrated mapplet?

Accepted Answer

A)  Those changes are automatically propagated and managed through domain settings. 
B)  The user must manually re-export the IDQ mapplet to PowerCenter. 
C)  The IDQ versioning system automatically synchs with PowerCenter and updates themapplet to the most current version. 
D)  None of the above. 
A)  Those changes are automatically propagated and managed through domain settings. 
B)  The user must manually re-export the IDQ mapplet to PowerCenter. 
C)  The IDQ versioning system automatically synchs with PowerCenter and updates themapplet to the most current version. 
D)  None of the above.

The Pattern Parser is used in conjunction with which transformation?

When sharing Projects across teams which of the following is True?

Which of the following is NOT a required step for using DQ for Excel?

What functionality does Data Quality Assistant provide?

When is sampling for Profiling a good idea?

Which two IDQ transformations can use parameters?

Which parameter function is supported in IDQ 9.1?

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

What is the primary purpose of grouping data?

When using field matching which is the best approach if using First Name as a match field?

Which statements describe the Consolidation Transformation?

Which is true with regard to Profiles?

How much data can DQA handle?

Select the transformation that will not allow a DQ mapplet to validate as a rule in version 9.1.

Accelerators provide which of the following?

IDQ parameters can be defined at what levels? Choose all that apply.

A customer wants to be able to review data on the overall quality of each record, which technique should be used?

Which of the following is not true when it comes to creating and updating Reference Tables?

Which of the following will Impact the total amount of time it takes to execute a column profiling process?

When changes are made to a mapplet in IDQ 9.1 that has been integrated into PowerCenter, howare those changes propagated to the integrated mapplet?

PowerCenter Data Integration 9.x Administrator Specialist

PowerCenter Data Integration 9.x:Developer Specialist

Filters

Exam 1: Data Quality 9.x Developer Specialist

The Pattern Parser is used in conjunction with which transformation?

When sharing Projects across teams which of the following is True?

Which of the following is NOT a required step for using DQ for Excel?

What functionality does Data Quality Assistant provide?

When is sampling for Profiling a good idea?

Which two IDQ transformations can use parameters?

Which parameter function is supported in IDQ 9.1?

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

What is the primary purpose of grouping data?

When using field matching which is the best approach if using First Name as a match field?

Which statements describe the Consolidation Transformation?

Which is true with regard to Profiles?

How much data can DQA handle?

Select the transformation that will not allow a DQ mapplet to validate as a rule in version 9.1.

Accelerators provide which of the following?

IDQ parameters can be defined at what levels? Choose all that apply.

A customer wants to be able to review data on the overall quality of each record, which technique should be used?

Which of the following is not true when it comes to creating and updating Reference Tables?

Which of the following will Impact the total amount of time it takes to execute a column profiling process?

When changes are made to a mapplet in IDQ 9.1 that has been integrated into PowerCenter, howare those changes propagated to the integrated mapplet?

PowerCenter Data Integration 9.x Administrator Specialist

PowerCenter Data Integration 9.x:Developer Specialist

Filters