ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 1 question 14 discussion

Actual exam question from Microsoft's PL-300
Question #: 14
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?

  • A. Add a SQL statement.
  • B. Set the Command timeout in minutes setting.
  • C. Set Data Connectivity mode to Import.
  • D. Set Data Connectivity mode to DirectQuery.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by MilouSluijter at Sept. 6, 2022, 9:59 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
lukelin08
Highly Voted 2 years, 5 months ago
Selected Answer: D
D is correct for me
upvoted 30 times
...
Igetmyrole
Highly Voted 1 year, 8 months ago
D is the correct answer. DirectQuery model allows Power BI to directly query the data source (Azure SQL database, in this case) in real-time or near real-time. When data is updated in the database, DirectQuery ensures that the reports reflect the most current data without the need to import and refresh the data into the Power BI model.
upvoted 6 times
...
BP215
Most Recent 6 days, 18 hours ago
Selected Answer: D
D is the right answer
upvoted 1 times
...
SliqueCia
2 months, 4 weeks ago
Selected Answer: D
Since the data is near real time, DirectQuery is necessary
upvoted 1 times
...
Odidepse
3 months, 4 weeks ago
Selected Answer: D
Presented answer is correct, within 5 minutes can only be achieved through direct query
upvoted 1 times
...
DexTorao
5 months, 2 weeks ago
D for direct querry
upvoted 2 times
...
tejas9patil
6 months, 3 weeks ago
Selected Answer: D
For near real time data, always use direct query When it is not feasible to cache data in power BI, due to size constraines , always user direct query
upvoted 1 times
...
Bob_38
7 months, 1 week ago
Selected Answer: D
correct
upvoted 1 times
...
rcaliandro
8 months, 3 weeks ago
Selected Answer: D
Also for me is D. Set the connectivity mode to Direct Query. Because the data is refreshed each 5 minutes and the data in this way is not loaded into a cache but it is always refreshed
upvoted 3 times
...
RedRoss
1 year, 1 month ago
Selected Answer: D
It'll not load the data in power query but go back to the original data source (SQL DB) which is updated frequently.
upvoted 2 times
...
sankeytm
1 year, 7 months ago
Selected Answer: D
D is correct for me
upvoted 2 times
...
Chenemi
1 year, 9 months ago
Selected Answer: D
dIRECT QUERY IS BEST
upvoted 1 times
...
ET_phone_home_son
1 year, 10 months ago
Selected Answer: D
Near real-time data needed, so DirectQuery is needed.
upvoted 2 times
...
Jagu_sheth
1 year, 11 months ago
Selected Answer: D
Correct Ans
upvoted 1 times
...
Shalaleh
2 years ago
Selected Answer: D
Direct Query is the best choice!
upvoted 2 times
...
lizbette
2 years ago
Selected Answer: D
DirectQuery - best for real-time, or if you have large datasets to pull from https://learn.microsoft.com/en-us/training/modules/get-data/6-storage-mode
upvoted 1 times
...
DUVANES
2 years, 1 month ago
Selected Answer: D
D. Establezca el modo de conectividad de datos en DirectQuery.
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago