Qlik QV12BA Exam - Topic 3 Question 18 Discussion

Actual exam question for Qlik's QV12BA exam

Question #: 18
Topic #: 3

[All QV12BA Questions]

Refer to the exhibit.

Which is the highest performing expression to accurately count the number of Account Owners?

ACOUNT (%AccountOwnerId)

BCOUNT(AccountOwnerld)

CCOUNT(DISTINCT %AccountOwnerId)

DCOUNT(TOTAL %AccountOwnerId)

Show Suggested Answer

Suggested Answer: C

by Weldon at May 03, 2022, 12:31 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Shala

7 months ago

Not sure about COUNT(DISTINCT %AccountOwnerId), could be overkill.

upvoted 0 times

...

Aleta

7 months ago

COUNT(%AccountOwnerId) is definitely the simplest choice.

upvoted 0 times

...

Ming

7 months ago

Surprised that COUNT(TOTAL %AccountOwnerId) is even an option!

upvoted 0 times

...

Candra

7 months ago

I disagree, COUNT(DISTINCT %AccountOwnerId) seems more accurate.

upvoted 0 times

...

Tarra

7 months ago

I think COUNT(AccountOwnerId) is the best option.

upvoted 0 times

...

Monte

8 months ago

I’m a bit confused about the use of the percentage sign in the options. Does it mean anything specific for the COUNT function?

upvoted 0 times

...

Temeka

8 months ago

I feel like we practiced a similar question, and I think COUNT(TOTAL %AccountOwnerId) was mentioned as less efficient.

upvoted 0 times

...

Sylvia

8 months ago

I remember we discussed how COUNT can be affected by null values, so I think option B might be the safest choice.

upvoted 0 times

...

Maybelle

8 months ago

I’m not entirely sure, but I think COUNT(DISTINCT %AccountOwnerId) could be useful if there are duplicates.

upvoted 0 times

...

Lon

8 months ago

This looks like a straightforward question about choosing a digital forensics service provider. I'm pretty confident I can identify the two key attributes they're looking for.

upvoted 0 times

...