Exam4Training

What is the correct way to optimize this query without modifying the column?

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char (5| They frequently restrict on this column, but the query is very inefficient.

What is the correct way to optimize this query without modifying the column?
A . Create a copy of FACT_SALES table with zip_code as integer data type.
B . alter table fact_sales to organize on zip_code. followed by groom.
C . CREATE ORGANIZED view for FACT_SALES table
D . Create a view with a typecast to integer and use view for query purposes

Answer: C

Latest C1000-085 Dumps Valid Version with 60 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version