> > Data Virtualization MCQs > Basic Data Virtualization MCQs

Basic Data Virtualization MCQ

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

Windowstate

Fixeddouble

Minmaxsize

FormBorderStyle

Answer

Correct Answer: FormBorderStyle

Note: This Question is unanswered, help us to find answer for this one

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

Default VLAN

BPDU filter

Virtual server

VLAN hopping attack

Answer

Correct Answer: Default VLAN

Note: This Question is unanswered, help us to find answer for this one

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

True

XEN

False

None of the above

Answer

Correct Answer: XEN

Note: This Question is unanswered, help us to find answer for this one

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

Data types

Ranges

Indexes

Queries

Answer

Correct Answer: Queries

Note: This Question is unanswered, help us to find answer for this one

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

Data warehouse (DWH) data can be exposed to business users in the form of analytics and user-friendly reports through Bl tools.

OLAP cubes and metadata can be used to provide ad-hoc analysis capabilities to the end users.

Analytics tools cannot be run on a warehouse to discover patterns.

Analytics tools can be run on a warehouse to generate trends and forecasts .

Answer

Correct Answer: Analytics tools can be run on a warehouse to generate trends and forecasts .

Note: This Question is unanswered, help us to find answer for this one

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

Data abstraction is used to hide complexity.

Data abstraction is used to simplify information access.

It provides separate business views of data to every consumer.

It provides end-to-end control.

Answer

Correct Answer: Data abstraction is used to hide complexity.
Data abstraction is used to simplify information access.
It provides end-to-end control.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

GIS

EIS

Video conference

Answer

Correct Answer: Email

Note: This Question is unanswered, help us to find answer for this one

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

Cost/Budget is limited

Time urgency for solution implementation

Small data query result sets required

Data source is multidimensional

Answer

Correct Answer: Cost/Budget is limited
Time urgency for solution implementation
Small data query result sets required

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Operational data store

Production database

Personal data store

Data staging area

Answer

Correct Answer: Operational data store
Production database

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

It cannot be used in place of a data warehouse.

it can be used for an organization whose data is stored off-site by a third party cloud service provider.

it can be used as an enhancement to add attributes, which are not supported by data warehouse API.

All the statements given above are correct.

Answer

Correct Answer: it can be used for an organization whose data is stored off-site by a third party cloud service provider.
it can be used as an enhancement to add attributes, which are not supported by data warehouse API.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

It is a business intelligence architecture.

It delivers data to data consumers but does not deliver meta data.

It can deliver data that is stored in production systems/warehouses but cannot deliver from data mart

It can deliver unstructured data to data consumers.

Answer

Correct Answer: It is a business intelligence architecture.
It can deliver data that is stored in production systems/warehouses but cannot deliver from data mart
It can deliver unstructured data to data consumers.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Data owners lose control over their data that leads to security and privacy issues.

It has short initial implementation time but cost is high

It takes time and costs high to add new data sources.

It provides unlimited flexibility of use and types of users.

Answer

Correct Answer: Data owners lose control over their data that leads to security and privacy issues.
It takes time and costs high to add new data sources.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

It reduces the risk of data errors.

It increases the speed to access data.

It does not require a governance approach to avoid budgeting issues.

It is suitable for recording historic data snapshots.

Answer

Correct Answer: It reduces the risk of data errors.
It increases the speed to access data.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Data warehouse focuses on Data in. whereas operational database focuses on Information out

Data warehouse contains historical data, whereas operational database contains current data

Data warehouse provides consolidated data. whereas operational database provides highly detailed data.

Data warehouse is used to analyze business. whereas operational database is used to run the Business.

Answer

Correct Answer: Data warehouse contains historical data, whereas operational database contains current data
Data warehouse provides consolidated data. whereas operational database provides highly detailed data.
Data warehouse is used to analyze business. whereas operational database is used to run the Business.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Production database

Data warehouse (DWH)

Personal data store (PDS)

Both a and b

Both b and c

Answer

Correct Answer: Both a and b

Note: This Question is unanswered, help us to find answer for this one

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

It reduces the cost.

It supports simple and powerful interfaces for querying data using JSON that enables quick development of applications.

It provides support for semi-structured data.

It does not provide support for unstructured data.

Answer

Correct Answer: It reduces the cost.
It supports simple and powerful interfaces for querying data using JSON that enables quick development of applications.
It provides support for semi-structured data.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Designing data structures

Def‌ining mappings

Def‌ining virtual tables

Installing a database server

Answer

Correct Answer: Designing data structures
Def‌ining mappings
Def‌ining virtual tables

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Def‌ining mappings

Def‌ining data structures

Def‌ining ETL logic for data transformation

Enabling caching

Answer

Correct Answer: Def‌ining data structures
Def‌ining ETL logic for data transformation

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Denodo Technologies

