~/dbtlabs-dbt-architect · study ▊

practice sheet · all objectives switch to smart practice →

dbt Architect Certification Exam

0/25 checked

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?

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.

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?

A Add a post-hook in the snapshot config that grants read and write privileges.
B Configure a service account with read and write privileges in the deployment environment settings.
C Add an on-run-end hook in the snapshot config that grants read and write privileges.
D Assign the developer the Job Admin role in dbt.

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

Q_05 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_06 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_07 domain/d2 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_08 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_09 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_10 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_11 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_12 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_13 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_14 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_15 domain/d5 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_16 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_17 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_18 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_19 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_20 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_21 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_22 domain/d7 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_23 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_24 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_25 domain/d8 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

23 questions locked

unlock all 23 questions