Question 1 of 30
A data analyst is working on optimizing a Power BI report that pulls data from a large SQL database. The report is experiencing slow performance, and the analyst decides to use the Query Diagnostics feature to identify the bottlenecks. After running the diagnostics, the analyst observes that the \"Query Duration\" is significantly higher than expected, and the \"Data Load\" time is also extended. Which of the following actions should the analyst prioritize to improve the performance of the report?
Investigate and optimize the SQL query used to retrieve the data from the database.
Increase the memory allocation for Power BI Desktop.
Reduce the number of visuals on the report page.
Change the data source from SQL to an Excel file.

Preparing for Microsoft DA-100 Analyzing Data with Microsoft Power BI? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free