Qlik Exam QV12SA Topic 4 Question 29 Discussion

Actual exam question for Qlik's QV12SA exam

Question #: 29
Topic #: 4

A system administrator needs to create a task that creates new QlikView documents with data associated with the Year field only. The QlikView documents need to be created using the Document Name and the values in the Year field.

What should the administrator do to meet the requirement?

ASet the Reduced Document name field to %SourceDocumentName% %yyyy% and the Simple Reduce value field to Year

BSet the Reduced Document name field to %SourceDocumentName% %yyyy% and the Loop and Reduce with Field value field to Year

CSet the Reduced Document name field to %SourceDocumentName% %DocumentField,Year% and the Simple Reduce value field to Year

DSet the Reduced Document name field to %SourceDocumentName% %DocumentField,Year% and the Loop and Reduce with Field value field to Year

Show Suggested Answer

Suggested Answer: C, E

by Audra at Jul 29, 2023, 08:45 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Dannette

20 days ago

D) Ah, the classic 'Loop and Reduce' approach. It's like trying to solve a problem with a sledgehammer when a scalpel would do the trick. But hey, if it works, it works!

upvoted 0 times

...

Alfred

22 days ago

Haha, C) is a little too complex. Why bother with the %DocumentField,Year% when you can just use %yyyy% in the Reduced Document name field? Simple is better, my friend.

upvoted 0 times

Talia

8 days ago

A) Set the Reduced Document name field to %SourceDocumentName% %yyyy% and the Simple Reduce value field to Year

upvoted 0 times

...

Staci

1 months ago

But option A specifies using the Simple Reduce value field, which makes more sense in this scenario.

upvoted 0 times

...

Adela

1 months ago

B) This is the way to go. The Loop and Reduce with Field value field to Year will create a new document for each unique value in the Year field, which is exactly what the requirement asks for.

upvoted 0 times

Beatriz

4 days ago

B) Set the Reduced Document name field to %SourceDocumentName% %yyyy% and the Loop and Reduce with Field value field to Year

upvoted 0 times

...

Ira

1 months ago

A) Looks good to me. The %SourceDocumentName% %yyyy% in the Reduced Document name field will create new documents with the original name and the year. And the Simple Reduce value field to Year will make sure the new documents only have data for the Year field.

upvoted 0 times

...

Lelia

1 months ago

I disagree, I believe option B is the correct choice.

upvoted 0 times

...

Staci

1 months ago

I think the administrator should choose option A.

upvoted 0 times

...