A SQL Dashboard was built for the supply chain team to monitor the inventory and product orders, but all of the timestamps displayed on the dashboards are showing in UTC format, so they requested to change the time zone to the location of New York.
How would you approach resolving this issue?
A . Move the workspace from Central US zone to East US Zone
B. Change the timestamp on the delta tables to America/New_York format
C. Change the spark configuration of SQL endpoint to format the timestamp to Ameri-ca/New_York
D. Under SQL Admin Console, set the SQL configuration parameter time zone to Ameri-ca/New_York
E. Add SET Timezone = America/New_York on every of the SQL queries in the dashboard.
Answer: D
Explanation:
The answer is, Under SQL Admin Console, set the SQL configuration parameter time zone to America/New_York
Here are steps you can take this to configure, so the entire dashboard is changed without
changing individual queries
Configure SQL parameters
To configure all warehouses with SQL parameters:
Latest Databricks Certified Professional Data Engineer Dumps Valid Version with 222 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund