Question
In the following question, out of the given four
alternatives, select the one which best expresses the meaning of the given word. FiendishSolution
The correct answer is B
Which schema uses multiple fact tables sharing dimension tables?
What is the main purpose of a data mart?
Which SQL clause is used to summarize data?
In OLAP, “Slice and Dice” means:
Which OLAP operation rotates the data axes to provide an alternative presentation?
Which of these is not a typical data warehouse characteristic?
Which type of slowly changing dimension (SCD) preserves full history by adding a new row for each change and using effective date ranges?
In a data warehouse, a fact table typically contains:
A snowflake schema differs from a star schema mainly because:
Which of the following is a key process in ETL?