Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You import data from an on-premises SQL Server 2019 database into Power BI Desktop and publish the report to a workspace in the Power BI service. The report must refresh automatically each night while the database remains inside the corporate network firewall. What must you configure in the Power BI service to meet the requirement?

  • Install and register an on-premises data gateway, then map the dataset's SQL Server credentials to the gateway.

  • Change the dataset's storage mode to DirectQuery.

  • Add the SQL Server dataset as a certified dataset in the workspace.

  • Enable the workspace's large dataset storage format.

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