Here you have the best QlikView QSBA2018 practice exam questions
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?
To meet the requirements, the best approach is to change the ProductGroup dimension to use the new field, and then create a new master dimension for the old field. This allows the existing charts to utilize the new values while keeping the old values accessible for comparison. This method ensures that all existing charts are updated to reflect the new ProductGroup values and also provides the ability to compare old and new values effectively.
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.)
To create new master items for quarterly calendar measures with company-specific conventions based on the Date field and the Sum of Sales, the business analyst should follow these steps: Right-click the Sales field in the assets panel and Select Create calendar measures, as Sales is the measure to be analyzed. Then, select Date, Sales, Sum, and Quarterly to define the appropriate time frame and aggregation for the calculations. Finally, save the created measures to master items and rename them according to the specified conventions, ensuring they are correctly identified and used in analyses.
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.)
To meet the requirements of the dashboard, the business analyst should use the 'Number of Purchases' and 'Purchase Amount' measures. 'Number of Purchases' is required for the table showing the total number of purchases by customer and the scatter plot displaying the correlation between purchases and total spent. 'Purchase Amount' is needed for the scatter plot and for the bar chart showing the top five customers by sales.
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?
To create a bar chart with a single measure and three dimensions, the final step should be to add Region, Product Category, and Month as three different dimensions. This will make the chart display the measure, Sum(Revenue), segmented by each of the three dimensions to meet the client's requirement.
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.)
To meet the required capabilities of viewing the total donation amount and identifying departments that raise $10,000 or more, two visualizations are ideal. The KPI is useful for displaying a single, important metric such as the total donation amount in a clear and concise manner. The bar chart is suitable for comparing the donation amounts of different departments, making it easy to identify which departments have raised $10,000 or more.