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 DP-600 Exam - Topic 1 Question 30 Discussion

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?
A) a view
B) a dataflow
C) a managed table
D) a shortcut

Microsoft DP-600 Exam - 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:

0/2000 characters
Submit Cancel
Alana
8 months ago
A dataflow seems unnecessary for just querying those tables.
upvoted 0 times
...
Raelene
9 months ago
Wait, can you really use a view across different workspaces?
upvoted 0 times
...
Margot
9 months ago
Definitely need a view to reference both tables easily!
upvoted 0 times
...
Lai
9 months ago
I think a shortcut could work too, but not sure.
upvoted 0 times
...
Annamae
9 months ago
A view is the way to go for this!
upvoted 0 times
...
Reita
10 months ago
I feel like a managed table could work, but I’m leaning more towards a view since it seems to fit the requirement better.
upvoted 0 times
...
Floyd
10 months ago
I practiced a similar question where we had to join tables from different lakehouses, and I think a dataflow might be the right choice here.
upvoted 0 times
...
Sonia
10 months ago
I'm not entirely sure, but I remember something about shortcuts being used to reference tables across workspaces.
upvoted 0 times
...
Eulah
10 months ago
I think we might need to use a view since it allows us to combine data from different sources without duplicating it.
upvoted 0 times
...
Chandra
10 months ago
I'm feeling a bit uncertain about this one. There are a few different options presented, and I want to make sure I understand the differences between them before selecting an answer. I'll need to review the concepts around views, dataflows, and managed tables to decide which one is the best fit.
upvoted 0 times
...
Gerardo
10 months ago
Okay, I've got a strategy here. I think the key is to use a feature that allows me to reference tables across workspaces without having to copy the data. A view seems like the most likely option, but I'll double-check the other choices just to be sure.
upvoted 0 times
...
Maira
10 months ago
Hmm, I'm a bit confused by this one. I'm not sure if a view is the right approach, or if there might be another way to access data across workspaces. I'll need to think this through carefully.
upvoted 0 times
...
Juan
10 months ago
This looks like a straightforward question. I think the answer is a view, since that would allow me to combine the data from the two different lakehouses in a single query.
upvoted 0 times
...
Veronica
1 year 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 years 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
1 year ago
I see your point, a dataflow could be a good solution for this situation.
upvoted 0 times
...
Lenna
1 year ago
I'm not sure about a view, I think B) a dataflow might be a better choice.
upvoted 0 times
...
Claudio
1 year ago
I agree, a view could work well for this scenario.
upvoted 0 times
...
Shawnda
1 year ago
I think A) a view would be the best option here.
upvoted 0 times
...
...
Ming
2 years 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
2 years 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
1 year 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 year 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 years ago
I'm not sure about views, maybe a managed table could also work?
upvoted 0 times
...
Nada
2 years ago
I agree with Lashaun, a view would allow us to reference both tables in the same query.
upvoted 0 times
...
Lashaun
2 years ago
I think we should use a view for this.
upvoted 0 times
...

Save Cancel