nerdexam
SAP

C_CPE_2409 · Question #47

For local development in the , which database option is recommended?

The correct answer is B. SQLite. SQLite is the recommended choice for local development because it is a lightweight, serverless, file-based database that requires zero installation or configuration - you can start building immediately without running a database server. In frameworks like SAP CAP (Cloud…

CAP Project Setup and Configuration

Question

For local development in the , which database option is recommended?

Options

  • ANosat
  • BSQLite
  • CPostgreSQL
  • DSAP HANA Cloud

How the community answered

(17 responses)
  • B
    88% (15)
  • C
    6% (1)
  • D
    6% (1)

Explanation

SQLite is the recommended choice for local development because it is a lightweight, serverless, file-based database that requires zero installation or configuration - you can start building immediately without running a database server. In frameworks like SAP CAP (Cloud Application Programming model), SQLite is the built-in default for local development precisely for this reason.

Why the distractors are wrong:

  • A (Nosat) - Not a real database; likely a fabricated distractor.
  • C (PostgreSQL) - A robust production-grade database, but requires a running server and additional setup, making it overkill for local dev.
  • D (SAP HANA Cloud) - A cloud-hosted database intended for production/staging environments; unusable offline and adds unnecessary complexity for local work.

Memory tip: Think "Simple Start = SQLite" - when you're developing locally, you want the simplest option that needs no server. SQLite lives in a single file on your machine, so it's the natural fit before you move to a cloud or production database.

Topics

#CAP#SQLite#local development#database

Community Discussion

No community discussion yet for this question.

Full C_CPE_2409 Practice