Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam PL-400 Topic 3 Question 79 Discussion

Actual exam question for Microsoft's PL-400 exam
Question #: 79
Topic #: 3
[All PL-400 Questions]

A company designs data integration with an external system by using virtual tables.

You need to implement the virtual tables.

Solution: Use a table that has a GUID as its primary key.

Does the solution meet the goal?

Show Suggested Answer Hide Answer

Contribute your Thoughts:

Shaquana
8 months ago
Hmm, I don't know. A GUID might be a good choice if we need to integrate with a lot of different systems. It could provide a consistent way to identify the data. But you guys make a good point about natural keys being more meaningful.
upvoted 0 times
...
France
8 months ago
Yeah, GUIDs are great for a lot of things, but for this use case, I'm not convinced. We should focus on making the virtual tables as intuitive and efficient as possible.
upvoted 0 times
...
Carey
8 months ago
I agree. A GUID doesn't really tell us anything about the data. Plus, it takes up more space in the database. I think we should look for a column or set of columns that uniquely identify the data.
upvoted 0 times
...
Pamela
8 months ago
I'm not sure if using a GUID as the primary key is the best solution. Wouldn't it be better to use a natural key that has meaning to the business?
upvoted 0 times
...

Save Cancel