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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

by Nickole at Jan 12, 2025, 02:17 AM

Limited Time Offer

25%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Veronica
2 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
2 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
Jamie
25 days ago
I see your point, a dataflow could be a good solution for this situation.
upvoted 0 times
...
Lenna
26 days ago
I'm not sure about a view, I think B) a dataflow might be a better choice.
upvoted 0 times
...
Claudio
27 days ago
I agree, a view could work well for this scenario.
upvoted 0 times
...
Shawnda
1 months ago
I think A) a view would be the best option here.
upvoted 0 times
...
...
Ming
3 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
3 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
2 months ago
No, the correct answer is A) a view. It provides a virtual table that combines data from multiple tables.
upvoted 0 times
...
Candra
2 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
3 months ago
I'm not sure about views, maybe a managed table could also work?
upvoted 0 times
...
Nada
3 months ago
I agree with Lashaun, a view would allow us to reference both tables in the same query.
upvoted 0 times
...
Lashaun
3 months ago
I think we should use a view for this.
upvoted 0 times
...

Save Cancel