Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Data Warehouse and CRISP-DM

Total questions: 10

Worksheet time: 6mins

Name
Class
Date
1.
What is a Data Mart?
a)
A data mart is a subgroup of the data warehouse
b)
A data mart is another type of data warehouse
c)
A data mart is not actually related to data warehouses
d)
None of these
2.

Which among the two is the modern approach that handles all the transformation in data warehouse?

a)

ETL

b)

ELT

3.

Data warehousing system mostly used for what purpose?

a)

Data integration and Data Mining

b)

Data Mining and Data Storage

c)

Reporting and Data Analysis

d)

Data Cleaning and Data Storage

4.

Data warehouse is based on_____________

a)

two dimensional model

b)

three dimensional model

c)

multidimensional model

d)

unidirectional model

5.

Following Job scope belongs to::

1. Data Cleaning

2. Statistic analysis

3. Analysing the trend

4. creating Visualization and dashboard

a)

Data Scientist

b)

Data Analyst

c)

Data Engineer

d)

Business Leader

6.

Which part of CRISP DM is this: Build Model Parameter Settings - Model Description

a)

Business Understanding

b)

Data Understanding

c)

Data Preparation

d)

Modelling

e)

Evaluation

7.

Which part of CRISP DM is this: Describe Data -Data Description Report

a)

Business Understanding

b)

Data Understanding

c)

Data Preparation

d)

Modelling

e)

Evaluation

8.

Which part of CRISP DM is this: Determine Business Objectives - Business Success Criteria

a)

Business Understanding

b)

Data Understanding

c)

Data Preparation

d)

Modelling

e)

Evaluation

9.

1. ____________ is the process of the discovering useful patterns and trends in large data set.

a)

Data Mining

b)

Data cleaning

c)

Data processing

d)

Data warehouse

10.

CRISP-DM full form___________________________

a)

Cross-Industry Standard Process for Data Mining

b)

crossed - industry standard process for data mining

c)

cross -industry standard processing for data mining

d)

cross-industry standard preprocessor for data mining