QlikView QSBA2018 Qlik Sense Business Analyst Certification Exam Version: 1.2 Practice Exams

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Write down your full name.

Write down your phone number.

Write down your email address.

QUESTION NO: 1 A data architect adds a field to an existing data model that contains new values for the Product Group. 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 Product Group Existing charts must use the new values for Product Group Business users must be able to compare the new and old values How should the business analyst meet these requirements?

1 point

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.

Clear selection

QUESTION NO: 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.)

1 point

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

QUESTION NO: 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.)

1 point

A. Customer Ranking

B. Number of Purchases

C. Purchase Amount

D. Number of Products

E. Correlation

QUESTION NO: 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?

1 point

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

Clear selection

QUESTION NO: 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.)

1 point

A. Pie chart

B. Box plot

C. Bar chart

D. KPI

E. Treemap

QUESTION NO: 6 A business analyst is building an app for a customer: The customer wants to be able to: Show row-level transaction details Access an overview of the most important numbers Analyze data How should the business analyst order the sheets to meet these requirements?

1 point

A. 1. Dashboard: sheet for the overview 2. Report: sheet for the row-level details 3. Analysis: sheet for the analysis

B. 1. Analysis: sheet for the analysis 2. Dashboard: sheet for the overview 3. Report: sheet for the row-level details

C. 1. Report: sheet for the row-level details 2. Dashboard: sheet for the overview 3. Analysis: sheet for the analysis

D. 1. Dashboard: sheet for the overview 2. Analysis: sheet for the analysis 3. Report: sheet for the row-level details

Clear selection

QUESTION NO: 7 A retailer with 300 locations worldwide needs to analyze its workforce to prepare for its next board meeting. The two most important items to the board members are total compensation and number of employees by city. Which visualization should a business analyst use to meet this requirement?

1 point

A. Scatter plot

B. Bar chart

C. Pivot table

D. Map

Clear selection

QUESTION NO: 8 A business analyst wants to develop a Qlik Sense app with some key performance indicators on the dashboard. The analyst decides to use two KPI objects to represent key metrics for the organization. Which two measures should the business analyst use to meet these requirements? (Choose two.)

1 point

A. Margin by region

B. Number of products by customer

C. Number of customers

D. Number of products sold

E. Number of customers by region

QUESTION NO: 9 A bus company wants to analyze customer travel patterns to add additional services or create new routes. The business analyst needs to consider the following data:190 routes across the city Start and end location of each route Volume of customers travelling per hour Customer complaints when buses are full Which visualization should a business analyst use to meet this requirement?

1 point

A. Area layer map

B. Treemap

C. Line layer map

D. Scatter plot

Clear selection

QUESTION NO: 10 A business analyst must adjust and create new visualizations on a published app in Qlik Sense Enterprise. The changes need to be made very quickly. Which two actions can the business analyst perform in the app on the hub? (Choose two.)

1 point

A. Duplicate sheets to edit visualizations

B. Create new sheets and visualizations

C. Add data to the app

D. Create and edit master items

E. Create variables in the app

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms