Data Warehousing

Data Warehousing

Professional Development

25 Qs

quiz-placeholder

Similar activities

Petjah Community

Petjah Community

Professional Development

20 Qs

Gadjian Level : Easy

Gadjian Level : Easy

Professional Development

20 Qs

Microsoft Teams Competition

Microsoft Teams Competition

University - Professional Development

20 Qs

DP-900 Aula - 04

DP-900 Aula - 04

Professional Development

20 Qs

Post Test Artificial Intelligence dan Scratch

Post Test Artificial Intelligence dan Scratch

KG - Professional Development

20 Qs

PRE TEST - MI 10 & MI COMMERCE

PRE TEST - MI 10 & MI COMMERCE

Professional Development

20 Qs

Kirby quiz!!!!!!

Kirby quiz!!!!!!

Professional Development

21 Qs

Lesson 5 Quiz

Lesson 5 Quiz

University - Professional Development

20 Qs

Data Warehousing

Data Warehousing

Assessment

Quiz

Instructional Technology

Professional Development

Practice Problem

Medium

Created by

Firoz Khan

Used 20+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

25 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which one is correct for data warehousing?

It can be updated by end users

It can solve all business questions

It is designed for focus subject areas

It contains only current data

2.

MULTIPLE SELECT QUESTION

1 min • 1 pt

Which are used in Multi-dimensional modeling?

Foreign key

Fact Table

Dimensional Table

Surrogate key

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which one come first to build data warehouse

Data Cleansing

Business questions

Data Acquisition

Data Profiling

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Why aggregate is used in dimensional model of data warehouse?

To store data in one operational system

To retrieve data from an operational system

To combine data from heterogeneous sources

To take the dimension and change its granularity

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Why do we apply snowflake schema?

Aggregation

Normalization

Generalization

Transformation

6.

MULTIPLE SELECT QUESTION

3 mins • 1 pt

What is metadata in data warehousing? You may answer more than one

Business definition

Data dictionary

BI report

Measures

7.

MULTIPLE SELECT QUESTION

3 mins • 1 pt

What is CORRECT about data warehouse? You may answer more than one

It makes use of historical data to answer business questions

It reveals insight from data

It supports roll-up and drill-down to explore data

Its design is the same as database

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?