Which option should I choose for a new application: Data Store, Process Data Persistence (PDP), Record Sync (RS), or Database-backed Record Types?

Hi everyone,

I’m starting a new application in Appian and I want to choose the right approach for storing and managing data. Should I go for 

Data Store (CDT + Data Store mappings) from there creating record type

or 

Directly use the Record Type backed by a database table

What's the purpose of data store generally? I meant by for the modern Appian developement do we need data store necessarily 

Since this is a new build, I want to follow best practices and avoid making architectural mistakes early.

My Question

For a fresh application, what is the recommended approach for:

Application/master/transactional data

CRUD operations

Reporting and relationships

Security and scalability

Long-term maintainability

Should I rely on Data Store, PDP, Record Sync, or directly use a Database-backed Record Type?

If you have any guidelines, comparison points, or real-world experience on which option is better in 2025 Appian architecture, please share your insights. Notes :  Appian version is 24.2 . 

Thanks!