Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 14 of 134
Free Preview · 134 of 444 · questions 1–134 of 444 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
D is correct answer
* Answer: - D. Set Data Connectivity mode to DirectQuery. * Explanation: Requirement: Data must be visible within five minutes of an update → This means near real-time reporting. DirectQuery mode queries the Azure SQL database on demand, so reports always reflect the latest data without waiting for scheduled refresh. Import mode would require scheduled refresh, which cannot guarantee a 5-minute latency. * Why not the others: - A. Add a SQL statement → Useful for filtering or shaping data, but does not affect refresh latency. - B. Set the Command timeout in minutes → Controls query execution time, not data freshness. - C. Import mode → Requires refresh; cannot meet the 5-minute freshness requirement.
Direct Query will give near real time data