Check our public questions below
Solve questions to get feedback or
take a practice test and get a free certificate.
The Data Warehouse online test assesses candidates' knowledge of data warehouses and their ability to design them.
It's an ideal test for pre-employment screening of candidates applying for roles such as Big Data Engineers, Data Warehouse Developers, and Data Warehouse Administrators.
This online test requires candidates to answer multiple-choice questions about how data warehouses are designed, how to convert a relational model to a snowflake or star schema, and how to work with OLAP cubes.
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:
What operations should be performed to transform the first OLAP cube into the second OLAP cube?
A construction supply company wants to implement a data warehouse to analyze the performance of their online portal for ordering custom cuts of lumber.
Their sales data is currently stored in two separate transaction processing relational databases, one contains inventory and the other one contains sales data. Both databases save their data in a normalized schema. One of the reasons for implementing a data warehouse is that it takes too much time to query the databases for average sales data and inventory status, which causes some online transactions to timeout.
How should the data warehouse be implemented?
A grocery shop is using the following tables in their relational database:
TABLE Product id INTEGER name VARCHAR categoryId INTEGER REFERENCES ProductCategory(id) TABLE ProductCategory id INTEGER name VARCHAR TABLE ProductSale id INTEGER productId INTEGER REFERENCES Product(id) price DECIMAL date DATE
The company has decided to implement a data warehouse since their analytic queries have started causing issues by consuming most database resources.
As a first step, the company wants to create a star schema of the previous tables. Which tables should be present in the star schema?
Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.
From web development and database administration to project management and customer support. See all pre-made tests.
Mix questions for different skills or even custom questions in one short test. See an example.