Crucial Exams

Microsoft Power BI Data Analyst Practice Question

Your Power BI Desktop report loads data from an on-premises SQL Server database and from a public CSV file hosted on GitHub. Both sources were originally configured with Organizational privacy level and the correct credentials. After you merge the two tables, query folding stops and refresh time increases. You need to disable the data privacy firewall so that query folding can occur, but you must leave the stored credentials unchanged. In the Data source settings dialog, which action should you take?

  • Change the SQL Server source to Database authentication and leave privacy levels unchanged.

  • Change the CSV source to Public privacy level and keep the SQL Server source as Organizational.

  • Disable connection encryption for the SQL Server source in its settings.

  • Change the privacy level for both data sources to None.

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