Qlik QSDA2018 dumps - 100% Pass Guarantee!

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, create a copy of PatientID in the lab orders table as LabPatientID, and use Count (Distinct LabPatientID)

B. load all three tables and use Count(Distinct PatientID)

C. load all three tables and use Count(PatientID)

D. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)

Two companies have merged and 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 (e.g., 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. Link tables are created

B. Synthetic keys are created

C. An auto concatenation occurs

D. A circular reference occurs

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 ODBC connection. Only the system administrator should have access to the credentials and make updates as needed. Each payroll manager who access the app should only see their own employees.

Which two actions are required to set up the appropriate security? (Choose two.)

A. Make sure that the administrator creates appropriate sync rules to access the payroll system

B. Apply the correct section access to restrict data visibility

C. Make sure that the administrator applies security rules to the correct stream to restrict data visibility

D. Apply security rules to the app to restrict data visibility

E. Make sure that the administrator applies the correct security rules to the ODBC connection

Refer the exhibit.

A new app is being developed. Users need to see:

Total sales for each customer

Total sales for given state

Customers that have not had any sales

Names of salesperson and regional manager

Total number of sales by date

The data architect constructs several data models and tests the validity of each model.

Which two data models meet these requirements? (Choose two.)

A.

The data architect aliases the MrgID field to RegionalAcctMgrID and the CustID field in the Customers table.

B.

The data architect loads two copies of the Employees table, aliases the appropriate fields, and aliases the CustID field when loading the Customers table.

C.

The data architect performs two Left Joins to the Sales table to get the Employee names and loads the Customers table aliasing the CustID field.

D.

The data architect performs three Left Joins to load the Customer and Employee data fields into the Sales table.

Refer to the exhibits.

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. Join the calendar with the currency conversion table Order by date and use the Peek function to fill in the blank values

B. Use IterNo and autogenerate to create a new calendar max and min dates of the currency conversion table Force concatenate with the master calendar

C. 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

D. Use IntervalMatch to load the currency conversion rate between dates the conversion changed Inner Join the resultant table back into the master calendar