dbt Core vs dbt Cloud - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to print the main difference between dbt Core and dbt Cloud.

dbt

print('dbt Core is open-source and [1] while dbt Cloud is a managed service.')

Drag options to blanks, or click blank then click option'

Afree to use locally

Bonly for cloud

Ca database

Da paid software

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'only for cloud' because both run in cloud environments.

Confusing dbt Core as paid software.

dbt Core is open-source and free to use locally, while dbt Cloud is a managed service with additional features.

2fill in blank

medium

Complete the code to show which feature is exclusive to dbt Cloud.

dbt

features = ['job scheduling', 'collaboration', '[1]']
print('dbt Cloud offers:', features)

Drag options to blanks, or click blank then click option'

Alocal command line

Bopen-source code

Cmanual runs only

Dintegrated IDE

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'open-source code' which applies to dbt Core.

Selecting 'manual runs only' which is not true for dbt Cloud.

dbt Cloud includes an integrated IDE for easier development, which dbt Core does not provide.

3fill in blank

hard

Fix the error in the code that compares deployment methods.

dbt

deployment = 'dbt Core runs on local machines, dbt Cloud runs on [1]'
print(deployment)

Drag options to blanks, or click blank then click option'

Acloud infrastructure

Blocal servers

Cdesktop apps

Doffline mode

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'local servers' which is for dbt Core.

Selecting 'offline mode' which is not applicable.

dbt Cloud runs on cloud infrastructure managed by the provider, unlike dbt Core which runs locally.

4fill in blank

hard

Fill both blanks to create a dictionary showing pricing models.

dbt

pricing = {'dbt Core': '[1]', 'dbt Cloud': '[2]'}
print(pricing)

Drag options to blanks, or click blank then click option'

Afree and open-source

Bsubscription-based

Cone-time purchase

Dpay per use

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing pricing models between the two.

Choosing 'one-time purchase' which is not typical for dbt Cloud.

dbt Core is free and open-source, while dbt Cloud uses a subscription-based pricing model.

5fill in blank

hard

Fill all three blanks to complete the code that lists key differences.

dbt

differences = {
  'deployment': '[1]',
  'features': '[2]',
  'pricing': '[3]'
}
print(differences)

Drag options to blanks, or click blank then click option'

Alocal vs cloud

Bopen-source vs managed

Cfree vs subscription

Dmanual vs automatic

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up deployment and pricing terms.

Choosing unrelated options like 'manual vs automatic'.

The key differences are deployment (local vs cloud), features (open-source vs managed), and pricing (free vs subscription).