Question
Which two signs should be interchanged to make the below
equation mathematically correct? 9 ÷ 3 + 6 – 6 × 2 = 30Solution
The correct answer is B
Which schema uses multiple fact tables sharing dimension tables?
Which type of OLAP allows analysis of multidimensional data stored in relational databases?
What is meant by 'cardinality' in data modeling?
Which OLAP operation allows users to view data at different levels of granularity?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which of the following best describes a Data Warehouse?
Which type of schema normalizes dimension tables to reduce redundancy?
Which OLAP operation rotates the data axes to provide an alternative presentation?
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Relevant for Exams:
