MCQs > Database Management > 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.

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.

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.

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)?

Answer

Correct Answer: Queries

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

14. When Extract Transform Load (ETL) technology is used for transforming data, which of the following are generally used as the target 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

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

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

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

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

17.

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?