Question 1

Which transformations can be used in DQ for Excel?

Accepted Answer

A)   Only mappings using a Case Converter and a Standardizer can be used on data in Excel.
B)   Only mappings using non active transformations can be used in DQ for Excel.
C)   All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.
D)   All DQ and Core Transformations can be used in DQ for Excel, there is no limitation. D

Question 2

Which of the following is not a function of Data Standardization?

Accepted Answer

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 C

Question 3

A customer has provided a number of delimited flat files that require profiling, but not filedefinition. What should you do first?

Accepted Answer

A)   Allow the wizard in Developer to automatically select the data types when creating the data objects.
B)   Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be.
C)   Import the file into a database table before profiling.
D)   Change the code page of the file to UTF-8. A

Question 4

Which two are index key levels in Identity Matching?

Accepted Answer

A)   Narrow
B)   Limited
C)   Typical
D)   Extended

Question 5

Should data be standardized before it reaches the Address Validator?

Accepted Answer

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.

Question 6

Which Informatica option provides solutions to common data quality issues in a country, region,or industry?

Accepted Answer

A)   populations
B)   accelerators
C)   dictionaries
D)   mapplets

Question 7

What types of profiling can be performed in the Developer Tool in Data Quality?

Accepted Answer

A)   Column Profiling, Primary Key Inference, Dependency Inference
B)   Column and Join Profiling only
C)   Column, Join Analysis, Mid Stream and Comparative Profiling
D)   Column, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling

Question 8

Which of the following options is TRUE? The Advanced Import Wizard differs from the Basic in that

Accepted Answer

A)   The Advanced method allows conflict resolution and the Basic doesn't.
B)   The Advanced Import Wizard allows objects to be imported into multiple target projects / folders and re-factor the dependencies.
C)   Import steps can be undone in the Advanced Wizard but not in the Basic one
D)   Users have a choice regarding which project objects are imported using Basic and Advanced.

Question 9

What happens to the records when corrections are made and a status of Accept is assigned?

Accepted Answer

A)   The corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record
B)   The corrections are committed to the Staging DB and record is automatically pushed into another DB
C)   Records are corrected and are sent to an Accepted DB table
D)   Records are accepted and are pushed out to Target/Production DB

Question 10

Users would export DQ mappings to PowerCenter for which of the following reasons? Choose all that apply.

Accepted Answer

A)   Performance
B)   Scalability
C)   Batch access
D)   DQ as part of ETL process
E)   None of the above

Question 11

Which is the best combination of functions to effectively implement a data quality project?

Accepted Answer

A)   Company Executives & IT
B)   IT & Business
C)   IT & Administration
D)   Sales & Marketing

Question 12

What Address Validator output field should you use to determine the quality of addressvalidated?

Accepted Answer

A)   Locality / City
B)   ElementlnputStatus
C)   Match Code
D)   MSA

Question 13

What is the best approach to implementing Address Validation in version 9.1?

Accepted Answer

A)   Run the addresses into the AV transformation without modification.
B)   Take an iterative approach and review AV output. Determine why addresses did not validate and attempt to resolve the issue prior to running them in the AV transformation.
C)   Canada Post defines the SERP certification standard for software applications that validate Canadian addresses.
D)   Remove all punctuation before sending the address to the AV transformation.

Question 14

When importing a flat file into a project. Developer and Analyst Tool work exactly the same

Accepted Answer

A) True 
 B)False

Question 15

When applying a reference table in the Labeler in token mode which of the following statementsis correct?

Accepted Answer

A)   The order of the reference tables defined will not impact your results displayed
B)   Selecting Inclusive mode will output items that are present in the reference table under the label provided
C)   Selecting Exclusive mode will exclude Items that are present in the reference table
D)   Any items that do not appear in the reference table are not displayed in the output

Question 16

When matching, is it always necessary to group data?

Accepted Answer

A)   Only if the customer thinks it's a good idea
B)   Only if the quality of the data is poor
C)   Not always. If the dataset is small enough, grouping is not required
D)   Yes, it's always necessary

Question 17

Where does Scorecarding fit into the data quality process?

Accepted Answer

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

Question 18

Which definition describes Column Profiling?

Accepted Answer

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

Question 19

How is Accelerator content installed?

Accepted Answer

A)   Using the IDQ content installer.
B)   It is imported through Developer.
C)   The file extracted onto the server and it is automatically picked up after restarting the services
D)   It is installed using the importer available in the Content Management service

Question 20

You want to derive the gender from a firstname, how would you do this?

Accepted Answer

A)   Use a reference table with the firstname as the valid column and the gender in the second column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.
B)   Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.
C)   Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif
D)   Then choose to Replace Reference Table Matches with Custom Strings when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

Exam 1: Data Quality 9.x Developer Specialist