ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 49 discussion

Actual exam question from Microsoft's PL-300
Question #: 49
Topic #: 2
[All PL-300 Questions]

You 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.

  • A. Reduce the number of rows and columns returned by each query.
  • B. Split log running queries into subsets of columns and use Power Query to merge the queries.
  • C. Use Power Query to combine log running queries into one query.
  • D. Disable query folding on long running queries.
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️
by jsking at Jan. 11, 2023, 4:27 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
milk97
Highly Voted 2 years, 2 months ago
This link helps explain query timeout and how to work around it. https://learn.microsoft.com/en-us/training/modules/get-data/9-import-errors
upvoted 32 times
...
SamuComqi
Highly Voted 1 year, 9 months ago
Selected Answer: AB
AB
upvoted 14 times
VS_Shwetha
1 year, 8 months ago
Hey have you gone through the questions after 22nd page
upvoted 1 times
...
...
jaume
Most Recent 5 months, 1 week ago
Selected Answer: AB
Option C would result in a longer query with opposite result (as it would take even more time to retrieve data, itwould easier would resut in a TimeOut error) Not sure about the effect of option D but reducing rows and columns as suggested in option A and split queries as in option B (to retrieve small datasets in each resulting querie) would definitively help to prevent the TimeOut error
upvoted 1 times
...
539d541
8 months, 1 week ago
I'm not sure why A is marked as a correct answer - what if you needed all of those rows instead of arbitrarily filtering them out? Agree with B. C looked like it may have been part of the procedure achieved by B
upvoted 1 times
...
rcaliandro
8 months, 2 weeks ago
Selected Answer: AB
A and B is the correct one: - Reduce the number of rows and columns returned by each query - Split log running queries into subsets of columns and use Power Query to merge the queries
upvoted 1 times
...
9f73003
1 year ago
Geee, I'm gonna do some "log" running today! Wow, once again, I paid for this, be nice if someone proof read the questions. Regardless, A and B are correct.
upvoted 2 times
...
iamSophie
1 year, 1 month ago
B is correct Splitting date/time BEFORE loading to Power BI will increase the performance and not AFTER: Source: https://learn.microsoft.com/en-us/training/modules/get-data/8-performance-issues?ns-enrollment-type=learningpath&ns-enrollment-id=learn-bizapps.data-preparation-in-power-bi If any of your tables have columns that combine date and time, make sure that you separate them into distinct columns before importing them into Power BI.
upvoted 1 times
...
SnakePlissken123
1 year, 3 months ago
Question uses the phrase "log running." This is a mis-spelling. It should be long running.
upvoted 2 times
...
WRTopics
1 year, 6 months ago
A&D for this question
upvoted 1 times
...
Igetmyrole
1 year, 7 months ago
A & D are correct. A. By reducing the amount of data retrieved from the SQL server database, you can make the query execution more efficient and reduce the likelihood of encountering errors due to resource constraints. D. Query folding is a feature in power query that pushes some of the data transformation operations back to the data source (in this case, SQL server) for processing. Query folding can sometimes cause issues with long-running queries. B and C are not appropriate solutions for resolving the error related to long-running queries. These options focus on combining or splitting queries, which may not directly address the root cause of the issue.
upvoted 2 times
...
Shalaleh
1 year, 12 months ago
Selected Answer: AB
Given answer is correct.
upvoted 3 times
...
RazaTheLegend
2 years ago
Selected Answer: AB
Exactly! The answer is correct. https://learn.microsoft.com/en-us/training/modules/get-data/9-import-errors
upvoted 4 times
...
1sourabhpatel1
2 years, 1 month ago
Disabling query folding on long running queries is not a recommended solution for resolving the error. Query folding is an optimization technique used by Power Query to translate transformations into optimized SQL statements. Disabling query folding may lead to less optimized query execution plans, which could result in longer query execution times and higher resource consumption.
upvoted 6 times
...
mkubrak
2 years, 2 months ago
Selected Answer: AB
seems ok
upvoted 2 times
...
darkfairy
2 years, 3 months ago
Can someone explain why AB are the correct answers?
upvoted 10 times
semauni
2 years ago
A reduces the amount of results that you're getting back, therefore reduces query time, and reduces the chances of a timeout occuring. B basically does the same, and is a solution for when you really need al columns and rows: instead of getting one large table back, you'll get multiple smaller ones, then you can combine those after loading. C does exactly the opposite, making the resulting table even larger. D will not help either, as query folding basically expands on the 'select * from <table>' that Power BI fires to the database. It can, for instance, add a where-clause to that statement if you're filtering in Power Query. That also reduces query time. Source for query folding: https://learn.microsoft.com/en-us/power-query/power-query-folding
upvoted 23 times
...
...
ewelaela
2 years, 3 months ago
Selected Answer: AB
AB is correct
upvoted 3 times
...
Sushvij
2 years, 3 months ago
A & B correct answer
upvoted 3 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago