MENU
You have an Azure SQL database named DB1.
You need to display the estimated execution plan of a query by using the query editor in the Azure portal.
What should you do first?
Suggested Answer: D, E
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
36 comments · newest first
LI
Lindsey
11 months ago
Seems like B is also an option, but D is more straightforward.
RY
Ryan
11 months ago
Wait, you can't just run a T-SQL statement for this?
BU
Bulah
11 months ago
I thought A was the answer, but I guess not.
CA
Candra
12 months ago
Definitely D! That's the way to go.
VI
Vi
12 months ago
You need to enable Query Store first.
VI
Viki
1 year ago
I'm leaning towards option D, but I also have a nagging feeling about the set showplan_all statement being important too.
HA
Haley
1 year ago
I practiced a similar question where we had to display execution plans, and I feel like running a Transact-SQL statement was involved.
AG
Agustin
1 year ago
I remember something about setting QUERY_CAPTURE_MODE, but I can't recall if that comes before or after enabling Query Store.
QU
Queenie
1 year ago
I think we need to enable Query Store first, but I'm not completely sure if that's the right first step.
AN
Anastacia
1 year ago
I'm pretty confident that the answer is option D, enabling Query Store for the database. That should give us the ability to view the execution plan directly in the Azure portal, which is what the question is asking for.
TR
Tracey
1 year ago
Okay, let me think this through. We need to display the estimated execution plan in the Azure portal, so we'll want to do something that integrates with the portal. Enabling Query Store seems like the most logical choice here.
MA
Marge
1 year ago
Hmm, I'm a bit confused. I thought we needed to use the SET SHOWPLAN_ALL statement to get the execution plan. I'm not sure if that's the right approach for this question.
BA
Barb
1 year ago
I think the key here is to enable Query Store for the database. That should give us the ability to view the estimated execution plan in the Azure portal.
CH
Cheryll
1 year ago
Option C with Flow seems like a good way to create a custom data entry wizard. That could help streamline the process and ensure data quality. I'll make sure to review the Flow functionality before the exam.
AL
Alexis
1 year ago
I'm a bit confused about how to calculate the confidence interval here; I think I need to find the mean first, but I'm not sure how to do that with this data.
MI
Minna
1 year ago
D is the answer, no doubt. Trying to use Transact-SQL statements is like trying to open a jar with a sledgehammer. Just enable Query Store and let the Azure portal do the work!
GE
Gene
1 year ago
I agree, using Query Store simplifies the process. No need to complicate things with Transact-SQL statements.
AL
Aleisha
1 year ago
Exactly! Enabling Query Store for DB1 is the way to go. It makes it much easier to view the estimated execution plan.
RO
Rosendo
1 year ago
D is the answer, no doubt. Trying to use Transact-SQL statements is like trying to open a jar with a sledgehammer. Just enable Query Store and let the Azure portal do the work!
LA
Lavonda
1 year ago
I'm torn between B and D, but I think D is the way to go. Enabling Query Store is the most direct approach to get the estimated execution plan.
TI
Tijuana
1 year ago
Let's go with option D and enable Query Store for DB1.
VI
Viola
1 year ago
I agree, enabling Query Store for DB1 is the correct first step.
HI
Hillary
1 year ago
I think D is the way to go. Enabling Query Store is the most direct approach to get the estimated execution plan.
LA
Lashawn
2 years ago
I'm going with D. Enabling Query Store is the way to go here. Trying to use Transact-SQL statements seems a bit overkill for this task.
LI
Lindsay
1 year ago
User3: D) Enable Query Store for DB1.
DU
Dulce
1 year ago
User2: I agree, enabling Query Store for DB1 is the first step.
CA
Catalina
1 year ago
User1: I'm going with D. Enabling Query Store is the way to go here.
NI
Nichelle
2 years ago
B looks promising, but I'm not sure if setting the QUERY_CAPTURE_MODE is necessary to just view the execution plan. D seems like the more straightforward option.
AM
Ammie
1 year ago
Agreed, let's go with enabling Query Store for DB1.
AN
Annice
1 year ago
D) Enable Query Store for DB1.
LI
Lilli
1 year ago
I think D) Enable Query Store for DB1 is the better option.
AL
Alpha
2 years ago
B) For DB1, set QUERY_CAPTURE_MODE of Query Store to All.
FR
Freida
2 years ago
Hmm, I think the correct answer is D. Enabling Query Store for DB1 should allow me to view the estimated execution plan in the Azure portal. No need for any additional Transact-SQL statements.
YO
Yoko
2 years ago
I think running the set showplan_all Transact-SQL statement is the correct first step to display the estimated execution plan.
PH
Phung
2 years ago
I agree with An. Enabling Query Store will allow us to capture the execution plan.
AN
An
2 years ago
I think the first thing to do is to enable Query Store for DB1.