Exam Certified Data Engineer Professional topic 1 question 116 discussion

Seems right

The correct answer is B. In environments where interactive code will be executed, production data should only be accessible with read permissions; creating isolated databases for each environment further reduces risks. Explanation: Best practices for managing production, development, and testing environments involve minimizing the risk of unintended data modifications or deletions, especially when dealing with production data. The ideal setup includes: Limiting permissions: Production data should only be accessible with read permissions in development or testing environments to prevent accidental changes. Isolating environments: Creating separate databases for development, testing, and production environments ensures that there are clear boundaries and that development code cannot unintentionally affect production data.