최신 Qlik Certification QSBA2018 무료샘플문제:

1. Refer to the exhibit.

A company is starting to use a new customer account system. The business analyst must include this data in an existing app Data from the legacy customer account system is already available in the app Both tables have similar data, but the columns have different names Which actions should the business analyst take to merge data from both systems?

A) 1 Select Legacy Accounts
2 Click Concatenate tables
3 Select New Customer Accounts
4 Click Sample data 5. Click Apply
B) 1. Select New Customer Accounts
2 Drag it over Invoices
3 Define the association
4 Click Apply
C) 1 Select Legacy Accounts
2 Click Concatenate tables
3 Select New Customer Accounts
4 Map the tables 5. Click Apply
D) 1. Select New Customer Accounts
2 Drag it over Legacy Accounts
3 Rename the association 4. Click Apply

2. 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 tar 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) Create a cyclic group with Region, Product Category, and Month as dimensions
D) Add Region as a dimension, add Product Category and Month as alternate dimensions

3.
Refer to the exhibits.
A business analyst must improve the first chart shown to make it look like the second chart Which two actions should the business analyst take to meet this requirement? (Select two.)

A) Change the Area property in the chart properties
B) Add Year as an additional dimension
C) Change the continuous chart property in the properties panel
D) Replace the three measures with one measure that calculates Total Sales
E) Change the stacked chart property in the properties panel

4.
Refer to the exhibit
A business analyst creates a bar chart and notices the weekdays are NOT in a US default format The analyst does NOT have permissions to enter the data load editor and edit the data The analyst only has a few minutes before the meeting to show the insights to a manager The business analyst wants to quickly customize the chart to show the weekdays in US format Which action should the business analyst take to fix the chart?

A) Change the dimension to a calculated dimension using an IF() function
B) Change the dimension label using the DATE() function to specify the right date format
C) Change the dimension label to a calculated dimension using an IF() function
D) Change the dimension to a calculated dimension using the REPLACEO function

5.
Refer to the exhibit.
A business analyst is testing an existing app that returns unexpected results.
Using the selection tool, the business analyst observes the following behavior
* Select a CompanyName and the associated OrderlD records are white
* Select a Year and all OrderlD records are gray
* Select an OrderlD and the Quarter values are all gray, but the CompanyNames are white
* Select a ProductID and the associated ShipperName and OrderDates are white, but the Year is gray What is causing these results?

A) MasterCalendar should be associated to the OrderDetails table
B) The OrderDate fields are different data types
C) The logical model is NOT a star schema
D) OrderlD should be the key field in the MasterCalendar

질문과 대답: