Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam PL-300 Topic 1 Question 41 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 41
Topic #: 1
[All PL-300 Questions]

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?

Show Suggested Answer Hide 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
Deane
1 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
Ulysses
7 days ago
A) Add a SQL statement.
upvoted 0 times
...
...
Glory
2 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
Noel
29 days ago
C) Set the Command timeout in minutes setting.
upvoted 0 times
...
Jodi
1 months ago
B) Set Data Connectivity mode to DirectQuery.
upvoted 0 times
...
...
Maynard
2 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
2 months ago
I disagree. We should add a SQL statement to configure the data connection.
upvoted 0 times
...
Twila
2 months ago
I agree with Tamar. DirectQuery will ensure real-time data visibility for detecting fraudulent transactions.
upvoted 0 times
...
Christiane
2 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
19 days ago
A) Add a SQL statement. That way the data will be visible within five minutes of an update.
upvoted 0 times
...
Deonna
20 days ago
B) Set Data Connectivity mode to DirectQuery.
upvoted 0 times
...
Eliz
24 days ago
A) Add a SQL statement.
upvoted 0 times
...
Cordelia
1 months ago
C) Set the Command timeout in minutes setting.
upvoted 0 times
...
Gussie
1 months ago
B) Set Data Connectivity mode to DirectQuery.
upvoted 0 times
...
Reita
2 months ago
A) Add a SQL statement.
upvoted 0 times
...
...
Tamar
2 months ago
I think we should set Data Connectivity mode to DirectQuery.
upvoted 0 times
...
Jamey
2 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
...

Save Cancel
a