Try and practice the latest Qlik : QSDA2018 real questions & answers

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)

• A. Option B
• B. Option A
• C. Option D
• D. Option C

A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built-in location servicetjenerates data for the airport locations The data load editor runs the script and sees a circular reference and a synthetic key How should the data architect fix these issues'?

• A. When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to 'None".
• B. Concatenate the airport table and the existing tables into one master table.
• C. When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct .
• D. When choosing which data to load, uncheck the non-unique field in the new data tables.

A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.
* Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID
* PatientID values in all three tables are completely accurate
* Patients may have encounters without lab orders or medications
The data architect needs to make sure that the count of patient lab orders is correct. Which method should the data architect to meet this requirement?

• A. Load all three tables and use Count(PatientlD)
• B. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(LabPatientlD)
• C. Load all three tables and use Count{Distinct PatientID)
• D. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)

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?

• A. 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
• B. 1. Load the Products table as the first table
  2. Create a new field in the OrderDetails table: Quantity * isNull (unitcost) as cogs
• C. 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
• D. 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

Refer to the exhibit.

The Country field in a CRM app is a free-form text field More spelling variations and countries are expected in the future A data architect must create a field called CountryCode based on the value in the Country field.
Which script should the data architect create to perform this task?
A)

B)

C)

D)

• A. Option B
• B. Option A
• C. Option D
• D. Option C