Question 278 of 388
Single answerYou use Power BI Desktop to load data from a Microsoft SQL Server database.While waiting for the data to load, you receive the following error.You need to resolve the error.What are two ways to achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
✓ASplit log running queries into subsets of columns and use Power Query to merge the queries.
BDisable query folding on long running queriesC.Reduce number of rows and columns returned by each query.
DUse Power Query to combine long running queries into one query.
✓
Correct Answer: A
Split log running queries into subsets of columns and use Power Query to merge the queries.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.