IBM Exam C1000-085 Topic 7 Question 4 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 4
Topic #: 7

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?

ACreate a copy of FACT_SALES table with zip_code as integer data type.

Balter table fact_sales to organize on zip_code. followed by groom.

CCREATE ORGANIZED view for FACT_SALES table

DCreate a view with a typecast to integer and use view for query purposes

Show Suggested Answer

Suggested Answer: C

by Laurel at May 08, 2022, 04:43 PM

Limited Time Offer

25%

Off

Get Premium C1000-085 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!