Microsoft PL-300 Exam - Topic 2 Question 13 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 13
Topic #: 2

[All PL-300 Questions]

You use Power 81 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 long running queries into subsets Of columns and use power Query to the queries

BDisable query folding on long running queries

CReduce number of rows and columns returned by each query.

DUse Power Query to combine long running queries into one query.

Show Suggested Answer

Suggested Answer: B, D

by Krissy at Aug 21, 2022, 07:57 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Laticia

4 months ago

I feel like D could just complicate things more.

upvoted 0 times

...

Tu

4 months ago

Wow, I didn't know splitting queries could make such a difference!

upvoted 0 times

...

Chauncey

4 months ago

Not sure about B, disabling query folding sounds risky.

upvoted 0 times

...

Larae

4 months ago

Definitely agree with C, reducing rows and columns helps a lot!

upvoted 0 times

...

Bettina

4 months ago

I think option A is a solid choice for handling long queries.

upvoted 0 times

...

Geraldo

5 months ago

Combining queries doesn't sound right for this situation. I feel like option D might not be the best approach here.

upvoted 0 times

...

Jeannetta

5 months ago

I practiced a similar question where reducing the number of rows returned was key. Option C seems like a solid choice.

upvoted 0 times

...

Merrilee

5 months ago

I'm not entirely sure, but I think disabling query folding might help with long-running queries. That sounds like option B, right?

upvoted 0 times

...

Matthew

5 months ago

I remember something about splitting queries to manage performance better, so maybe option A could work.

upvoted 0 times

...

Janae

5 months ago

Aha, I think I've got it! The client is using Basic authentication, but the server is expecting NTLM. That's the mismatch causing the 401 response.

upvoted 0 times

...

Glenn

5 months ago

Hmm, I'm not too familiar with RSA NetWitness, so I'll have to think this one through carefully.

upvoted 0 times

...

Man

5 months ago

I recall something about tenant names possibly being 128 characters, but I might be mixing it up with another system.

upvoted 0 times

...

Bernadine

5 months ago

I feel pretty confident about this. The EDPB has been clear that derogations should only be used as a last resort and interpreted restrictively. So I'm going with option D.

upvoted 0 times

...