Free DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine Demo

Q2 Single choice

A platform team lead is responsible for automating the individual teams attribution towards SQL Warehouse usage. The requirement is to identify the SQL warehouse usage at the individual user's level and generate a daily report to be shared with an executive team that includes leaders from all business units.

How should the platform lead generate an automated report that can be shared daily?

A
Use the system tables to capture the audit and billing usage data and share the queries with the executive team. This enables the executives to execute the query and see the latest results any time.
B
Use the system tables to capture the audit and billing usage data and create a dashboard with daily refresh schedules and shared with the executive team.
C
Restrict users from running any SQL query unless they provide all the query details so that the attribution can be calculated and shared with the executive team.
D
Let the users run the SQL query and then directly report the usage to the executives. The ownership of the SQL warehouse usage will be with the individual teams.

DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine demo