Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You publish a Power BI report to the Power BI service. The report's semantic model retrieves data by using DirectQuery from three separate data sources: an Azure SQL Database that is publicly accessible, a CSV file stored in a SharePoint Online document library, and a SQL Server database hosted on-premises. To ensure that the report can retrieve data from all sources when viewed in the Power BI service, for which of the data sources must you configure an on-premises data gateway?

  • Only the SQL Server database

  • Only the Azure SQL Database

  • Only the CSV file and the SQL Server database

  • All three data sources

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