When profiling, why is it good to sort the value lists in both ascending and descending order?
Options are :
A. None of the above.
B. There is no specific reason. It is simply a step of an ordered best practice approach.
C. Values with leading spaces or punctuation will typically sort to the top or bottom making them easier to identify.
D. It is good because it is easier to determine if a field is numeric or text.
正解:D
質問 2:
You have just standardized values in a field and you would like to review how the modified data appears alongside the original data. Which profiling method would best be suited for this?
Options are :
A. Comparative Profiling
B. Column Profiling
C. Mid Stream Profiling
D. Join Analysis Profile
正解:C
質問 3:
What is the best approach to implementing Address Validation in version 9.1?
Options are :
A. Remove all punctuation before sending the address to the AV transformation.
B. Take an iterative approach and review AV output. Determine why addresses did not validate and attempt to resolve the issue prior to running them in the AV transformation.
C. Run the addresses into the AV transformation without modification.
D. Canada Post defines the SERP certification standard for software applications that validate Canadian addresses.
正解:D
質問 4:
With regard to a Basic Import which of the following is FALSE?
A. The import can consist of an XML file and a Zip file containing the reference tables
B. A conflict resolution can be selected to apply to all imported objects.
C. Default is replace, options include rename or reuse.
D. Once added, the target will display resolution for each folder imported.
正解:C
質問 5:
What must you do in order to utilize Data Quality accelerators in PowerCenter? Choose 2 answers
A. Install accelerators into Developer
B. Import accelerators directly to Power Center
C. Export accelerator mapplets and/or mappings to PowerCenter
D. Install accelerators directly to PowerCenter
正解:C,D
質問 6:
Where does Scorecarding fit into the data quality process?
Options are :
A. At the start and during regular intervals of the process to measure on-going data quality levels
B. Not at all - Scorecardlng is a separate process
C. At the start of the process only to assess current data quality levels
D. At the end of the process only to prove the value of the data quality tool
正解:A
質問 7:
Which of the following is NOT a required step for using DQ for Excel?
A. In Excel, choose to Add a service and either enter the URL address or select the .wsdl or .xml file to be imported.
B. Export the Mapping to PowerCenter and test.
C. Create and Deploy the mapping as an Application.
D. Build and Test a web Services Mapping in the Developer Tool.
正解:A
松下** -
きっちりとまとまっていてわかりやすかったです。効率よくData-Quality-10-Developer-Specialist学習できそうです。