Official Bank 0/51

Qlik Sense Data Architect Certification Exam (QSDA2018) - QlikView Actual Exam Questions

Last updated on May 01, 2026

97% Exam Compliance
51 Total Questions
1
Question

Refer to the exhibits Business analysts report data issues in the Value field of a table since the latest reload of the data What is causrng this issue?

Question image Question image Question image
Options
A

Null values in the source data

B

Hyphen characters (' -') in the source data

C

Pre-aggregated data is being used

D

Some categories do NOT exist in the Category table

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question

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

Select 2
Options
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

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question

Refer to the exhibit. The data architect is using section access to meet the security requirements of an app After the first draft, the data architect discovers that users can NOT see the right subset of data Which solution should a data architect use to fix this issue?

Question image
Options
A

Associate the Section Access table with the data model

B

Name the field for data reduced as SectionAccess'

C

Capitalize field names and values

D

Capitalize only field values

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question

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?

Options
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(PatientlD)

D

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

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question

Refer to the exhibit. A new app is being developed. Users need to see; • Total sales for each customer • Total sales for a 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? (Select two.)

Question image
Select 4
Options
A Question image
B

Option A

Question image
C Question image
D

Option B

Question image
E Question image
F

Option C

Question image
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.