DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

Question

You have a Fabric warehouse containing two tables named DimDate and Trips.

DimDate contains the following fields.

Question Image

Trips contains the following fields.

Question Image

You need to compare the average miles per trip for statutory holidays with non-statutory holidays.

How should you complete the T-SQL statement?

Select

Select d.IsHoliday,
     as MilesPerTrip
from dbo.Trips t
inner join dbo.DimDate d on t.dateID = d.DateID
 d.IsHoliday

Explanation

Average miles per trip is calculated as the sum of trip distances divided by the count of trip identifiers. Since d.IsHoliday is selected with an aggregate, it must be included in the GROUP BY clause, which produces one average for statutory holidays and one for non-statutory holidays.

DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

AstroTutor

Notes

Readiness

QuestionQ190

Community Discussion