MENU
Two of the tables in the QlikView data model are InvoiceHeader (one million rows) and InvoiceDetail (nine million rows) InvoicelD links the two Invoice tables.
This expression is used several times in the QlikView application, count (distinct invoiceiT)
How can a business analyst optimize this expression for use in the application?
Suggested Answer: D
Get Premium QV12BA Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
19 comments · newest first
AN
Anthony
11 months ago
Sorting the table first is definitely a good move!
BA
Barabara
11 months ago
I disagree, option A seems more efficient to me.
GL
Glenna
12 months ago
Wait, can we really optimize that much with just a script change?
IR
Iraida
12 months ago
I think option B makes the most sense here.
AN
Annamae
1 year ago
The InvoiceDetail table has nine million rows, wow!
JA
Jacquelyne
1 year ago
I believe option D could be a good choice since it focuses on the InvoiceHeader table, but I’m not entirely sure how that impacts performance.
AL
Aliza
1 year ago
I practiced a similar question where we had to optimize counts, and I feel like using Peek() might be the right direction, but I’m not confident about the syntax.
MA
Mary
1 year ago
I think option B sounds familiar, but I can't recall if adding "I" as DistinctlnvoicelD is the best approach.
VA
Vashti
1 year ago
I remember we discussed optimizing expressions in QlikView, but I'm not sure if sorting the InvoiceDetail table is necessary.
SK
Skye
1 year ago
I thought adding DistinctlnvoicelD to the InvoiceHeader table was a common method, but I'm not confident if that's the best way to optimize in this case.
FE
Felicidad
1 year ago
I practiced a similar question where we had to optimize counts, and I feel like using Peek() could be a good strategy, but I'm unsure about the exact syntax.
ST
Stefania
1 year ago
I think option B sounds familiar, but I can't recall if adding "I" as DistinctlnvoicelD is the right approach.
LO
Lorean
1 year ago
I remember we discussed optimizing expressions in QlikView, but I'm not sure if sorting the InvoiceDetail table is necessary.
TE
Terina
1 year ago
I remember practicing a question about revenue recognition that mentioned something about matching expenses, so I wonder if that's relevant here.
LU
Luis
1 year ago
I'm a little confused by this question. The options seem pretty technical, and I'm not sure I fully understand the differences between SNMP, syslog, REST API, and pxGrid. I'll need to review my notes and maybe ask the instructor for some clarification.
NA
Natalie
1 year ago
Okay, I think I've got a plan. The Search Job Inspector can show me statistics on how much time and how many events each indexer has processed. That should help me understand where the bottleneck might be and if the search is truly taking too long to run.
JA
Jamal
1 year ago
I think the Salesforce Identity Connect is the way to go here. That should provide the integration with Active Directory that we need, without requiring a mobile VPN. The other options don't seem as relevant.
LA
Lashonda
1 year ago
Okay, I'll first calculate the total minutes needed per day: 50 requests × 30 minutes = 1500 minutes
ER
Erick
1 year ago
I'm a little confused by the wording on the decision table options. I'm not sure which one is the correct answer based on the information provided. I may need to re-read the question a few times to make sure I'm understanding it properly.