Online Access Free QSDA2021 Exam Questions

Refer to the exhibit.

Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping dat a. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?

• A.Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
• B.Left Join the three date fields onto one bridge table using the key field containing KeyField and Date
• C.Create a Month field for each of the three dates in the fact table and use that in the chart

A global retailer has a large database in which millions of sales transactions are added per hour.
Each regional sales manager should only see details for customers in their region. After filtering based on criteria such as region, gender, and income level, sales managers should be able to see the most current detailed transactions.
What should a data architect do to meet these requirements?

• A.Use section access and include a service account in the table
• B.Use section access to restrict sales manager access by region
• C.Create an app for each sales manager with Qlik GeoAnalytics
• D.Use On-Demand App Generation (ODAG) and section access

Refer to the exhibit.

Refer to the exhibits.
The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.
In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.
What should the data architect do in the data load editor?

• A.Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport
• B.Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field
• C.Apply a FOR loop to load to the MasterSports table creating the values for the Sport field

ITALY IT001 HR
GERMANY DE002 HR
SPAIN SP03 FINANCE
FRANCE FRO04 SALES
Refer to the exhibit
A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.

• A.LTRIM (SUBFIELD (Key, ' ', 2), 2)
• B.RIGHT(SUBFIELD (Key,' ', 2), 3)
• C.LEFT(SUBFIELD(Key, ' ', 2), 2)
• D.MID ( SUBFIELD (Key , ' ', 2), 3)

The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.
Which method should the data architect use to manage the modifications in all apps?

• A.Create only a single app with all the master items needed and protect it with SECTION ACCESS.
• B.Create a selection app with all the master items and use an on-demand app generation method.
• C.Create a variable repository and load them using INCLUDE statements in the apps where needed
• D.Create a core app with all the master items needed and use a BINARY load in the other apps.