IBM

lnformatica

None of the above

Answer

Correct Answer: Denodo Technologies
IBM
lnformatica

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Virtual tables

Source tables

Mappings

SOAP services

Answer

Correct Answer: Virtual tables
Source tables
Mappings

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

PDSs

Data staging areas

Data marts

Production data stores

Answer

Correct Answer: PDSs
Data marts

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Production data stores

Data staging areas

Data marts

None of the above

Answer

Correct Answer: Production data stores
Data staging areas

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Only the functionality of the component systems is responsible

Lack of storage capacity

The architectural view of an information system

Only the business rules and integrity constraints are responsible

Answer

Correct Answer: Lack of storage capacity
The architectural view of an information system

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

They are instances of applications.

They can be created from physical databases as well as abstracted databases.

They cannot be created from APls.

They cannot be created quickly.

Answer

Correct Answer: They are instances of applications.
They can be created from physical databases as well as abstracted databases.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Operational data store

Data staging area

Data warehouse

Data mart

Answer

Correct Answer: Operational data store
Data staging area

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Accounting and f‌inancial models

Representational models

Optimization models

None of the above

Answer

Correct Answer: Accounting and f‌inancial models
Representational models
Optimization models

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

27.
With reference to federated database systems (FDBSs), which of the following schemas is used to
represent a subset of a component schema that is available to a specif‌ic federation?

Answer

Correct Answer:

Note: This Question is unanswered, help us to find answer for this one

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

Tables are organized around a central fact table.

Surrogate keys are not used.

A fact table has relationships only with the dimension tables.

Answer

Correct Answer:
Surrogate keys are not used.

Note: This Question is unanswered, help us to find answer for this one

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

Star schema

Snowflake schema

Both star schema and snowflake schema

Neither star schema nor snowflake schema

Answer

Correct Answer: Snowflake schema

Note: This Question is unanswered, help us to find answer for this one

30.
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?

Data Warehouses

Portals

Operational data stores

Answer

Correct Answer: Portals

Note: This Question is unanswered, help us to find answer for this one

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

All 1. 2 and 3 can be performed.

Only1 and 3 can be performed.

Only 2 and 3 can be performed.

Answer

Correct Answer:
All 1. 2 and 3 can be performed.

Note: This Question is unanswered, help us to find answer for this one

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

All 1. 2 and 3 can be used

Only1 and 3 can be used

Only 1 and 2 can be used

Answer

Correct Answer:
All 1. 2 and 3 can be used

Note: This Question is unanswered, help us to find answer for this one

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

Data warehouse

Online analytical processing (OLAP)

Business performance management (BPM)

a and c

a. b and c

Answer

Correct Answer: a. b and c

Note: This Question is unanswered, help us to find answer for this one

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

It imposes a heterogeneous data model.

It cannot impact the response time of an operational system.

It decreases the requirement of data storage.

None of the above statements is correct

Answer

Correct Answer: It decreases the requirement of data storage.

Note: This Question is unanswered, help us to find answer for this one

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

Model-driven DSS

Document-driven DSS

Communication-driven and group DSS

None of the above

Answer

Correct Answer: Document-driven DSS

Note: This Question is unanswered, help us to find answer for this one

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

Yes

No

Answer

Correct Answer: Yes

Note: This Question is unanswered, help us to find answer for this one

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

Only 1, 3, 4

Only 1, 2, 3

Only 1, 2, 4

All 1, 2, 3, 4

Answer

Correct Answer: All 1, 2, 3, 4

Note: This Question is unanswered, help us to find answer for this one

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

Denormalized schemas

Normalized schemas

Either of the above given options

Answer

Correct Answer: Denormalized schemas

Note: This Question is unanswered, help us to find answer for this one

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

Physical layer

Application layer

Business layer

All of the above

Answer

Correct Answer: Physical layer

Note: This Question is unanswered, help us to find answer for this one

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

Application layer

Physical layer

Data sources layer

Consumer layer

Answer

Correct Answer: Data sources layer

Note: This Question is unanswered, help us to find answer for this one

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

Data flow within an organization and business to business transactions cannot be visualized.

Relationships between process flows cannot be visualized.

It can limit innovations

None of the above.

Answer

Correct Answer: It can limit innovations

Note: This Question is unanswered, help us to find answer for this one

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

Production databases

Replicated databases

Both a and b

Answer

Correct Answer: Production databases

Note: This Question is unanswered, help us to find answer for this one

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

It provides low data consistency.

It provides support for consolidated analytics platform.

Performing custom analytics on data warehouse brings down the performance of the DWI-l

Both b and c are correct.

Answer

Correct Answer: Performing custom analytics on data warehouse brings down the performance of the DWI-l

Note: This Question is unanswered, help us to find answer for this one

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

Schema on read.

Schema on write.

