MENU
There is a QlikView document with separate "City" and "State" fields A system administrator needs to create separate QVW documents each with a singular "City and State" field.
Which method should the system administrator use?
Suggested Answer: C
Get Premium QV12SA Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
31 comments · newest first
VI
Vivienne
11 months ago
Not sure if concatenating is the best approach...
SH
Sharen
11 months ago
I'm surprised they need to create separate docs for this!
AN
Annice
11 months ago
Wait, why not just use option B? Seems simpler.
TI
Timmy
11 months ago
Definitely agree with that! Concatenation makes sense.
TY
Tyra
11 months ago
I think option C is the way to go!
SV
Svetlana
12 months ago
I’m leaning towards option B, but I recall that we discussed how concatenation can sometimes simplify the process. I just can’t remember if it’s required here.
TA
Tamar
12 months ago
I feel like option C is the best choice since it explicitly mentions concatenating before reducing, which seems necessary for this task.
CE
Celia
12 months ago
I think looping and reducing by 'City and State' makes sense, but I’m a bit confused about whether we need to concatenate first.
OR
Oretha
1 year ago
I remember we practiced something similar where we had to combine fields, but I'm not sure if concatenating is the right approach here.
VA
Valentin
1 year ago
This seems like a pretty standard QlikView administration task. I'd go with option C - concatenate the fields and then loop and reduce by the combined "City and State" field. That way, we can create the separate QVW documents with the desired single field structure.
JU
Julio
1 year ago
I'm a little confused by the wording of the question. Does "loop and reduce" mean we need to use some kind of looping or iterative process to create the new documents? I'll have to review my QlikView knowledge to figure out the best approach here.
IV
Ivan
1 year ago
Hmm, I'm a bit unsure about this one. I know we need to create separate QVW documents with a single "City and State" field, but I'm not sure which method is the best approach. I'll have to think this through carefully.
FE
Felicidad
1 year ago
This looks like a straightforward question about QlikView document management. I think the key is to understand how to properly concatenate the "City" and "State" fields to create a single "City and State" field.
RU
Ruth
1 year ago
Okay, let's see. I think the answer is C - concatenate the "City" and "State" fields, then loop and reduce by the combined "City and State" field. That seems like the most logical way to achieve the desired result.
EL
Eleonore
1 year ago
Okay, I think I've got this. The key here is to minimize operational effort, so I'm leaning towards the Amazon RDS Proxy option (D). That way, we can still use the Aurora MySQL DB but offload the connection management to the proxy. Seems like the most straightforward solution.
JA
Jacki
1 year ago
I'm just picturing the system administrator trying to figure out how to spell 'concatenate' during the exam. That's the real challenge here.
AN
Antonio
1 year ago
I'm going to have to go with option B. Looping and reducing by 'City and State' just sounds like the most efficient way to handle this. Plus, it's got a nice ring to it, don't you think?
JE
Jeffrey
1 year ago
I would go with option D, it includes creating a bookmark for 'City and State'.
VI
Virgina
1 year ago
I think option C could work too, by concatenating 'City' and 'State' first.
JO
Jolene
1 year ago
I agree, option B does seem like the most efficient choice.
MA
Marshall
1 year ago
Option D with the bookmark seems a bit overkill. I don't think we need to create a bookmark for this task. C is the way to go.
SH
Sheron
1 year ago
Yeah, creating a bookmark for this task does seem unnecessary. Concatenating 'City' and 'State' then looping and reducing by 'City and State' should work just fine.
WA
Walton
1 year ago
I think concatenating 'City' and 'State' first before looping and reducing by 'City and State' is the best approach.
LE
Leslie
1 year ago
I agree, option C seems like the most efficient method for this task.
CR
Cristina
1 year ago
I'm not sure why we need to loop and reduce at all. Couldn't we just concatenate the 'City' and 'State' fields and be done with it? That would give us the singular 'City and State' field we're looking for.
AL
Alyce
1 year ago
User 2
MA
Macy
1 year ago
User 1
DO
Dortha
1 year ago
Option C seems the most straightforward. Concatenating the 'City' and 'State' fields and then looping and reducing by the combined 'City and State' field is a logical approach.
HA
Hannah
1 year ago
Why do you think option B is better?
GE
Gertude
2 years ago
I disagree, I believe option B is the best method.
HA
Hannah
2 years ago
I think the system administrator should use option C.