SnowPro Advanced: Data Engineer — Question 86

To meet governance requirements, a company needs to completely isolate its production environment from its development and testing environments. The solution must prevent zero-copy cloning from occurring.

How can these requirements be met?

Answer options

• A. Create one account and ensure that strict process controls are in place including a strict Role-based Access Control (RBAC) strategy.
• B. Create one account that includes one database for each business function. Within the database, use separate schemas to isolate production, development, and test environments.
• C. Create one account that separates the production, development, and testing environments by database. Use Role-based Access Control (RBAC) to further isolate these environments based on roles/grants.
• D. Create three separate accounts, one each for the production, development, and testing environments, and manage each account individually.

Correct answer: D

Explanation

The correct answer is D because creating three separate accounts ensures complete isolation of the production, development, and testing environments, which is crucial for governance. The other options do not provide the required level of separation, as they either rely on schemas or a single account structure, which could allow for potential data access and cloning issues.