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

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

Alana

1 days ago

C) Set the Command timeout in minutes setting.

upvoted 0 times

...

Paulina

8 days ago

B) Set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Ulysses

15 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

Burma

6 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

...

Cristen

8 days ago

D) Set Data Connectivity mode to Import.

upvoted 0 times

...

Noel

1 months ago

C) Set the Command timeout in minutes setting.

upvoted 0 times

...

Jodi

2 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

27 days ago

A) Add a SQL statement. That way the data will be visible within five minutes of an update.

upvoted 0 times

...

Deonna

28 days ago

B) Set Data Connectivity mode to DirectQuery.

upvoted 0 times

...

Eliz

1 months 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

2 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

...