C2090-304 Online Practice Questions and Answers

Which two steps in the QualityStage Data Quality Methodology facilitates effective matching?

A. Parsing

B. Surviving

C. Tokenization

D. Data Mapping

E. Standardization

If a match pass has a match cutoff weight of 10 and a clerical cutoff weight of 8. what would be the weight range for clerical records?

A. 10 > Clerical Records > 8

B. 10 > Clerical Records >= 8

C. 10 >= Clerical Records > 8

D. 10>= Clerical Records >= 8

Which statement would NOT be a purpose for the matching process?

A. Creating the best record in the group.

B. Reconciling inventory or transactions.

C. Locating entities in a data warehouse.

D. Grouping records with the same or similar values, such as householding.

Which two are goals for re-engineering data?

A. Identifying duplicate records.

B. Masking personal information.

C. Optimizing database performance.

D. Identifying hidden attributes in free-form fields.

E. Monitoring database activity for sensitive objects.

What is the most optimized way to pass data between jobs?

A. Storing data in XML.

B. Storing data in text files.

C. Storing data in parallel datasets.

D. Storing data in indexed database tables.

A major international financial firm has clients in over 35 countries, including the U.S. and Japan. A requirement exists to standardize all addresses and validate the U.S. and Japanese physical addresses.

How can this be accomplished?

A. Use AVI to process all addresses within the single source.

B. Use USAC to certify the U.S. addresses, AVI for the Japan addresses and custom rule sets for the remaining countries.

C. Filter all the records by country. Use AVI for the U.S. and Japan and domain-specific rule sets for the remaining countries.

D. Filter U.S., Japan and remaining countries into individual files. Process the U.S. and Japan addresses through AVI and use MNS for the remaining countries.

Which statement represents the pattern that does NOT end with a number?

A. + | + | + | $

B. + | + | !A | $

C. + | + | nA | $

D. +1 + I <>A I $

You added a new field to matching fields of an existing match specification and provisioned all match specification components. Then you ran the job but it failed immediately. The input data size is 2G bytes and the job worked without any issues before you modified.

What is most likely the cause of the problem?

A. Lack of physical memory.

B. Lack of scratch disk space.

C. The job needs to be re-compiled.

D. The frequency file needs to be re-generated.

In addition to the QualityStage module, what product do you need to deploy a QualityStage job as a service?

A. DataStage

B. Federation Server

C. Tivoli Deployment Manager

D. Information Services Director

When exporting a rule set to a .dsx file, what check box options should be selected?

A. All check boxes are selected.

B. No check boxes are selected.

C. The Exclude Read Only items check box is selected and the Include Dependent Items check box is cleared.

D. The Exclude Read Only items check box is cleared and that the Include Dependent Items check box is selected.