Question 530
An implementation decision is needed: A compliance dashboard must query current balances stored in a relational system, and policy prohibits copying those rows into Power BI storage. What should the analyst do?
Explanation
Correct Answer
This directly addresses the stated constraint. DirectQuery queries the underlying source for visuals and has performance and feature constraints. Confirmation: An authorized visual queries current source balances without importing transaction rows into the model.
Incorrect Answers
A full outer join unintentionally includes CRM-only customers outside the required population. The specific problem here is that an Import connection creates an unacceptable persisted copy and may show stale balances until refresh.
Splitting on a space would fail for multi-word surnames and preserved commas. The specific problem here is that an Import connection creates an unacceptable persisted copy and may show stale balances until refresh.
Hard-coding the server name separately into twelve queries makes environment switches error-prone. The specific problem here is that an Import connection creates an unacceptable persisted copy and may show stale balances until refresh.