Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.