Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-600 Topic 1 Question 30 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 30
Topic #: 1
[All DP-600 Questions]

You have a Fabric tenant that contains two workspaces named Woritspace1 and Workspace2. Workspace1 contains a lakehouse named Lakehouse1. Workspace2 contains a lakehouse named Lakehouse2. Lakehouse! contains a table named dbo.Sales. Lakehouse2 contains a table named dbo.Customers.

You need to ensure that you can write queries that reference both dbo.Sales and dbo.Customers in the same SQL query without making additional copies of the tables.

What should you use?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

Veronica
1 months ago
C) a managed table? Really? That's like trying to herd cats with a butterfly net. I'm going with D) a shortcut, for sure.
upvoted 0 times
...
Maile
1 months ago
A) a view could also work, but it might be overkill for this use case. I'm going with B) a dataflow.
upvoted 0 times
...
Ming
1 months ago
D) a shortcut seems like the best option to me. It's a way to create a reference to the tables without duplicating them.
upvoted 0 times
...
Tawna
1 months ago
I think the answer is B) a dataflow. It allows you to combine data from multiple sources in a single query.
upvoted 0 times
Candra
21 days ago
No, the correct answer is A) a view. It provides a virtual table that combines data from multiple tables.
upvoted 0 times
...
Candra
1 months ago
I think the answer is B) a dataflow. It allows you to combine data from multiple sources in a single query.
upvoted 0 times
...
...
Werner
2 months ago
I'm not sure about views, maybe a managed table could also work?
upvoted 0 times
...
Nada
2 months ago
I agree with Lashaun, a view would allow us to reference both tables in the same query.
upvoted 0 times
...
Lashaun
2 months ago
I think we should use a view for this.
upvoted 0 times
...

Save Cancel