Qlik Sense Data Architect Certification Exam (QSDA2018) - QlikView Exam Questions

A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions. The data architect wants to reduce duplicate script, save time on expression modifications, and increase reusable Qlik developer assets. The data architect creates a common script and stores it on a file server that Qlik Sense can access.

How should the data architect complete the requirements'?

Refer to the exhibit.



A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum([Budgeted Sales]) are calculated correctly. Which load script meets these requirements? A)

Budget: load * inline I



Year, Region, Budgeted Sales
2015, south, 16];
inner join (Budget)

Sales: 2015, North, 2, 8 2015, West, 1, 12 load * inline [ 2015, East, 2, 9 2015, North, 10 2015, West, 12 2015, East, 14 2015, North, 1, 10 2015, West, 2, 11 2015, East, 1, 14 2015, South, 1, 16 Year, Region, Semester, Actual Sales 2015, South, 2, 7 B)



Budget: load * inline [ Year, Region, Budgeted Sales 2015, North, 10 2015, West, 12 2015, East, 14 2015, South, 16]:

Sales: concatenate (Budget) load * inline I Year, Region, Semester, Actual Sales 2015, North, 1, 10 .015, North, 2, a 1015, West, 1, 12 2015, West, 2, 11 2015, East, 1, 14 2015, East, 2, 9 2015, South, 1,16 2015, South, 2, 7 1: C)

used Refer to the exhibit.



A global company recently released an app that uses much more memory than similar apps have When reviewing data in the data manager, the data architect observes that several fields use Globally Unique Identifiers (GUIDs). There is one key field. Other fields are used for different KPIs to count the number records. The data architect must reduce the memory used as much as possible. Which steps should a data architect take to meet these requirements?

Refer to the exhibit.



A.
In the data load editor, the tables are loaded in the following sequence;
1 OrderHeader

2. OrderDetails

3. Products
B. 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

2. Create a new field in the OrderDetails table, if (Unitcost = nulio or •', 0) C.

2. Create a new field in the OrderDetails table: Replace (Null, o, unitcost) D.

1. Perform a preceding load on the Products table
1 Join the Products and OrderDetails tables on ProductID

1. Create a mapping load table as the first table from the Products table

* Quantity as cogs

* Quantity as cogs

2. Create a new field to the OrderDetails table: toplyMap('unitcos^Map', as cogs
ProductID, 0) * Quantity

Refer to the exhibit.



An organization stores sales data in SQL Server. A database administrator creates a view to show the transaction data The data architect must

• Create a data model that shows the total sales for each salesperson by month

• Create an indicator that shows whether the total monthly sales meet or exceed the monthly quota,
which is always $1,200
Which script should the data architect use to meet these requirements?





A) B)
C) D)