Answer-first summary for fast verification
Answer: Under SQL Admin Console, set the SQL configuration parameter time zone to America/New_York
The correct answer is to set the SQL configuration parameter time zone to America/New_York under the SQL Admin Console. This approach ensures the entire dashboard reflects the New York time zone without the need to alter individual queries. Here's how to configure it: 1. Click Settings at the bottom of the sidebar and select SQL Admin Console. 2. Click the SQL Warehouse Settings tab. 3. In the SQL Configuration Parameters textbox, specify the timezone parameter followed by America/New_York, each on a new line if there are multiple parameters. This method is efficient and applies the change across all relevant queries automatically.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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?
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 America/New_York
D
Under SQL Admin Console, set the SQL configuration parameter time zone to America/New_York
E
Add SET Timezone = America/New_York on every of the SQL queries in the dashboard.