File Info
| Exam | Data Quality 9.x Developer Specialist |
| Number | PR000005 |
| File Name | Informatica.PR000005.CertDumps.2018-03-01.39q.vcex |
| Size | 78 KB |
| Posted | Mar 01, 2018 |
| Download | Informatica.PR000005.CertDumps.2018-03-01.39q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
A customer wants to be able to review data on the overall quality of each record, which technique should be used?
- Scorecarding
- Matching
- Grading
- Standardization
Correct answer: D
Question 2
What types of profiling can be performed in the Developer Tool in Data Quality?
- Column Profiling, Primary Key Inference, Dependency Inference
- Column and Join Profiling only
- Column, Join Analysis, Mid Stream and Comparative Profiling
- Column, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling
Correct answer: C
Question 3
When importing a flat file into a project. Developer and Analyst Tool work exactly the same
- TRUE
- FALSE
Correct answer: A
Question 4
Which transformation would you typically use to remove noise, symbols or words?
- Decision
- Standardizer
- Comparison
- Parser
Correct answer: B
Question 5
Accelerators provide which of the following? Choose 4 answers
- Rules
- Reference tables
- Demonstration mappings
- Demonstration data objects
- Profiles
Correct answer: ACDE
Question 6
Which of the following statements is true regarding DQ for Excel?
- DQ for Excel allows .xls files be used as source and target objects in mappings.
- DQ for Excel enables non Informatica users to benefit from data quality rules by consuming and applying data quality rules directly from MS Excel data/worksheets.
- DQ for Excel can be used in any version of Excel.
- In order to be able to use DQ for Excel, both PowerCenter and Data Quality Developer must be installed.
Correct answer: B
Explanation:
Reference:https://community.informatica.com/solutions/data_quality_microsoft_excel Reference:
https://community.informatica.com/solutions/data_quality_microsoft_excel
Question 7
How is Accelerator content installed?
- Using the IDQ content installer.
- It is imported through Developer.
- The file extracted onto the server and it is automatically picked up after restarting the services
- It is installed using the importer available in the Content Management service
Correct answer: C
Question 8
When applying a reference table in the Labeler in token mode which of the following statementsis correct?
- The order of the reference tables defined will not impact your results displayed
- Selecting Inclusive mode will output items that are present in the reference table under the label provided
- Selecting Exclusive mode will exclude Items that are present in the reference table
- Any items that do not appear in the reference table are not displayed in the output
Correct answer: B
Question 9
What is the best approach to implementing Address Validation in version 9.1?
- Run the addresses into the AV transformation without modification.
- 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.
- Canada Post defines the SERP certification standard for software applications that validate Canadian addresses.
- Remove all punctuation before sending the address to the AV transformation.
Correct answer: C
Question 10
When profiling, why is it good to sort the value lists in both ascending and descending order?
- There is no specific reason. It is simply a step of an ordered best practice approach.
- It is good because it is easier to determine if a field is numeric or text.
- Values with leading spaces or punctuation will typically sort to the top or bottom making them easier to identify.
- None of the above.
Correct answer: B
