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

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 1 question 13 discussion

Actual exam question from Microsoft's DP-700
Question #: 13
Topic #: 1
[All DP-700 Questions]

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?

  • A. a database project
  • B. a deployment pipeline
  • C. a Python script
  • D. a T-SQL script
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by QAZdbarhate12345678 at Dec. 15, 2024, 9:44 a.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
QAZdbarhate12345678
Highly Voted 5 months ago
Selected Answer: B
Microsoft Fabric's deployment pipelines provide a built-in mechanism to manage and validate the deployment of artifacts like warehouses. When you use a deployment pipeline to move Warehouse1 from one workspace (Workspace1) to another (Workspace2), the pipeline automatically checks for issues such as invalid references or missing dependencies during the deployment process.
upvoted 11 times
tomaszstaroszczyk
3 months, 2 weeks ago
What kind of references may a Warehouse have? We don't have shortcuts in a warehouse. It seems to be an indepentent item, there is no possiblity to break a reference to anything external. Therfor I think this relates to internal references, i.e. stored procedure operating on non-existing table. In this case a database project (answer A) would be necessary, but I don't find it related to a Deployment Pipeline in any way.
upvoted 4 times
toniteo
2 months, 3 weeks ago
agreed with answer A. Here is the hint. https://community.fabric.microsoft.com/t5/Data-Engineering/Microsoft-fabric-WareHouse-migration-issue-via-deployment/td-p/4281976
upvoted 4 times
CloudKaKida
3 weeks, 4 days ago
A https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/intro-to-deployment-pipelines?tabs=new-ui#supported-items
upvoted 1 times
...
...
...
...
hebertorosillo
Most Recent 2 months, 2 weeks ago
Selected Answer: A
A. a database project for minimal effor
upvoted 4 times
...
Anushareddysri
3 months, 1 week ago
Selected Answer: C
Question is focusing on "As part of the deployment process, you need to verify whether Warehouse1 contains invalid references" for this python script can be written to identify invalid references and can add it as a notebook activity in pipeline. So answer is python script.
upvoted 1 times
toniteo
2 months, 3 weeks ago
Python script could be a lengthy solution, while the question asks for minimal effort.
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago