DATA-QUALITY-10-DEVELOPER-SPECIALIST Online Practice Questions and Answers

With regard to a Basic Import which of the following is FALSE?

A. Once added, the target will display resolution for each folder imported.

B. A conflict resolution can be selected to apply to all imported objects.

C. Default is replace, options include rename or reuse.

D. The import can consist of an XML file and a Zip file containing the reference tables

Which statements describe the Consolidation Transformation?Choose 2 answers

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

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

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

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

The Pattern Parser is used in conjunction with which transformation?

A. Token Parser

B. Standardizer

C. Exception

D. Labeler

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

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

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

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.