Deck 1: Data Quality 9.x Developer Specialist

Question 1

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

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.

Answer 1

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.

Question 2

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

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

Answer 2

Column, Join Analysis, Mid Stream and Comparative Profiling

Question 3

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

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

Answer 3

Standardization

Question 4

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
E) None of the above

Question 5

Accelerators provide which of the following?

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

Question 6

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

Question 7

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

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 8

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

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

Question 9

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

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 10

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.

Question 11

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

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 12

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

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 13

Which statements describe the Consolidation 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 14

The Pattern Parser is used in conjunction with which transformation?

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

Question 15

Which is true with regard to Profiles?

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 16

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

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 17

Which two IDQ transformations can use parameters?

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

Question 18

How is Accelerator content installed?

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 19

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?

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.

Question 20

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

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

Question 21

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

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 22

Which two are index key levels in Identity Matching?

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

Question 23

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

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.

Question 24

How much data can DQA handle?

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 25

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

Question 26

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

Question 27

When matching, is it always necessary to group data?

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 28

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

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

Question 29

What functionality does Data Quality Assistant provide?

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

Question 30

Which parameter function is supported in IDQ 9.1?

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 31

When is sampling for Profiling a good idea?

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 32

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

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

Question 33

Which transformations can be used in DQ for Excel?

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.

Question 34

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

Question 35

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

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 36

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

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

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 41

What Data Quality Transformation utilizes Identity populations?

A) Key Generator Transformation
B) Match Transformation
C) Edit Distance Transformation
D) Comparison Transformation

Question 42

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