Focus
Planner
News
Login
Get Started

Advanced databases

advanced-databases-1

Exit

Question 1 of 1

Time Left

0

200199

0

120

block

what is a data warehouse

Fill in the blanks

(0/0)

0

1

database designed for

2

3

and

4

3

5

of

6

4

7

data

4

200201

0

120

none

features of data warehouse

Match the text (click and drag)

(0/0)

0

Match the text
TIME VARIANT
SUBJECT ORIENTATED
NON-VOLATILE
INTEGRATED

0

1

2

3

4

Click and drag
data from multiple data sources
Once data is in the DW, it won’t change
analyse a particular subject area
Historical data kept in DW

4

200203

0

120

none

Operational database features

Select the correct answer(s).

(0/0)

0

1

2

3

1

4

2

5

3

6

7

4

8

5

200205

0

120

none

what is a dimensional schema

Fill in the blanks

(0/0)

0

1

and

2

3

data model as set of

4

3

5

that are described by

6

4

7

aspects of business

4

200209

0

120

none

dimensional schemas

Match the text (click and drag)

(0/0)

0

Match the text
STAR
SNOWFLAKE

0

1

2

Click and drag
One large central table – fact table, Set of smaller tables arranged in radial pattern around fact table – dimension tables
Multiple fact tables , Share dimensional tables between fact tables

2

200210

0

120

none

data warehousing basic concepts

Match the text (click and drag)

(0/0)

0

Match the text
FACTS
DIMENSIONS
MEASURES

0

1

2

3

Click and drag
Collection of members/units of same type of views
Collection of related data items (dimensions) and measures
Numeric attribute of a fact, representing performance/behaviour of business interests based on dimensional perspectives

3

200212

0

120

none

Applications of data warehousing

Match the text (click and drag)

(0/0)

0

Match the text
OLTP – online transactional processing
OLAP – online analytical processing

0

1

2

Click and drag
Info manipulation by reporting, dashboards, Supported by DW
Manipulate data by SQL, Supported by operational db

2

200213

0

120

none

Supporting data analytics

Match the text (click and drag)

(0/0)

0

Match the text
SLICE
DICE

0

1

2

Click and drag
Cutting horizontally through cube to another perspective so users can be more specific with data analysis
Cutting vertically through cube so users can focus on specific perspective

2

200217

0

120

none

DATA MANAGEMENT TOWARDS DATA ANALYTICS

Match the text (click and drag)

(0/0)

0

Match the text
Business Intelligence
Business Intelligence
BI Technologies
Predictive analytics
Predictive analytics
Predictive analytics
Descriptive analytics
Descriptive analytics

0

1

2

3

4

5

6

7

8

Click and drag
Categorising customers by product preferences and make predictions
Exploits patterns found in historical data – identify risks and opportunities
DW, OLAP, Data mining, text mining, process mining , Event processing, Benchmarking , Predictive/descriptive analytics
Meaningful insights for business purposes
Quantify different relationships between data and customers or products
Guides decision making concerning transactions
Uses statistical techniques – machine learning and data mining
Set of theories, methodologies, processes, architectures and technologies to handle raw data

8

200219

0

120

none

dashboards are a

Fill in the blanks

(0/0)

0

1

representation of

2

3

data

2

200222

0

120

none

a distributed database is

Select the correct answer(s).

(0/0)

0

1

2

3

1

200224

0

120

none

types of distributed database

Match the text (click and drag)

(0/0)

0

Match the text
HOMOGENEOUS
HETEROGENEOUS

0

1

2

Click and drag
different software on all nodes
same software on all nodes

2

200225

0

120

none

types of distributed database

Match the text (click and drag)

(0/0)

0

Match the text
HOMOGENEOUS
HETEROGENEOUS

0

1

2

Click and drag
same software on all nodes
different software on all nodes

2

200227

0

120

none

why distributed database

Select the correct answer(s).

(0/0)

0

1

2

3

4

5

6

4

7

5

200228

0

120

none

physical distribution

Fill in the blanks

(0/0)

0

1

Results

Correct

0 Incorrect

0 Skipped

0 Overall Percentage

0%

Saving quiz

Save Score

Rate Quiz

Save Rating

Exit

Correct Answer

You've answered correctly.

Answer Incorrect

You've answered incorrectly.

Out Of Time

You've ran out of time.

Save

To save scores or ratings you'll need to login or register.

Sign In

Register

Audio Settings

Language

Set the correct audio language for your text.

Danish Dutch English French German Icelandic Italian Japanese Korean Norwegian Polish Portuguese Romanian Russian Spanish Swedish Turkish Welsh

Highlighting

Improve your learning by highlighting words as they are spoken.

Word-By-Word Highlighting

Listen To Audio

You can play quizzes, courses and flashcards without needing to login. However to save scores and to make quizzes, courses and flashcards you'll need to be logged in. To play audio you'll need to be logged into a Professional Account.

Register Login

Listen To Audio

Take your learning to the next level. Upgrade to a Professional Account to hear your questions read aloud as well as enjoying many other benefits.

Audio is generated for any question or answer you create.

Many people learn better when they listen to what they're learning. For learning a foreign language we supported over 18 different languages.

Supported languages include Danish, Dutch, English, French, German, Icelandic, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Romanian, Russian, Spanish, Swedish, Turkish and Welsh.

We also support automatic word-by-word highlighting as words are read aloud.

Find Out More