Daily News Performance

Management of a multinational news company would like to see how the number of viewers of different news sections varies per country, for each day.

The data is in an OLAP cube and needs to be transformed to get the data the management is looking for. Below are the diagrams of starting and expected OLAP cubes:

An OLAP cubeAn OLAP cube

What operations should be performed to transform the first OLAP cube into the second OLAP cube?

(Select all acceptable answers.)

Tags

  • AI-resistant
  • Data Warehouse
  • Drilldown
  • OLAP Operations
  • Pivot
  • New
  • Public
  • Easy

Information

Difficulty: Easy

Duration: 3 min

Score Distribution

% of candidates
0-33%
34-67%
68-100%
Score

Would you like to see our other questions?

We have 1000+ premium hand-crafted questions for 160+ job skills and 20+ coding languages. We prefer questions with small samples of actual work over academic problems or brain teasers.

Would you like to see our tests?

The following tests contain Data Warehouse related questions:

On the blog

Since we're all biased and we use incorrect proxies, why not just outsource hiring to experts or recruitment agencies? After all, they've been screening people for many years, so they must know how to do it right?

Not really. I was surprised to discover that many experts...