Certbus > Informatica > Developer Specialist > PR000005 > PR000005 Online Practice Questions and Answers

PR000005 Online Practice Questions and Answers

Questions 4

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

A. Locality / City

B. ElementlnputStatus

C. Match Code

D. MSA

Browse 70 Q&As
Questions 5

With respect to field matching in IDQ, which best describes the approach to address matching?

A. No standardization is necessary, map input fields to the match transformation

B. Standardize address fields and use address line, locality, region and postcode fields as input to the match transformation

C. Standardize address fields and use the discrete address component fields, locality, region and postcode fields as input to the match transformation

D. Standardize address fields, create a group key field which contains parts of the address fields and only use the group key for address matching

Browse 70 Q&As
Questions 6

Where are IDQ mappings saved?

A. In the location specified in your Source object

B. In the Staging Database

C. In the Model Repository

D. On the Object Explorer tab in the Developer

Browse 70 Q&As
Questions 7

What transformation would you use to standardize data using a reference table?

A. Labeler

B. Decision

C. Standardizer

D. Parser

Browse 70 Q&As
Questions 8

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

A. Company Executives and IT

B. IT and Business

C. IT and Administration

D. Sales and Marketing

Browse 70 Q&As
Questions 9

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

A. TRUE

B. FALSE

Browse 70 Q&As
Questions 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.

Browse 70 Q&As
Questions 11

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

Browse 70 Q&As
Questions 12

Which two IDQ transformations can use parameters? Choose 2 answers

A. Comparison

B. Decision

C. Case converter

D. Address Validation

E. Labeller

Browse 70 Q&As
Questions 13

What versions of PowerCenter can an IDQ 9.1 mapping be exported to?

A. PC 8.6.1 and higher

B. PC 8.51 and higher

C. All PC versions

D. PC 8.11, PC 8.51 and PC 8.6

Browse 70 Q&As
Questions 14

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

Browse 70 Q&As
Questions 15

What must you do in order to utilize Data Quality accelerators in PowerCenter? Choose 2 answers

A. Import accelerators directly to Power Center

B. Install accelerators directly to PowerCenter

C. Install accelerators into Developer

D. Export accelerator mapplets and/or mappings to PowerCenter

Browse 70 Q&As
Questions 16

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

Browse 70 Q&As
Questions 17

In the Case Converter transformation which of the following is not a valid Case Transform?

A. Upper Case

B. Lower Case

C. Toggle merge Case

D. Sentence Case

Browse 70 Q&As
Questions 18

What statement best describes IDQ's Web service capabilities?

A. Mappings can only be created as a web service through PC integration

B. DQ has both native web service functionality and allows integration through PC

C. DQ mappings can only be made accessible through native means

D. DQ has not web service support

Browse 70 Q&As
Exam Code: PR000005
Exam Name: Data Quality 9.x Developer Specialist
Last Update: Mar 25, 2024
Questions: 70 Q&As

PDF

$45.99

VCE

$49.99

PDF + VCE

$59.99