Courseiva

DP-203 Practice Question: Secure, monitor, and optimize data storage and data processing

Your organization uses Azure Data Factory to orchestrate data pipelines. You need to ensure that sensitive data is not exposed in pipeline logs. What should you configure?

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

Enable 'Secure output' on pipeline activities.

Enabling 'Secure output' on pipeline activities prevents sensitive data from being written to Azure Data Factory logs. Option A is incorrect because while storing connection strings in Azure Key Vault is a security best practice, it does not prevent sensitive data from appearing in pipeline logs. Option C is incorrect because setting a retention policy for logs controls how long logs are kept, but does not prevent sensitive data exposure. Option D is incorrect because data flow debug logs are for debugging and do not mask sensitive data in pipeline logs.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Store connection strings in Azure Key Vault.

    Why it's wrong here

    Key Vault stores secrets but does not mask pipeline logs.

  • Enable 'Secure output' on pipeline activities.

    Why this is correct

    Secure output masks sensitive data in activity logs.

  • Set a retention policy for pipeline logs.

    Why it's wrong here

    Retention policy does not mask sensitive data.

  • Use data flow debug logs with session logs.

    Why it's wrong here

    Debug logs may still expose sensitive data.

About these practice questions

Courseiva writes every DP-203 question from scratch — 760 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DP-203 practice question is part of Courseiva's free Microsoft 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 DP-203 exam.