New Year Special Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

 
Home > Qlik > Qlik Sense Business Analyst > QSBA2021

QSBA2021 Qlik Sense Business Analyst Certification Exam - February 2021 Release Question and Answers

Question # 4

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.

Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded

B.

Deselect the fields that do NOT have the '_c' suffix in the data manager table preview

C.

Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition

D.

Load all columns because the recommended associations will use only columns with the suffix '_c*

Full Access
Question # 5

A business analyst s creating an app for the sales team. The app must meet several requirements

• Compare 10 top -performing sales representatives and the amount of sales for each

• Investigate margin percentage and total sales by each product category

• View distribution of sales amount

Which visualizations should be used for this app?

A.

A treemap box plot, and histogram

B.

A bar chart, line chart, and scatter plot

C.

A treemap container and distribution plot

D.

A bar chart scatter plot and histogram

Full Access
Question # 6

An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized

What should the business analyst do to meet this requirement?

A.

• Add the new Customers and Orders tables and associate the new tables to me existing data model

• Filter the data from the Customers and Orders table to bring only data created within the past two years

B.

• Add the new Customers and Orders tables and concatenate the new tables to the existing data model

• Filter the data from the Orders table to bring only data created within the past two years

C.

• Add the new Customers and Orders tables and associate the new tables to the existing data model

• Filter the data from the Orders table to bring only data created within the past two years

D.

• Add the new Customers and Orders tables and concatenate the new tables to the existing data model

• Filter the data from the Customers and Orders table to bring only data created within the past two years

Full Access
Question # 7

A business analyst creates an app for a large retailer The app is based on me past ^2 months of transactional data in CSV formal

After successfully demonstrating the app the retailer provides a tile that contains another seven years of data

After the new datais loaded the previously responsive app takes 10 times longer to respond to users' selections The app has many complex expressions

Which two actions should the business analyst take to resolve the issues?(Select two)

A.

Request the data architect to create flagsin the data model to optimize set analysis expressions

B.

Use JOIN statements to reduce the number of tables m the data model

C.

Make sure a I master items contain variables that define the expressions

D.

Replace set analysis with calculated fields in the data manager

E.

Create versions of the app using a WHERE clause m the data manager to restrict the data

Full Access
Copyright myexamcollection.com. All Right Reserved.