General Data Virtualization MCQs

1. With reference to virtual database, which of the following refers to dealing with query syntax or incompatible data types?

2. Data integration includes the practices, architectural techniques, and tools used to gain consistent access to data. regardless of data structure type or group, in order to meet the requirements of applications and business processes

3. In which of the following layers of data abstraction architecture, data sources are integrated into the abstraction?

4.

5. Which of the following components Of the logical data warehouse provides abstracted and semantic layer overview of enterprise data across virtualized, distributed and repository-based sources?

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

7. Which of the following Options is NOT a disadvantage of data warehouse (DWH)?

8. Generally six approaches are used for data integration problem: manual integration, common user interface, integration by applications, integration by middleware, uniform data access and common data storage. Which of the following systems use all the six integration approaches simultaneously?

9. Can database servers be used for data transformation?

10. Which of the following is an example of the common data storage approach toward data integration problem?

11. Which Of the following can be used in order to access virtualized data? 1. Enterprise service bus 2. Object-relational mapper 3. Dedicated data virtualization server

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

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

14. The most successful implementation of data virtualization uses a layered architecture that combines physical and virtual data stores at the appropriate levels to fit different performance requirements for different areas within the company.

15. Which of the following components of logical data warehouse is used to integrate data virtually within/beyond an enterprise?

16. Correct statements about distributed processes component of logical data warehouse? 1. It is used to integrate big data sources such as Hadoop with distributed processes performed in the cloud. 2. It provides abstracted and semantic layer overview of enterprise data across virtualized sources. 3. It provides data governance, auditability and lineage required.

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

18. In the ETL process, what is the function Of data cleansing?

19. Which components of a logical data warehouse? 1. Repository Management 2. Auditing Statistics and Performance Evaluation Services 3. SLA Management

20. Which of the following statements are correct about data virtualization?

21. ln data virtualization architecture, which of the following statements is/are correct about an enterprise service bus (ESB) working at the data consumer layer?

22. Which of the following statements is incorrect?

23.

24. decision support system (D85) and business intelligence 1. Decision support system is a computer program application that can be used to analyze business data. 2. Business intelligence (Bl) can be used to present business data, whereas decision support system (DSS) cannot be used. 3. Business intelligence is a category of applications and technologies that can be used for collecting, storing and analyzing data.

25. Which of the following is the lowest level of access, and the fundamental building block for all storage?

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

27. Which of the following is/are the fundamental concepts about data delivery platform (DDP)?

28. In which of the following techniques, data is copied from the source either record-wise or transaction-Wise?

29. Which of the following immediate layers in business intelligence architecture is responsible for transferring data to the business layer?

30. Which of the following layers is/are responsible for presenting user—friendly data?

31. Which of the following approaches is NOT used in the traditional approach for business intelligence

32. Which of the following statements is/are correct about traditional Bl - DataStack 2.0?

33. Reporting on which of the following databases can cause concurrency issues?

34. Business process management (BPM) works at the data consumer layer in data virtualization architecture. Which of the following is correct about BPM?

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

36. Business intelligence servers can accept data directly from which of the following layers?

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

38. Which of the following options are the existing components of a traditional Bl big data framework? 1. DWH 2. OLAP 3. Metadata 4. Reports

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

40. A search engine tool is associated with which of the following decision support systems?

41. Which of the following statements is correct about data virtualization software?

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

43. A virtual data warehouse can be developed by using which Of the following options? 1. Data marts 2. Production databases 3. Data virtualization server

44. Which operation can be performed with the PowerPivot workbook feature of Excel ? 1. Dimensional data models can be created 2. Dirty data can be identified and removed 3. Data models can be published to SharePoint

45. With reference to data integration problem, which of the following serve an example of uniform data access that are personalized doorways to intranet or internet. and where every user is provided with information according to their requirement?

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

47. Which of the following statements is NOT correct about snowflake schemas in business intelligence architecture?

48.

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

50. In business intelligence architecture, which of the following data stores does not contain time-variant or historical data?

51. Which of the following statements are correct about Mashups?

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

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

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

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

56. Which of the following vendors provide data virtualization software?

57. While setting up a virtual data mart, which of the following activities are NOT required?

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

59. In business intelligence, which of the following statements are correct in the case when big data is adopted?

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

61. Which of the following are the differences between data warehouse and operational database?

62. What are the benefits of a data virtualization software?

63. Which of the following options are correct about data warehouse (DWH)?

64. Which of the following statements is/are correct about data delivery platform (DDP)?

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

66. In business intelligence architecture, integrated data is stored in which of the following data stores?

67. Which of the following factors make the application of data visualization highly recommended?

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

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

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

71. To which Of the following options, it is difficult to accommodate changes in data warehouse (DWH)?

72. The _________ hypervisor is an example of an open source project.

73. A switch is typically preconfigured with one _______________ that includes all its ports.

74. The ________ property can prevent the user from resizing your application's form at runtime.