Billing dashboard overview in AWS - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select the total cost metric in the billing dashboard query.

AWS

SELECT [1] FROM billing_data WHERE service = 'Amazon EC2'

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

Aservice_name

Btotal_cost

Cusage_quantity

Dbilling_period

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting service_name instead of total_cost

Using usage_quantity which is not a cost metric

The total_cost column contains the cost values needed for the billing dashboard.

2fill in blank

medium

Complete the code to filter billing data for the month of January 2024.

AWS

SELECT total_cost FROM billing_data WHERE billing_period = [1]

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

A'2024-01'

B'2023-11'

C'2024-02'

D'2023-12'

Attempts:

3 left

💡 Hint

Common Mistakes

Using December 2023 or other months by mistake

Omitting quotes around the date string

To filter for January 2024, use the billing_period value '2024-01'.

3fill in blank

hard

Fix the error in the DAX measure to calculate total billing cost.

AWS

TotalCost = SUM([1])

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

Abilling_data[total_cost]

Bbilling_data[service_name]

Cbilling_data[usage_quantity]

Dbilling_data[billing_period]

Attempts:

3 left

💡 Hint

Common Mistakes

Summing usage_quantity instead of total_cost

Using non-numeric columns like service_name

The SUM function should be applied to the total_cost column to get the total billing cost.

4fill in blank

hard

Fill both blanks to create a filter expression that shows costs only for the 'Amazon S3' service in March 2024.

AWS

FILTER(billing_data, billing_data[service] = [1] && billing_data[billing_period] = [2])

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

A'Amazon S3'

B'2024-03'

C'Amazon EC2'

D'2024-04'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong service name or billing period

Mixing up the order of conditions

The filter should check for 'Amazon S3' service and billing period '2024-03' for March 2024.

5fill in blank

hard

Fill all three blanks to create a calculated measure that sums total cost for a selected service and billing period.

AWS

TotalCostSelected = CALCULATE(SUM(billing_data[[1]]), billing_data[service] = [2], billing_data[billing_period] = [3])

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

Atotal_cost

B'Amazon DynamoDB'

C'2024-05'

Dusage_quantity

Attempts:

3 left

💡 Hint

Common Mistakes

Using usage_quantity instead of total_cost

Omitting quotes around service or billing period

Swapping service and billing period values

The measure sums the total_cost column filtered by service 'Amazon DynamoDB' and billing period '2024-05'.