Informatica Informatica Certifications DATA-QUALITY-10-DEVELOPER-SPECIALIST Questions & Answers

• Question 11:

  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.

  Correct Answer: D

  Reference: http://south.readthedocs.org/en/latest/tutorial/part3.html

• Question 12:

  Select the item that is not a common symptom of data quality problems.

  A. Lack of trust and agreement in reporting

  B. high customer satisfaction

  C. Supply-chain 'out of stock' situations

  D. Failure of IT projects

  Correct Answer: A

• Question 13:

  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

  Correct Answer: D

• Question 14:

  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

  Correct Answer: C

• Question 15:

  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

  Correct Answer: C

• Question 16:

  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

  Correct Answer: B

• Question 17:

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

  A. Mappings

  B. Mapplets

  C. Re-usable Transformations

  D. Rules

  Correct Answer: ABCD

• Question 18:

  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.

  Correct Answer: D

• Question 19:

  In version 9.1, what does the Content Management Service do?

  A. It manages the dictionaries created in the Analyst Tool.

  B. It provides the DIS with information on the location of the address validation data as well as license and other AV configuration settings.

  C. It runs Identity Matching

  D. It makes the Profile repository available to outside reporting applications like Jaspersoft.

  Correct Answer: B

• Question 20:

  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

  Correct Answer: BD