Online Access Free QSDA2018 Practice Test

Payroll managers need access to the payroll system to complete a quarterly report. A username and password is required to access the payroll system through an ODDC connection Only the system administrator should have access to the credentials and make updates as needed Each payroll manager who accesses the app should only see their own employees.
Which two actions are required to set up the appropriate security? (Select two.)

• A.Apply the correct section access to restrict data visibility
• B.Make sure that the administrator applies the correct security rules to the ODBC connection
• C.Make sure that the administrator creates appropriate sync rules to access the payroll system
• D.Apply security rules to the app to restrict data visibility
• E.Make sure that the administrator applies security rules to the correct stream to restrict data visibility

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

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

Refer to the exhibits.

A data architect needs to build a Project Management dashboard. The ProjectStatus table lists all indexes in the fields. Descriptions for the indexes are stored in a single Master table.
To build the dashboard, all descriptions should be in a single table:

Which function should the data architect use to meet this requirement?

• A.PurgeChar
• B.Keep
• C.Join
• D.ApplyMap

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

Refer to the exhibits



Which corrective action should be taken to achieve the expected view?

• A.Add a link table.
• B.Use distinct in the LOAD statement.
• C.Use upper () to align the Salesperson fields
• D.Alias one of the fields in the Orders table.