QlikView QSDA2018 Exam Questions

Question 6 of 50

Refer to the exhibit.
Exam QSDA2018: Question 6 - Image 1

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. Data must 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.

Correct Answer: B

Question 7 of 50

Refer to the exhibit.
Exam QSDA2018: Question 7 - Image 1

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 EmployeeID. 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 architect use to resolve these issues?

Left Join

Inner Join

Left Keep

Outer Join

Correct Answer: B

Question 8 of 50

Refer to the exhibit.
Exam QSDA2018: Question 8 - Image 1

In the data load editor, the tables are loaded in the following sequence:
1. OrderHeader
2. OrderDetails
3. Products
The three tables CANNOT be modified as all fields are required. A data architect must create a Cost of Goods Sold (COGS) field calculated as UnitCost* Quantity.
Some products may NOT have UniCost, so the COGS value must be zero for these products.
How should the data architect meet this requirement?

1. Load the Products table as the first table 2. Create a new field in the OrderDetails table: Quantity * IsNull (UnitCost) as COGS

1. Perform a preceding load on the Product table 2. Create a new field in the OrderDetails table: if((UnitCost ג€" null() or ג€, 0) * Quantity as COGS

1. Join the Products and OrderDetails on ProductID 2. Create a new field in the OrderDetails table: Replace(Null, 0, UnitCost) * Quantity as COGS

1. Create a mapping load table as the first table from the Product table 2. Create a new field to the OrderDetails table: ApplyMap ('UnitCost_Map', ProductID, 0) * Quantity as COGS

Correct Answer: D

Question 9 of 50

Two companies have merged and full database integration is planned for next year. The data architect needs an interim solution to view all employee data from both companies.
✑ The tables come from different systems
✑ Both companies have similar Employees tables
✑ Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
✑ The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?

Link tables are created

Synthetic keys are created

An auto concatenation occurs

A circular reference occurs

Correct Answer: B

Question 10 of 50

Refer to the exhibit.
Exam QSDA2018: Question 10 - Image 1

A major healthcare organization requests a new app with the following requirements:
✑ Users can filter AdmissionDate and DischargeDate by all fields in the master Calendar table
✑ Use an existing QVD file, which includes dates 20 years into the future
✑ Users should not be able to filter on dates that have no associated encounters
Which approach should the data architect take to meet these requirements?

1. Load the Encounters table 2. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Admission Date 3. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Discharge Date

1. Load the master calendar 2. Create two mapping tables called AdmissionCalendar and DischargeCalendar from the Resident master calendar that has all fields appropriately named 3. Load the Encounters and use ApplyMap for the AdmissionDate and DischangeDate appropriately.

1. Load the Master Calendar and Encounters tables. 2. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Admission Date 3. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Discharge Date

1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission 2. Load the master calendar as Discharge Calendar and alias the fields to reflect they are for Discharge 3. Load the Encounters table

Correct Answer: B