exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 5 question 9 discussion

Actual exam question from Microsoft's DA-100
Question #: 9
Topic #: 5
[All DA-100 Questions]

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Configure the dataset to use the existing On-premises data gateway.
  • B. Deploy an On-premises data gateway in personal mode.
  • C. Set the refresh frequency to Daily.
  • D. Configure the dataset to use the personal gateway.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

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
Bernie2206
Highly Voted 4 years, 7 months ago
It should be A and C.
upvoted 231 times
Zakriya
3 years, 12 months ago
Should be.
upvoted 3 times
...
D24G
3 years, 11 months ago
Absolutely, no brainer
upvoted 6 times
...
...
VR1
Highly Voted 4 years, 7 months ago
Ans - A & C. No need to configure a personal gateway "You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured"
upvoted 37 times
...
Marlon_Tamanini
Most Recent 2 years, 8 months ago
Selected Answer: AC
Resposta correta A e C
upvoted 1 times
...
QWERTYman
2 years, 9 months ago
Selected Answer: AC
Answer is A and C
upvoted 1 times
...
RamzanAnjum
2 years, 9 months ago
If there is already an existing On-premises data gateway, no need to use personal gateway. So, A & C seems right.
upvoted 1 times
...
ryoame
3 years, 1 month ago
Selected Answer: AC
It says "You have admin access to the workspace and permission to use an existing On-premises data gateway"
upvoted 1 times
...
TechDiva
3 years, 1 month ago
I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.
upvoted 1 times
TechDiva
3 years, 1 month ago
Answered:A
upvoted 1 times
...
...
Meyti
3 years, 3 months ago
by default there is not any On-premises data gateway and you should first configure it, thereby B and C should be.
upvoted 1 times
dfretyhg
3 years, 1 month ago
The question establishes that someone has already set up a gateway though. You have to read all the information before just solving the problem on these exams
upvoted 1 times
...
...
Shan
3 years, 4 months ago
In exam 30/12/21
upvoted 1 times
...
PatrickStr
3 years, 4 months ago
on exam 12/10/2021
upvoted 1 times
...
PatrickStr
3 years, 4 months ago
on exam 12/10/2021
upvoted 1 times
...
aguilartu1
3 years, 5 months ago
on exam - Nov 11, 2021. my answers: Set the refresh frequency to Daily. Configure the dataset to use the existing On-premises data gateway.
upvoted 3 times
...
kcwood94
3 years, 6 months ago
On exam 10/14/21
upvoted 1 times
...
nowwin
3 years, 7 months ago
question in exam on 18th September
upvoted 3 times
...
katherine_dawalk
3 years, 8 months ago
personal gateway dones't support directquery, it says so here:https://powerbi.microsoft.com/en-us/gateway/. Also is a gateway can support multiple data sources?
upvoted 2 times
...
Prathameshsable
3 years, 9 months ago
Definitely, A&C because once you publish your report and go to manage gateways it will automatically show the existing gateway connection to Oracle. This will minimize the effort of installing a personal gateway (Option B). Also, option B seems irrelevant because if your system is off which means your personal gateway also will be off thereby impacting your daily refresh and not answering the question
upvoted 6 times
...
tramynt
3 years, 9 months ago
https://powerbi.microsoft.com/en-us/gateway/ A and C
upvoted 2 times
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago