Data Ware Housing - IT & Programming
Practice questions to test your knowledge and improve your understanding.
Which MDX operation returns all possible combinations of one or more sets?
Data quality management refers to the fact that:
Modifying an OLAP Cube to view information from only a single year is an example of which operation?
Normalisation is:
When is it appropriate to use a Joiner Transformation during ETL?
Which of the following is true about multidimensional models?
Which Data Mining technique partitions the database so that each partition or group is similar according to some criteria or metric ?
The modification of data as it is moved into the data warehouse is:
In which component of the enterprise is the data re-organised for analysis and information extracted from the data?
Which of the following is not a valid context for the MDX From clause?
Which of the following is TRUE about MOLAP?
A data warehouse is an ‘integrated’ collection of data because?
In order to populate the data warehouse, which of the following set of operations are appropriate?
A datawarehouse should be able to implement advanced query functionality. This means :
The main objects used by OLAP programs are:
What are the following is not a requirement of First Normal Form?
Which technique of Data Mining involves developing mathematical structures with the ability to learn?
Which of the following can present summary data from an OLAP server?
Which language is appropriate for querying a non-relational OLAP database?
Which of the following type of data is most likely to be stored on some form of mass storage ?
What is a slice in the context of Amazon Redshift?
Which of the following is TRUE about ROLAP?
Data Warehouse (OLAP) is based on which of the following?
Which of the following is not TRUE about subject oriented characteristics of a data warehouse?
Which of the following uses the idea of a data cube to represent the dimensions of data ?
What property do Router Transformations and Filter Transformations have in common?
The requirement that the datawarehouse RDBMS server must support hundreds and thousands of concurrent users while maintaining an acceptable query performance is known as:
Which of the following is true about 'Pivot' operation?
In a star schema, the central table which contains the individual facts being stored in the database is called a:
Which of the following is true about Data Scrubbing?
Which of the following applies to Fact Tables?
Which system is appropriate for recording customer transactions in real time?
Metadata does not include:
Data Volatility describes:
The logical organisation of data in a database is called:
Under OLAP terminology, slice and dice refers to:
Which of the following operation is performed by introducing new dimensions?
Choose the most correct statement:
The Metadata of the data warehouse should at least contain:
Which of the following would be the only similarity between a datawarehouse and OLTP system?
Which of following stages involve data update in the warehouse for every transaction performed on the source data?
In the Discovery model of Data Mining, the emphasis is on which of the following?
Which of the following rules would be considered the central core of OLAP?
Which of the following techniques can be used to improve query performance?
Which of the following operations navigate data from less detailed data to highly detailed data?
Which of the following is not a property of a perspective?
A slice is:
Which of the following would not be an application of Data Mining in the banking field?
Which of the following is true about Data mining?
Which operation on a multidimensional database is most equivalent to a relational join?