A SQL Dashboard was created for the supply chain team to monitor inventory and product orders. However, all timestamps on the dashboards are displayed in UTC format. The team has requested to adjust the time zone to New York's local time. What is the best approach to resolve this issue?

Real Exam

Move the workspace from Central US zone to East US Zone

6.5%

Change the timestamp on the delta tables to America/New_York format_

16.2%

Change the spark configuration of SQL endpoint to format the timestamp to America/New_York_

20.8%

Under SQL Admin Console, set the SQL configuration parameter time zone to America/New_York_

44.8%

Add SET Timezone = America/New_York on every of the SQL queries in the dashboard._

11.7%

Databricks Certified Data Engineer - Associate