Free Practice Questions for DBT Architect Certification Exam Certification
Study with 341 exam-style practice questions designed to help you prepare for the DBT Architect Certification Exam.
Start Practicing
Random Questions
Practice with randomly mixed questions from all topics
Domain Mode
Practice questions from a specific topic area
Exam Information
Exam Details
Key information about DBT Architect Certification Exam
- Multiple choice
- Ordering
- Matching
$200
English
Multiple-choice, Fill-in-the-blank, Matching, Hotspot, Build list, Discrete Option Multiple Choice (DOMC)
65% or higher
SQL proficiency, at least six months of experience administrating an Enterprise dbt account, dbt Fundamentals badge
online proctored
120 minutes
Caveon Web browsers
65 questions
2 years
Exam Topics & Skills Assessed
Skills measured (from the official study guide)
Domain 1: Configuring dbt data warehouse connections
Subdomain 1.1: Understanding how to connect the warehouse
Understanding how to connect the warehouse
Subdomain 1.2: Configuring IP whitelist
Configuring IP whitelist
Subdomain 1.3: Creating and testing a connection for the project
Creating and testing a connection for the project
Subdomain 1.4: Authenticating through OAuth to access the data in dbt
Authenticating through OAuth to access the data in dbt
Subdomain 1.5: Adding Client ID and Secret for OAuth
Adding Client ID and Secret for OAuth
Domain 2: Configuring dbt git connections
Subdomain 2.1: Connecting the git repo to dbt
Connecting the git repo to dbt
Subdomain 2.2: Setting up integrations with git providers
Setting up integrations with git providers
Domain 3: Creating and maintaining dbt environments
Subdomain 3.1: Understanding access control to different environments
Understanding access control to different environments
Subdomain 3.2: Determining when to use a service account
Determining when to use a service account
Subdomain 3.3: Rotating key pair authentication via the API
Rotating key pair authentication via the API
Subdomain 3.4: Understanding environment variables
Understanding environment variables
Subdomain 3.5: Creating a new dbt deployment environment
Creating a new dbt deployment environment
Subdomain 3.6: Setting a default schema/dataset for environments
Setting a default schema/dataset for environments
Subdomain 3.7: Understanding custom branches and how to configure them to environments
Understanding custom branches and how to configure them to environments
Subdomain 3.8: Configuring dbt to allow deferral to other environments
Configuring dbt to allow deferral to other environments
Domain 4: Creating and maintaining job definitions
Subdomain 4.1: Set up a CI job with deferral
Set up a CI job with deferral
Subdomain 4.2: Understanding steps within a dbt job
Understanding steps within a dbt job
Subdomain 4.3: Scheduling a job to run on schedule
Scheduling a job to run on schedule
Subdomain 4.4: Implementing run commands in the correct order
Implementing run commands in the correct order
Subdomain 4.5: Creating a new dbt job
Creating a new dbt job
Subdomain 4.6: Configuring optional settings such as environment variable overrides, threads, deferral, target name, and dbt version override
Configuring optional settings such as environment variable overrides, threads, deferral, target name, and dbt version override
Subdomain 4.7: Generating documentation on a job that populates the dbt Catalog page
Generating documentation on a job that populates the dbt Catalog page
Subdomain 4.8: Configuring jobs to be triggered after other dbt jobs (job chaining)
Configuring jobs to be triggered after other dbt jobs (job chaining)
Subdomain 4.9: Configuring Advanced CI
Configuring Advanced CI
Subdomain 4.10: Configuring self-deferral
Configuring self-deferral
Subdomain 4.11: Understanding when to use which type of job deferral
Understanding when to use which type of job deferral
Domain 5: Configuring dbt security and licenses
Subdomain 5.1: Creating service tokens for API access
Creating service tokens for API access
Subdomain 5.2: Assigning permission sets
Assigning permission sets
Subdomain 5.3: Creating license mappings
Creating license mappings
Subdomain 5.4: Adding and removing users
Adding and removing users
Subdomain 5.5: Adding SSO application for dbt Enterprise
Adding SSO application for dbt Enterprise
Subdomain 5.6: Creating and assigning RBAC
Creating and assigning RBAC
Domain 6: Setting up monitoring and alerting for jobs
Subdomain 6.1: Setting up email notifications
Setting up email notifications
Subdomain 6.2: Using Webhooks for event-driven integrations with other systems
Using Webhooks for event-driven integrations with other systems
Domain 7: Setting up a dbt mesh and leveraging cross-project references
Subdomain 7.1: Setting up additional dbt projects
Setting up additional dbt projects
Subdomain 7.2: Understanding how environment types relate to cross-project references
Understanding how environment types relate to cross-project references
Subdomain 7.3: Utilizing model governance
Utilizing model governance
Domain 8: Configuring and using dbt Catalog
Subdomain 8.1: Using dbt Catalog to understand the current lineage, troubleshoot issues and optimise cost and performance
Using dbt Catalog to understand the current lineage, troubleshoot issues and optimise cost and performance
Subdomain 8.2: Using dbt Catalog to find public models and cross-project references
Using dbt Catalog to find public models and cross-project references
Techniques & products