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

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 1 question 11 discussion

Actual exam question from Microsoft's DA-100
Question #: 11
Topic #: 1
[All DA-100 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 Data Connectivity mode to DirectQuery.
  • C. Set the Command timeout in minutes setting.
  • D. Set Data Connectivity mode to Import.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by RajGoy at Oct. 14, 2020, 5:58 p.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
RajGoy
Highly Voted 4 years, 9 months ago
Direct mode is best option here.
upvoted 87 times
marciomanini
4 years, 9 months ago
Agreed
upvoted 1 times
...
...
vinothravi
Highly Voted 4 years, 9 months ago
B. Set Data Connectivity mode to DirectQuery.
upvoted 25 times
Bamo
4 years, 4 months ago
agreed
upvoted 3 times
...
...
RamzanAnjum
Most Recent 3 years ago
Agreed - DirectQuery
upvoted 1 times
...
vineyvinni
3 years, 3 months ago
Selected Answer: B
Direct Mode is correct option
upvoted 2 times
...
PowerBIAddict
3 years, 4 months ago
B is correct. A new SQL query will not solve the issue. Import is better for infrequently updated tables.
upvoted 1 times
...
TechDiva
3 years, 4 months ago
I got it on my exam 03/17/2022. 90-95% questions were from here.
upvoted 1 times
claudeaboki
3 years, 2 months ago
how did you find the correct answers? the most voted are the best or the answers on the site? Thanks
upvoted 1 times
...
...
Letsgo9999
3 years, 5 months ago
In exam 07-03-2022
upvoted 1 times
REINORK
3 years ago
Hello, can you send me an email? I will do my exam next week
upvoted 1 times
...
...
battenarajesh
3 years, 6 months ago
Direct Mode
upvoted 1 times
...
Pritam85
3 years, 6 months ago
B is correct answer
upvoted 1 times
...
kwanalytics
3 years, 7 months ago
On exam Dec 27, 2021 - answer B
upvoted 2 times
...
MustPassDA100
3 years, 7 months ago
on exam 12/25/2021
upvoted 1 times
...
kblee
3 years, 7 months ago
Answer is B for retrieve more recent data, import is for caching and performance
upvoted 2 times
...
PatrickStr
3 years, 7 months ago
on exam 12/10/2021
upvoted 1 times
...
klaudio92
3 years, 8 months ago
Selected Answer: B
B: Azure SQL database supports DirectQuery
upvoted 3 times
...
aguilartu1
3 years, 8 months ago
on exam - Nov 11, 2021. my answer: Set Data Connectivity mode to DirectQuery.
upvoted 3 times
...
kcwood94
3 years, 9 months ago
On exam 10/14/21
upvoted 1 times
...
francis6170
3 years, 11 months ago
Got this in the exam - Aug 15, 2021.
upvoted 6 times
HaliBrickclay
3 years, 10 months ago
What is correct answer? that will be more helpful rather to know about you got this question in exam.
upvoted 4 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