dbt Core vs dbt Cloud - Practice Questions

Challenge - 5 Problems

🧠 Conceptual

intermediate

Key difference between dbt Core and dbt Cloud

Which statement best describes the main difference between dbt Core and dbt Cloud?

A dbt Core is a cloud-only service, while dbt Cloud is a local desktop application.

B dbt Core is an open-source command-line tool, while dbt Cloud is a managed service with a user interface and additional features.

C dbt Core supports scheduling and alerting natively, but dbt Cloud does not.

D dbt Core requires a paid subscription, while dbt Cloud is free and open-source.

💡 Hint

Think about how open-source tools differ from managed cloud services.

dbt Core is the open-source command-line tool for building data transformations. dbt Cloud is a hosted platform that includes dbt Core plus a web interface, job scheduling, logging, and collaboration features.

❓ Predict Output

intermediate

Output of dbt run in dbt Core vs dbt Cloud

Consider running dbt run in both dbt Core and dbt Cloud environments. Which output is unique to dbt Cloud?

A A web dashboard showing job status and logs after the run completes.

B A command-line printout of executed SQL queries.

C A local file with compiled SQL models.

D An error message if the SQL syntax is invalid.

💡 Hint

Think about what extra features a cloud platform provides beyond command-line output.

dbt Cloud provides a web dashboard with job status and logs, which is not available in dbt Core's command-line interface.

❓ data_output

advanced

Scheduling dbt jobs in Core vs Cloud

You want to schedule a dbt job to run every night at midnight. Which environment supports this natively, and what is the expected output?

A dbt Core supports native scheduling with cron jobs and shows scheduled runs in the CLI; dbt Cloud does not support scheduling.

B Both dbt Core and dbt Cloud support native scheduling and provide identical scheduling dashboards.

C dbt Cloud supports native scheduling and will show scheduled job runs in the UI; dbt Core requires external schedulers and has no native output for scheduling.

D Neither dbt Core nor dbt Cloud support scheduling; you must use third-party tools.

💡 Hint

Consider which tool includes a user interface and built-in job management.

dbt Cloud includes native job scheduling with a UI to monitor runs. dbt Core requires you to set up scheduling externally, such as with cron or Airflow.

🔧 Debug

advanced

Debugging environment variable usage in dbt Core vs dbt Cloud

You set an environment variable DBT_ENV_VAR to configure your dbt project. In which environment will this variable be automatically available during runs, and why might it fail in the other?

A dbt Cloud automatically injects environment variables set in the UI during runs; dbt Core requires manual export in the shell before running.

B dbt Core automatically reads environment variables from a config file; dbt Cloud ignores environment variables.

C Both dbt Core and dbt Cloud ignore environment variables and require hardcoded values.

D dbt Core requires environment variables to be set in the UI; dbt Cloud reads them from the local shell.

💡 Hint

Think about how environment variables are managed in cloud vs local command-line environments.

dbt Cloud allows setting environment variables in its UI, which are injected during runs. dbt Core depends on the local shell environment, so variables must be exported manually.

🚀 Application

expert

Choosing between dbt Core and dbt Cloud for a team

Your data team wants to collaborate on models, schedule runs, and monitor logs easily without managing infrastructure. Which option best fits their needs and why?

A Use neither; both dbt Core and dbt Cloud lack collaboration and scheduling features.

B Use dbt Core because it has a graphical interface for collaboration and built-in scheduling.

C Use dbt Core because it automatically manages cloud infrastructure and user access.

D Use dbt Cloud because it provides collaboration tools, scheduling, and logging in a managed environment.

💡 Hint

Consider which product is designed for teams and managed services.

dbt Cloud is designed for teams with collaboration, scheduling, and logging features built-in. dbt Core is a command-line tool without these managed features.