Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Microsoft Discussions

Exam DP-600 topic 1 question 85 discussion

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

You have a Fabric tenant that contains a warehouse.

You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD).

You need to recommend which columns to add to the table. The columns must NOT already exist in the source.

Which three types of columns should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

  • A. a foreign key
  • B. a natural key
  • C. an effective end date and time
  • D. a surrogate key
  • E. an effective start date and time
Show Suggested Answer Hide Answer
Suggested Answer: CDE 🗳️
by VAzureD at April 24, 2024, 11:32 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
newusername
3 days, 5 hours ago
Selected Answer: CDE
To create SCD type 2 one needs to add a surrogate key + start/end date beside the other technical attributes. Therefore CDE.
upvoted 1 times
...
vish9
1 week, 1 day ago
Selected Answer: CDE
As per chat GPT: Surrogate keys are typically used in dimension tables rather than fact tables. In a data warehouse, a surrogate key is a unique identifier assigned to each record in a dimension table, usually for internal processing and joining purposes. It provides a stable reference to the dimension record, regardless of any changes in the natural key or other attributes.
upvoted 1 times
dp600
6 days, 3 hours ago
chatgpt is not a source
upvoted 2 times
b4163b3
2 days, 15 hours ago
It is often a better source than some random here...
upvoted 1 times
...
...
...
Unbounded
1 week, 2 days ago
Selected Answer: BCE
B: A natural key would be the Dim tables own Primarykey column not the source Primary key C & D: is requires to incorporate SCD Type 2.
upvoted 1 times
Unbounded
1 week, 2 days ago
Sorry there is a type in my comment above it should read C&E so the correct answer is BC&E
upvoted 1 times
newusername
3 days, 5 hours ago
I didn't get, why would you create a new "Dim table own Primarykey"?
upvoted 1 times
...
...
...
VAzureD
1 week, 3 days ago
Selected Answer: CDE
Let's discard, A. A FOREIGN KEY in SQL is a key (a column field) that is used to relate two tables. The FOREIGN KEY field is related or linked to the PRIMARY KEY of another database table. It already exists at the origin. B. Natural key, likewise, already exists in the origin. CDE, are the fields that we must create in our ETL to create an SCD2.
upvoted 2 times
Unbounded
1 week, 2 days ago
Surrogate key is used in Fact Tables not Dim Tables
upvoted 1 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel