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

Lakeesha

2 days ago

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

upvoted 0 times

...

Twila

4 days ago

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

upvoted 0 times

...

Christiane

7 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

...

Tamar

8 days ago

I think we should set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Jamey

10 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

...