Online Access Free QSDA2018 Practice Test

The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app.
Which load strategy should a data architect use to transfer this data in the most efficient way?

• A.Binary load
• B.Generic load
• C.QVD load
• D.Preceding load

A data architect is working on a time and expense app for an organization that has Sales, Marketing, and Finance departments Department managers should only be able to view the data for their department's team members.
Where should the data architect apply this security restriction?

• A.Data load editor
• B.Expression editor
• C.Qlik Management Console
• D.Data manager

Refer to the exhibit

A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis.
The date format for the source data field "Common Date" is M/D/YYYY This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.
Which expression should the data architect use to fix this issue?

• A.Date(MonthStart([Common Date]), *MMM-YYYY')
• B.Date(InMonth([Conmon Date]),'MMM-YYYY')
• C.Date (MonthsStart ([Common Dace]),'MMM-YYYY'
• D.Date([Common Date],'MMM-YYYY')

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?

• A.Synthetic keys are created
• B.An auto concatenation occurs
• C.A circular reference occurs
• D.Link tables are created

Refer to the exhibit.

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 EmployeelD.
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 architecwise to resolve these issues?

• A.Left Keep
• B.Inner Join
• C.Outer Join
• D.Left Join