100+ Free dbt Architect Practice Questions

Pass your dbt Architect Certification exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately

100+ Questions

100% Free

1 / 10

Question 1

Score: 0/0

Which authentication methods does dbt Cloud support for Snowflake?

Password, key pair, and OAuth (user or service-level)

Password only

Kerberos only

No authentication

to track

2026 Statistics

Key Facts: dbt Architect Exam

Questions

dbt Labs

2 hours

Time Limit

dbt Labs

65%

Passing Score

dbt Labs

$200

Exam Fee

dbt Labs

2 years

Validity

dbt Labs

Talview

Proctor

dbt Labs

As of April 15, 2026, the dbt Labs page lists the Architect exam as 65 questions, 2 hours, with a 65% passing score and a $200 fee, delivered via Talview with live proctoring. The current blueprint covers configuring warehouse connections, Git connections, environments, job definitions, dbt security and licenses, monitoring and alerting, dbt Mesh and cross-project references, and dbt Catalog. Certification is valid for 2 years. Prerequisites: SQL proficiency plus at least six months administrating an Enterprise dbt Cloud account.

Sample dbt Architect Practice Questions

Try these sample questions to test your dbt Architect exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1Which authentication methods does dbt Cloud support for Snowflake?

A.Password, key pair, and OAuth (user or service-level)

B.Password only

C.Kerberos only

D.No authentication

Explanation: Snowflake supports several auth methods in dbt Cloud. Password is simple but discouraged for production; key pair and OAuth are recommended for service accounts and user-level auth.

2Which BigQuery authentication is suitable for a shared service account in dbt Cloud?

A.Service account JSON key or OAuth

B.Anonymous access

C.No authentication

D.Snowflake SSO

Explanation: BigQuery integrations in dbt Cloud accept service account JSON keys and OAuth. Anonymous access is not an option; Snowflake SSO is unrelated.

3For Databricks, which connection method is typical from dbt Cloud?

A.Personal access token (PAT) against a SQL Warehouse endpoint

B.Windows NTLM

C.No authentication

D.Only Oracle Wallet

Explanation: Databricks SQL Warehouses accept PATs for machine authentication. NTLM is not used; unauthenticated access is not permitted; Oracle Wallet is for Oracle only.

4Which Redshift-specific dbt connection setting is required?

A.dbname, host, port, user, password (or IAM), and schema

B.Only password

C.Only hostname

D.Only port

Explanation: dbt's Redshift profile requires multiple fields: dbname, host, port, user (with password or IAM), and target schema. Leaving any out causes connection failures.

5Which best describes a Postgres dbt connection?

A.Uses host, user, password, port, dbname, schema just like other Postgres clients

B.Requires a proprietary JDBC driver written by dbt Labs

C.Works only with Amazon RDS

D.Works only over SSH tunnel

Explanation: Postgres connections are standard. Enterprise teams often add SSH tunnels or VPNs but dbt's adapter mirrors typical Postgres client behavior.

6Why configure warehouse-specific roles for dbt service accounts?

A.Enforce least privilege: models can read sources, write to schemas they own, and are blocked elsewhere

B.Increase cost

C.Hide queries

D.Disable MFA

Explanation: Separate roles per environment constrain what dbt can read or write. This is the backbone of data governance in warehouses.

7Which is a recommended Snowflake setup for a production dbt workload?

A.Dedicated virtual warehouse scaled for concurrency with auto-suspend and auto-resume

B.Use a laptop

C.Share a single small warehouse across all teams

D.Disable auto-suspend to save startup time

Explanation: A dedicated warehouse sized for dbt's concurrent threads keeps runtime predictable and costs controlled. Auto-suspend and auto-resume minimize idle spend.

8What is the safest way to store long-lived warehouse credentials in dbt Cloud?

A.Encrypted in dbt Cloud connection settings and/or environment variables, never in Git

B.In the Git repo in plain text

C.In a README

D.In a Slack DM

Explanation: dbt Cloud stores credentials encrypted at rest. Git and chat channels are not credential stores.

9Which pattern is best for dbt Cloud hitting a database behind a private network?

A.Use dbt Cloud IP allowlisting plus a private connection option (PrivateLink, Private Service Connect, VPN)

B.Expose the database to the public internet

C.Copy data nightly to a public database

D.Trust random proxies

Explanation: dbt Cloud supports IP allowlists and private network options. Exposing production databases to the internet is unacceptable.

10How does Snowflake key pair authentication differ from password auth?

A.Key pair uses RSA keys bound to a user, supports rotation, and avoids sending passwords

B.Key pair requires no user

