Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are building a Power BI report that must query a table of about 300 million rows stored in Azure SQL Database. Business stakeholders insist that the data shown be no more than five minutes old during business hours, and scheduled dataset refreshes cannot exceed ten minutes. Which Power BI connection mode best meets these requirements while avoiding lengthy refresh operations?

  • Composite model with default Import storage

  • DirectQuery mode

  • Live connection

  • Import mode

Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot