Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with...

IBM C1000-085 Full Course Access
IBM C1000-085 View All Questions

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

C1000-085 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now C1000-085 pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
When choosing a distribution key for a large fact table, what is a valid choice?
What is the maximum length of a CHAR/VARCHAR column?
Previous