Qlik QSBA2024 Quiz 1 Topic 4 Questions 1-5

Question: 1

A business analyst using a shared folder mapped to S:\488957004\ receives an Excel file with more than 100 columns. Many of the columns are duplicates. Any current columns that should be used have the suffix '_c' appended to the column name.

Which action should the business analyst take to load the Excel data?

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

BUtilize filter functionality in the Data manager to select only columns with the suffix '_c' with a filter condition

COpen the Excel file, remove all columns that do not have the suffix '_c', and save the file to be loaded

DDeselect the fields that do not have the '_c' suffix in the Data manager table preview

Show Answer

Question: 2

Refer to the exhibit.

q2_QSBA2024

An app that will track experiments for rodents (e.g., rats and mice) that navigate mazes (labyrinths) is being developed. Individual rodents are catalogued in the Rodent table, while the Mazes table has metadata for the mazes. The MazeEscapes table holds a record of each attempt at a maze by a rodent. A business analyst needs to build a KPI that will allow users to see how many rodents have made at least one attempt at any maze.

How should the analyst construct the KPI?

A* Create RodentlD AS RodentID_Counter in the MazeEscapes table.
* Use Count (Distinct RodentlD Counter) as the KPI expression.

B* Create 1 AS RodentID_Counter in the Rodent table.
* Use Sum (RodentlD Counter) as the KPI expression.

CCreate 1 AS RodentID_Counter in the MazeEscapes table.
Use Sum (RodentlD Counter) as the KPI expression.

D* Create RodentlD AS RodentlD Counter in the Rodent table.
* Use Count (Distinct RodentID Counter) as the KPI expression.

Show Answer

Question: 3

Two customers in an organization want to use an app that contains a finance data set. With different analysis objectives, each customer will only use a subset of that data. Which procedure should the business analyst follow?

AApply Section Access to manage the data for each customer

BCreate multiple visualizations using set analysis

CDuplicate and rename the apps for each customer

DUnpivot, then re-associate the data tables for each customer

Show Answer

Question: 4

A data analyst is working on a new Qlik Sense application and realizes that some of the required data sources have already been used in previous applications. To streamline the data loading process and maintain consistency, the analyst decides to leverage existing data connections.

What actions should the analyst take to utilize the pre-existing data connections in Qlik Sense?

ACopy the script from the old application and paste it into the new application's script editor

BAccess the Data load editor and select the desired data connection from the list of available connections

CExport the data connection from the old application and import it into the new one

DUse a Qlik Sense extension to search and replicate data connections from other applications

Show Answer

Question: 5

A company CEO requests an app that contains global sales information. The CEO needs to present this information to an audience of international investors during an upcoming meeting.

The presentation must meet several requirements:

* Contain visualizations that present clearly to a large audience

* Answer audience questions dynamically

* Be made available as shared content

* Emphasize important sales revenue

Which Qlik Sense features should the business analyst prepare?

AEmbed a video player in the shared app with a recording to describe the charts

CCreate a sheet that features colorful and layered visualizations and export as a PDF

CSet up NPrinting to connect to the app and design a si ides how-style report

DCreate a storytelling narration in a published app that contains embedded sheets

Show Answer

Qlik QSBA2024 Quiz:1 Topic:4 Questions:1-5