9. Question 9 In the Gartner market summary of data integration products, ability to execute involves 1 point product performance features. recent stock price performance. breadth and…
3. Question 3 Publisher/subscriber specification is an important part of change data capture in a data integration tool. 1 point True False
7. Question 7 In Pentaho Data Integration, a step is 1 point an execution sequence. a data flow with steps connected by hops. a process in a…
5. Question 5 The ELT architecture 1 point performs transformations and loading concurrently. performs transformations after loading typically using a DBMS for transformations. requires a DBMS to…
10. Question 10 Identify TRUE statements about the Open Core Model. 1 point Commercial software versions with proprietary extensions beyond the core product Paid subscription services to augment core…
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…
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. …
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…
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…
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…
