Question
Which of the following does not contribute to early
identification of stressed assets?Solution
Profitability ratios are backward-looking; they do not directly indicate asset stress in real-time.
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?