Question No. 1
When you select Suggestion List mode what statement is true?
The Address Validator transformation searches the address reference data and returns all
The Address Validator transformation searches the address reference data and returns the most
The Address Validator transformation parses data into the suggested address fields without
The Address Validator transformation will return various cleansed standardized versions of the
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 2
How much data can DQA handle?
2000 rows and 20 columns
Million rows and 100 columns
There are no built-in restrictions. Large deployments will require more hardware and database
Maximum 1 million rows and up to 10,000 columns
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 3
What is the primary purpose of grouping data?
standardize data in preparation for matching
normalize data in preparation for matching
Improve match performance
improve match results
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 4
Which definition describes Column Profiling?
Colum profiling automatically recognizes all functional and other dependencies in all tables, in
Column profiling is the process of looking at every distinct value to determine the true minimum,
Column profiling identifies the attributes for referential integrity
Column profiling is the process of creating a normalized schema for your target system
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 5
Which parameter function is supported in IDQ 9.1?
Set parameter for RTM Location/ Path
Set parameter for RTM Name
Ability to parameterise relational and flat-file connections
All of the above
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 6
Which of the following is not true when it comes to creating and updating Reference Tables?
Reference Tables can be updated from a Value Frequency list in the Developer
All except Un-Managed Reference Tables can be updated through the Reference Table Manager in
Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories
Reference Tables can be imported and exported using the Developer Tool
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 7
Which of the following will Impact the total amount of time it takes to execute a column profiling
Number of Columns in the file
Number of Rows in the source data
Amount of memory and speed of the processor on the server
All of the above
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 8
Which two are index key levels in Identity Matching? Choose 2 answers
Narrow
Limited
Typical
Extended
Reveal Solution Select all that apply, then reveal solution.
View discussion (0 Comments)
Question No. 9
Which of the following will Impact the total amount of time it takes to execute a column profiling
Number of Columns in the file
Number of Rows in the source data
Amount of memory and speed of the processor on the server
All of the above
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 10
Which are correct statements for IDQ grouping and matching?Choose 2 answers
IDQ field level matching does not utilize grouping
When field level matching is performed, the records within each group will be compared against
When field level matching is performed, matching will be performed across multiple groups in a
When field level matching is performed, matching will not be performed across groups, therefore
Reveal Solution Select all that apply, then reveal solution.
View discussion (0 Comments)
Question No. 11
A customer has provided a number of delimited flat files that require profiling, but not filedefinition.
Allow the wizard in Developer to automatically select the data types when creating the data
Set all of the data types to text and length longer than those specified. The profiler will tell you
Import the fileinto a database table before profiling.
Change the code page of the file to UTF-8.
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 12
A customer has provided a number of delimited flat files that require profiling, but not filedefinition.
Allow the wizard in Developer to automatically select the data types when creating the data
Set all of the data types to text and length longer than those specified. The profiler will tell you
Import the fileinto a database table before profiling.
Change the code page of the file to UTF-8.
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 13
Which Informatica option provides solutions to common data quality issues in a country, region,or industry? Choose 1 Answer
Reveal Solution Select all that apply, then reveal solution.
View discussion (0 Comments)
Question No. 14
The IDQ and PowerCenter repositories all share the same schema.
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)
Question No. 15
The IDQ and PowerCenter repositories all share the same schema.
Reveal Solution Select one option, then reveal solution.
View discussion (0 Comments)