This exam was my first Hands-on Performance Exam and was very nice to take because it tests you against real life situations besides the usual multiple-choice questions, so be prepared to execute actions in OCI console.
As stated in the exam page, is suggested to user to have at least 6 months of hands-on experience, this helped me to execute the tasks in a good time frame.
In the exam link you will find more details: https://mylearn.oracle.com/ou/exam/oracle-cloud-infrastructure-2023-security-professional-1z0-1104-23/35644/119472/184824
To study I have used the official documentation (I really like to read everything in docs) and the videos from Mylearn helped a lot.
The security topic is a must have to anyone that is willing to work in cloud environments and this exame was great to take because its covers from the basis and core functionalities of OCI like OCI Cloud Guard, OCI Vault and OCI Firewall.