Knowledge quiz

It's time to put what you've learned to the test, get 7 right to pass this week.

When doing data tiering, what is the most suitable dimension to allocate by?

Choose the correct answer.

Time

Color

Required Space

Random

What is the spaces concept?

Choose the correct answer.

An approach to separate data into neighborhoods

An approach to replicata data required for computational intensive tasks nearer to specific resources (e.g. hardware with specific simulation pipelines)

An approach to keep empty disk areas between data from different organizational units

A concept in programming languages to hook in algorithms at runtime

What are benefits of columnar databases?

There are two correct answers.

Columnar databases are beneficial for compression mechanisms

Aggregate and scan functions can better exploit prefetching

Direct access to tuples (tuple reconstruction) is faster than for row oriented databases

Backups are not necessary any longer

What are approaches to scalability?

There are two correct answers.

Scale up

Scale out

Scale over

Scale down

What is synchronous replication?

Choose the correct answer.

An approach to transfer data between two databases. Whatever happens on the primary database, will also be applied to the secondary database. It can be employed to achieve high availability.

An approach to speed up (re-)boot times. If a server fails, it is synchronously replicated from several backup servers, thus speeding up recovery and helps reducing downtimes.

A mechanism to coordinate several worker nodes via replication flags. It avoids work-stealing and thus increases reliability and re-calculations.

A song of a famous K-pop group which happens to be the favorite band of one of the HANA lead developers. Thus the name found its way into the concepts used to keeping the servers up and running in good mood.

Which property is not part of the database ACID criterias?

Choose the correct answer.

Atomicity

Consistency

Integration

Durability

What is elasticity in databases?

Choose the correct answer.

The ability to understand other languages than SQL

The ability to scale quickly

The ablitity to bend results to the users needs

The ability to integrate elastic search

What is the zone concept?

Choose the correct answer.

A zone co-locates data and applications for customers

A zone specifies how important the data is

A zone determines on which continent data should be stored

A zone is the same as a database table, but ensures the data stays within pre-set boundaries