C.Key pair is less secure

D.Key pair works only for admin users

Explanation: Key pair auth binds a public key to a user in Snowflake and uses the corresponding private key from dbt Cloud. It is more secure and easier to rotate than passwords.

About the dbt Architect Exam

The dbt Architect Certification validates the ability to administer dbt Cloud at scale. It covers warehouse and Git connections, environments, job definitions, security and RBAC, monitoring and alerting, dbt Mesh with cross-project references, and dbt Catalog — the skills expected of an Enterprise dbt Cloud administrator.

Assessment

65 questions including multiple-choice, matching, fill-in-the-blank, and hotspot

Time Limit

2 hours

Passing Score

65%

Exam Fee

$200 (dbt Labs)

dbt Architect Exam Content Outline

15%

Warehouse Connections

Connecting dbt Cloud to Snowflake, BigQuery, Databricks, Redshift, and Postgres; service accounts, key pair authentication, OAuth, and environment-level overrides.

10%

Git Connections

Connecting to GitHub, GitLab, Azure DevOps, and generic Git; native vs app integrations, branch protection, and PR CI triggers.

15%

Environments

Development vs deployment environments, environment variables, deferral targets, custom branches, and promoting from staging to production.

15%

Job Definitions

Scheduled jobs, CI jobs, generic jobs, commands, selectors, threads, warnings-as-errors, and webhook-triggered jobs.

10%

Security and Licenses

RBAC, groups, permissions, SSO/SAML, SCIM provisioning, developer vs read-only vs IT licenses, and IP allowlists.

10%

Monitoring and Alerting

Job notifications, webhooks, Slack and email alerts, run history, Artifacts API, and integrating with observability tools.

15%

dbt Mesh and Cross-project Refs

Splitting projects, dbt Mesh, access modifiers, ref() across projects, groups, contracts, versions, and governance patterns.

10%

dbt Catalog and Metadata

dbt Catalog (formerly dbt Explorer), column-level lineage, exposures, semantic layer integration, and metadata APIs.

How to Pass the dbt Architect Exam

What You Need to Know

Passing score: 65%
Assessment: 65 questions including multiple-choice, matching, fill-in-the-blank, and hotspot
Time limit: 2 hours
Exam fee: $200

Keys to Passing

Complete 500+ practice questions
Score 80%+ consistently before scheduling
Focus on highest-weighted sections
Use our AI tutor for tough concepts

dbt Architect Study Tips from Top Performers

1Memorize the supported warehouse auth patterns: Snowflake key pair vs password, BigQuery service account key vs OAuth, Databricks personal access token.

2Know the difference between a development environment and a deployment environment, and what defer does when CI is configured.

3Understand job selectors: --select, --exclude, state:modified+, source_status:fresher+, and how selectors combine.

4Review RBAC: group permissions, licenses (developer, read-only, IT), and how SCIM provisioning affects group membership.

5Practice Mesh scenarios: a model with access=private is not referenceable across projects, public is, and group-level protected limits to defined groups.

6Get familiar with dbt Catalog navigation: column-level lineage, exposures, and the difference between Catalog and the legacy dbt Explorer.

Frequently Asked Questions

How many questions are on the dbt Architect exam?

The dbt Labs page lists 65 questions with a 2 hour time limit and a 65% passing score. The exam is delivered online via Talview with live proctoring, and you will see your score immediately after submitting.

How is this different from the Analytics Engineering exam?

The Analytics Engineering exam focuses on modeling, testing, documentation, and Jinja — the day to day work of building dbt projects. The Architect exam focuses on administering dbt Cloud: connections, environments, jobs, security, monitoring, Mesh, and Catalog. Both exams are 65 questions, 2 hours, and $200, but the Architect exam assumes admin experience.

What experience should I have?

dbt Labs recommends SQL proficiency and at least six months administering an Enterprise dbt Cloud account. Many candidates hold the Analytics Engineering credential first, then move into Cloud administration, then take Architect.

Does the Architect exam cover dbt Mesh in depth?

Yes. Mesh, groups, access modifiers (public, protected, private), contracts, versions, and cross-project ref() are core topics. Expect scenario questions that ask whether a downstream project can reference a model given its access configuration.

How long is the certification valid?

The Architect certification is valid for 2 years from the date you earn it. You will need to retake to recertify and stay aligned with dbt Cloud product changes.

How long should I prepare?

Practicing admins typically prepare 3-6 weeks with a running dbt Cloud trial. Spend the most time on environments, jobs, Mesh, and permissions. Architecture-level exams reward scenario reasoning, so do a lot of 'which action would you take' practice questions.