topic Re: Section Access - question from quiz in QlikView

Section Access - question from quiz

karolina_ — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I'm doing quiz from qlik.com website and I got stuck on one question.

Which of the following is true about Section Access tables?

A. The number of user security records is limited to one million - it is not, although there is limitation for reduction field(s) that cannot handle more than 1M unique values (Section Access limitation of 1M rows?)

B. All Section Access tables must be defined in the Hidden Script - not a must, a good practise

C. You can only perform data reduction on a single field - no, u can have more than 1

D. All field names and values are automatically converted to upper case - only in inline load or text file load (When does Section Access "ACCESS" field value require upper case ?). From QV 11 reference manual "All the fields listed in Load or Select statements in the section access must be written in UPPER CASE. Any field name containing lower case letters in the database should be converted to upper case using the upper function, see upper(textexpression) (page 320), before being read by the Load or Select statement."

E. Don't know - fits best for me now

Help & explanation appreciated

Re: Section Access - question from quiz

rubenmarin — Wed, 14 Oct 2015 10:33:34 GMT

Hi Karolina, I don't know where is this quiz but I agree with you. That quiz was done by Qlik or by one user?

Re: Section Access - question from quiz

karolina_ — Wed, 14 Oct 2015 10:37:52 GMT

By Qlik.
It's available here: Take the Qlik Skills Assessment: Become A Power User

Re: Section Access - question from quiz

vincent_ardiet — Wed, 14 Oct 2015 11:31:26 GMT

Hi Karolina,

I have add also the same reaction.

I was a bit disappointed by this quizz my score was poorer than the one I have obtained for the certification .

Regards,

Vincent

Re: Section Access - question from quiz

rubenmarin — Wed, 14 Oct 2015 11:42:53 GMT

I made the test, also choosed the 'E' option. I was expecting to see wich one is the correct question but you can't know wich one is correct, neither wich ones you have failed.

Try-error method can give us the expected correct answer but I'm not that curious to waste the time.

Re: Section Access - question from quiz

Bill_Britt — Wed, 14 Oct 2015 17:53:46 GMT

Hi,

None of the ones you have listed are correct.

Bill

Re: Section Access - question from quiz

karolina_ — Thu, 15 Oct 2015 10:16:40 GMT

Thanks for confirmation.

Re: Section Access - question from quiz

karolina_ — Thu, 15 Oct 2015 10:22:32 GMT

Thanks for effort Ruben.
It's a pity there is no info where failure was. Nice idea for try-error method It this case whichever answer it would be the question is 'why did qlik choose it?'

Re: Section Access - question from quiz

luiskeyrus — Tue, 18 Apr 2017 10:31:28 GMT

i'm sure the correct answer is D. I did the test yesterday and i passed with 94%. i have done the test five minutes ago only changing this question with answer B and i scored 91%

Re: Section Access - question from quiz

luiskeyrus — Tue, 18 Apr 2017 12:06:25 GMT

hahahah i did the same!!

Re: Section Access - question from quiz

Thu, 11 May 2017 16:34:41 GMT

I can confirm - an extract from my QV Developer book (from the classroom course) states:

All field names and values are converted to Uppercase in the SECTION ACCESS. Use the UPPER function to convert the field values to UPPERCASE.

Re: Section Access - question from quiz

Bill_Britt — Mon, 15 May 2017 13:19:52 GMT

HI,

That is only taking about inline loads..

**Note that all data loaded via an external data source must be loaded in upper case

in the SECTION ACCESS statement. This does not apply to INLINE data which always

will be treated as upper case.