Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 14 discussion

Actual exam question from Microsoft's PL-300

Question #: 14
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?

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

Suggested Answer: D 🗳️

by MilouSluijter at Sept. 6, 2022, 9:59 a.m.

Comments

Submit Cancel

lukelin08

Highly Voted 2 years, 8 months ago

Selected Answer: D

D is correct for me

upvoted 30 times

...

Igetmyrole

Highly Voted 1 year, 10 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

...

bona2024

Most Recent 1 month, 3 weeks ago

Selected Answer: D

Direct Query will give near real time data

upvoted 1 times

...

BP215

2 months, 3 weeks ago

Selected Answer: D

D is the right answer

upvoted 1 times

...

SliqueCia

5 months, 2 weeks ago

Selected Answer: D

Since the data is near real time, DirectQuery is necessary

upvoted 1 times

...

Odidepse

6 months, 2 weeks ago

Selected Answer: D

Presented answer is correct, within 5 minutes can only be achieved through direct query

upvoted 1 times

...

DexTorao

8 months ago

D for direct querry

upvoted 2 times

...

tejas9patil

9 months, 1 week 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

9 months, 3 weeks ago

Selected Answer: D

correct

upvoted 1 times

...

rcaliandro

11 months, 1 week 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, 4 months 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, 9 months ago

Selected Answer: D

D is correct for me

upvoted 2 times

...

Chenemi

1 year, 11 months ago

Selected Answer: D

dIRECT QUERY IS BEST

upvoted 1 times

...

ET_phone_home_son

2 years ago

Selected Answer: D

Near real-time data needed, so DirectQuery is needed.

upvoted 2 times

...

Jagu_sheth

2 years, 2 months ago

Selected Answer: D

Correct Ans

upvoted 1 times

...

Shalaleh

2 years, 2 months ago

Selected Answer: D

Direct Query is the best choice!

upvoted 2 times

...

lizbette

2 years, 2 months 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

...

Load full discussion...