Data Virtualization MCQs (Chapterwise Multiple Choice Questions)

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

Application layer

Data consumer layer

Business layer

Physical layer

Answer & Explanation

Correct Answer: Data consumer layer

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

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 & Explanation

Correct Answer: Data Virtualization

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

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 & Explanation

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

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 & Explanation

Correct Answer: Def‌ining virtual tables

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

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 & Explanation

Correct Answer: Data staging area

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

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 & Explanation

Correct Answer: Data staging areas

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

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 & Explanation

Correct Answer: Typically. data is dynamic but dated.

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

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

Email

GIS

EIS

Video conference

Answer & Explanation

Correct Answer: Email

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

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

Yes

No

Answer & Explanation

Correct Answer: Yes

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

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 & Explanation

Correct Answer: It can limit innovations

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

Data Virtualization Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.