QlikView QlikView Certification QSBA2018 Questions & Answers

• Question 1:

  

  Refer to the exhibit.

  A business analyst must update an app by adding a new table called `Invoices'. This table must be associated to the existing mode via reference code values.

  `Full Invoice No' includes the `CostCenter Code', the `Department Code', and a `Reference Code'.

  The CostCenter Code is NOT relevant for further analysis, so the analyst must split this new field into two new columns.

  Which set of actions should the business analyst take to meet these requirements?

  A. 1. Select the split marker

  2.

  Click This instance

  3.

  Uncheck the first column

  4.

  Rename the fields

  5.

  Click Create fields

  B. 1. Select the split marker

  2.

  Click All Instances

  3.

  Uncheck the last two columns

  4.

  Rename the fields

  5.

  Click Reset

  C. 1. Select the split marker

  2.

  Click This Instance

  3.

  Uncheck the last two columns

  4.

  Rename the fields

  5.

  Click Reset

  D. 1. Select the split marker

  2.

  Click All Instances

  3.

  Uncheck the first column

  4.

  Rename the fields

  5.

  Click Create fields

  Correct Answer: D

• Question 2:

  Which two features/functions are enabled by the Qlik Associative Engine?

  A. Smart search and mashups

  B. Insight advisor and smart search

  C. Insight advisor and data profiling

  D. Smart search and data profiling

  Correct Answer: B

• Question 3:

  A Qlik Sense Enterprise data architect creates and publishes an app to a stream and gives access to users. The users do NOT have access to Qlick Management Console All dimensions and measures used in the app are created in the master items library

  Which two actions can the users perform? (Choose two.)

  A. Create charts using dimensions and measures from master items

  B. Export stories created in the app to a PDF of PowerPoint format

  C. Export the data model to a QVD format and load it into another app

  D. Create a calculated measure for a chart and add it to master items

  E. Export the app from the hub and open it in Qlick Sense Desktop

  Correct Answer: AC

• Question 4:

  A business analyst needs to add some images to a slide in a story in their personal workspace in Qlik Sense Enterprise.

  What should the business analyst do to meet this requirement?

  A. Use the image import wizard within the hub and add to the story slide

  B. Copy and paste the images onto the story slide

  C. Upload the images to the media library and add to the story slide

  D. Drag and drop the images onto the story slide

  Correct Answer: C

  Reference: https://help.qlik.com/en-US/sense/February2019/pdf/Collaborate%20in%20Qlik%20Sense.pdf

• Question 5:

  A business analyst has a QVD containing Sales, Manager, Date, and Region.

  The business analyst needs to quickly create a sheet with three visualizations: Total Sales, Sales By Manager, and Sales by Date. The sheet must allow for analysis by Region.

  In the search bar, the analyst enters "Sales", "Manager", and "Date", and adds the objects to the sheet.

  Which steps should the business analyst perform to finish creating the sheet?

  A. 1. Add two filter panes: Region and Sales

  2.

  Drag and drop Manager from the Fields list onto the sheet

  3.

  Add a line chart with Date as the dimension and Sales as the measure

  B. 1. Add two filter panes: Date and Manager

  2.

  Drag and drop Sales from the Fields list onto the sheet

  3.

  Add a line chart with Manager as the dimension and Sales as the measure

  C. 1. Add two filter panes: Sales and Manager

  2.

  Drag and drop Sales from the Fields list onto the sheet

  3.

  Add a line chart with Date as the dimension and Sales as the measure

  D. 1. Add two filter panes: Region and Manager

  2.

  Drag and drop Sales from the Fields list onto the sheet

  3.

  Add a line chart with Date as the dimension and Sales as the measure

  Correct Answer: B

