Pass the Qlik Qlik Sense Business Analyst QSBA2021 Questions and answers with CertsForce

Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
Questions # 11:

Country

USA

US

U.S.A.

Refer to the exhibit.

A business analyst needs to load several data files and notices that some of the values for the United States of America are formatted inconsistently.

What should the business analyst do?

Options:

A.

Use data profiling to group the country values


B.

Use data profiling and replace the country names


C.

Use data profiling 10 hide the inconsistent country names


D.

Use the filter and rename the country values


Expert Solution
Questions # 12:

A company CEO requests a dashboard that easily displays provides understating and tracks company performance. There are several ma n dashboard requirements:

• Viewable by a mobile device

• Display multiple key measures

• Provide ability to easily navigate to other sheets

Which feature meets these requirements?

Options:

A.

Multi KPI object with master visualizations


B.

Multiple text and images visualizations


C.

Multiple visualizations m a container


D.

Multi master item visualizations


Expert Solution
Questions # 13:

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)

Options:

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


Expert Solution
Questions # 14:

A business analyst inherits an app full of sheets The business analyst needs to redesign the app using the DAR principle How should the business analyst orderthe visualizations?

Options:

A.

• KPIs

• Table PivotTable

• Bar Chart Pie Chart Line Chart


B.

• Bar Chart Pie Chart Line Chart

• KPIs

• Table Pivol Table


C.

• KPIS

• Ba' Chart Pie Chart Line Chart

• Table Pivot. Table


D.

• Bar Chart Pie Chart Line Chart

• Table Pivot Table

• KPIs


Expert Solution
Questions # 15:

A company that manages several tennis clubs uses an app mat includes three master measures TotalCost, Totallncome. and TotalMargin A business analyst needs to create a new table that utilizes master items and meets the following requirements:

• Number of bookings that users make

• Cost associated with booking (including electricity and indirect costs)

• Income obtained and profit originated m each booking

• Sales margin: percentage of margin over income

• Detail by tennis clubs

Which optimal expressions should the business analyst use?

Options:

A.

• count(BookinglD)

• [TolalCost]

• [Totalincomel

• sum(income|-sum[TotalCost]

• [TotalMargin]-sum(Cost)/sumTotal(lncome)*100


B.

• count(dislinct BookinglD)

• [TolalCost]

• [Totalincomel

• ITotalincome|-[TotalCost]

• [TotalMargin]/{Totalllncome}*100


C.

• count(dislinct BookinglD)

• [TolalCost]

• [Totalincome]

• [Totalincome|-[TotalCost]

• [TotalMargin]/[Totalllncome}*100


D.

• count(distinct BookinglO)

• [TolalCost]

• [Totalincomel

• ITotalincome|-[TotalCost]

• [TotalMargin]/{Totalllncome}*100


Expert Solution
Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions