nerdexam
Databricks

CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #110

The data engineer team is configuring environment for development testing, and production before beginning migration on a new data pipeline. The team requires extensive testing on both the code and da

The correct answer is C. In environments where interactive code will be executed, production data should only be. The best practice in such scenarios is to ensure that production data is handled securely and with proper access controls. By granting only read access to production data in development and testing environments, it mitigates the risk of unintended data modification. Additionally,

Data Security and Governance

Question

The data engineer team is configuring environment for development testing, and production before beginning migration on a new data pipeline. The team requires extensive testing on both the code and data resulting from code execution, and the team want to develop and test against similar production data as possible. A junior data engineer suggests that production data can be mounted to the development testing environments, allowing pre production code to execute against production data. Because all users have Admin privileges in the development environment, the junior data engineer has offered to configure permissions and mount this data for the team. Which statement captures best practices for this situation?

Options

  • ABecause access to production data will always be verified using passthrough credentials it is safe
  • BAll developer, testing and production code and data should exist in a single unified workspace;
  • CIn environments where interactive code will be executed, production data should only be
  • DBecause delta Lake versions all data and supports time travel, it is not possible for user error or

How the community answered

(28 responses)
  • A
    7% (2)
  • C
    79% (22)
  • D
    14% (4)

Explanation

The best practice in such scenarios is to ensure that production data is handled securely and with proper access controls. By granting only read access to production data in development and testing environments, it mitigates the risk of unintended data modification. Additionally, maintaining isolated databases for different environments helps to avoid accidental impacts on production data and systems.

Topics

#Data Security#Environment Management#Access Control#Data Governance

Community Discussion

No community discussion yet for this question.

Full CERTIFIED-DATA-ENGINEER-PROFESSIONAL Practice