QUESTION: 9

Refer to the exhibit.

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 UnitCost 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 Products table
2. Create a new field in the OrderDetails table, if (Unitcost = nulio or ·', 0) * Quantity as cogs
1 Join the Products and OrderDetails tables on ProductID
2. Create a new field in the OrderDetails table: Replace (Null, o, unitcost) * Quantity as cogs
1. Create a mapping load table as the first table from the Products table
2. Create a new field to the OrderDetails table: toplyMap('unitcos^Map', ProductID, 0) * Quantity as cogs

Answer(s): D

Reveal Solution Next Question

QUESTION: 10

Two companies have merged and a 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 (eg , 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

Answer(s): B

Reveal Solution Next Question

QUESTION: 11

Refer to the exhibit.

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 anADischargeCalendar from the Resident master calendar that has all fields appropriately named 3 Load the Encounters table and use ApplyMap for the AdmissionDate and DischargeDate 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 DischargeCalendar and alias the fields to reflect they are for Discharge
3. Load the Encounters table

Answer(s): A

Reveal Solution Next Question

QUESTION: 12

A data architect needs to build a dashboard that displays the aggregated -sales for each sales representative. All aggregations or data must be performed in the script.
Which script should the data architect use to meet these requirements? A)

B)

C)

D)

Option A
Option B
Option C
Option D

Answer(s): D

Reveal Solution Next Question

Free QSDA2018 Exam Braindumps (page: 4)

QUESTION: 9

QUESTION: 10

QUESTION: 11

QUESTION: 12

QSDA2018 Discussions & Posts