Microsoft Exam PL-300 Topic 1 Question 41 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 41
Topic #: 1

You have an Azure SQL database that contains sales transactions. The database is updated frequently.

You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.

How should you configure the data connection?

AAdd a SQL statement.

BSet Data Connectivity mode to DirectQuery.

CSet the Command timeout in minutes setting.

DSet Data Connectivity mode to Import.

Show Suggested Answer

Suggested Answer: A

by Jacqueline at Apr 23, 2024, 01:25 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Vannessa

4 days ago

Hmm, this one seems tricky. I'll need to think carefully about the requirements - the data needs to be visible within 5 minutes of an update, so I can't just import the data. Maybe DirectQuery is the way to go?

upvoted 0 times

...

Jeanice

7 days ago

I'm feeling pretty confident about this one. The key is to ensure the data access logs are retained for 6 months and that only audit personnel can access them. I think option D, using an aggregated export sink, is the most robust solution.

upvoted 0 times

...

Tonette

16 days ago

This looks straightforward - I just need to calculate the arithmetic mean of the new customer numbers given in the data.

upvoted 0 times

...

Tashia

18 days ago

This seems like a straightforward data transformation task. I'd recommend using Power Platform dataflows to combine the Room and Shelf fields into a single column during the import process.

upvoted 0 times

...

Deane

5 months ago

I bet the answer is B) Set Data Connectivity mode to DirectQuery. Anything else and the finance team will be coming after me with pitchforks for late reports!

upvoted 0 times

Alana

4 months ago

C) Set the Command timeout in minutes setting.

upvoted 0 times

...

Paulina

4 months ago

B) Set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Ulysses

4 months ago

A) Add a SQL statement.

upvoted 0 times

...

Glory

5 months ago

A) Add a SQL statement? I'm not sure how that would help with the 5-minute data visibility requirement. Sounds more like a manual process than an automated solution.

upvoted 0 times

Burma

4 months ago

A) Add a SQL statement? I'm not sure how that would help with the 5-minute data visibility requirement. Sounds more like a manual process than an automated solution.

upvoted 0 times

...

Cristen

4 months ago

D) Set Data Connectivity mode to Import.

upvoted 0 times

...

Noel

5 months ago

C) Set the Command timeout in minutes setting.

upvoted 0 times

...

Jodi

5 months ago

B) Set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Maynard

6 months ago

Hmm, I'm not sure if C) Set the Command timeout in minutes setting is the answer. That might help with long-running queries, but it doesn't address the requirement for near-real-time data visibility.

upvoted 0 times

...

Lakeesha

6 months ago

I disagree. We should add a SQL statement to configure the data connection.

upvoted 0 times

...

Twila

6 months ago

I agree with Tamar. DirectQuery will ensure real-time data visibility for detecting fraudulent transactions.

upvoted 0 times

...

Christiane

6 months ago

D) Set Data Connectivity mode to Import? Really? That would defeat the purpose of generating reports within 5 minutes of an update.

upvoted 0 times

Daren

4 months ago

A) Add a SQL statement. That way the data will be visible within five minutes of an update.

upvoted 0 times

...

Deonna

4 months ago

B) Set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Eliz

5 months ago

A) Add a SQL statement.

upvoted 0 times

...

Cordelia

5 months ago

C) Set the Command timeout in minutes setting.

upvoted 0 times

...

Gussie

5 months ago

B) Set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Reita

5 months ago

A) Add a SQL statement.

upvoted 0 times

...

Tamar

6 months ago

I think we should set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Jamey

6 months ago

B) Set Data Connectivity mode to DirectQuery sounds like the right choice here. It'll keep the data in sync with the database without having to wait for a full import.

upvoted 0 times

...