Both a and b are used in the traditional Bl architecture.

None of the above is used in the traditional Bl architecture.

Answer

Correct Answer: Schema on read.

Note: This Question is unanswered, help us to find answer for this one

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

Business layer

Physical layer

Application layer

Both b and c

Answer

Correct Answer: Application layer

Note: This Question is unanswered, help us to find answer for this one

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

Data source layer

Application layer

Physical layer

None of the above

Answer

Correct Answer: Physical layer

Note: This Question is unanswered, help us to find answer for this one

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

Exact transfer load

Replication

Exact Load transform

Both b and c

Answer

Correct Answer: Replication

Note: This Question is unanswered, help us to find answer for this one

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

3 Sharing of meta data specification

3 Decoupling of data consumers and data stores

3 Both a and b

2) Neither a nor b

Answer

Correct Answer: 3 Both a and b

Note: This Question is unanswered, help us to find answer for this one

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

Component schema

External schema

Export schema

Federated schema

Answer

Correct Answer: Export schema

Note: This Question is unanswered, help us to find answer for this one

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

File-based data access

Object-based storage

Block-based data access

None of the above

Answer

Correct Answer: Block-based data access

Note: This Question is unanswered, help us to find answer for this one

51.
Which of the following statements are correct about decision support system (D85) and business intelligence (8|)?
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.

All 1, 2, 3 are correct

Only 1, 2 are correct

Only 2, 3 are correct

Only 1, 3 are correct

Answer

Correct Answer: Only 1, 3 are correct

Note: This Question is unanswered, help us to find answer for this one

52.
Which of the following are the technical benefits that are Obtained through data virtualization over data materialization?
1. Ease Of data integration
2. Iterative development
3. Increased developer productivity

All 1, 2, 3

Only 1, 2

Only 1, 3

Only 2, 3

Answer

Correct Answer: All 1, 2, 3

Note: This Question is unanswered, help us to find answer for this one

53. Which of the following statements is incorrect?

Data abstraction is the handling Of data in meaningful ways.

Abstract properties are visible to the consumer of abstracted data type.

Physical instances are visible to the consumer of abstracted data type.

Abstraction allows data consumers to leverage the adoption of XML industry standards.

Answer

Correct Answer: Physical instances are visible to the consumer of abstracted data type.

Note: This Question is unanswered, help us to find answer for this one

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

No communication between clients and services can take place ifthe ESB is down.

It can decrease the performance of client-service communication due to extra level of indirection.

It cannot authenticate and authorize a client before forwarding service requests to services.

Answer

Correct Answer:
No communication between clients and services can take place ifthe ESB is down.

It can decrease the performance of client-service communication due to extra level of indirection.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

Data virtualization can augment the capabilities of a data warehouse.

Self-service Bl methods can be facilitated through data virtualization.

Data virtualization cannot help in prototyping and sandboxing.

All of the above statements are correct.

Answer

Correct Answer: Data virtualization can augment the capabilities of a data warehouse.
Self-service Bl methods can be facilitated through data virtualization.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

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

All 1, 2, 3

Only 1 and 2

Only 2 and 3

Only 1 and 3

Answer

Correct Answer: All 1, 2, 3

Note: This Question is unanswered, help us to find answer for this one

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

It is used to remove data from data warehouse (DWH).

It is used to modify DWH data.

It involves the process of data collection in different forms and making them uniformly consistent with each other.

t is a process of loading transformed data into the data warehouse.

Answer

Correct Answer: It involves the process of data collection in different forms and making them uniformly consistent with each other.

Note: This Question is unanswered, help us to find answer for this one

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

It is used to access source data.

It links data from different sources.

It provides data to BI server.

Answer

Correct Answer: It is used to access source data.
It links data from different sources.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

59.
Which of the following statements is/are correct about the 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.

Only statement 1 is correct

Only statement 3 is correct

Both statements 1 and 2 are correct

Both statements 2 and 3 are correct

Answer

Correct Answer: Only statement 1 is correct

Note: This Question is unanswered, help us to find answer for this one

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

SLA Management

Distributed Processes

Metadata Management

Data Virtualization

Answer

Correct Answer: Data Virtualization

Note: This Question is unanswered, help us to find answer for this one

61.
Analyze the information given below and answer the question that follows.
"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."
What is the source of the given information?

Gartner

Forrester

Wayne Eckerson

Answer

Correct Answer: Forrester

Note: This Question is unanswered, help us to find answer for this one

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

Data staging area

Data warehouse

Data mart

None of the above

Answer

Correct Answer: Data staging area

Note: This Question is unanswered, help us to find answer for this one

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

Yes

No

Answer

Correct Answer: Yes

Note: This Question is unanswered, help us to find answer for this one

64.
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

Only 3 can be used

Only 1 and 3 can be used

