QSBA2021 무료 덤프문제 온라인 액세스

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.Combo chart
• B.Gauge
• C.Table
• D.Text and Image

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?

• A.* count(distinct BookinglO)
  * [TolalCost]
  * [Totalincomel
  * ITotalincome|-[TotalCost]
  * [TotalMargin]/{Totalllncome}*100
• B.* count(dislinct BookinglD)
  * [TolalCost]
  * [Totalincome]
  * [Totalincome|-[TotalCost]
  * [TotalMargin]/[Totalllncome}*100
• C.* count(BookinglD)
  * [TolalCost]
  * [Totalincomel
  * sum(income|-sum[TotalCost]
  * [TotalMargin]-sum(Cost)/sumTotal(lncome)*100
• D.* count(dislinct BookinglD)
  * [TolalCost]
  * [Totalincomel
  * ITotalincome|-[TotalCost]
  * [TotalMargin]/{Totalllncome}*100

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 data is 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.Use JOIN statements to reduce the number of tables m the data model
• B.Request the data architect to create flags in the data model to optimize set analysis expressions
• C.Create versions of the app using a WHERE clause m the data manager to restrict the data
• D.Make sure a I master items contain variables that define the expressions
• E.Replace set analysis with calculated fields in the data manager

Refer to the exhibit.


A business analyst must add a list of interns to the current sates app. The app contains an existing employees table When the business analyst profiles the data the association vow displays possible associations as shown.
Which action should the business analyst take to meet the requirements?

• A.Create an association between the EmpID and EmployeelD fields
• B.Create a concatenated key to associate the Employees and internEmp tables
• C.Force an association between the InternEmp and the Orders tables
• D.Concatenate the InternEmp table to the Employees tables within data manager

A business analyst is creating a new app with sales dat
a. The visualizations must meet several requirements:
* A Bar chart mat shows sales by product group is used m multiple sheets
* A KPI object that visualizes that the total amount of sales is used once
* A Treemap mat shows margin by product group is used one time inside a Container What should be added to the master items library?

• A.Container
• B.KPI
• C.Bar chart
• D.Treemap