Free Databricks Certified Data Analyst Associate Actual Exam Questions - Question 1 Discussion

It’s B, refresh schedules are set outside the Query Editor.

B vs E? You definitely can’t set refresh schedules in Query Editor.

Maybe E is off because I don’t think you need to be a workspace admin to set a refresh schedule. Usually, if you have edit permissions on the dataset or query, you can schedule refreshes. Admin rights seem like overkill for just setting up a refresh. B makes sense as wrong too since Query Editor is for query writing, not scheduling. So I’d say E is probably the incorrect statement here.

Probably B is the odd one out here. Refresh schedules are generally set in the workspace or dataset settings, not inside the Query Editor itself. The editor is mainly for writing and testing queries, not managing refresh jobs. I agree with the others that C could be tricky depending on how the backend runs scheduled queries, but B feels clearly wrong since it’s mixing up where configurations happen. Also, E seems too strict—workspace admins might have special privileges, but contributors often can manage refresh schedules too.

Maybe C is wrong because I thought scheduled refreshes usually rely on some compute resources like SQL Warehouses to run the queries. Not sure if it’s always the case, but that stood out to me.

E imo feels off because usually you don’t need to be a workspace admin just to set refresh schedules—sometimes contributors or editors can do that too. I’m with the others on B not being right since refresh settings aren’t typically done inside Query Editor itself. C also caught my eye, but I think refreshes often do use SQL Warehouses behind the scenes, so that one might be true. So E stands out as the incorrect statement from my view.

Maybe B is off because refresh schedules are usually set outside the Query Editor, like in settings or a separate admin area, not directly in the editor itself.

Does the question specify which platform or tool this refresh schedule is about? Different systems have different rules for refresh intervals and permissions. Without that, it’s hard to say which statement is definitely incorrect.