Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

QlikView QSBA2018 Exam Actual Questions

The questions for QSBA2018 were last updated on May 3, 2024.
  • Viewing page 1 out of 13 pages.
  • Viewing questions 1-4 out of 50 questions

Topic 1 - Single Topic

Question #1 Topic 1

A data architect adds a field to an existing data model that contains new values for the ProductGroup. The business analyst needs to efficiently update the app and meet these requirements:
✑ Use the existing charts, which are built using a master item dimension called ProductGroup
✑ Existing charts must use the new values for ProductGroup
✑ Business users must be able to compare the new and old values
How should the business analyst meet these requirements?

  • A. Change the ProductGroup dimension using the new field, and create a new dimension in the master items for the old field.
  • B. Create a calculated dimension on the charts to allow the users to compare the new value to the old value.
  • C. Replace the dimensions on all charts to use the new ProductGroup field added to the data model.
  • D. Use set analysis on the chart measures to see the difference in ProductGroup between the new field and the old field.
Reveal Solution Hide Solution   Discussion   4

Correct Answer: D 🗳️

Question #2 Topic 1

A business analysis must create new master items for quarterly calendar measures with company-specific conventions based on:
✑ The Date field and the Sum of Sales
✑ The new master items will calculate QTD Sales, Current QTD Sales, Last QTD Sales, Current Quarter Sales, Last Year Current Quarter Sales, and Last

Quarter Sales -
Which three steps should the business analyst take to meet these requirements? (Choose three.)

  • A. Right-click the Date field in the assets panel and Select Create calendar measures
  • B. Right-click the Sales field in the assets panel and Select Create calendar measures
  • C. Select Date, Sales, Sum, and Quarterly
  • D. Sales to master items, rename master items
  • E. Select Date, Sales, Sum, and Yearly
Reveal Solution Hide Solution   Discussion   4

Correct Answer: ABC 🗳️

Question #3 Topic 1

A business analyst is building a dashboard to track customer loyalty. The app has several requirements:
✑ A table that shows the total number of purchases by customer
✑ A scatter plot that shows the correlation between the number of purchases and total spent by customer
✑ A bar chart that shows the top five customers by sales
Which two measures should the business analyst use to meet these requirements? (Choose two.)

  • A. Customer Ranking
  • B. Number of Purchases
  • C. Purchase Amount
  • D. Number of Products
  • E. Correlation
Reveal Solution Hide Solution   Discussion   2

Correct Answer: BC 🗳️

Question #4 Topic 1

A client wants to see a bar chart with a single measure and three dimensions: Region, Product Category, and Month.
The business analyst creates a bar chart with the measure, Sum(Revenue).
Which final step should the business analyst take to complete the chart?

  • A. Add Region, Product Category, and Month as three different dimensions
  • B. Create a single master dimension with Region, Product Category, and Month
  • C. Add Region as a dimension, add Product Category and Month as alternate dimensions
  • D. Create a cyclic group with Region, Product Category, and Month as dimensions
Reveal Solution Hide Solution   Discussion   4

Correct Answer: C 🗳️

Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...