CCSP Cloud Platform and Infrastructure Security Practice Question
A company uses Azure Functions for serverless data processing. To securely access an Azure SQL database, which of the following is the most secure method for managing the database connection string?
⚠ Common exam trap
The trap is treating 'encrypted at rest' or 'environment variable' as equivalent to secure secret management; the exam expects you to know that only a dedicated secret store (Key Vault) accessed via managed identity removes the secret from code and configuration entirely.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Reference the connection string from Azure Key Vault using a managed identity
Referencing the connection string from Azure Key Vault using a managed identity eliminates secrets from code and configuration entirely: the Function App authenticates to Key Vault via its Microsoft Entra ID managed identity, and Key Vault returns the secret at runtime. This removes the need to store, rotate, or transmit the credential manually and is Microsoft's recommended pattern for secret management.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Embed the connection string in the function code and encrypt the code file
Why it's wrong here
Embedding the string in code places the secret in source control, build artefacts and deployment history, and file encryption does not prevent a reader of the running function from extracting it. It tempts as self-contained, yet Key Vault retrieval via managed identity removes the secret from code entirely.
- ✗
Store the connection string as an environment variable in the function app settings
Why it's wrong here
Function app settings are readable by anyone with Contributor on the app and surface in portal and deployment slots, so the secret is not isolated from code or operators. It tempts because app settings beat hard-coding, but the correct approach references the string from Azure Key Vault via a managed identity.
- ✗
Use Azure Policy to enforce encryption of the connection string at rest
Why it's wrong here
Azure Policy audits or enforces configuration properties; it cannot encrypt a connection string value, since encryption at rest is applied by the platform to the storage medium. It tempts because policy governs compliance, but the stem asks how the secret itself is managed, which Key Vault with managed identity satisfies.
- ✓
Reference the connection string from Azure Key Vault using a managed identity
Why this is correct
A managed identity lets Azure Functions authenticate to Key Vault without stored credentials, and the connection string is retrieved at runtime rather than embedded in code or configuration. This satisfies the stem's most-secure requirement by eliminating secrets from the application entirely.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
About these practice questions
This CCSP question is part of Courseiva's 934-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official ISC2 exam blueprint
This CCSP practice question is part of Courseiva's free ISC2 certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the CCSP exam.