Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 13 discussion

Actual exam question from Microsoft's DP-700

Question #: 13
Topic #: 1

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

Suggested Answer: B 🗳️

by QAZdbarhate12345678 at Dec. 15, 2024, 9:44 a.m.

Comments

Submit Cancel

QAZdbarhate12345678

Highly Voted 6 months, 3 weeks 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 17 times

tomaszstaroszczyk

5 months, 1 week 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

4 months, 1 week 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

2 months, 2 weeks ago

A https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/intro-to-deployment-pipelines?tabs=new-ui#supported-items

upvoted 1 times

Sr18

1 month, 1 week ago

B: Its preview like most of the things in Fabric but it does work. Read deployment with pipelines. Don't get distracted with git. https://learn.microsoft.com/en-us/fabric/data-warehouse/source-control#deployment-pipelines

upvoted 1 times

Sr18

1 month, 1 week ago

And believe me MS is still in Marketing mode, so even if it breaks sometimes. The feature is there and you must use it specially deployment pipeline :)

upvoted 1 times

...

smanzana

Most Recent 2 weeks, 2 days ago

Selected Answer: B

B is correct

upvoted 1 times

...

upliftinghut

1 month, 3 weeks ago

Selected Answer: D

T-SQL below: SELECT referencing_object_name = OBJECT_NAME(referencing_id), referenced_entity_name, is_ambiguous, is_missing_reference FROM sys.sql_expression_dependencies WHERE is_missing_reference = 1;

upvoted 1 times

...

hebertorosillo

4 months, 1 week ago

Selected Answer: A

A. a database project for minimal effor

upvoted 4 times

...

Anushareddysri

5 months 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

4 months, 1 week ago

Python script could be a lengthy solution, while the question asks for minimal effort.

upvoted 1 times

...