Free Microsoft Power BI PL-300 Actual Exam Questions - Question 13 Discussion

D/C? Scheduled refresh (D) handles timing, but incremental refresh (C) ensures only last month’s data updates, which might be what they want to save time. Depends if efficiency or timing is the main goal.

D vs A? D makes sense for setting the refresh timing, but if your data source is on-premises, you’ll also need A to enable that scheduled refresh to actually run. So strictly speaking, setting up a scheduled refresh (D) handles the timing, but without the gateway (A) for on-prem data, the refresh won’t succeed. If it’s cloud data only, then D alone is fine. The question doesn’t specify data location, so both could be relevant depending on context.

Actually, D is definitely the way to go here if your main goal is to trigger the update regularly on the first day of each month. Incremental refresh (C) helps with load optimization, but it doesn’t control *when* the refresh happens. The scheduled refresh feature lets you set specific times or days for updates, which fits perfectly with the requirement. Options A and B don’t really apply since a gateway is about connecting on-prem data, and Power Automate is more about workflows, not scheduled dataset refreshes.

C/D? Incremental refresh handles data loads smartly, but scheduled refresh triggers it monthly.

Option C could work too since incremental refresh is designed for handling large datasets efficiently by refreshing only recent data. If the model is big, this might save time and resources, especially when updating just last month’s sales instead of the whole dataset every time. That said, it still needs to be combined with a scheduled refresh to run automatically on the first day. So you might actually want both C and D together depending on your dataset size.

D imo, scheduled refresh fits monthly updates best without extra setup.

D, scheduled refresh is for automatic updates on set times