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, 12: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

Glory

8 days 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

Jodi

2 days ago

B) Set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Maynard

12 days 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

16 days ago

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

upvoted 0 times

...

Twila

18 days ago

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

upvoted 0 times

...

Christiane

21 days 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

Gussie

3 days ago

B) Set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Reita

6 days ago

A) Add a SQL statement.

upvoted 0 times

...

Tamar

22 days ago

I think we should set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Jamey

24 days 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

...