Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You will publish a report that uses DirectQuery to a SQL Server 2019 database in your on-premises data center. The database is reachable only from inside the corporate network. After you publish the semantic model to the Power BI service, you must schedule refresh so users always query live data. What must you do to let the service connect to the database?

  • Embed a personal gateway in the Power BI Desktop file before publishing.

  • Enable service principal authentication for the workspace to bypass the firewall.

  • No additional configuration is required because DirectQuery eliminates the need for a gateway.

  • Install and configure an on-premises data gateway, then add the SQL Server instance as a data source.

Microsoft Power BI Data Analyst
Manage and secure Power BI
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