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.
Suggested Answer: B, D
Get Premium PL-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
13 comments · newest first
LA
Laticia
11 months ago
I feel like D could just complicate things more.
TU
Tu
11 months ago
Wow, I didn't know splitting queries could make such a difference!
CH
Chauncey
12 months ago
Not sure about B, disabling query folding sounds risky.
LA
Larae
12 months ago
Definitely agree with C, reducing rows and columns helps a lot!
BE
Bettina
1 year ago
I think option A is a solid choice for handling long queries.
GE
Geraldo
1 year ago
Combining queries doesn't sound right for this situation. I feel like option D might not be the best approach here.
JE
Jeannetta
1 year ago
I practiced a similar question where reducing the number of rows returned was key. Option C seems like a solid choice.
ME
Merrilee
1 year ago
I'm not entirely sure, but I think disabling query folding might help with long-running queries. That sounds like option B, right?
MA
Matthew
1 year ago
I remember something about splitting queries to manage performance better, so maybe option A could work.
JA
Janae
1 year 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.
GL
Glenn
1 year ago
Hmm, I'm not too familiar with RSA NetWitness, so I'll have to think this one through carefully.
MA
Man
1 year ago
I recall something about tenant names possibly being 128 characters, but I might be mixing it up with another system.
BE
Bernadine
1 year 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.