Online Access Free QSDA2021 Practice Test

A data architect wants to combine data on present and historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.
Which script should the data architect use?
A)

B)

C)

D)

• A.Option B
• B.Option D
• C.Option A
• D.Option C

A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.
These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.
The Human Resources manager creates a table that maps these keys to another, called Associations.
The resultant data model must meet the following requirements:
* Associations must be valid
* The model must be optimized for performance
* The option must support multiple tables added
Which solution should the data architect use to meet these requirements?

• A.MAP EmloyeeKey USING Associations;
• B.MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
• C.RENAME FIELDS USING Associations;
• D.APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;

Refer to the exhibits.

A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

• A.Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed INNER JOIN the resultant table back into the master calendar
• B.Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
• C.Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar
• D.OUTER JOIN the calendar with the currency conversion table
  ORDER BY the date and use the PEEK function to fill in blank values

A data architect needs to arrange data to create an app with a map where multiple location points consolidate into hexagonal areas based on postal codes The areas will be color coded based on the number of vendors in the location.
Which GeoAnalytics operation should the data architect use?

• A.Intersect
• B.Binning
• C.Simplify
• D.AddressLookup

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