IBM
A2090-614 · Question #40
A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows: What can be done to improve the performance of a query that joins…
The correct answer is D. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh. See the full explanation below for the reasoning.
Question
A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows:
What can be done to improve the performance of a query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?
Options
- AReload table SALES and use only one partition with a collocated join to the DATE_DIM table
- BReload table DATE_DIM and use only one partition with a collocated join to the SALES table
- CCreate a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table,
- DCreate a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh
How the community answered
(40 responses)- A5% (2)
- B13% (5)
- C3% (1)
- D80% (32)
Community Discussion
No community discussion yet for this question.