Practice · dbt Architect Certification Exam

~/dbtlabs-dbt-architect · dbtlabs-dbt-architect_d1_efc9de405401 ▊

← dbt Architect Certification Exam · practice sheet

dbtlabs-dbt-architect_d1_efc9de405401 domain/d1 · medium single

Your team is setting up a production deployment environment in dbt and is deciding how to authenticate the connection to the data warehouse. A developer suggests reusing his personal SSO-based OAuth credentials so the deployment jobs run under his identity. Why is this approach discouraged for production deployments?

A SSO OAuth tokens rely on authentication sessions that can expire or require re-authentication, causing unexpected failures in automated deployment jobs.
B SSO OAuth connections cannot technically reach cloud data warehouses due to incompatible authentication protocols.
C SSO OAuth connections prevent the use of environment variables that production deployments require.
D SSO OAuth connections can only be used by users holding the Account Admin role.

Unlock this exam to join the per-question discussion and vote on questions.

next question →