Answer-first summary for fast verification
Answer: The entire dashboard with 10 queries can be refreshed at once, requiring a single schedule to be set up to refresh at 8 AM.
The correct approach is to refresh the entire dashboard with all 10 queries at once by setting up a single schedule for 8 AM. This method is efficient and leverages the dashboard's capability to automatically refresh all its queries on a schedule. To configure this, the dashboard owner or users with 'Can Edit' permission can: 1. Click the 'Schedule' button at the top right of the dashboard. 2. Select a period in the 'Refresh every' drop-down. 3. Optionally select a SQL warehouse for the queries in the 'SQL Warehouse' drop-down. 4. Optionally enter email addresses to notify when the dashboard is updated. 5. Click 'Save' to activate the schedule.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
The data engineering team has provided 10 queries for the Data Analyst team to build a dashboard that needs to be refreshed daily at 8 AM. What is the best approach to set up the data refresh for this dashboard?
A
Each query requires a separate task, setting up 10 tasks under a single job to run at 8 AM to refresh the dashboard.
B
Use Incremental refresh to run at 8 AM every day.
C
The entire dashboard with 10 queries can be refreshed at once, requiring a single schedule to be set up to refresh at 8 AM.
D
Setup a JOB with linear dependency to load all 10 queries into a table so the dashboard can be refreshed at once.
E
A dashboard can only refresh one query at a time, necessitating 10 schedules to set up the refresh.
No comments yet.