IBM IBM Certified Solution Developer C2090-304 Questions & Answers

• Question 31:

  Which acronym is also referred to as CASS?

  A. AVI.

  B. GEO.

  C. MNS.

  D. US AC.

  Correct Answer: D

• Question 32:

  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.

  Correct Answer: A

• Question 33:

  Which match type would you use to perform a "fuzzy" match for a field containing many un- parsed words (such as a comments field)?

  A. CNT_DIFF

  B. PRORATED

  C. MULT_EXACT

  D. MULT_UNCERT

  Correct Answer: C

• Question 34:

  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.

  Correct Answer: AB

• Question 35:

  A complex QualityStage job is running slowly on a two CPU server. The parallel engine configuration file contains eight nodes.

  How can performance be improved?

  A. Reduce scratch space in configuration file.

  B. Increase scratch space in configuration file.

  C. Reduce number of nodes in configuration file.

  D. Increase number of nodes in configuration file.

  Correct Answer: B

• Question 36:

  A transaction date field has format MM-DD-YYYY. The customer wants to see how many records contain a valid month in the transaction date field. Which mask type should be used in the Character Discrete investigation?

  A. TTXXXXXXXX

  B. CCXXXXXXXX

  C. CCTTTTTTTT

  D. TTCCCCCCCC

  Correct Answer: D

• Question 37:

  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.

  Correct Answer: B

• Question 38:

  What are two purposes of Standardization processing?

  A. It removes duplicate data elements.

  B. It identifies best record to move forward in processing.

  C. It certifies and verifies data elements based on USPS postal standards.

  D. It places each value into a single domain field, and transforms data into a standard format.

  E. It applies consistent representations, corrects misspellings, and incorporates business or industry standards.

  Correct Answer: AE

• Question 39:

  Which statement is NOT a task for the MNS stage?

  A. Assigns ISO country codes <2 and 3 byte versions).

  B. Separates city-level address information from province-level information.

  C. Assigns city, locality, province/state, postal code, and postal code add-on to separate fields.

  D. Assigns city name phonetics with enhanced New York State Information and Intelligence Systems (NYSIIS) and reverse Soundex to match incorrectly spelled city names.

  Correct Answer: C

• Question 40:

  Which of these statements is NOT true?

  A. NLS can only process multi-byte characters.

  B. NLS supports various languages and countries.

  C. You can process Japanese data in an English version of QualityStage.

  D. When installing a non-English language version of QualityStage, NLS is enabled automatically.

  Correct Answer: B