QSDA2019 Online Practice Questions and Answers

Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer. Some

customers have Sales without a Budget, and other customers have a Budget with no Sales During loading,

the data architect resolves a synthetic key by creating the composite key For validation, the data architect

creates a table containing Customer, Month. Sales, and Budget columns.

What does the data architect see when selecting a month?

A. All Customers, all Budget and all Sales records

B. Customer and Sales records for that month, but missing values for Budget

C. Customer and Budget records for that month, but missing values for Sales

D. Customer, Sales, and Budget records for that month

A data architect needs to write the expression for a measure on a KPI to show the sales person with the

highest sales. The sort order of the values of the fields is unknown. When two or more sales people have

sold the same amount, the expression should return all of those sales people.

Which expression should the data architect use?

A. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')

B. FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))

C. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')

D. FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))

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. Option A

B. Option B

C. Option C

D. Option D

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 exhibit.

A company has different departments Executive and Sales should always be the first values in a

Department filter pane.

Which script must the data architect use to meet this requirement?

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

A data architect executes the following script:

What will Field_1 contain after this script is executed?

A. Abcd, abcd

B. abed

C. Abed. abed. ABCD, ABCDABCD

D. Abcd, abcd. ABCD

Refer to the exhibit.

A. The UserAccess table contains seven fields Year Month, Hourr AccesslD. AccessDate. UserlD, and Duration (minutes) The table is only linked to Users on the UserlD field

B. The UserAccess Table contains seven fields: Year, Month. Hour. AccessID, AccessDate. UserlD, and Duration (minutes) The table is linked to the Access table with the AccessID field and linked to Users on the UserlD field

C. The UserAccess table contains seven fields AccessYear, AccessMonth, Hour AccesslD, AccessDate, UserlD, and Duration (minutes) The table is only linked to Users on the UserlD field

D. The UserAccess table contains seven fields AccessYear. AccessMonth. Hour. AccesslD, AccessDate. UserlD. and Duration (minutes) The table is linked to the Access table on the AccesslD field and linked to Users on the UserlD field

Refer to the exhibit.

A shipping company needs to track its shipments using Qlik Sense A data architect has the data in Excel as shown on the left Business rules state that if the ShipmentDate field is empty, it should be populated with the first valid previous date as shown on the right.

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

A. Option A

B. Option B

C. Option C

D. Option D

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

A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies: Source 1 Contains frequently updated data and must be refreshed hourly Source 2 Contains data that is transferred from a partner and must be refreshed weekly

Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs.

Which tasks should be created to meet these requirements?

A. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

2.

ScheduleTask 2 to run weekly and refresh data from Source 2

3.

Schedule a task for the app that is dependent on completion ofTasks 1 or 2 that loads the two QVDs

B. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

2.

ScheduleTask 2 that is dependent onTask 1 to refresh data from Source 2

3.

Schedule a task for the app that is dependent on completion ofTask 2 that loads the two QVDs

C. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

2.

ScheduleTask 2 that is dependent onTask 1 to refresh data from Source 2

3.

Schedule a task for the app that is dependent on completion ofTasks 1 and 2 that loads the two QVDs

D. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

2.

ScheduleTask 2 to run weekly and refresh data from Source 2

3.

Schedule a task for the app that is dependent on completion ofTask 2 that loads the two QVDs