Only 2 and 3 can be used

All 1, 2 and 3 can be used

Answer

Correct Answer: All 1, 2 and 3 can be used

Note: This Question is unanswered, help us to find answer for this one

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

Mediated query systems

Operational data stores

Federated database systems

Answer

Correct Answer:
Operational data stores

Note: This Question is unanswered, help us to find answer for this one

66. Can database servers be used for data transformation?

Yes

No

Answer

Correct Answer: Yes

Note: This Question is unanswered, help us to find answer for this one

67.
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?

Workflow Management System

Personal Data integration system

Medicated Query System

Dataspace system

Answer

Correct Answer: Dataspace system

Note: This Question is unanswered, help us to find answer for this one

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

Typically. data is dynamic but dated.

Typically, no data drilldown capabilities are available.

Difficult to accommodate changes in data source schema.

Cannot actively monitor data changes

Answer

Correct Answer: Typically. data is dynamic but dated.

Note: This Question is unanswered, help us to find answer for this one

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

Application layer

Data consumer layer

Business layer

Physical layer

Answer

Correct Answer: Data consumer layer

Note: This Question is unanswered, help us to find answer for this one

70.
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?

Data Virtualization

Distributed Process

Repository Management

Taxonomy/Ontology Resolution

Answer

Correct Answer:
Taxonomy/Ontology Resolution

Note: This Question is unanswered, help us to find answer for this one

71.
Value-added tasks such as name aliasing, value formatting and data type casting are performed in which of the following layers?

Application Layer

Business Layer

Physical Layer

Answer

Correct Answer: Physical Layer

Note: This Question is unanswered, help us to find answer for this one

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

Application layer

Physical Layer

Business Layer

Answer

Correct Answer: Physical Layer

Note: This Question is unanswered, help us to find answer for this one

73.
Analyze the information given below and answer the question that follows.
"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."
What is the source of the given information?

Gartner

Forrester

Wayne Eckerson

Answer

Correct Answer:
Gartner

Note: This Question is unanswered, help us to find answer for this one

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

Heterogeneity

Autonomy

Schema Mapping

Answer

Correct Answer: Schema Mapping

Note: This Question is unanswered, help us to find answer for this one

Data Virtualization MCQs | Topic-wise

MCQ on Basic Data Virtualization General Data Virtualization MCQs

Data Virtualization Subjects

More Resources

Data Virtualization MCQ

Data Virtualization Skill Assessment

Data Virtualization PDF

Related MCQs

ADO.NET MCQs

CMDB MCQs

Database MCQs

NoSQL MCQs

Transact-SQL (T-SQL) MCQs

Join our newsletter for the latest updates.

Coming Soon

Our Products

Skill Assessment

Categories

MCQs

Company

About

Advertising

Privacy Policy

Terms & Conditions

Sitemap

Contact

Blog

Back to top

Coming Soon

© Copyrights 2026 Quizack.com

Basic Data Virtualization MCQ

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

27. With reference to federated database systems (FDBSs), which of the following schemas is used torepresent a subset of a component schema that is available to a specif‌ic federation?

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

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

30. 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?

31. Which of the following operations can be performed with the PowerPivot workbook feature of Microsoft Excel 2010?1. Dimensional data models can be created2. Dirty data can be identified and removed3. Data models can be published to SharePoint

32. A virtual data warehouse can be developed by using which Of the following options?1. Data marts2. Production databases3. Data virtualization server

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

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

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

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

37. Which of the following options are the existing components of a traditional Bl big data framework?1. DWH2. OLAP3. Metadata4. Reports

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

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

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

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

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

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

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

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

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

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

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

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

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

52. Which of the following are the technical benefits that are Obtained through data virtualization over data materialization?1. Ease Of data integration2. Iterative development3. Increased developer productivity

53. Which of the following statements is incorrect?

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

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

56. Which of the following are the components of a logical data warehouse?1. Repository Management2. Auditing Statistics and Performance Evaluation Services3. SLA Management

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

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

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

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

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

64. Which Of the following can be used in order to access virtualized data?1. Enterprise service bus2. Object-relational mapper3. Dedicated data virtualization server

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

66. Can database servers be used for data transformation?

67. 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?

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

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

70. 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?

71. Value-added tasks such as name aliasing, value formatting and data type casting are performed in which of the following layers?

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

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

27.
With reference to federated database systems (FDBSs), which of the following schemas is used to
represent a subset of a component schema that is available to a specif‌ic federation?

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

30.
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?

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

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

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

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

52.
Which of the following are the technical benefits that are Obtained through data virtualization over data materialization?
1. Ease Of data integration
2. Iterative development
3. Increased developer productivity

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

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

64.
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

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

67.
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?

70.
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?

71.
Value-added tasks such as name aliasing, value formatting and data type casting are performed in which of the following layers?

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