Data Consolidation — Learn free

Self-check

Questions 1–10 of 10

1. How does data consolidation differ from data virtualization and data federation?
Question 1A. It is restricted to relational databasesB. It keeps complete historical copies of data from all source systemsC. It never uses ETL or ELTD. It creates only virtual views over the sourcesE. It exposes data through a single query language
2. Which of the following is a data consolidation environment?
Question 2A. A data virtualization semantic layerB. A federated query wrapperC. A data warehouseD. A VPNE. A web scraping tool
3. Which of the following does NOT fall under the umbrella of data consolidation?
Question 3A. Data martB. Data lakeC. Delta lakeD. Business vaultE. Data federation
4. What processing sometimes takes place during data consolidation?
Question 4A. A complex ETL or ELT to process data into different data modelsB. Real-time write-back into the source systemsC. Encryption of every columnD. Deletion of historical recordsE. Conversion of relational data into web services
5. Data virtualization, data federation and data consolidation are discussed together with respect to what?
Question 5A. Encrypting data at restB. Exposing data to data consumersC. Scraping data from websitesD. Choosing a cloud vendorE. Reducing storage costs
6. Besides transforming data into different models, what other data model approach can a consolidation environment maintain?
Question 6A. A virtual-only modelB. A one-to-one data model with the sourceC. A model with no keysD. A model that discards historyE. A federated relational model
7. Which of these approaches hosts no copy of data in its own environment?
Question 7A. Data warehouseB. Data lakeC. Data vaultD. Data federationE. Data mart
8. Under which umbrella do data vaults and business vaults fall?
Question 8A. Data consolidationB. Data virtualizationC. Data federationD. Data sovereigntyE. Data encoding
9. What is the scope of the copies kept in a data consolidation environment?
Question 9A. Only the latest snapshot of each sourceB. Only data from relational sourcesC. Complete historical copies of all data from all source systemsD. Only aggregated summariesE. Only data that has passed quality checks
10. Which statement about data consolidation is correct?
Question 10A. It always requires a complex ETLB. It never maintains a one-to-one modelC. It is a virtual layer without storageD. It may use a complex ETL or ELT, or maintain a one-to-one data modelE. It is limited to data lakes