~/dbtlabs-dbt-architect · study ▊

← all exams

practice sheet · all objectives switch to smart practice →

dbt Architect Certification Exam

0/4 checked
Practising Configuring dbt data warehouse connections · 4 questions · View the full exam →
Q_01 domain/d1 · medium single discuss →

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?

Q_02 domain/d1 · medium single discuss →

In your dbt project, a snapshot writes to a schema named prod_snapshot. You need developers to be able to read from that schema when working in the dev environment, but only the production job should be able to both read and write to it. What is the recommended way to enforce this?

Q_03 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_04 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

2 questions locked

unlock all 2 questions