QUESTION: 5

Refer to the exhibits

Which corrective action should be taken to achieve the expected view?

Alias one of the fields in the Orders table.
Use distinct in the LOAD statement.
Use upper () to align the Salesperson fields
Add a link table.

Answer(s): A

Refer to the exhibit

The business analyst previews some data and notices different values for the United States in the Country field. The analyst must be able to report the total sales for the United States The data architect must fix this issue in the LOAD script.
Which function should the data architect use to fix this data quality issue?

Switch
ApplyMap
Case
Replace

Answer(s): B

Reveal Solution Next Question

QUESTION: 7

Refer to the exhibit.

The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company
As a business requirement, users must be able to drill down by department and country. Datajnust not be lost.
Due to data quality issues, some departments are NOT included in the Sales and Budget tables. The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model
Which method should the data architect use?

A link table to associate the two tables
A forced concatenation statement
Field aliases or comment out redundant fields
A Left Join statement in the script

Answer(s): A

Reveal Solution Next Question

QUESTION: 8

Refer to the exhibit.

A data architect has two tables that contain Sales and Target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeelD. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for Target are too high, and employees with NO sales should be excluded Which function should the data architecwise to resolve these issues?

Left Join
Inner Join
Left Keep
Outer Join

Answer(s): C

Reveal Solution Next Question

Free QSDA2018 Exam Braindumps (page: 3)

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8

QSDA2018 Discussions & Posts