In Pentaho Data Integration, a hop is
8. Question 8 In Pentaho Data Integration, a hop is 1 point a process in a data flow such as input/output, sort, filter, lookup, and validation. a directed…
The Canvas in the Talend integrated development environment contains
6. Question 6 The Canvas in the Talend integrated development environment contains 1 point the outline of components in a job. a list of folders containing components. …
The ETL architecture
4. Question 4 The ETL architecture 1 point performs transformations before loading typically using a transformation engine separate from a DBMS. performs transformations after loading typically using a…
Indicate the typical components of job management for data integration tools
2. Question 2 Indicate the typical components of job management for data integration tools 1 point Publisher/subscriber specifications Monitoring including logging and performance alerts and reports Scheduling…
Identify the FALSE choice about quasi identifiers.
8. Question 8 Identify the FALSE choice about quasi identifiers. 1 point Can consist of individual fields or combinations of fields Must be unique in each data source…
The edit operations to transform the source string “Saturday” to the target string “Sunday” are
10. Question 10 The edit operations to transform the source string “Saturday” to the target string “Sunday” are 1 point 2 deletions and 2 substitutions 2 insertions and…
Choose the search strings matched by the search expression: “cd{1,3}e”. You should ignore the quotation marks in the regular expression and search strings.
7. Question 7 Choose the search strings matched by the search expression: “cd{1,3}e”. You should ignore the quotation marks in the regular expression and search strings. 1 point “cdce”…
Select the following choice that is FALSE about the initial data warehouse load process.
4. Question 4 Select the following choice that is FALSE about the initial data warehouse load process. 1 point Typically discover many data quality problems during the load process…
Metaphone distance refines soundex using
9. Question 9 Metaphone distance refines soundex using 1 point No consonant sounds. 16 consonant sounds. 6 consonant sounds. 12 consonant sounds.
Identify enumerated or range characters among the following choices.
7. Question 7 Identify enumerated or range characters among the following choices. 1 point $ to match at the end of a string . to match at the…
