Question 1

A marketing team is using an app to analyze the company events. The team registers attendees with information such as an ID name and region and discusses business opportunities with attendees Opportunities are evaluated m time and set to a different status.

The team wants to use insight Advisor to query events and opportunities to:

* Review specific areas and periods

* Use marketing terms not currently present in the app when classifying opportunities

* Define calendar periods and add calculations for specific data fields

Some examples are as follows:

Other-Image-72ab1f2a4-aa74-4e74-80c2-4fa267633198

Which process should the business analyst follow?

Options :

A : Add tags into the data fields to improve how the Insight Advisor identifies the fields when using the natural language queries Use the Selection tool to remove any tads not needed for the search results

B :

Define me business logic and vocabulary to define values using the fields m me data set Create groups and set properties in fields Use Calendar groups to define custom periods

C : Create master dimensions and measures, including calendar measures to define fiscal periods Use tags to improve the insight Advisor search features and include vocabulary terms

D : Update the data set using data manager or data load editor to include these terms as flags or values in the data set Also define the variable to determine which calculation should be used for each field

Answer: D

Question 2

A business analyst is creating an app for the sales department

Users of the app most be able to create sheets and analyze data The sales department has several additional requirements

* Reuse the global sales visualization

* Create new visualizations

* The app has over 100 visualizations

Users will NOT have access to the full data model

What should be added to the master items to meet the requirement?

Options :

A :

* All fields as dimensions and measures

* All visualizations

B :

* All fields as dimensions and measures

* Selected visualizations

C :

* Seated fields as dimensions and measures

* Selected visualizations

D :

* Selected fields as dimensions and measures

* All visualizations

Answer: A

Question 3

A business analyst is testing an existing application that returns some unexpected results. Using the selection tool the business analyst observes the following:

When you select the Category field and the contents of Doc remain white. Selects the Year field and all Doc records become gray. Select some content in Doc and the Contents of Week are all gray, but the contents of Category are white. Selects a content from the ProductID field and the associated field ShipperID and Date remain white, but the Year field is grayed out.

What is causing these results?

2021-10-22-14-38-54-67b97a9a592cc6b65756f4592e7d1508

Options :

A : The model logic is incorrect and does not reflect a star schema

B : The master calendar table should be associated with the sales details table (Dim_Sales_Add)

C : The Doc field should be a key field in the master calendar table

D : Date fields have different properties and/or date types

Answer: D

Question 4

A business analyst needs to analyze sales using an existing Sales Orders application:

• The sales order details table were added from a QVD file using Data Manager;

• The in-app and QVD sales order table does not have the pre-calculated "Sales" field

• Sales can be calculated by multiplying between "Qty" and "UnPrice"

How should the business analyst add the "Sales" field to the sales order table?

2021-10-22-14-30-44-24d6ee1c04d0d9442c628f3ab0500d6a

Options :

A : In the Data Viewer, add a calculated field named "Sales" with the expression: UnPrice * Qty

B : In Data Manager, add a calculated field named "Sales" with the expression: Sum(UnPrice * Qty)

C : In Data Manager, add a calculated field named "Sales" with the expression: UnPrice * Qty

D : In qvd file sales orders, add an additional field with the name "Sales" with the expression: UnPrice * Qty

Answer: C

Question 5

A business analyst needs to share a link to a specific visualization with colleagues

Which steps should the business analyst use?

Options :

A :

1. Go to the OMC and select App Object

2. Right-click the correct visualization to get the URL

3. Share the URL with colleagues

B :

1. Go to the Dev Hub and select Single Configurator

2. Select Add data

3. Copy the URL from the browser and share with colleagues

C :

1. Right-click the visualization and select Share

2. Select </> Embed

3. Copy the URL and share with colleagues

D :

1. Right-click the visualization and select View data

2. Select Export data

3. Share the provided link with colleagues

Answer: A

Free QSBA2022 Mock Exam – Practice Online Confidently

Buying Options: