Data Federation — Learn free

Self-check

Questions 1–10 of 10

1. To which kind of data store is data federation restricted?
Question 1A. NoSQL databasesB. Web services and SaaS applicationsC. Relational databasesD. Data appliancesE. Enterprise applications
2. What does data virtualization create that data federation does not?
Question 2A. A unified data modelB. A physical copy of the dataC. An ETL pipelineD. A backup of the source systemsE. An access control list
3. The relationship between data federation and data virtualization is compared to the relationship between which pair?
Question 3A. Data warehouse and data martB. OLTP and OLAPC. Data mining and data scienceD. Encryption and encodingE. Data lake and data swamp
4. Why do data federation and data virtualization require no additional storage?
Question 4A. Because they compress the source data heavilyB. Because they hold only a virtual copy rather than a separate copy of the dataC. Because they delete data after each queryD. Because they store data in the cloud rather than on-premisesE. Because they only ever read summary tables
5. Why is data federation described as low risk compared with a data warehouse or data lake?
Question 5A. Because it applies stronger encryptionB. Because it never allows write accessC. Because it is not hosting a data copy, so there is no chance of missing any dataD. Because it runs only on relational databasesE. Because it caches every query result
6. Which of the following is a listed drawback shared by data federation and data virtualization?
Question 6A. Data must be physically moved through ETLB. Users must learn a different query language for each sourceC. Historical data is not maintainedD. A separate storage copy is requiredE. Only one data store can be accessed at a time
7. How do data federation and data virtualization make querying easier for users?
Question 7A. By generating dashboards automaticallyB. By letting users write in one language while a wrapper talks to all connected systemsC. By replicating all data into a single relational databaseD. By limiting queries to a single source at a timeE. By pre-computing every possible aggregate
8. Which of the following is NOT listed as a shared behaviour of data federation and data virtualization?
Question 8A. Single access pointB. User access management in one placeC. No data movementD. Complete historical copies of source dataE. Data quality issues identified from a single point
9. Why do data federation and data virtualization need dedicated involvement from data stewards and functional consultants?
Question 9A. Because functional knowledge of the connected sources is requiredB. Because they must approve every ETL jobC. Because the tools cannot connect without manual scriptingD. Because they must maintain the historical archiveE. Because relational databases require licences
10. Alongside which data store are data federation and data virtualization best suited?
Question 10A. A data swampB. A message queueC. A spreadsheetD. A data warehouse in placeE. A scraping tool