June Developer Challenge - CAP Knowledge - Analysis

[qmacro]

Greetings earthlings!

We're part way through now at the end of this month's SAP Developer Challenge on CAP knowledge, and you folks seem to be having a good time and doing well! Here are some stats - updated Sun 28 Jun at 1530 BST (GMT+0200).

We've had a great number of responses from lots of SAP Community members, some of whom (listed here) have worked very hard to submit responses to every single question so far - good work!

• @SachinArtani🚀
• @shotokka🚀
• @kasch-code🚀
• @Swathi_SAP_Philomath
• @MatLakaemper🚀
• @parthasaradhi🚀
• @Dan_Wroblewski🚀
• @Laco
• @ajmaradiaga
• @Anusha2025
• @VishnAndr
• @Joery
• @lidavidlee
• @Andrii
• @MioYasutake
• @berkaydurmaz
• @mvaibhav🚀
• @Rupesh_Kumar25
• @furkan5🚀

What's more - some members of this elite bunch have even got every single one of these question correct - they are highlighted with a 🚀 - well done!

---

Here's a breakdown of each question so far, with the number of responses, how many were correct and incorrect, and the percentage of correct answer. As this is the final analysis, we've included the answers too.

Question	Responses	Nr PASS	Nr FAIL	% PASS	Title	Answer
1	64	42	22	65.62	Common types and aspects	@cds.on.update
2	56	32	24	57.14	Content for common reuse types	@sap/cds-common-content
3	51	35	16	68.63	Declarative field control with @mandatory	Common.FieldControlType/Mandatory
4	50	36	14	72.00	Namespaces, contexts and name prefixes	outer.space.challenge.main.Books
5	45	35	10	77.78	Portable functions across all supported databases	years_between
6	42	28	14	66.67	Project specific configuration	CDS_REQUIRES_DB_KIND
7	42	39	03	92.86	Authorization annotations	@readonly
8	37	32	05	86.49	CXL case-when-then operator	ternary
9	37	32	05	86.49	Injecting conditions via filters	infix
10	35	31	04	88.57	Redirection targets	@cds.redirection.target
11	33	21	12	63.64	Metaphysics of languages	Reflections
12	33	28	05	84.85	Query mode in cds REPL	.ql
13	31	28	03	90.32	Optional CDL keyword	define
14	31	28	03	90.32	Change tracking	@changelog
15	30	26	04	86.67	Local binding registry	.cds-services.json
16	29	23	06	79.31	Escaped names	![a name]
17	28	25	03	89.29	Schema evolution testing	--dry
18	28	20	08	71.43	RFC for UUIDs	4122
19	25	22	03	88.00	CDS source formatter	format-cds
20	26	22	04	84.62	Compiler messages	wildcard-excluding-one

We'll update these stats daily from now on, too, so keep checking back! If you want more info, we have a little OData V4 service with all the stats so far (and which will also be updated daily) - see what sort of cool analyses you can come up with yourselves - use the comments to this post to share any interesting query URLs that you come up with!