• Question 6:

  A CEO of an automotive manufacturing company wants a single dashboard sheet to track the company's sales.

  The app must meet several requirements: All charts must be on one sheet Show summary charts of key performance data Ability to scroll up and down the sheet

  Which set of actions should the business analyst use to meet these requirement?

  A. Use KPI objects Use Insight Advisor

  B. Adjust grid spacing Use Insight Advisor

  C. Use KPI objects Activate Chart assistance

  D. Activate grid spacing Activate Extend sheet

  Correct Answer: A

• Question 7:

  A manufacturer uses a dashboard for analysis. Users created many bookmarks to simplify their workflow. An administrator also created some bookmarks in the app based on user feedback.

  The organization needs to republish the app and maintain both the users' and administrator's bookmarks.

  Which steps should the business analyst take to meet this requirement?

  A. Duplicate the app in Work Request bookmark owner to publish bookmark Replace the existing app

  B. Duplicate the app in Work Review previous bookmarks Replace the existing published app

  C. Review previous bookmarks Copy the app to a new stream Publish the app in the new stream

  D. Create a duplicate copy of the app Delete the published app Publish the duplicate app

  Correct Answer: D

• Question 8:

  

  Refer to the exhibit.

  A business analyst creates a KPI visualization to show the total global sales for a large organization. When an expression is written, the default format appears as shown.

  The business users must be able to see the actual number to the last dollar value (e.g., $19,169,020) whenever this KPI is used.

  Which actions should the business analyst take to meet the requirement?

  A. 1. Change the number format to money

  2.

  Check Remove Decimal Points under Appearance > Presentation

  3.

  Add the KPI to the master items

  B. 1. Change the number format to USD

  2.

  Check Remove Decimal Points under Appearance > Presentation

  3.

  Add the KPI to the master items

  C. 1. Change the number format to USD

  2.

  Change the format pattern to remove decimal points

  3.

  Add the KPI to the master items

  D. 1. Change the number format to money

  2.

  Change the format pattern to remove decimal points

  3.

  Add the KPI to the master items

  Correct Answer: B

• Question 9:

  

  Refer to the exhibit.

  The data architect informs the business analyst of an additional data source for Customer data. The values are stored in a different format.

  Users do NOT need to display values in the current format for the NewCustomer.

  The business analyst has split the `Customer' column into two new fields in the New Customer table.

  Which steps should the business analyst take to finish integrating the new customer records into the existing visualizations?

  A. 1. Click on the Customer table

  2.

  Select Concatenate tables in the `...' option menu

  3.

  Select the New Customer table

  4.

  Edit Mappings to align the `Customer Name' and `Status' columns from the two tables

  5.

  Remove the remaining third column from the `New Customer' row

  B. 1. Click on the NewCustomer table

  2.

  Select Concatenate tables in the `...' option menu

  3.

  Select the Customer table

  4.

  Edit Mappings to align the `Customer Name' and `Status' columns from the two tables

  5.

  Rename the columns to `Customer Name' and `Status'

  C. 1. Click on the Customer table

  2.

  Select Concatenate tables in the `...' option menu

  3.

  Select the New Customer table

  4.

  Edit Mappings to align the `Customer Name' and `Status' columns from the two tables

  5.

  Rename the columns to `Customer Name' and `Status'

  D. 1. Click on the NewCustomer table

  2.

  Select Concatenate tables in the `...' option menu

  3.

  Select the Customer table

  4.

  Edit Mappings to align the `Customer Name' and `Status' columns from the two tables

  5.

  Remove the remaining third column from the `New Customer' row

  Correct Answer: A

• Question 10:

  A business analyst is using a box plot to show distribution. The data scientist provides the formulas to configure a custom box plot.

  Which action(s) should the business analyst take to meet these requirements?

  A. Under Box plot elements, disable Use presets and enter the given formulas as calculated dimensions

  B. Under Box plot elements, disable Use presets and enter the given formulas in the expressions field

  C. Select Add measure, and enter the given formulas as expressions

  D. Create variables and enter the given formulas as expressions

  Correct Answer: A