Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 49 discussion

Actual exam question from Microsoft's PL-300

Question #: 49
Topic #: 2

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

Suggested Answer: AB 🗳️

by jsking at Jan. 11, 2023, 4:27 p.m.

Comments

Submit Cancel

milk97

Highly Voted 2 years, 5 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 2 years ago

Selected Answer: AB

upvoted 14 times

VS_Shwetha

2 years ago

Hey have you gone through the questions after 22nd page

upvoted 1 times

...

jaume

Most Recent 8 months, 4 weeks 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 2 times

...

539d541

11 months, 4 weeks 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

12 months 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, 3 months 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, 5 months 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, 7 months ago

Question uses the phrase "log running." This is a mis-spelling. It should be long running.

upvoted 2 times

...

WRTopics

1 year, 10 months ago

A&D for this question

upvoted 1 times

...

Igetmyrole

1 year, 11 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

2 years, 3 months ago

Selected Answer: AB

Given answer is correct.

upvoted 3 times

...

RazaTheLegend

2 years, 4 months 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, 5 months 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 7 times

...

mkubrak

2 years, 5 months ago

Selected Answer: AB

seems ok

upvoted 2 times

...

darkfairy

2 years, 6 months ago

Can someone explain why AB are the correct answers?

upvoted 10 times

semauni

2 years, 3 months 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, 7 months ago

Selected Answer: AB

AB is correct

upvoted 3 times

...

Sushvij

2 years, 7 months ago

A & B correct answer

upvoted 3 times

...

Load full discussion...