Hitachi Vantara Exam HCE-5920 Topic 4 Question 56 Discussion

Actual exam question for Hitachi Vantara's HCE-5920 exam

Question #: 56
Topic #: 4

In a PDI transformation you are retrieving data from a large lookup table using a Database Lookup step from improve performance, you enable caching in the step and use the Load all data from table option.

In this scenario, which three statement s are correct about the data flow of the 'Database Lookup step? (Choose three.)

AWhen caching is enable, only rows with matching lookup values will passed through.

BThere must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.

CCached comparisons are case sensitive.

DEvery input row must have only one matching row in the lookup table

EOnly one matching row is used from the Lookup table.

Show Suggested Answer

Suggested Answer: A, B, C

by Lettie at Sep 18, 2024, 11:05 AM

Limited Time Offer

25%

11 months ago

Hmm, let's see... I'd go with B, C, and E. The case sensitivity thing is a real gotcha, you know?

upvoted 0 times

Francoise

10 months ago

E) Only one matching row is used from the Lookup table.

upvoted 0 times

...

Leeann

10 months ago

C) Cached comparisons are case sensitive.

upvoted 0 times

...

Omer

11 months ago

B) There must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.

upvoted 0 times

...

Della

11 months ago

Woah, this one's a toughie! But I think A, B, and E are the correct answers. Gotta love that caching, am I right?

upvoted 0 times

Lajuana

10 months ago

Yes, that's correct. Caching can make a big difference in data retrieval speed.

upvoted 0 times

...

Lili

10 months ago

I think you're right, A, B, and E are correct. Caching really helps with performance.

upvoted 0 times

...