General MCQ for Data Virtualization

1. In data virtualization architecture, app server works at which of the following layers?

2. Can database servers be used for data transformation?

3. Can we def‌ine a nested virtual table in data virtualization server with mapping?

4. In business intelligence architecture, which of the following data stores contains volatile data?

5. ln data virtualization, which of the following statements are incorrect about an application layer?

6. Which of the following statements is incorrect?

7. With reference to federated database systems (FDBSs), which of the following schemas is an integration of multiple export schemes?

8. In data virtualization architecture, which of the following layers is the lowest layer to store data?

9. A table can contain duplicate data while working with which of the following schemas?

10. According to data virtualization architecture, can Bl servers accept data directly from application layer?

11. Bl architecture consists of which of the following components?

12. Dimension tables are normalized in which of the following schemas?

13. Which of the following models can be used by a model-driven decision support system?

14. Data integration problem is caused by which of the following reasons?

15. When Extract Transform Load (ETL) technology is used for transforming data, which of the following are generally used as the source data stores?

16. Which of the following are the main building blocks of a data virtualization server?

17. Which of the following activities is/are required for setting up a virtual data mart?

18. With reference to business intelligence architecture, which of the following data stores is/are used to store detailed data?

19. Which of the following statements is/are correct about data federation technology?

20. Which of the following options fall under communication-driven DSS?

21. Which of the following are the benef‌its of data abstraction?

22. Which of the following options are correct about traditional Bl architecture?