Exhibit.

To answer the two questions:

How many students are in the system?

What percentage of students have not yet attempted an exam?

The analyst needs to focus on theStudentIDfield, specifically in relation to theAttemptstable. This is because theAttemptstable captures all exam attempts made by students, and we can deduce which students have and have not made an attempt by examining the presence of StudentID values in this table.

Key Concepts:

Total Distinct Values: This provides the total number of unique students who have attempted exams. It helps identify how many students have made at least one attempt.

Subset Ratio: This compares the values ofStudentIDbetween theStudentstable and theAttemptstable. The subset ratio shows how many students in theStudentstable are represented in theAttemptstable. This ratio helps determine the percentage of students who have not yet attempted any exams.

Why the Other Options Are Less Suitable:

B. Non-null values and Subset ratio for the StudentID field in the Students table: Thenon-nullvalues in theStudentstable are not relevant to the question about exam attempts. The focus should be on whether theStudentIDis present in theAttemptstable.

C. Subset ratio and Present distinct values for the ExamID field in the Attempts table: This focuses on exams, not students. The question specifically relates to how many students have attempted exams.

D. Present distinct values and Density% for the ExamID field in the Exams table: This focuses on the number of exams and their density, which does not help in determining how many students have attempted or not attempted an exam.

References for Qlik Sense Business Analyst:

Subset Ratio and Distinct Counts: Qlik Sense’s data model viewer provides valuable metadata like thedistinct countof a field and itssubset ratiowhen compared to related fields in othertables. This is particularly useful for understanding relationships and gaps in the data, such as identifying students who have not yet made an exam attempt.

By focusing on theTotal distinct valuesandSubset ratiofor theStudentIDfield in theAttemptstable, the business analyst can easily determine the total number of students and the percentage who have not yet attempted an exam, makingAthe verified answer.