Online Access Free QSDA2018 Exam Questions

A health system needs to analyze patient admissions and discharges in a chart with a common date axis that looks like the chart below.

The initial data table (InpatientEncounters) contains a patient admission date and a discharge date for each patient encounter. The data architect will use set analysis to calculate the number of admissions and discharges in the chart.

The data architect needs to design a data model with a minimum number of tables. Which tables should the data architect create to meet these requirements?

• A.AdmissionCalendar, DischargeCalendar, and CommonCalendar
• B.DateLink, AdmissionCalendar. and DischargeCalendar
• C.DateLink and CommonCalendar
• D.AdmissionCalendar and DischargeCalendar

A business analyst must see a currency conversion rate for any given date in a chart The currency conversion rate data is held in a separate table in the database and only contains a record when the rate changes. An existing master calendar exists in the data model that contains a full set of dates Which technique should the data architect use to meet this requirement?
A business analyst must see a currency conversion rate for any given date in a chart The currency conversion rate data is held in a separate table in the database and only contains a record when the rate changes. An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

• A.* Use IterNo and autogenerate to create a new calendar from max and min dates of the currency conversion table
  * Force concatenate with the master calendar
• B.* Use a For loop between the start date and end date of the master calendar
  * Use the Match function to add the currency conversion rates to the master calendar
• C.* Use IntervalMatch to load the currency conversion rate between dates the conversion changed
  * Inner Join the resultant table back into the master calendar
• D.* Join the calendar with the currency conversion table
  * Order by the date and use the Peek function to fill in blank values

Stock levels are stored online in a system that keeps information for the current period only.
What should the data architect do to enable analysis of the trends of the stock levels?

• A.for each period and use a binary load task to create a single app
• B.Create an app for each period as it changes and use document chaining Create an app
• C.Capture the periodic information in an incremental QVD file for use in an app
• D.Use On-Demand App Generation (ODAG) to create new apps from the selected period

Refer to the exhibit.
How should the account that runs the Qlik Sense Services be configured in the Section Access table?

• A.ADMIN, QLIK_SERVICES, *
• B.ADMIN, DOMAIN\QLIK_SERVICES.
• C.ADMIN, DOMAIN\QLIK_SERVICES, *
• D.ADMIN, QUK_SERVICES,

Refer to the exhibit.

The two tables have been loaded by the script shown This script creates a synthetic key, which is not desired.
The Dept code in the Employee table is incorrect for EmplD=3
The data architect must change line 27 to create a single table in the data model that is accurate Which LOAD statement should the data architect use?

• A.KEEP LOAD EmpID, ManagerlD, Level
• B.JOIN LOAD EmpID, ManagerlD, Level
• C.JOIN LOAD *
• D.CONCATENATE LOAD EmpID, ManagerlD, Level