Data engineering team has provided 10 queries and asked Data Analyst team to build a dashboard and refresh the data every day at 8 AM, identify the best approach to set up data refresh for this dashaboard?

Data engineering team has provided 10 queries and asked Data Analyst team to build a dashboard and refresh the data every day at 8 AM, identify the best approach to set up data refresh for this dashaboard?
A . Each query requires a separate task and setup 10 tasks under a single job to run at 8 AM to refresh the dashboard
B. The entire dashboard with 10 queries can be refreshed at once, single schedule needs to be set up to refresh at 8 AM.
C. Setup JOB with linear dependency to all load all 10 queries into a table so the dashboard can be refreshed at once.
D. A dashboard can only refresh one query at a time, 10 schedules to set up the refresh.
E. Use Incremental refresh to run at 8 AM every day.

Answer: B

Explanation:

The answer is,

The entire dashboard with 10 queries can be refreshed at once, single schedule needs to be set up to refresh at 8 AM.

Automatically refresh a dashboard

A dashboard’s owner and users with the Can Edit permission can configure a dashboard to auto-matically refresh on a schedule. To automatically refresh a dashboard:

✑ uk.co.certification.simulator.questionpool.PList@d6d24d0

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments