IBM
A2090-614 · Question #40
A2090-614 Question #40: Real Exam Question with Answer & Explanation
Sign in or unlock A2090-614 to reveal the answer and full explanation for question #40. The question stem and answer options stay visible for context.
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
Unlock A2090-614 to see the answer
You've previewed enough free A2090-614 questions. Unlock A2090-614 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.