QlikView QSBA2018 Exam Practice Questions (P. 1)
- Full Access (50 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #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?
✑ 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?
- AChange the ProductGroup dimension using the new field, and create a new dimension in the master items for the old field.Most Voted
- BCreate a calculated dimension on the charts to allow the users to compare the new value to the old value.
- CReplace the dimensions on all charts to use the new ProductGroup field added to the data model.
- DUse set analysis on the chart measures to see the difference in ProductGroup between the new field and the old field.
Correct Answer:
D
D
send
light_mode
delete
Question #2
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.)
✑ 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.)
- ARight-click the Date field in the assets panel and Select Create calendar measures
- BRight-click the Sales field in the assets panel and Select Create calendar measuresMost Voted
- CSelect Date, Sales, Sum, and QuarterlyMost Voted
- DSales to master items, rename master itemsMost Voted
- ESelect Date, Sales, Sum, and Yearly
Correct Answer:
ABC
ABC
send
light_mode
delete
Question #3
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 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.)
- ACustomer Ranking
- BNumber of PurchasesMost Voted
- CPurchase AmountMost Voted
- DNumber of Products
- ECorrelation
Correct Answer:
BC
BC
send
light_mode
delete
Question #4
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?
The business analyst creates a bar chart with the measure, Sum(Revenue).
Which final step should the business analyst take to complete the chart?
- AAdd Region, Product Category, and Month as three different dimensions
- BCreate a single master dimension with Region, Product Category, and Month
- CAdd Region as a dimension, add Product Category and Month as alternate dimensionsMost Voted
- DCreate a cyclic group with Region, Product Category, and Month as dimensions
Correct Answer:
C
C
send
light_mode
delete
Question #5
A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays.
Leadership needs the following capabilities:
✑ Ability to view the total donation amount
✑ Ability to identify departments that raise $10,000 or more
Which two visualizations should the business analyst use without set analysis to meet these requirements? (Choose two.)
Leadership needs the following capabilities:
✑ Ability to view the total donation amount
✑ Ability to identify departments that raise $10,000 or more
Which two visualizations should the business analyst use without set analysis to meet these requirements? (Choose two.)
send
light_mode
delete
All Pages