Trigger-based retraining (schedule, drift, performance) in MLOps - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the SQL query to select all records from the retraining_schedule table.

MLOps

SELECT [1] FROM retraining_schedule;

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

Amodel_name

Bschedule_id

Cretrain_date

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting only one column instead of all columns.

Using incorrect column names.

The * symbol selects all columns from the table.

2fill in blank

medium

Complete the SQL query to find retraining events scheduled after January 1, 2024.

MLOps

SELECT * FROM retraining_schedule WHERE retrain_date [1] '2024-01-01';

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

A<

B>

C<=

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using < which selects dates before the given date.

Using = which selects only that exact date.

The > operator selects dates after January 1, 2024.

3fill in blank

hard

Fix the error in the query to count retraining events triggered by drift.

MLOps

SELECT COUNT(*) FROM retraining_events WHERE trigger_type = [1];

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

A'drift'

Bdrift

C"drift"

Ddrift'

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around string values.

Using mismatched or double quotes incorrectly.

String values in SQL must be enclosed in single quotes.

4fill in blank

hard

Fill both blanks to select model names and their last retraining date for models with performance below 0.8.

MLOps

SELECT model_name, [1] FROM model_performance WHERE performance [2] 0.8;

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

Alast_retrain_date

B>

C<

Dperformance_date

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting the wrong date column.

Using '>' instead of '<' for filtering performance.

Select the last retraining date and filter models with performance less than 0.8.

5fill in blank

hard

Fill all three blanks to create a dictionary of model names to their retraining count where retraining was triggered by schedule.

MLOps

SELECT [1], COUNT(*) AS retrain_count FROM retraining_events WHERE trigger_type = [2] GROUP BY [3];

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

Amodel_name

B'schedule'

Dtrigger_type

Attempts:

3 left

💡 Hint

Common Mistakes

Not grouping by model_name.

Not quoting the string 'schedule'.

Using wrong columns in SELECT or GROUP BY.

Select model names, count retraining events triggered by schedule, and group by model name.