Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You need to connect Power BI Desktop to an Azure SQL Database that stores roughly 40 million sales records and receives new transactions every minute. Business users must see figures that are no more than five minutes old when they open a report. The organization has only Power BI Pro licenses and will publish the report to a workspace that runs in shared capacity (no Premium features). The database is well-tuned and can return aggregate queries in under five seconds. Which Power BI connectivity mode should you choose so the report meets the freshness requirement without requiring Premium capacity?

  • Create a live connection to Azure Analysis Services.

  • Import all data and schedule a refresh every hour.

  • Import the data and configure an incremental refresh policy.

  • Use DirectQuery mode when creating the semantic model.

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