A business analyst using a shared folder mapped to S \419379942\ receives an Excel We with more than 100 columns Many of the columns are duplicates. The current set of columns mat should be used have the suffix '_c* appended to the column name What should the business analyst do to load the Excel data?
A. Load all columns because the recommended associations will use only columns with the suffix '_c*
B. Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition
C. Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded
D. Deselect the fields that do NOT have the '_c' suffix in the data manager table preview
正解:B
質問 2:
A business analyst is creating an app that requires several visualizations
* A scatter plot mat shows the margin percentage and total sales by product category
* A map with a the layer that visualizes lines between retail stores and lactones
* A KPI that shows total cost
Margin% can be calculated by dividing profit by revenue Profit is the difference between total cost and total sates Which two sets of fields can the business analyst use to meet these requirements? (Select two.)
A. Line Geometry
B. Line Geometry
Margin%
C. Product Category
Location
D. Sales
Total Cost
E. Product Category
Retail Store Location
Factory Location
正解:A,D
質問 3:
A Help Desk department sets a first-time fix target of 65% for ail customer calls. The department has a measure that captures the actual first-time fix percentage. A business analyst needs to choose the visualization that most effectively shows the performance against the target using a color gradient Which visualization should the business analyst use?
A. Table
B. Gauge
C. Text and Image
D. Combo chart
正解:A
質問 4:
How does the Qlik Associative Engine analyze data from one or more data sources?
A. Creates a set of pre aggregated queries for Qlik Sense to run
B. Inner joins multiple data sources together to remove unrequired information
C. Combines multiple data sources without pre-aggregation
D. Associates data into cubes to enable multidimensional analysis
正解:A
質問 5:
A business analyst has access to all of a company's data tor the past 10 years The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into What should the business analyst do to reprove the app performance?
A. 1. Deselect Cardholder and time field in data manager
2. Use a pant based on auto-calendar fields
3. Perform a daily reload via the data manager
B. 1. Delete Cardholder and time fields in data manager
2. Use set analysis to show data based on transaction year
3. Use an API to perform a daily reload task
C. 1. Delete Cardholder and time fields in data manager
2. Use a bookmark based on auto-calendar fields
3. Use the reload function in the sheet Editor asset panel
D. 1. Deselect Cardholder and time fields in data manager
2. Apply a filter to extract data based on transaction year
3. Request a daily reload task from the System Admin
正解:C
Yamazaki -
試験に合格するにはQSBA2021試験ガイドで十分です。スムーズにかけたし、合格することもできました。