MENU
You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1.
You plan to deploy Warehouse1 to a new workspace named Workspace2.
As part of the deployment process, you need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort.
What should you use?
Suggested Answer: C
Get Premium DP-700 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
A deployment pipeline in Fabric allows you to deploy assets like warehouses, datasets, and reports between different workspaces (such as from Workspace1 to Workspace2). One of the key features of a deployment pipeline is the ability to check for invalid references before deployment. This can help identify issues with assets, such as broken links or dependencies, ensuring the deployment is successful without introducing errors. This is the most efficient way to verify references and manage the deployment with minimal development effort.
27 comments · newest first
PA
Paola
10 months ago
Definitely a database project for verifying references!
RO
Rodrigo
10 months ago
I think a T-SQL script would be more efficient.
MI
Mitsue
11 months ago
I agree, a T-SQL script seems like the simplest option here.
DI
Dierdre
11 months ago
Wait, can a deployment pipeline really check for invalid references?
AS
Asha
11 months ago
A deployment pipeline is usually the way to go for this.
BE
Bettina
11 months ago
I’m leaning towards a Python script, but I’m not confident it would minimize development effort as much as the other options.
IO
Iola
12 months ago
A database project sounds familiar, but I feel like it might require more setup than I want right now.
GL
Gladys
12 months ago
I'm not entirely sure, but I remember practicing with T-SQL scripts for checking references in similar scenarios.
AR
Arlene
12 months ago
I think using a deployment pipeline might be the best option since it can automate the verification process.
LE
Lemuel
1 year ago
I'm leaning towards the deployment pipeline option. That way, I can automate the process of checking for invalid references and ensure that the deployment to the new workspace goes smoothly.
TO
Tommy
1 year ago
A T-SQL script could be a good option, as it would allow me to directly query the warehouse and check for any invalid references. However, I'm not sure if that would be the most efficient or user-friendly solution.
EL
Elbert
1 year ago
I'm a bit confused by this question. I'm not sure if a database project or a deployment pipeline would be the best way to verify the invalid references. I'll have to think this through a bit more.
RA
Raina
1 year ago
I think a Python script would be the best option here. It would allow me to quickly and easily check for any invalid references in the warehouse without having to set up a whole database project or deployment pipeline.
ME
Merlyn
2 years ago
A deployment pipeline? Now that's thinking outside the box! It's like using a teleportation device to bypass the stairs. Genius!
GL
Glendora
1 year ago
User2: Definitely! It's like using a teleportation device to bypass the stairs. Genius!
AN
Annice
1 year ago
User1: A deployment pipeline? Now that's thinking outside the box!
GL
Glory
2 years ago
Hmm, a T-SQL script? That's the classic approach, but it might be a bit tedious. I'd prefer something more user-friendly, like a database project.
EL
Elouise
2 years ago
A Python script? Really? That's like trying to use a sledgehammer to crack a walnut. T-SQL is the way forward, my friend.
GU
Gussie
2 years ago
I'd go with the deployment pipeline. It's more automated and can handle the validation as part of the deployment process.
JE
Jesse
2 years ago
I think a Python script might be easier to implement and maintain.
LI
Lina
2 years ago
I'm not sure, maybe a database project could also work?
AN
Annamaria
2 years ago
I agree with Francisca, a T-SQL script would be the best option.
FR
Francisca
2 years ago
I think we should use a T-SQL script.
XU
Xuan
2 years ago
A database project is the way to go! It'll give you a comprehensive view of the warehouse and identify any invalid references.
AI
Ailene
1 year ago
C: I agree, using a database project is the most efficient way to deploy Warehouse1 to Workspace2.
RE
Renea
1 year ago
B: Yeah, a database project would definitely help minimize development effort in this case.
AD
Adolph
1 year ago
A: I think a database project is the best option for verifying invalid references in Warehouse1.