dbt Cloud deployment - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the dbt Cloud job ID for deployment.

dbt

job_id = [1]

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

A'12345'

B12345

Cjob_id

DNone

Attempts:

3 left

💡 Hint

Common Mistakes

Using the job ID as a number without quotes.

Using an undefined variable instead of a string.

The job ID must be a string, so it needs to be enclosed in quotes.

2fill in blank

medium

Complete the code to trigger a dbt Cloud job run using the API.

dbt

response = client.run_job(job_id=[1])

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

A'job_id'

Bjob_id

C12345

DNone

Attempts:

3 left

💡 Hint

Common Mistakes

Passing the job ID as a string literal instead of variable.

Passing a number directly without variable.

The variable job_id should be passed without quotes to use its value.

3fill in blank

hard

Fix the error in the code to check if the dbt Cloud job run was successful.

dbt

if response.status_code == [1]:
    print('Run succeeded')

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

AOK

B'200'

CTrue

D200

Attempts:

3 left

💡 Hint

Common Mistakes

Comparing status_code to string '200' instead of integer 200.

Using boolean or string literals instead of numeric code.

The status code is an integer, so it should be compared to 200 without quotes.

4fill in blank

hard

Fill both blanks to create a dictionary with job ID and cause for triggering a run.

dbt

payload = [1]: [2]

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

A{'job_id'}

B'job_id'

C12345

D'Triggered by API'

Attempts:

3 left

💡 Hint

Common Mistakes

Using set notation instead of dictionary for keys.

Using numbers instead of descriptive strings for values.

The dictionary key should be a string 'job_id' and the value a string describing the cause.

5fill in blank

hard

Fill both blanks to create a dictionary comprehension filtering runs with status 'success'.

dbt

successful_runs = {run: run['id'] [1] run in runs if run['status'] [2] 'success'}

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

A['name']

B:

C==

D.get()

Attempts:

3 left

💡 Hint

Common Mistakes

Using '.' instead of ':' in dictionary comprehension.

Using '.get()' instead of direct key access.

Using '=' instead of '==' for comparison.

Use ':' to separate key and value, access run['name'], and check status with '=='.

Practice

1. What is the main purpose of dbt Cloud deployment?

easy

A. To automate running data transformations in the cloud

B. To write SQL queries manually every time

C. To store raw data without processing

D. To create dashboards for data visualization

Solution

1. Step 1: Understand dbt Cloud deployment

   dbt Cloud deployment is designed to automate the running of data transformation commands in a cloud environment.

2. Step 2: Compare options with purpose

   Only To automate running data transformations in the cloud describes automation of data transformations in the cloud, which matches the main purpose.

3. Final Answer:

   To automate running data transformations in the cloud -> Option A

4. Quick Check:

   dbt Cloud deployment = automate transformations [OK]

Hint: Remember: dbt Cloud runs your data jobs automatically [OK]

Common Mistakes:

• Confusing deployment with manual query writing
• Thinking dbt Cloud is for raw data storage only
• Mixing deployment with visualization tools

2. Which of the following is the correct way to schedule a job in dbt Cloud UI?

easy

A. Upload SQL files to the cloud storage

B. Write a Python script to run dbt commands

C. Manually run dbt commands every hour

D. Set a cron expression to run commands automatically

Solution

1. Step 1: Identify scheduling method in dbt Cloud

   dbt Cloud UI allows scheduling jobs using cron expressions to automate command runs.

2. Step 2: Eliminate incorrect options

   Options B, C, and D do not describe scheduling via the UI; only "Set a cron expression to run commands automatically" correctly describes cron scheduling.

3. Final Answer:

   Set a cron expression to run commands automatically -> Option D

4. Quick Check:

   Scheduling in dbt Cloud = cron expression [OK]

Hint: Scheduling uses cron expressions in dbt Cloud UI [OK]

Common Mistakes:

• Confusing manual runs with scheduled jobs
• Thinking Python scripts are needed for scheduling
• Assuming uploading files schedules jobs

3. Given this dbt Cloud job configuration:

commands:
  - dbt run
schedule: '0 2 * * *'

What does this job do?

medium

A. Runs dbt seed command once a week

B. Runs dbt tests every hour

C. Runs dbt transformations every day at 2 AM

D. Runs dbt run command manually

Solution

1. Step 1: Interpret the schedule cron expression

   The cron '0 2 * * *' means the job runs daily at 2:00 AM.

2. Step 2: Identify the command being run

   The command is 'dbt run', which runs data transformations.

3. Final Answer:

   Runs dbt transformations every day at 2 AM -> Option C

4. Quick Check:

   dbt run + daily 2 AM = Runs dbt transformations every day at 2 AM [OK]

Hint: Cron '0 2 * * *' means daily at 2 AM [OK]

Common Mistakes:

• Misreading cron schedule as hourly or weekly
• Confusing 'dbt run' with 'dbt test' or 'dbt seed'
• Assuming manual run instead of scheduled

4. You set up a dbt Cloud job with this schedule:

schedule: '60 2 * * *'

What is the problem with this schedule?

medium

A. The hour value 2 is invalid in cron syntax

B. The minute value 60 is invalid in cron syntax

C. The schedule runs too frequently

D. There is no problem; it is valid

Solution

1. Step 1: Check cron minute value

   Cron minutes must be between 0 and 59; 60 is invalid.

2. Step 2: Check cron hour value

   Hour 2 is valid (0-23), so the problem is the minute value.

3. Final Answer:

   The minute value 60 is invalid in cron syntax -> Option B

4. Quick Check:

   Cron minute max = 59, 60 invalid [OK]

Hint: Cron minutes max 59, hours max 23 [OK]

Common Mistakes:

• Focusing on the hour value instead of the minute
• Assuming schedule is valid without checking ranges
• Thinking frequent runs cause syntax errors

5. You want to deploy a dbt Cloud job that runs tests after transformations finish successfully. Which setup achieves this?

hard

A. Create two jobs: one runs 'dbt run', second runs 'dbt test' triggered after first succeeds

B. Create one job with commands: 'dbt test' then 'dbt run'

C. Schedule 'dbt run' and 'dbt test' to run at the same time

D. Run 'dbt test' only, skipping 'dbt run'

Solution

1. Step 1: Understand job dependencies

   Tests should run only after transformations succeed to validate results.

2. Step 2: Setup jobs with triggers

   Creating two jobs with the second triggered after the first ensures correct order.

3. Step 3: Eliminate incorrect options

   Create one job with commands: 'dbt test' then 'dbt run' runs tests before transformations, C runs both simultaneously, D skips transformations.

4. Final Answer:

   Create two jobs: one runs 'dbt run', second runs 'dbt test' triggered after first succeeds -> Option A

5. Quick Check:

   Test after run = two jobs with trigger [OK]

Hint: Use job triggers to run tests after transformations [OK]

Common Mistakes:

• Running tests before transformations
• Scheduling jobs to run simultaneously
• Skipping transformations before testing