LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Databricks Certified Data Engineer - Associate

Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.


Comments

Loading comments...

A data engineer is curating data in the silver layer of a hospital management data warehouse system. The data engineer is trying to aggregate hospital billing data from a table patient_billing to generate a daily revenue fact table daily_revenue.

Assume this as a sample of dataframe billing_df:

billing_idpatient_iddepartmentbilling_dateamount_billedquantity
401p001Cardiology2024-03-0115001
402p002Radiology2024-03-0230001
403p001Cardiology2024-03-0165001
404p003Radiology2024-03-035001

Which code snippet aggregates the amount billed per day with the unique invoices from a Dataframe billing_df? (Options were provided separately.)

Other Sources
Community
DDucse



Powered ByGPT-5