MENU
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel.
Does this meet the goal?
Suggested Answer: C
Get Premium PL-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
40 comments · newest first
JA
Jamal
11 months ago
Yes, this is a solid approach!
CO
Cornell
11 months ago
Wait, can you really just reference it like that?
CA
Carmen
11 months ago
Not sure if that's enough, might need more changes.
RO
Ronnie
12 months ago
Totally agree, makes maintenance easier.
DO
Dorothy
12 months ago
This definitely simplifies the queries!
DE
Deangelo
1 year ago
I feel like there might be more steps involved to ensure that all queries are updated correctly. Just creating a new query seems too simple.
AN
Anika
1 year ago
I'm a bit confused here. Does just creating a new query really solve the issue of updating all instances of the data source?
KA
Kallie
1 year ago
I remember a similar practice question where we had to replace hard-coded values, and it seemed like referencing the parameter directly was the right move.
LA
Laquanda
1 year ago
I think creating a new query that references the parameter might be a good approach, but I'm not entirely sure if it fully meets the goal.
TA
Tasia
1 year ago
This seems like a good opportunity to demonstrate my ability to work with parameters. I'll create the new query and reference the DataSourceExcel parameter.
NO
Noah
1 year ago
I'm a bit confused. Does the question mean I need to update all the queries that reference the data source, or just create a new query? I'll need to think this through.
EF
Effie
1 year ago
Okay, I think I've got this. Referencing the parameter in the query definition should be the solution to meet the goal.
MI
Mireya
1 year ago
Hmm, I'm not sure if creating a new query is the right approach here. Let me re-read the question carefully to make sure I understand the requirements.
NA
Nadine
1 year ago
This looks like a straightforward question. I'll create a new query that references the DataSourceExcel parameter to update the location.
EL
Ellsworth
1 year ago
This looks like a tricky XML namespace question. I'll need to carefully analyze the namespace declarations in the XML document to determine which one the "usage" attribute belongs to.
KA
Karl
1 year ago
Hmm, I'm a bit confused on this one. I know interfaces are important, but I'm not sure I fully grasp the specific reasons why it's important to follow the same ones. I'll need to think this through carefully.
MA
Margot
1 year ago
Okay, let's break this down step-by-step. FFE collected basic personal info like name, contact, age, and ID from prospective clients. They also got Stephen's messenger/cell details through Kelvin. And they shared his info with affiliates for marketing. I'll need to evaluate each of those against the data collection principle.
ME
Merilyn
1 year ago
Okay, I've got this. Banks would never publish links to phishing websites, so that's an easy one to rule out. The other options seem more plausible, so I'll need to analyze them closely.
SH
Shawnda
1 year ago
This looks like a straightforward question about troubleshooting a GPU-related issue. I'll carefully review the options and think through the potential causes.
AN
Antonio
1 year ago
As long as the new query correctly references the parameter, this should do the trick. Nice and simple, just the way I like it.
SH
Shaun
1 year ago
User 3: A) Yes
RO
Rosio
1 year ago
User 2: B) No
AV
Avery
1 year ago
User 1: A) Yes
RO
Rosalind
2 years ago
Haha, I bet the exam writers thought they were being clever with this one. But creating a new query is a pretty obvious way to solve this problem.
BL
Blossom
1 year ago
User 4: A) Yes
ME
Merissa
1 year ago
User 3: A) Yes
IO
Iola
1 year ago
User 2: B) No
SH
Sheron
2 years ago
User 1: A) Yes
KI
Kimberlie
2 years ago
No, I think creating a new query is not necessary. We can just update the existing queries with the parameter.
KA
Kattie
2 years ago
I agree with Mirta, it's more efficient to reference a parameter instead of hard-coding the location.
AS
Ashley
2 years ago
This solution seems straightforward and meets the requirement. I don't see any issues with it.
MI
Mirta
2 years ago
Yes, that makes sense to create a parameter for the Excel data source.
GE
Gearldine
2 years ago
Creating a new query that references the parameter is a valid solution. It allows you to centralize the data source location and update it in one place if needed.
MI
Millie
1 year ago
Creating a new query that references the parameter is a valid solution. It allows you to centralize the data source location and update it in one place if needed.
AL
Aliza
1 year ago
A) Yes
CR
Craig
2 years ago
Creating a new query that references the parameter is a valid solution. It allows you to centralize the data source location and update it in one place if needed.
HA
Harley
2 years ago
A) Yes
SH
Sharen
2 years ago
I'm not sure, maybe we should consider other options before deciding.
YU
Yuki
2 years ago
I agree with Jennifer, that seems like the right approach.
JE
Jennifer
2 years ago
I think the solution is to create a new query that references DataSourceExcel.