QSDA2019 Online Practice Questions and Answers

A table is generated resulting from the following script

When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date? A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

Users of a published app report incomplete visualizations. The data architect checks the app multiple times

and cannot replicate the error. The error affects only one team.

What is the most likely cause?

A. An Omit field has been applied

B. A security rule has been applied to the sheet object

C. Section access restricts too many records

D. The affected users were NOT added to the Section Access table

Refer to the exhibit.

Refer to the exhibits.

While using an app, the users report that some Sales Reps do NOT have personal details, like Division or

Address Number A data architect has been called in to investigate. The data architect uses the data model

viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.

What is the cause of the issue?

A. 26 values for Sales Rep are null in CustomerMaster

B. 40.7% of the Sales Rep have CustomerMaster information

C. 59.3% of the Sales Rep have CustomerMaster information

D. Density is 100% while Total Distinct and Present Distinct are NOT the same

Refer to the exhibit.

A data architect needs to analyze the number of orders by customer. The data is stored in two Excel files: Orders and Customers The data architect creates a bar chart, but the data is obviously incorrect.

What should the data architect do to resolve this issue?

A. Open the data manager, split the Customers table, and Concatenate Orders and Customers on the CustomerlD field

B. Open the data manager split the Customers table, and associate on CustomerlD

C. Open the data load editor, use CONCATENATE to concatenate Orders and Customers

D. Open the data load editor, rename the CustomerlD field, and concatenate Orders and Customers

Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.

How should the data architect resolve the errors?

A. In the data manager split the Region table and associate by EmployeelD

B. In the data manager split the Region table and associate by Region.ID

C. In the data load editor, concatenate the Region and Employee tables

D. In the data manager, concatenate the Region table and associate by Region.ID

Refer to the exhibits.

A business analyst needs to see the currency conversion rate for any given date in a chart The currency conversion rate data comes from Qlik DataMarket and only contains a record when the rate changes An existing master calendar exists in the data model which contains a full set of dates.

Which technique should the data architect use to meet this requirement?

A. Outer Join the calendar with the currency conversion table Order by the date and use the Peek function to fill in blank values

B. Use 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

C. Use IntervalMatch to load the currency conversion rate between dates the conversion changed Inner Join the resultant table back into the master calendar

D. Use IterNo and AutoGenerate to create a new calendar from max and mm dates of the currency conversion table Force concatenate with the master calendar

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 alphanumeric key. Employees in the Sales system are identified using an integer key The Human Resources manager creates a table which maps these keys to one 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 from both systems now and in the future

Which function should the data architect use to meet these requirements?

A. APPLYMAP { 'Associations' , EmployeeKey) AS EmployeeKey;

B. MAP EmployeeKey USING Associations;

C. RENAME FIELDS USING Associations;

D. MapSubString('Associations', EmployeeKey) AS EmployeeKey;

Refer to the exhibit.

An app has been built to analyze salesperson performance by department. Salespeople often move

between departments. There is a strict business rule which states a salesperson must be associated with

ONLY one department at all times.

The data architect creates a summary of department performance and notices the values are incorrect.

The KPI showing the total sales shows the correct result.

How should the data architect modify the data model to correct the issue?

A. Create a bridge table between the Departments and Salespeople tables to resolve the many-to- many relationship

B. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to- many relationship

C. Join the Transactions and Salespeople tables to resolve the many-to-many relationship

D. Join the Departments and Salespeople tables to resolve the many-to-many relationship

A data architect plans to build an app that contains geographically diverse data that must be specific to

user run-time selections. The source contains transactional data. The app must have minimal impact on

already limited server resources.

Which approach should the data architect use?

A. Loop and Reduce

B. QVDs

C. In-memory

D. ODAG

Refer to the exhibit.

The Section Access security table for an app is shown User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns.

What is the result?

A. The user gets an "Invalid visualization" error

B. The table is displayed without the LEVEL column

C. The table is removed from the user interface

D. The user gets a "Field not found" error