Search Header Logo

Data Virtualization, Lakehouse, Platform and Architecture Quiz

Authored by Nicole Nie

Computers

University

Used 4+ times

Data Virtualization, Lakehouse, Platform and Architecture Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

User requirement in a data warehouse project is urgent but not yet confirmed, may change in a short term. Which way is recommended?

Prototype with a view to deliver solution, and change the view logic along with the requirement change, and rebuild it to ETL after requirement is confirmed.

Directly develop ETL process base on developer's understanding because it saves effort.

Develop ETL process after user requirement is finally confirmed.

2.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

Which of the below belongs to Data Virtualization? (multiple choice)

Pivot table of raw data table in an Excel worksheet.

Physical table stored in Storage Grid.

A view built on a DB table.

a data service API, the data is from heterogeneous data sources.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT the capacity of a Data Virtualization Platform?

ETL

Caching

Optimization

Transformation

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is in Operation phase of a Data Virtualization project?

User acceptance test

Design Metadata

Monitor performance

Study and explore source data

5.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

what is a data lakehouse? (multiple choice)

A data lakehouse removes the walls between lakes and warehouses

marrying the low-cost, flexible storage of a data lake with the data management, schema, and governance of a warehouse

A data lakehouse acts as a single platform for storing both structured and unstructured data, supporting a variety of workloads from batch processing to real-time analytics.

Data lakehouses enforce schema on read and write operations, bringing the governance and reliability of data warehouses to the flexibility of data lakes.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main benefit of using a data lakehouse architecture over traditional data warehouses?

Reduced data storage capabilities

Improved performance for transactional databases

Enhanced data governance and a unified platform for different data workloads

Higher dependency on proprietary file formats

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which feature of a data lakehouse ensures transactional consistency and accuracy for data analytics workloads?

Use of structured data only

ACID transactions

Dependence on a single data format

Lack of schema enforcement

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?